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?  

Transcribed Image Text:

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: Department Baking hours used per unit Mixing hours used per unit In the Solver, the resulting sensitivity report is shown as: Sensitivity Report Variable Cells Cell $B$8 A $B$9 B $B$10 C Constraints Cell $E$2 $E$3 Name Name Baking used Mixing used Final Value 700 10 451.8181818 Final Value 2500 1609.818182 Reduced Objective Cost 0.060606 Coefficient -1.30303 0 Shadow Price 4.242424242 0 6 11 14 Constraint R.H. Side 2500 3900 Product Usage (in hours) 2 3 2.9 3.3 0.9 3.1 2.1 1 1.4 Allowable Increase Allowable Decrease 1E+30 0.060606061 1.30303 1E+30 0.14285 1.482758621 Allowable Increase Allowable Decrease 159 1E+30 2290.181818 1458 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: Department Baking hours used per unit Mixing hours used per unit In the Solver, the resulting sensitivity report is shown as: Sensitivity Report Variable Cells Cell $B$8 A $B$9 B $B$10 C Constraints Cell $E$2 $E$3 Name Name Baking used Mixing used Final Value 700 10 451.8181818 Final Value 2500 1609.818182 Reduced Objective Cost 0.060606 Coefficient -1.30303 0 Shadow Price 4.242424242 0 6 11 14 Constraint R.H. Side 2500 3900 Product Usage (in hours) 2 3 2.9 3.3 0.9 3.1 2.1 1 1.4 Allowable Increase Allowable Decrease 1E+30 0.060606061 1.30303 1E+30 0.14285 1.482758621 Allowable Increase Allowable Decrease 159 1E+30 2290.181818 1458

Answer rating: 100% (QA)

The production constraints for Cute Accessories Co can be expressed as follows Baking hours constrai... View the full answer