Question: Please answer the attached problem using Microsoft Excel or Google Sheets if needed. Giapetto's Woodcarving, Inc. manufactures two types of toys: soldiers and trains. Each

Please answer the attached problem using Microsoft Excel or Google Sheets if needed.

Please answer the attached problem using Microsoft Excel or Google Sheets if

Giapetto's Woodcarving, Inc. manufactures two types of toys: soldiers and trains. Each soldier sold generates $3 in profit while each train generates $2 in profit. The manufacture of wooden soldiers and trains requires two types of skilled labor: carpentry and finishing. A soldier requires 2 hours of finishing labor and 1 hour of carpentry labor. A train requires 1 hour of finishing labor and 1 hour of carpentry. Each week, Giapetto can obtain all the needed raw materials but only 100 finishing hours and 80 carpentry hours. Demand for trains is unlimited, but at most 40 soldiers are bought each week. Formulate the linear program to help Giapetto maximize his profits. Solve the linear program graphically

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 Finance Questions!