Cute Accessories Co. sells three products, 1, 2, and 3 with demand of 700 units, 100 units and 500 units respectively. There is a contractual obligation to make at least 10 units of each product. Each of the products utilize different numbers of hours in each of two unique departments, mixing and baking. The specific use of the departmental hours by each of the products is as follows: Product Usage (in hours) Department 2 3 Baking hours used per unit 1.4 2.9 3.3 Mixing hours used per unit 0.9 3.1 2.1 1 In the Solver, the resulting sensitivity report is shown as: Sensitivity Report Variable Cells Name Final Value 700 10 451.8181818 Cell $B$8 A $B$9 B $B$10 C Reduced Cost 0.060606 -1.30303 0 Objective Coefficient 6 Allowable Allowable Increase Decrease 1E+30 0.060606061 1.30303 1E+30 0.14285 1.482758621 11 14 Constraints Final Shadow Cell Name Value Price $E$2 Baking used 2500 4.242424242 $E$3 Mixing used 1609.818182 0 Constraint R.H. Side 2500 3900 Allowable Allowable Increase Decrease 159 1458 1E+30 2290.181818 a) State all production constraints (input and output) in the form of mathematical inequalities, and state which product would be produced if an extra baking hour could be obtained, and why it is the choice? Cute Accessories Co. sells three products, 1, 2, and 3 with demand of 700 units, 100 units and 500 units respectively. There is a contractual obligation to make at least 10 units of each product. Each of the products utilize different numbers of hours in each of two unique departments, mixing and baking. The specific use of the departmental hours by each of the products is as follows: Product Usage (in hours) Department 2 3 Baking hours used per unit 1.4 2.9 3.3 Mixing hours used per unit 0.9 3.1 2.1 1 In the Solver, the resulting sensitivity report is shown as: Sensitivity Report Variable Cells Name Final Value 700 10 451.8181818 Cell $B$8 A $B$9 B $B$10 C Reduced Cost 0.060606 -1.30303 0 Objective Coefficient 6 Allowable Allowable Increase Decrease 1E+30 0.060606061 1.30303 1E+30 0.14285 1.482758621 11 14 Constraints Final Shadow Cell Name Value Price $E$2 Baking used 2500 4.242424242 $E$3 Mixing used 1609.818182 0 Constraint R.H. Side 2500 3900 Allowable Allowable Increase Decrease 159 1458 1E+30 2290.181818 a) State all production constraints (input and output) in the form of mathematical inequalities, and state which product would be produced if an extra baking hour could be obtained, and why it is the choice
