Question
Aggregate Production Planning Problem Consider the problem of scheduling the weekly production of a certain item for the next 4 weeks. The production cost of
Aggregate Production Planning Problem
Consider the problem of scheduling the weekly production of a certain item for the next 4 weeks. The production cost of the item is $10 for the first 2 weeks, and $15 for the last 2 weeks. The weekly demands are 300, 700, 900, and 800 units, which must be met. The plant can produce a maximum of 700 units each week. In addition, the company can employ overtime during the second and third weeks. This increases the weekly production by an additional 200 units, but the cost of production increases by $5 per item. Excess production can be stored at a cost of $3 an item per week. How should the production be scheduled so as to minimize the total costs? Formulate this as a linear programming problem and solve using Excel Solver. You must write out the optimal production plan.
Additionally, I saw this solution but little confused about how the constraints are fixed in Excel.
Objective function: minimiz Z=3(11+12+13+14)+10(x1+x2)+15(x3+x4)=1501+200 s.t. Constraints x11=300I1+x2+012=700I2+x3+o213=900I3+x414=800x1,x2,x3,x470001,02200 Solution using Excel Solver Objective value: objective coeff. CiStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started