Giapetto’s Woodcarving, Inc. manufactures two types of toys: soldiers and trains. Each soldier sold generate $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. Help Giapetto to maximize his profit.
- a) Formulate the linear programming model for the problem.
- b) Use the Graphical method to find the optimal solution. Show all steps.
- c) Use Excel Solver or Lindo to solve the model you formulated. Copy and paste your spreadsheet and the Answer report in its entirety from Excel OR your Lindo input and output.
- d) Generate the range sensitivity analysis as part of the output (will use next week)
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.