Use case study to solve excel sheets

A B C D E F G H - J 21-Speed Gizmos N High Medium Low 3 Retail Price $124.95 $99.95 $74.95 4 Expected demand 25000 37500 55000 5 6 Variable Cost Data: 7 8 9 10 Fixed Cost Data: 11 12 13 14 15 Distributor Margin: 30% 16 17 Q1: CALCULATE MANUFACTURER PRICE High Medium Low 18 19 Manufacturer Price: 20 21 22 23A B C D E F G H J K L M N 21-Speed Gizmos High Medium Low W N Retail Price $124.95 $99.95 $74.95 Expected demand 25000 37500 55000 VOUA Variable Cost Data: CO 9 10 11 Fixed Cost Data: 12 13 14 15 16 17 Distributor Margin: 30% 18 19 Q3: WHAT IS THE NET PROFIT AT EACH PRICE POINT? HOW WOULD YOU PRICE the DCS? 20 21 High Medium Low 22 Total Revenue: 23 24 Total Variable Cost 25 26 Total Contribution: 27 28 Total Fixed Costs: 29 30 Net Profit Before Taxes: 31A B C D E F G H I J K L M 21-Speed Gizmos High Medium Low Retail Price $124.95 $99.95 $74.95 OUT A W N - Expected demand 25000 37500 55000 Variable Cost Data: CO 00 10 11 Fixed Cost Data: 12 13 14 15 16 17 Distributor Margin: 30% 18 19 Q2: WHAT IS THE BREAK-EVEN VOLUME AT EACH PRICE POINT? 20 21 Selling Price: 22 23 Unit Variable Costs: 24 25 Unit Contribution: 26 27 28 Total Fixed Costs: 29 30 31 Break-even Volume: 32 33 34 35 36