ALT-BE-CHART Choose Exercise (1 only) PRICE/UNIT $10 VARIABLE COST/UNIT 6 CONTRIBUTION MARGIN/UNIT $4 FIXED COSTS 100,000 Grade table: 1 VOLUME (UNITS) 0 5,000 10,000 15,000 20,000 25,000 30,000 0 5,000 10000 15,000 20000 25,000 30000 2 TOTAL REVENUE 1 0 0 0 0 3 FIXED COSTS ol 0 4 TOTAL VARIABLE COSTS 1 0 5 TOTAL COSTS o o 6 OPERATING INCOME Column C Formulas 1 VOLUME (UNITS) Enter 0 in C13; enter 5,000 in D13. Select both cells. Click and drag the fill handle to the right. 2 TOTAL REVENUE =C13*$C$7, then copy to right. 3 FIXED COSTS =$C$11, then copy to right. Breakeven Chart 4 TOTAL VARIABLE COSTS =C13*$C$8, then copy to right. $1 5 TOTAL COSTS =C15+C16 6 OPERATING INCOME =C14-C17 $1 S1 What is the breakeven point in units? 0 $1 What is the breakeven point in revenue? 0 SO SO SO 5,000 10,000 15,000 20,000 25,000 30,000 35,000