Proctoring Enabled: Chapter 7 Using Binary Integer Progr...SavedHelp3.A manufacturer produces both widgets and gadgets. Widgets generate a profit of $75 each and gadgets have a profit margin of $65each. To produce each item, a setup cost is incurred. This setup cost is $400 for widgets and $300 for gadgets. Widgets consume 4units of raw material A and 8 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Eachday, the manufacturer has 400 units of each raw material available. Assume that it is possible to produce fractional quantities ofwidgets and gadgets.Set up the problem in Excel and find the optimal solution.a. The manufacturerwidgets andgadgets.(Leave no cells blank - be certain to enter "O" wherever required. Round your answers to 2 decimal places.)b. The manufacturer will producewidgets andgadgets(Round your answer to 2 decimal places.)cThe manufacturer's profit will beMcGrawHill< Prev3 of 5Next >

Answered: A manufacturer produces both widgets…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Which of the following would be considered a direct holding cost? (choose all that apply)
7
Hansen Controls has been awarded a contract for a large number of control panels. To meet this demand, it will use its existing plants in Houston and Tulsa, and consider new plants in Portland, St. Louis and Lexington. Finished control panels are to be shipped to Denver, Kansas City and Seattle. Pertinent information is given in the table. Denver 1 1- 2- 3- Sources 4- 5- Houston Tulsa Portland Construction St. Louis Cost Kansas City 2 ---- 1 Shipping Cost to Destination: Capacity Seattle 3 6 6 500,000 450,000 Lexington 400,000 Demand 14,000 13,000 18,000 We develop a transportation model as an LP that includes provisions for the fixed costs (construction costs in this case) for the three new plants. The solution of this model would reveal which plants to build and the optimal shipping schedule. Let xij = the number of panels shipped from source i to destination j y₁ = 1 if plant i is built, = 0 otherwise (i = 3, 4, 5) The constraint x21 + x22+x23 <= 13,000*y3 represents which of the…
The life time of a giant loading machine is 10 years and its maintenance costs 4,455 JD per year. If the machine will be maintained starting 3 years after purchase, calculate the equivalent uniform series the owner should put aside to cover these costs at 9% per year
Reduces costs and their feasibility ranges are rooted in making changes in the right hand side of the constraint. Your answer: True False
Which of the following is incorrect about the safety stock? Group of answer choices As the amount of safety stock carried increases, service level increases As the amount of safety stock carried increases, the risk of stock-out decreases If there is no uncertainty, there is no need to keep safety stock As the amount of safety stock carried increases, the risk of stock-out increases Safety stock protects companies against uncertainty
PA machine shop manufactures custom brake disks for high performance cars. The shop needs to meet a demand of 1200 units per year. For each production run there is a setup cost of 1200 dollars, and there is a cost of 90 dollars per unit for materials and supplies. Storage of unsold units costs the shop 18 dollars per year. How many units should the shop produce on each production run in order to minimize inventory costs (setup plus storage)? Round your answer to the nearest integer. Answer: 90 units per production run
Another approach that might be used relates to the time before a breakdown occurs. Suppose that the average time before breakdown is normally distributed and has a mean of3 weeks and a standard deviation of .60 week. If breakdown cost averages $1,000 and preventive maintenance costs $250, what is the optimal maintenance interval?
snip
SM manufacturer produces scarves. They evenly split the $600 factory rent with GM gloves manufacturers, and the raw material for each scarf costs $2. If the selling price of a pair of GM gloves is $4 and a SM scarf is $5, how many scarves should SM sell to break even?
Avexim Pharmaceutical Laboratories is an international group of companies that manufactures an antiepileptic prescription drug in huge volumes. The setup time for manufacturing the drug is 75 minutes, the processing time is 8 minutes, and the order size is 700 units. In this case, which of the following is the total time required to meet the given production volume? a. 4275 minutes b. 968 minutes c. 1300 minutes d. 5675 minutes
Please provide formula and answer

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS