Required:

 Formulate an LP model for this problem and solve the problem using the excel sheet along with the Analytic Solver Platform in excel.

Transcribed Image Text:

In the next production period, the company has limited amounts of supplies available for each resource to be used for production, so that the company must make a production plan that can be executed without exceeding these limits. The excel template shows these limits (column C "Available"). The marketing department suggests that the production of each model does not exceed the expected demand, but they also suggest that a certain minimum quantity be produced for each model. These minimums can be found in the Excel template. The company has two groups of workers, namely, groups 1 and 2. Workers in group 1 can only assemble Models A, B, and C, while workers in group 2 can only assemble models D and E. Each group has its own production capacity, which are 150 units (laptops) for group 1 and 200 units (laptops) for group 2. You must make sure that your production schedule will not violate these capacity constraints. The company's objective is to maximize its profit by a finding the optimal number of production units for each model. Your task is to help the company management make the optimal production decision. Use the integer tolerance of 0 (zero) when solving the problem. In the next production period, the company has limited amounts of supplies available for each resource to be used for production, so that the company must make a production plan that can be executed without exceeding these limits. The excel template shows these limits (column C "Available"). The marketing department suggests that the production of each model does not exceed the expected demand, but they also suggest that a certain minimum quantity be produced for each model. These minimums can be found in the Excel template. The company has two groups of workers, namely, groups 1 and 2. Workers in group 1 can only assemble Models A, B, and C, while workers in group 2 can only assemble models D and E. Each group has its own production capacity, which are 150 units (laptops) for group 1 and 200 units (laptops) for group 2. You must make sure that your production schedule will not violate these capacity constraints. The company's objective is to maximize its profit by a finding the optimal number of production units for each model. Your task is to help the company management make the optimal production decision. Use the integer tolerance of 0 (zero) when solving the problem.

Answer rating: 100% (QA)

LP Model Formulation Objective Function Maximize Profit 240x1 280x2 380x3 240x4 3... View the full answer