ALT-BE-CHART Choose Exercise (1 only) 5 7 PRICE/UNIT $10 VARIABLE COST/UNIT 6 CONTRIBUTION MARGIN/UNI $4 0 1 FIXED COSTS 100,000 12 Gr 1 VOLUME (UNITS) 5,000 13 0 10,000 15,000 20,000 25,000 30,000 14 2 TOTAL REVENUE 15 3 FIXED COSTS 16 4 TOTAL VARIABLE COSTS 17 5 TOTAL COSTS 18 6 OPERATING INCOME 19 20 Column C Formulas 21 1 VOLUME (UNITS) Enter 0 in C13; enter 5,000 in D13. Select both cells. Click and drag the fill handle to the right 22 2 TOTAL REVENUE C13 SC$7, then copy to right 23 Bre 3 FIXED COSTS SC$11, then copy to right. 24 4 TOTAL VARIABLE COSTS C13 SC$8, then copy to right $1 25 S TOTAL COSTS C15 C16 26 $1 6 OPERATING INCOME C14-C17 27 $1 What is the breakeven point in units? 28 0 29 $1 What is the breakeven point in revenue? 30 0 S0 31 32 S0 33 R S T Q M N G H J K D E 10 6 $4 00 Grade table 20,000 5,000 10,000 15,000 25,000 30,000 0 0 0 C 0 Formulas in C13; enter 5,000 in D13. Select both cells. Click and drag the fill handle to the right. SCS7, then copy to right Breakeven Chart 1, than copy to right SCS8, than copy to right $1 C16 $1 C17 $1 its? S1 venue? 0 S0 50 50 5,000 10,000 15,000 20,000 25,000 30,000 35,000 TOTALREVENUE FIXED COSTS TOTAL COSTS