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.

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
Get step-by-step solutions from verified subject matter experts
