Class #5 Aggregate Planning Assignment - 1 Excel (2)

.xlsx
School
University of California, Irvine **We aren't endorsed by this school
Course
BUSINESS 290
Subject
Economics
Date
Oct 17, 2023
Pages
1
Uploaded by dhruvkhanna958 on coursehero.com
Aggregate Planning Number of periods: 6 Period 1 2 3 4 5 6 Total Forecast 110 110 140 140 160 160 820 Output Regular 120 120 120 120 120 120 720 Part Time 0 0 16 16 28 31 91 Overtime 0 0 0 0 0 0 0 Subcontract 0 0 0 0 0 0 0 Output - Forecast 10 10 -4 -4 -12 -9 -9 Inventory Beginning 0 10 20 16 12 0 Ending 10 20 16 12 0 0 Average 5.0 15.0 17.8 13.8 6.0 0.0 58 Backlog 0 0 0 0 0 9 9 Costs: Regular @ 15 1,800 1,800 1,800 1,800 1,800 1,800 10,800 Part Time @ 18 0 0 282 294 504 552 1,632 Overtime @ 20 0 0 0 0 0 0 0 Subcontract @ 30 0 0 0 0 0 0 0 Hire/Layoff 0 0 0 0 0 0 0 Inventory @ 5 25.0 75.0 89.2 69.2 30.0 0.0 288 Back orders @ 20 0 0 0 0 0 187 187 Total 1,825.0 1,875.0 2,171.3 2,163.2 2,333.9 2,538.7 12,907 1 2 3 4 5 6 Cumulative Forecast 200 400 700 1,300 1,800 2,100 Cumulative Production 300 600 900 1,200 1,500 1,800 Ending Inventory 100 200 200 Backlog 100 300 300
Page1of 1
Uploaded by dhruvkhanna958 on coursehero.com