Please submit as a single Excel file. To receive credit,appropriate detail needs to be provided. In addition, aprofessional presentation of findings is important.
#1 Determine the total cost forthis plan given the following forecast:
Month 1 2 3 4 5 6
Forecast 380 400 420 440 460 480
Use steady regular output of 400 units per month, use overtimeas needed for up to 40 units per month, and use subcontracting tomake up any needed output to match the forecast. Unit costsare:
Regular output $25
Overtime $40
Subcontract $60
Average Balance Inventory $15
Expert Answer
A solution will be send to your mail shortly . . . .