Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

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.

image text in transcribed 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. Ci

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Business Ethics

Authors: Peter A. Stanwick, Sarah D. Stanwick

3rd Edition

9781506303239

Students also viewed these General Management questions