I need someone that knows solver for excel with parameters

profilefamar
week_6_willie_tankom_503_aggregate_planning.xlsx
Home>Business & Finance homework help>Economics homework help>I need someone that knows solver for excel with parameters

Part a

Problem 8(Part a)
Month May Jun July August September October Total
Forecast 4,000 4,800 5,600 7,200 6,400 5,000 33,000
Output
Regular 5,000 5,000 5,000 5,000 5,000 5,000 30,000
Overtime 1,600 1,400 3000
Output- forcast 1,000 200 -600 -600 0 0 0
Inventry
Begning 1,000 1,200 600 0 0
Ending 1,000 1,200 600 0 0 0
Average 500 1100 900 300 0 0 2800
Backlog 0 0 0 0 0 0 0
Cost
Regular 10 10 10 10 10 10 300000
Overtime 16 16 16 16 16 16 48000
Inventry 1 1 1 1 1 1 2800
Total 350800

Part b

Problem 8 (Part b)
Month May Jun July August September October Total
Forecast 4,000 4,800 5,600 7,200 6,400 5,000 33,000
Output
Regular 5,000 5,000 5,000 5,000 5,000 5,000 30,000
Overtime 500 500 500 500 500 0 2500
Suncontract 0 0 0 0 500 0 500
Output- forcast 1,500 700 -100 -1,700 -400 0 0
Inventry
Beginning 1,500 2,200 2,100 400 0
Ending 1,500 2,200 2,100 400 0 0
Average 750 1850 2150 1250 200 0 6200
Backlog 0 0 0 0 0 0 0
Cost
Regular 10 10 10 10 10 10 300000
Overtime 16 16 16 16 16 16 40000
Subcontract 20 20 20 20 20 20 10000
Inventry 1 1 1 1 1 1 6200
Back Orders 0 0 0 0 0 0 0
Total 356200

Part c

Problem 8 (Part c)
Month May Jun July August September October Total
Forecast 4,000 4,800 5,600 7,200 6,400 5,000 33,000
Output
Regular 5,000 5,000 5,000 5,000 5,000 5,000 30,000
Overtime 750 750 750 750 0 3000
Output- forcast 1,000 950 150 -1,450 -650 0 0
Inventry
Beginning 1,000 1,950 2,100 950 0
Ending 1,000 1,950 2,100 950 0 0
Average 500 1475 2025 1375 325 0 5700
Cost
Regular 10 10 10 10 10 10 300000
Overtime 16 16 16 16 16 16 48000
Inventry 1 1 1 1 1 1 5700
Back Orders 10 10 10 10 10 10 300000
Total 653700

Sheet1