Answer Happy

Fixed Cost, FC = $25,000 Material Cost per Unit, MC = $2.15 Labor Cost per Unit, LC = $2.00 Outsourcing Cost per Unit, O = $4.50 Build a spreadsheet model and then use a two-way data table to show how the savings due to outsourcing changes as a function of different production volume and different bids on per-unit cost for outsourcing. Vary the production volume from 0 to 100,000 in increments of 10,000. The six bids are $3.11, $3.49, $4.50, $4.98, $5.12, and $5.45. Instructions: 1. Download the spreadsheet template for Avengers.xlsx. Fill in the parts in yellow. 2. Complete the parameters (2 pts). 3. Compute total cost to produce (1 pts). 4. Compute total cost to outsource (1 pts). 5. Compute savings due tp outsourcing (1 pts). 6. Complete the two way table to show the different values of savings from outsourcing (5 pts). 7. Upload your spreadsheet to this canvas question.
125% VE Tol Chart Text Shape Mochi Co Sheet1 Parameters Outsourcing Cost per unit Production Food Cost Material Cost per unit Labor Cost per unit Model Production Volume 30000 Total cost to outsource Total fue cost Total material cost Total labor cost Total cost to produce Savings due to outsource esc 1 с
125 Sheet Sheet Na 3.09 45 4.98 5.12 Sheet1 Backgrour Outsourcing cost per unit 0 3.11 0 10000 20000 30000 40000 50000 60000 70000 80000 90000 100000 esc c