Question: Answer this using both graphical analysis and MS Excel. Giapetto's Woodcarving, Inc., manufactures two types of wooden toys: soldiers and trains. You may assume they

Answer this using both graphical analysis and MS

Answer this using both graphical analysis and MS Excel. Giapetto's Woodcarving, Inc., manufactures two types of wooden toys: soldiers and trains. You may assume they can produce partial toys. A soldier sells for $29 and uses $12 worth of raw materials. Each soldier that is manufactured increases Giapetto's variable labor and overhead costs by $15. A train sells for $24 and uses $10 worth of raw materials. Each train built increases Giapetto's variable labor and overhead costs by $13. The manufacture of wooden soldiers and trains requires two types of skilled labor: carpentry and finishing. A soldier requires 3 hours of finishing labor and 1 hour of carpentry labor. A train requires 1 hour of finishing and 2 hours of carpentry labor. Each week, Giapetto can obtain all the needed raw materials but only 150 finishing hours and 90 carpentry hours. Demand for trains is unlimited, but at most 45 soldiers are bought each week. Giapetto wants to maximize weekly profit (revenues - costs). Show that if the contribution to profit for trains is between $0.67 and $4, the current basis remains optimal. If the contribution to profit for trains is $1.50, then what would be the new optimal solution

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!