Question: 1. Complete the question below using the Aggregate Excel planning tool (15 marks): Cut and paste the excel spreadsheet and include in your word document

1. Complete the question below using the Aggregate Excel planning tool (15 marks): Cut and paste the excel spreadsheet and include in your word document for upload. 3. Determine the total cost for the following plan given the following forecasts: LO Use steady regular output of 400 units per month, use overtime as needed for up to 40 units per month, and use subcontracting to make up any shortage. Unit costs are: Regular output =$25 Overtime =$40 Subcontract =$60 Inventory per month =$15
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
