How to lower cost: MIX AGGREGATE PLAN extra credit

Period $123456782925024750$

Forecast $2624527110295103749049030518154080536845$

Production level: $83\mathrm{.}01777778?$

Regular Time $303735837357382503825038250382503825038250$

Overtime $45$

Subcontract $125$

Total Production $3735737357382503825038250382503825038250$ max level of workers $85$

Number of Workers $55838385858585858518$

Inventory

Beginning $3000141122435933099338592307995146959$ workers more needed $29$

Ending $30001411224359330993385923079951469598364$ max overtime hours $100$

Average $855619235\mathrm{.}528729334792846916296\mathrm{.}58236\mathrm{.}57661\mathrm{.}5$ max reg hours $450$

Backlog

max overtime production $8500$

Labor Costs

Regular $3011207101120710114750011475001147500114750011475001147500$

Overtime $4500000000$

Subcontract $12500000000$ subcontract price $0$

Hire $2000560000400000000$

Fire $140000000000$

Total Labor Cost $11767101120710115150011475001147500114750011475001147500$

Inventory Costs

Holding Cost $1855619235\mathrm{.}528729334792846916296\mathrm{.}58236\mathrm{.}57661\mathrm{.}5$

Back Order $10000000000$

Total Production Cost $11852661139945\mathrm{.}51180229118097911759691163796\mathrm{.}51155736\mathrm{.}51155161\mathrm{.}5$

Total Cost $$9,337,083\mathrm{.}00$

target: $9,055,000$