ABC Company sells three products, A, B, and C with demand of 700 units, 100 units...

  

Transcribed Image Text:

ABC Company sells three products, A, B, and C 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 Coll $858 A $859 B $8510 C When this information was input into Solver the resulting sensitivity report was as follows: Sensitivity Report Variable Cells Constraints Cell 5852 Name Name Baking used SE$3 Ming used Final Value 700 10 451.8181818 Final Value 1609.818182 Price 2500 4.242424242 Reduced Objective Allowable Allowable Cost Coefficient Increase 0.060606 130303 0 6 Shadow Constraint R.H. Side D 11 14 Product Usage (in hours) B с A 1.4 2.9 0.9 3.1 2500 3900 3.3 2.1 Decrease 1E+30 0.060606061 1.30303 1E+30 0.14285 1482758621 Allowable Increase Allowable Decrease 159 1458 1E+30 2290 181818 a) State all production constraints (input and output) in the form of mathematical inequalities (4 marks) ABC Company sells three products, A, B, and C 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 Coll $858 A $859 B $8510 C When this information was input into Solver the resulting sensitivity report was as follows: Sensitivity Report Variable Cells Constraints Cell 5852 Name Name Baking used SE$3 Ming used Final Value 700 10 451.8181818 Final Value 1609.818182 Price 2500 4.242424242 Reduced Objective Allowable Allowable Cost Coefficient Increase 0.060606 130303 0 6 Shadow Constraint R.H. Side D 11 14 Product Usage (in hours) B с A 1.4 2.9 0.9 3.1 2500 3900 3.3 2.1 Decrease 1E+30 0.060606061 1.30303 1E+30 0.14285 1482758621 Allowable Increase Allowable Decrease 159 1458 1E+30 2290 181818 a) State all production constraints (input and output) in the form of mathematical inequalities (4 marks)