Spreadsheet Suzy's Temporary Emlaye (SE), located in a boty, cant de moine crime boround check house for $1.40 per search whated cost of 532.000. A third party online security im offered to do a uma city arch for 800 per person with an annual service contract with STEI STEs forecastis 3400 seches next year should STE continue to do the searchin house accept the third party offer? Use the Excellerave to determine the best decision Hound your answer for the even quantity to the rest whole number and round your newer for the amount of saving to the west en hy since the demand forecast of 2.400 seates a select than the breakevente out the work. STESS by outsourcing Profitability Analysis Outsourcing Decision Technolory Choice Decision Quantity 11 000 10,000 Quantity 17.000 Quantity Produce In-House Option A Coit Fixed cost Unit cost $100,000.00 $12.00 Raed cost $250,000.00 $20.00 Fixed cost Unit cost $200,000.00 518 60 Unit cost Outsource Option Revenue Fixed cost Unit cost Fixed cost Unit cost $100,000.00 $21.00 Unit revenue 32000 SIS Total Cost Total Revenue Net Profit Profit or los $220,000.00 $200,000.00 520,000.00 ton Total In-House Production Cost 5490000.00 Total Outsourced Cost $420,000.00 Cost difference In-House - Outsourced 570,000.00 Economical Decision Outsource Total Cost Option A Total Cost Option Cost difference (Option A Option 1) Economical Decision $404.600.00 $231.000.00 S73.000.00 Option Spreadsheet Suzy's Temporary Emlaye (SE), located in a boty, cant de moine crime boround check house for $1.40 per search whated cost of 532.000. A third party online security im offered to do a uma city arch for 800 per person with an annual service contract with STEI STEs forecastis 3400 seches next year should STE continue to do the searchin house accept the third party offer? Use the Excellerave to determine the best decision Hound your answer for the even quantity to the rest whole number and round your newer for the amount of saving to the west en hy since the demand forecast of 2.400 seates a select than the breakevente out the work. STESS by outsourcing Profitability Analysis Outsourcing Decision Technolory Choice Decision Quantity 11 000 10,000 Quantity 17.000 Quantity Produce In-House Option A Coit Fixed cost Unit cost $100,000.00 $12.00 Raed cost $250,000.00 $20.00 Fixed cost Unit cost $200,000.00 518 60 Unit cost Outsource Option Revenue Fixed cost Unit cost Fixed cost Unit cost $100,000.00 $21.00 Unit revenue 32000 SIS Total Cost Total Revenue Net Profit Profit or los $220,000.00 $200,000.00 520,000.00 ton Total In-House Production Cost 5490000.00 Total Outsourced Cost $420,000.00 Cost difference In-House - Outsourced 570,000.00 Economical Decision Outsource Total Cost Option A Total Cost Option Cost difference (Option A Option 1) Economical Decision $404.600.00 $231.000.00 S73.000.00 Option
