Home Insert Page Layout Formulas Data Review View Cut A A Calibri (Body) 11 Copy T B Paste I U Forma

Home Insert Page Layout Formulas Data Review View Cut A A Calibri (Body) 11 Copy T B Paste I U Format fx Tracey Excel MAC Version A1 A C D E F G H 1 Tracey Excel MAC Version Name Variable and Fixed Costs 2 Enter a formula or cell reference in every yellow cell Tracey Company manufactures and sells a single product. Apartially completed schedule of the company's total and per unit costs over a relevant range of 60,000 to 100,000 units produced and sold each year is given below 3 4 6 7 Units produced and sold 60,000 80,000 100,000 9 10 Total costs: 11 Variable costs $150,000 $200,000 12 Fixed costs 360,000 360,000 13 Total costs $510,000 $560,000 14 15 Cost per unit 16 Variable cost $2.50 17 Fixed cost $6.00 18 Total cost per unit $8.50 19 20 Required: 1. Complete the schedule above of the company's total and unit costs. 21 22 2. Assume that the company produces and sells 90,000 units during the year at a selling price 23 of $7.50 per unit. Prepare a contribution format income statement for the year 24 25 26 Sales in units 90,000 Sales price per unit $7.50 27 28 29 Sales 30 Variable expenses 31 Contribution margin Fixed expenses 32 33 Net operating income 34 35 36 37 38