Practical Management Science
Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
Bartleby Related Questions Icon

Related questions

Question
1
A manufacturer produces both widgets and gadgets. Widgets generate a profit of $35 each and gadgets have a profit margin of $55
each. To produce each item, a setup cost is incurred. This setup cost is $500 for widgets and $300 for gadgets. Widgets consume 2
units of raw material A and 3 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each
day, the manufacturer has 400 units of each raw material available. Assume that it is possible to produce fractional quantities of
widgets and gadgets.
X 01:30:43
Set up the problem in Excel and find the optimal solution.
a. The manufacturer
widgets and
gadgets.
Skipped
(Leave no cells blank – be certain to enter "0" wherever required. Round your answers to 2 decimal places.)
b. The manufacturer will produce
widgets and
gadgets
(Round your answer to 2 decimal places.)
Mc
Graw
Hill
< Prev
1 of 5
Next >
ASUS
expand button
Transcribed Image Text:1 A manufacturer produces both widgets and gadgets. Widgets generate a profit of $35 each and gadgets have a profit margin of $55 each. To produce each item, a setup cost is incurred. This setup cost is $500 for widgets and $300 for gadgets. Widgets consume 2 units of raw material A and 3 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturer has 400 units of each raw material available. Assume that it is possible to produce fractional quantities of widgets and gadgets. X 01:30:43 Set up the problem in Excel and find the optimal solution. a. The manufacturer widgets and gadgets. Skipped (Leave no cells blank – be certain to enter "0" wherever required. Round your answers to 2 decimal places.) b. The manufacturer will produce widgets and gadgets (Round your answer to 2 decimal places.) Mc Graw Hill < Prev 1 of 5 Next > ASUS
(Round your answer to 2 decimal places.)
C.
The manufacturer's profit will be
< Prev
1 of 5
Next >
ASUS
expand button
Transcribed Image Text:(Round your answer to 2 decimal places.) C. The manufacturer's profit will be < Prev 1 of 5 Next > ASUS
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Similar questions
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Text book image
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
Text book image
Business in Action
Operations Management
ISBN:9780135198100
Author:BOVEE
Publisher:PEARSON CO
Text book image
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
Text book image
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.