Question: can you just write the model please, (variables are given, can u write the objectives and constrains please) ZOOM + THE Exercise 1.2. Production Planning.

can you just write the model please, (variables are given, can u write the objectives and constrains please)
ZOOM + THE Exercise 1.2. Production Planning. A company which produces a single product has definite orders for this product over the next four quarters as follows: Quarter 1234 Demand 350 680 275 590 The company enucled the previous year with an inventory of 200 units, and the final quarter pro duction level was 400 units. The company wishes to end this year with an inventory of at least 250 units It crests $3.50 per unit to increase the production level from one quarter to the next, and $6.00 per unit to decrease it. The cost of holding inventory from one quarter to the next is $4.80 per unit per quarter. No shortages are permitted. The company wishes to minimize the sum of production level change costs and inventory costs over the four quarter planning horizan. Model this problem as a linear program and solve it using Excel Solver. .Write the model (sets, parameters, variables, objective, constraints), add a snapshot of your excel solution, report the solution values (objective and variables). summarize in words that the solution means. Use the following variables: P:= the number of units produced in quarter ili = 0,1,2,3,4) T= the number of units in inventory at the end of quarter ili = 0,1,2,3,4) U; the increase in the number of units produced from quarter i - 1 to quarter ii 1, 2, 3, 4) D; = the decrease in the member of units produced from quarter 1 - 1 to o quarter ii = 1,2,3,4)Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
