use a monthly version of the annual amount? How will you be handling the monthly output for each month? Make sure that you read the problem for the costs because there is a hint! please show spreadsheet formulas

2. Determine the monthly aggregate plan for an annual forecast of 854,000 cars given the following table of information: 0 $14.00 $18.00 $32.00 Beginning Inventory Regular Time Rate per hour Overtime Rate per hour Subcontract Rate per hour $1.450 To hire each additional person $7.90 Carry Cost of Inventory $50.00 Back Orders Do not forget that you must convert the hourly rates to per car rates for the correct aggregate plan cost using our toy builds from class. The company does not want to carry back order since the cost of back orders cost is high. The company can complete a car about every 25 minutes on average. The company would allow overtime to cover any additional production or the company can hire additional people that can produce at 35 on average. Hint: What tool do you have to help solve output and costs? 2. Determine the monthly aggregate plan for an annual forecast of 854,000 cars given the following table of information: 0 $14.00 $18.00 $32.00 Beginning Inventory Regular Time Rate per hour Overtime Rate per hour Subcontract Rate per hour $1.450 To hire each additional person $7.90 Carry Cost of Inventory $50.00 Back Orders Do not forget that you must convert the hourly rates to per car rates for the correct aggregate plan cost using our toy builds from class. The company does not want to carry back order since the cost of back orders cost is high. The company can complete a car about every 25 minutes on average. The company would allow overtime to cover any additional production or the company can hire additional people that can produce at 35 on average. Hint: What tool do you have to help solve output and costs