Description
COMPLETE THE EXCELLoad the line as efficient as possible and avoid OT if you can.Avoid OOS (out of stock) for both items.Avoid unnecessary increase in inventory.Maintain the total inventory below the warehouse capacity.
Don't use plagiarized sources. Get Your Custom Assignment on
Simple Production Planning in Excel
From as Little as $13/Page
Unformatted Attachment Preview
Demand
Item 1
Item 2
MPS
Standard Capacity
OT Capacity
Most Efficient Run Qty
Storage Capacity
Beginning Inv
Production Plan
Item 1
Item 2
Inv Item 1
Inv Item 2
Apr
May
2800
500
Jun
5000
750
Jul
4500
500
Aug
12000
750
Sep
3000
500
Oct
6500
750
8000
500
6000/month
1500/month
6000
10000
0
Mar
Apr
May
Jun
Jul
Aug
Sep
Nov
Dec
2000
750
Oct
Jan
1500
500
Nov
Feb
5500
750
Dec
Mar
8000
500
Jan
2500
750
Feb
Purchase answer to see full
attachment
