1. Mike wants to determine the impact of different advertising approaches and answer the following questions:
   1. How many units of Tournament disks should be sold by Word of Mouth in order for this disk type to break even?
2. 2. What should the Price per Unit be set at in order for the Supreme disks to break even?
   3. What Excel feature did you use to answer these questions?

00 B C D E F Income Statement 2 NOWN 5 Revenue Units Sold Based on Word of Mouth Units Sold Based on Advertising Total Units Sold Price per Unit Total Regular 2100 205 2305 $12.00 $27,664.60 High Flyer 2050 205 2255 $20.00 $45,107.67 Tournament 1750 205 1955 $24.00 $46,929.21 Supreme Total 1000 6900 205 822 1205 7722 $32.00 $22.00 $38,572.28 $158.273.76 Regular 2.535.92 $5.00 $12,679.61 High Flyer 2,480.92 $10.00 $24,809.22 Tournament Supreme 2,150.92 1,325.92 $16.00 $20.00 $34,414.75 $26,518.44 Total 8,493.69 $12.75 $98,422.02 10 Variable Expenses 11 Units Produced To Cover Demand 12 Cost per Unit 13 Total 14 15 Fixed Expenses 16 Insurance and maintenance 17 Other Overhead 18 Advertising 19 Total 20 21 Income Summary 22 Total Revenue 23 Total Expenses 24 Net Income Regular $3,000.00 $6,000.00 $1,000.00 $10,000.00 High Flyer $5,000.00 $8,500.00 $1,000.00 $14,500.00 Tournament Supreme Total $6,000.00 $10,000.00 $24,000.00 $12,000.00 $18,000.00 $44,500.00 $1,000.00 $1,000.00 $4,000.00 $19,000.00 $29,000.00 $72,500.00 Regular $27,664.60 $22,679.61 $4,984.99 High Flyer $45,107.67 $39,309.22 $5.798.45 Tournament Supreme Total $46.929.21 $38,572.28 $158,273.76 $53,414.75 $55,518.44 $170,922.02 ($6,485.54) ($16,946.16) ($12,648.26) B C D E F H J 2 3 Increase in Sales based on Advertising . 75 3,000 2,500 2,000 Advertising () Increase in Units Sold $0 0 $500 $1,000 206 $1,500 408 $2.000 689 $2,500 1,040 $3,000 1,432 $3,500 1,824 $4,000 2,175 $4,500 2,456 $5,000 2,658 $5,500 2,789 $6,000 2,864 $6,500 2,903 $7,000 2,921 $7,500 2,928 $8,000 2,931 $8,500 2,932 $9,000 2,932 $9,500 2,932 $10,000 2,932 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Increase in Units Sold 1,500 1,000 500 50 $2,000 $4,000 $6,000 $8,000 $10,000 Advertising Dollars