Question: ANSWER QUICK PLEASE WITH LINGO CODE The ACM manufacturing firm produces four different models of desks (M1 to M4) which differ in size, specifications and
ANSWER QUICK PLEASE WITH LINGO CODE
The ACM manufacturing firm produces four different models of desks (M1 to M4) which differ in size, specifications and material usage, as shown in the following table. Over the coming week, the company anticipates to have up to 5000 hours of skilled labor time available, 8000 ounces of metal, 10000 ounces of glass and 12,000 ounces of wood available. The cost per unit of each of the resources is shown in the table below. Based on market analysis, the sales department believes that the company won't sell more than 1000, 500, 800 and 1500 units of M1, M2, M3 and M4, respectively. The company does not want to keep any desks in inventory at the end of the week. The selling prices per desk of the four models are 30, 22, 35 and 26, respectively. Resource Resource requirement per desk M2 MB Cost per unit M1 M4 Labor time 2 1.5 8 2 2 4 2 1 0.75 Metal Glass 3 + 2 1 1 Wood 6 4 5 3 0.5 a) The company would like to determine the most profitable product mix. Formulate this problem as a linear program (clearly define the decision variables) b) Provide the corresponding LINGO formulation for the model developed in part (a) and make sure to use the compact form in LINGO syntax The ACM manufacturing firm produces four different models of desks (M1 to M4) which differ in size, specifications and material usage, as shown in the following table. Over the coming week, the company anticipates to have up to 5000 hours of skilled labor time available, 8000 ounces of metal, 10000 ounces of glass and 12,000 ounces of wood available. The cost per unit of each of the resources is shown in the table below. Based on market analysis, the sales department believes that the company won't sell more than 1000, 500, 800 and 1500 units of M1, M2, M3 and M4, respectively. The company does not want to keep any desks in inventory at the end of the week. The selling prices per desk of the four models are 30, 22, 35 and 26, respectively. Resource Resource requirement per desk M2 MB Cost per unit M1 M4 Labor time 2 1.5 8 2 2 4 2 1 0.75 Metal Glass 3 + 2 1 1 Wood 6 4 5 3 0.5 a) The company would like to determine the most profitable product mix. Formulate this problem as a linear program (clearly define the decision variables) b) Provide the corresponding LINGO formulation for the model developed in part (a) and make sure to use the compact form in LINGO syntax
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
