Must be done in excel

y 1or $160,000. Would you of 30,000 units, or would you close it? Sup- pate computations. Problem omprehensive problem including special order, outsourcing, and LO 6-2.6-3 segment elimination decisions Bain Corporation makes and sells st The Math Machine, an inexpensive calculator. The company's chief accountant recenty prepared the CHECK FIGURE following income statement showing annual revenues and expenses associated with the segment's a.CM: $6,000 operating activities. The relevant range for the production and sale of the calculators is between 30,000 and 60.000 units per year. Revenue (40,000 units $10.80) Unit-level variable costs $432,000 Materials cost (40,000 $2.70) Labor cost (40,000 $1.20) Manufacturing overhead (40,000 $1.20) Shipping and handling (40,000 $0.30) Sales commissions (40,000 $1.20) (108,000) (48,000) (48,000) (12,000) (48,000) 168,000 Contribution margin Fixed expenses Advertising costs Salary of production supervisor Allocated companywide facility-level expenses (24,000) (72,000) (96,000) $(24.000) Net loss