The ABC Company produces three electrical products—blenders, choppers, and toasters. The manufacturer has a maximum daily production budget of RM2000 and a maximum of 660 hours of labor. Maximum daily customer demand is for 200 blenders, 300 choppers, and 150 toasters. The unit profit for blender is RM8, choppers, RM10, and toaster, RM7. The company desires to know the optimal product mix that will maximize profit. These products have the following resource requirements as shown in Table 1.After solving the problem using linear programming, Table 4 shows the LP sensitivity report. Based on the report, answer the following questions and justify all your answers.Formulate the LP model for the above case study.Optimize the Company ABC production using simplex method.Verify your answer in (b) using SOLVER. Provide SOLVER Answer Report, Sensitivity Report, and Excel Sheet of your modelling. Suppose that the company would like to increase the profit of the toasters to RM9 per unit without affecting the optimum number of products to be produced based on earlier conditions. Based on the Sensitivity Report, advise the company if this can be accomplished and justify your answer. If this can be done, what would be the company’s profit based on new pricing. The company has some extra funds and is trying to increase the company’s profit by either increasing the number of labor hours by hiring more workers or increasing its daily production budget. Based on the Sensitivity Report, propose and justify which course of action should the company choose. Sometimes the company is facing worker absenteeism that reduces the total labor hours to 644 hours. Based on Sensitivity Report, evaluate how this scenario affects the company’s profit. Resource RequirementProductCost/UnitLabor hours/UnitBlenderRM72Chopper103Toaster2

Answered: The ABC Company produces three…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

The ABC Company produces three electrical products—blenders, choppers, and toasters. The manufacturer has a maximum daily production budget of RM2000 and a maximum of 660 hours of labor. Maximum daily customer demand is for 200 blenders, 300 choppers, and 150 toasters. The unit profit for blender is RM8, choppers, RM10, and toaster, RM7. The company desires to know the optimal product mix that will maximize profit. These products have the following resource requirements as shown in Table 1.

After solving the problem using linear programming, Table 4 shows the LP sensitivity report. Based on the report, answer the following questions and justify all your answers.

Formulate the LP model for the above case study.
Optimize the Company ABC production using simplex method.
Verify your answer in (b) using SOLVER. Provide SOLVER Answer Report, Sensitivity Report, and Excel Sheet of your modelling.
Suppose that the company would like to increase the profit of the toasters to RM9 per unit without affecting the optimum number of products to be produced based on earlier conditions. Based on the Sensitivity Report, advise the company if this can be accomplished and justify your answer. If this can be done, what would be the company’s profit based on new pricing.
The company has some extra funds and is trying to increase the company’s profit by either increasing the number of labor hours by hiring more workers or increasing its daily production budget. Based on the Sensitivity Report, propose and justify which course of action should the company choose.
Sometimes the company is facing worker absenteeism that reduces the total labor hours to 644 hours. Based on Sensitivity Report, evaluate how this scenario affects the company’s profit.