The select tab options are proccess A or proccess B

ER Spreadsheet Samoset Fans, Inc. manufacturers its fan blades in-house. The owner, Betty Dice, doesn't outsource any fan parts except fan motors all other fans parts are made in-house. Their current process and its equipment are getting old. Maintenance and repair costs are increasing at seven percent per year. She and her company team are evaluating two new processes. The first process has an annual fixed cost of $790,000 and a variable cost of $13 per fan blade. The second process is more automated and requires an annual fixed cost of $1,300,000 and a variable cost of $11 per fan blade. The internal transfer cost of a fan blade is $21, and this helps the firm determine the total manufactured cost of a completed fan. Use the Excel template Break-Even in MindTap to answer the following questions: a. What is the break-even quantity between these two processes? Round your answer to the nearest whole number. fan blades b. If predicted demand for next year is 140,000 blades, what process do you recommend? Round your answers to the nearest dollar. Total cost of Process A: $ Total cost of Process B: $ So, -Select- v is recommended. What is the cost savings? Round your answer to the nearest dollar. $ C. What volume of demand does Samoset Fans, Inc need to make an internal profit on fan blades of $120,000, assuming they installed the process you recommend in part (b)? Round your answer to the nearest whole number. fan blades Cengage Learning. Not for commercial use. Break-Even Analysis Enter data only in yellow cells. Profitability Analysis Outsourcing Decision Technology Choice Decision Quantity 10,000 Quantity 12,000 Quantity 11,000 Cost Produce In-House Option A Fixed cost Fixed cost Unit cost $100,000.00 $12.00 Fixed cost $250,000.00 Unit cost $20.00 $200,000.00 $18.60 Unit cost Outsource Option B Revenue Fixed cost Fixed cost Unit cost $100,000.00 $21.00 Unit revenue $20.00 $35.00 Unit cost Total Cost Total Revenue Net Profit Profit or Loss $220,000.00 $200,000.00 -$20,000.00 Loss Total In-House Production Cost $490,000.00 Total Outsourced Cost $420,000.00 Cost difference (In-House - Outsourced) $70,000.00 Economical Decision Outsource Total Cost Option A Total Cost Option B Cost difference (Option A - Option B) Economical Decision $404,600.00 $331,000.00 $73,600.00 Option B