HONTHLY DRUM LESSON REVENUE Registered 3 Class 4 Basic Drum Theory Monthly Revenue Hourly Rate Students 35.00 10 350.00 5 Beginner Rock Drumming 6 Intermediate Rock Drumming 7 Advanced Rock Drumming 8 Beginner Jazz Drumming 9 Developing Jazz Style 10 Single Pedal Drum Beats II Single Pedal Drum Fills 12 Bass Drum Doubles 35.00 15 525.00 39.00 8 312.00 43.00 4 172.00 35.00 18 630.00 39.00 10 390.00 35.00 22 770.00 35.00 15 525.00 39.00 16 624.00 13 TOTAL 4,298.00 14 15 Base hourly rate for all lessons: 35.00 16 17 Monthly Save the workbook with the name 5-Lessons. The current worksheet is shown in Figure 5.1. The hourly rates in the B4:B12 are linked to the cell named BaseRate, which is cell B15. range For intermediate lessons and advanced lessons, $4 and $8, respectively, is added to the hourly base rate. The Drum Studio wants to earn $4,770 per month from teaching lessons (instead of the current total of $4,298). Use the Goal Seek feature to change the base hourly rate to the value required to reach the studio's target. Save, print, and then close 5-Lessons.