QUESTION 1

1. Refer to the Kelson Sporting Equipment problem (Chapter 2, Problem 24 in your textbook).

   Let R = number of regular gloves

   C = number of catcher's mitts

   leads to the following formulation:

   Max	5R + 8C
   s.t.	R + 3/2C 900		Cutting and sewing
   	1/2R + 1/3C 300		Finishing
   	1/8R + 1/4C 100		Packaging and shipping
   	R, C 0

   The LP model is entered and solved via Excel Solver. Use the attached Excel file to generate the computerized sensitivity analysis report.

   Kelson Sporting Equipment LP Model.xlsx Answer all questions based on the sensitivity reports.

   Submit the Excel file here after running the model. Make sure you generate the Answer Report, Sensitivity Report and Limits Report. Refer to instructor's videos on how to generate sensitivity reports postoptimization.

   1. Attach File

2 points

QUESTION 2

1. Based on the LP model solution you obtained for Kelson Sporting Equipment, what is the optimal solution, and what is the value of the total profit contribution?

   R =

   C =

   Profit = $

2 points

QUESTION 3

1. According to the Answer Report you generated, which constraints are binding? Select all that apply.

   Learning moment: Remember binding constraints have 0 slack/surplus on right-hand-side. Meaning that any improvement (increase in the less than or equal to case) in the right hand side value will potentially improve the objective value.

   		Cutting and sewing
   		Finishing
   		Packaging and shipping

2 points

QUESTION 4

1. Based on the sensitivity report you generated for Kelson Sporting Equipment, what are the dual values for the resources?

   Resource	Dual Value
   Cutting and sewing
   Finishing
   Packaging and shipping

2 points

QUESTION 5

1. Additional finishing time is worth $3 per unit and additional packaging and shipping time is worth $28 per unit.

   True

   False

1 points

QUESTION 6

1. If overtime can be scheduled in one of the departments, where would you recommend doing so?

   	A.	In the packaging and shipping department because each additional hour has the lowest impact on the objective function value.
   	B.	In the finishing department because each additional hour has the highest impact on the objective function value.
   	C.	In the cutting and sewing department because each additional hour has the highest impact on the objective function value.
   	D.	In the packaging and shipping department because each additional hour has the highest impact on the objective function value.
   	E.	In the cutting and sewing department because each additional hour has the lowest impact on the objective function value.
   	F.	In the finishing department because each additional hour has the lowest impact on the objective function value.