Attached is a PDF file describing What is the spread sheet model and an application example of the spreadsheet model to Nowlin plastics. In the application example, the manufacturing fixed cost is listed $ 234,000. Suppose the manufacturing fixed cost increases to $ 240,000 . All other information remains same. In this extra credit, you develop the spreadsheet model using the changed information C Manufacturing fixed cost from $234,000 to $ 240,000) and generate the new Solution. Answer the following questions based on the new solution. QI. Total cost to produce = $ 02. Total cost to outsource = $ Q3. Savings due to Outsourcing = $ Q4. The savings due to outsourcing at 150,000 units 05. For 75,00 Vipers at a cost of $3.13 per unit, the savings from buying versus manufacturing the units is $ (Referto Figure 10.1) - B C A 1 Nowlin Plastics I 3 Parameters 4 Manufacturing Fixed Cost 5 Manufacturing Variable Cost per Unit Outsourcing Coster Unit 10 Model u Quantity 100001 13 Total Cost to produce -B4.BII B5 15 Total Cost to Outsource B7 BII 17 Savings due to Outsourcing =BIBIS 1 Nowlin Plastics 3 Parameters 4 Manufacturing Fixed Cost 5 Manufacturing Variable Cost per Unit $234.000.00 MODEL file Nowlin 7 Outsourcing Cost per Unit 10 Model 11 Quantity 10,000 13 Total Cost to produce $294.000.00 15 Total Cost to Outsource $15.000.00 17) Savings due to Outsourcing I 5219.000.00