Break Even

G B C D E F H 1 J K 1 1 For each of the following, calculate the Break Even point in # of Units. (Where sales equal costs) 2 2 Save and upload to Break Even 3 4 Sales Units Total Dollars Sales Units Total Dollars 5 $60 /unit $50 /unit 6 Costs (per Year) Costs (per Year) Rent $65,100 Rent $65,215 8 Utilities $32,560 Utilities $32,500 9 Insurance $45,800 Insurance $45,800 10 Supplies $4,590 Supplies $4,350 11 Advertising $31,500 Advertising $31,500 12 Labor $15 /unit Labor $14 /unit 13 Overhead $7 /unit Overhead $7 /unit 14 15 16 17 Sales Units Total Dollars Sales Units Total Dollars 18 $100 /unit $250 /unit 19 Costs (per Year) Costs (per Year) 20 Rent $65,183 Rent $65,050 21 Utilities $32,540 Utilities $32,550 22 Insurance $8,700 Insurance $45,800 23 Supplies Supplies $4,581 24 Advertising $31,505 Advertising $31,539 25 Labor $28 /unit Labor $27 /unit 26 Overhead $9 /unit Overhead $19 /unit 27 28 29 30 Units Total Dollars Sales Units Total Dollars 31 $5 /unit $2 /unit 32 Costs (per Year) 33 Rent $65,000 Rent $65,250 34 Utilities $32,500 Utilities $32,500 35 Insurance $45,800 Insurance $45,550 36 Supplies $4,580 Supplies $4,584 37 Advertising $31,500 Advertising $31,500 38 Labor $2 /unit Labor $0.57 /unit 39 Overhead $1 /unit Overhead $0.07 /unit 40 41 $4,515