Maximize profit by changing how many of each donut you make. You must meet maximum demand...

  

Transcribed Image Text:

Maximize profit by changing how many of each donut you make. You must meet maximum demand to keep customers happy but must not exceed maximum demand or else you will lose money on inventory. Additionally, you only have 20 hours of total employees labour available to devote to donut making Ice Made Chocolate Plain Vanilla cream Profit per ice cream 0,05 0,3 0,49 Labor time Min per ice cream 0,02 0,05 0,49 Demand 150 100 50 i. Formulate a linear programming model for this problem. Max Demand 250 200 150 [10] iv. Solve with the Simplex Method, using Excel Solver. Generate a sensitivity analysis report I What is the lowest number of labour hours allowable? [10] [4] What is the maximum amount of profit that the company can get by having some additional labour hours? [3] [3] Maximize profit by changing how many of each donut you make. You must meet maximum demand to keep customers happy but must not exceed maximum demand or else you will lose money on inventory. Additionally, you only have 20 hours of total employees labour available to devote to donut making Ice Made Chocolate Plain Vanilla cream Profit per ice cream 0,05 0,3 0,49 Labor time Min per ice cream 0,02 0,05 0,49 Demand 150 100 50 i. Formulate a linear programming model for this problem. Max Demand 250 200 150 [10] iv. Solve with the Simplex Method, using Excel Solver. Generate a sensitivity analysis report I What is the lowest number of labour hours allowable? [10] [4] What is the maximum amount of profit that the company can get by having some additional labour hours? [3] [3]

Answer rating: 100% (QA)

To formulate a linear programming model for this problem we need to define the decision variables objective function and constraints Decision Variables Lets denote the number of ice cream donuts made ... View the full answer