Generate the range sensitivity analysis as part of the output

Question 1

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.

1. a) Formulate the linear programming model for the problem.
2. b) Use the Graphical method to find the optimal solution. Show all steps.
3. 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.
4. d) Generate the range sensitivity analysis as part of the output (will use next week).

Questions 2

My diet requires that all the food I eat come from one of the four “basic food groups” (chocolate cake, ice cream, soda, and cheesecake).  At present, the following four foods are available for consumption: brownies, chocolate ice cream, cola, and pineapple cheesecake.  Each brownie cost $0.50, each scoop of ice cream costs $0.20, each bottle of cola cost $0.30, and each piece of pineapple cheesecake costs $0.80.  Each day, I must ingest at least 500 calories, 6 oz. of chocolate, 10 oz of sugar, and 8 oz of fat.  The nutritional content per unit of each food is shown in the table.  Formulate a linear programming model that can be used to satisfy my daily nutritional requirements at minimum cost.

1. a) Formulate the linear programming model for the problem.
2. b) 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.