Question: Please solve using excel as soon as possible and post the screen shot i will be very happy thanks 1. Complete the question below using
Please solve using excel as soon as possible and post the screen shot i will be very happy
thanks

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: 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
