Question

1 Approved Answer

Posted on Sep 03, 2024

a Create Scenarios for Drum Lesson Revenue 1. Open Lessons. 2. Save the workbook with the name 5-Lessons-2. 3. The Drum Studio has decided to

a Create Scenarios for Drum Lesson Revenue 1. Open Lessons. 2. Save the workbook with the name 5-Lessons-2. 3. The Drum Studio has decided to create three models for an increase in the base hourly rate charged for lessons before deciding which base rate to use next year. Examine the Scenario Summary report shown in Figure 5.2. Create three scenarios to save the hourly base rates shown: Low Rate Increase, Mid Rate Increase, and High Rate Increase. 4. Generate a Scenario Summary report to show the monthly revenue for each class at the three hourly base rates. Hint: Use the range containing the monthly revenue as the Result cells. 5. Format the report by changing the fill colors and font colors and adding the descriptive text in row 7. Use your best judgment in choosing colors that match those shown in Figure 5.2. 6. Edit the Notes text in cell B20 so the sentence correctly references the highlighted color for changing cells. 7. Change the page layout to Landscape orientation and then print the Scenario Summary sheet. 0 1 Scenario Summary Current Values: Low Rate Increase Mid Rate Increase High Rate Increase Changing Cells: Base Rate 35.00 37.00 39.00 41.00 Result Cells Monthly revenue for each lesson assuming no change in number of registered studenta Basic Theory 350.00 370.00 390.00 410.00 BegRock 525.00 555.00 585.00 615.00 IntRock 312.00 328.00 344.00 360.00 AdvRock 172.00 180.00 188.00 196.00 Beglazz 630.00 666.00 702.00 738.00 Devjare 390.00 410.00 430.00 450.00 Single PedalBeats 770.00 814.00 858.00 902.00 Single PedalFills 525.00 555.00 585.00 BassDoubles 624.00 656.00 688.00 720.00 Monthly RevTotal 4.298.00 4.534.00 4.770.00 5.006 00 Notes Current Values column represents values of changing cells at time Scenario Summary Report was 2 13 14 15 16 17 615.00 18 19 THE DRUM STUDIO 2 MONTHLY DRUM LESSON REVENUE Registered Students 10 15 + 8 3 Class Hourly Rate 4. Basic Drum Theory 35.00 5 Beginner Rock Drumming 35.00 6 Intermediate Rock Drumming 39.00 7 Advanced Rock Drumming 43.00 8 Beginner Jazz Drumming 35.00 9 Developing Jazz Style 39.00 10 Single Pedal Drum Beats 35.00 Single Pedal Drum Fills 35.00 12 Bass Drum Doubles 39.00 13 TOTAL 14 15 Base hourly rate for all lessons: 35.00 4 18 10 22 15 16 Monthly Revenue 350.00 525.00 312.00 172.00 630.00 390.00 770.00 525.00 624.00 4,298.00 a Create Scenarios for Drum Lesson Revenue 1. Open Lessons 2. Save the workbook with the name 5-Lessons-2. 3. The Drum Studio has decided to create three models for an increase in the base hourly rate charged for lessons before deciding which base rate to use next year. Examine the Scenario Summary report shown in Figure 5.2. Create three scenarios to save the hourly base rates shown: Low Rate Increase, Mide Rate Increase, and High Rate Increase. 4. Generate a Scenario Summary report to show the monthly revenue for each class at the three hourly base rates. Hint: Use the range containing the monthly revenue as the Result cells. 5. Format the report by changing the fill colors and font colors and adding the descriptive text in row 7. Use your best judgment in choosing colors that match those shown in Figure 5.2. 6. Edit the Notes text in cell B20 so the sentence correctly references the highlighted color for changing cells. 7. Change the page layout to Landscape orientation and then print the Scenario Summary sheet 8. Save and then close 5-Lessons-2. Figure 5.2 Visual Benchmark 2 A B C D E 6 7 8 9 10 Scenario Summary Current Values Low Rate Increase Mid Rate Increase High Rate Changing Cells: Base Rate 35.00 37.00 39.00 Result Cells Monthly revenue for each lesson assuming no change in number of registered studere BasicTheory 350.00 370.00 390.00 41000 BegRock 525.00 555.00 585.00 61500 IntRock 312.00 328.00 34400 36000 Ad Rock 172.00 180.00 188.00 19.00 Beglan 630.00 666,00 702 00 738.00 Devjars 390.00 410.00 430.00 450.00 SinglePedalBeats 770.00 81400 858.00 902.00 SinglePedalFills 525.00 555.00 385.00 615.00 BassDoubles 62400 656.00 68400 720.00 Monthly RevTotal 4 298.00 4.514.00 Notes Current Values column representa values of changing cells at 4.770.00 time Scenario Summary Report was created. Changing cells for each scenario are highlighted to preen 12 13 14 15 16 17 18 5.000.00 19 20 B THE DRUM STUDIO 1 2 MONTHLY DRUM LESSON REVENUE Monthly Revenue Registered Students 10 15 8 4 3 Class Hourly Rate 4 Basic Drum Theory 35.00 5 Beginner Rock Drumming 35.00 6 Intermediate Rock Drumming 39.00 7 Advanced Rock Drumming 43.00 8 Beginner Jazz Drumming 35.00 9 Developing Jazz Style 39.00 10 Single Pedal Drum Beats 35.00 35.00 11 Single Pedal Drum Fills 39.00 12 Bass Drum Doubles 13 TOTAL 14 35.00 15 Base hourly rate for all lessons: 18 10 22 15 16 350.00 525.00 312.00 172.00 630.00 390.00 770.00 525.00 624.00 4,298.00 a Create Scenarios for Drum Lesson Revenue 1. Open Lessons. 2. Save the workbook with the name 5-Lessons-2. 3. The Drum Studio has decided to create three models for an increase in the base hourly rate charged for lessons before deciding which base rate to use next year. Examine the Scenario Summary report shown in Figure 5.2. Create three scenarios to save the hourly base rates shown: Low Rate Increase, Mid Rate Increase, and High Rate Increase. 4. Generate a Scenario Summary report to show the monthly revenue for each class at the three hourly base rates. Hint: Use the range containing the monthly revenue as the Result cells. 5. Format the report by changing the fill colors and font colors and adding the descriptive text in row 7. Use your best judgment in choosing colors that match those shown in Figure 5.2. 6. Edit the Notes text in cell B20 so the sentence correctly references the highlighted color for changing cells. 7. Change the page layout to Landscape orientation and then print the Scenario Summary sheet. 0 1 Scenario Summary Current Values: Low Rate Increase Mid Rate Increase High Rate Increase Changing Cells: Base Rate 35.00 37.00 39.00 41.00 Result Cells Monthly revenue for each lesson assuming no change in number of registered studenta Basic Theory 350.00 370.00 390.00 410.00 BegRock 525.00 555.00 585.00 615.00 IntRock 312.00 328.00 344.00 360.00 AdvRock 172.00 180.00 188.00 196.00 Beglazz 630.00 666.00 702.00 738.00 Devjare 390.00 410.00 430.00 450.00 Single PedalBeats 770.00 814.00 858.00 902.00 Single PedalFills 525.00 555.00 585.00 BassDoubles 624.00 656.00 688.00 720.00 Monthly RevTotal 4.298.00 4.534.00 4.770.00 5.006 00 Notes Current Values column represents values of changing cells at time Scenario Summary Report was 2 13 14 15 16 17 615.00 18 19 THE DRUM STUDIO 2 MONTHLY DRUM LESSON REVENUE Registered Students 10 15 + 8 3 Class Hourly Rate 4. Basic Drum Theory 35.00 5 Beginner Rock Drumming 35.00 6 Intermediate Rock Drumming 39.00 7 Advanced Rock Drumming 43.00 8 Beginner Jazz Drumming 35.00 9 Developing Jazz Style 39.00 10 Single Pedal Drum Beats 35.00 Single Pedal Drum Fills 35.00 12 Bass Drum Doubles 39.00 13 TOTAL 14 15 Base hourly rate for all lessons: 35.00 4 18 10 22 15 16 Monthly Revenue 350.00 525.00 312.00 172.00 630.00 390.00 770.00 525.00 624.00 4,298.00 a Create Scenarios for Drum Lesson Revenue 1. Open Lessons 2. Save the workbook with the name 5-Lessons-2. 3. The Drum Studio has decided to create three models for an increase in the base hourly rate charged for lessons before deciding which base rate to use next year. Examine the Scenario Summary report shown in Figure 5.2. Create three scenarios to save the hourly base rates shown: Low Rate Increase, Mide Rate Increase, and High Rate Increase. 4. Generate a Scenario Summary report to show the monthly revenue for each class at the three hourly base rates. Hint: Use the range containing the monthly revenue as the Result cells. 5. Format the report by changing the fill colors and font colors and adding the descriptive text in row 7. Use your best judgment in choosing colors that match those shown in Figure 5.2. 6. Edit the Notes text in cell B20 so the sentence correctly references the highlighted color for changing cells. 7. Change the page layout to Landscape orientation and then print the Scenario Summary sheet 8. Save and then close 5-Lessons-2. Figure 5.2 Visual Benchmark 2 A B C D E 6 7 8 9 10 Scenario Summary Current Values Low Rate Increase Mid Rate Increase High Rate Changing Cells: Base Rate 35.00 37.00 39.00 Result Cells Monthly revenue for each lesson assuming no change in number of registered studere BasicTheory 350.00 370.00 390.00 41000 BegRock 525.00 555.00 585.00 61500 IntRock 312.00 328.00 34400 36000 Ad Rock 172.00 180.00 188.00 19.00 Beglan 630.00 666,00 702 00 738.00 Devjars 390.00 410.00 430.00 450.00 SinglePedalBeats 770.00 81400 858.00 902.00 SinglePedalFills 525.00 555.00 385.00 615.00 BassDoubles 62400 656.00 68400 720.00 Monthly RevTotal 4 298.00 4.514.00 Notes Current Values column representa values of changing cells at 4.770.00 time Scenario Summary Report was created. Changing cells for each scenario are highlighted to preen 12 13 14 15 16 17 18 5.000.00 19 20 B THE DRUM STUDIO 1 2 MONTHLY DRUM LESSON REVENUE Monthly Revenue Registered Students 10 15 8 4 3 Class Hourly Rate 4 Basic Drum Theory 35.00 5 Beginner Rock Drumming 35.00 6 Intermediate Rock Drumming 39.00 7 Advanced Rock Drumming 43.00 8 Beginner Jazz Drumming 35.00 9 Developing Jazz Style 39.00 10 Single Pedal Drum Beats 35.00 35.00 11 Single Pedal Drum Fills 39.00 12 Bass Drum Doubles 13 TOTAL 14 35.00 15 Base hourly rate for all lessons: 18 10 22 15 16 350.00 525.00 312.00 172.00 630.00 390.00 770.00 525.00 624.00 4,298.00