Larry is director and lead dancer of Larry and the Lions, a famous pole dancing troupe. Larry is starting an off-Broadway revival of the musical Cats, but with pole dancing. Naturally, it will be called Pole Cats. A dream come true!
Larry's friend Ben, a well-known architect, has an idea for a new theater design. Theaters usually separate the performers and the audience, like this:
For Pole Cats, Ben wants to replace the stage and the seats with ten microstages, scattered around the space.
The audience will be free to wander around, as the story unfolds on the microstages.
Some of the microstages will have poles, and some will not, as the drawing shows (poles are not to scale). Those with poles will also have tip jars.
Most aspects of the design are nailed down, but Larry and Ben aren't sure how many microstages should have poles, and how many should not. Write an Excel worksheet to help them figure out what to do. You can download a starter worksheet. Remember to save it on your PC before you open it.
The worksheet estimates profit for each performance. It starts like this:
There are three inputs you should validate:
- Number of microstages with poles.
- Number of microstages without poles.
- Number of tickets sold.
All must be numbers that are zero or more. If there's an error, show a message and stop the program. Here's an example:
There are ten microstages, so the number with poles, plus the number without poles, must add up to ten.
The theater is small, so the number of tickets sold cannot be more than 700.
The worksheet should show four outputs, like this:
Another example:
Tickets are $42 each.
Estimated tips depend on the number of people in the audience (that is, the number of tickets sold), and the number of microstages with poles. Larry estimates that there will be $4 in tips for each ticket sold, for each pole-enhanced stage. So, the code is something like:
tips = ticketsSold * withPoles * 4
Each pole has to be cleaned, straightened, and anchored after each performance. That costs $300 per pole.
Production costs are $15,800 per performance.
So, profit is ticket revenue, plus tips, minus pole cost, minus production costs.
Write the code, and upload your solution.
Hint: make all numbers single, rather than integer.
(If you were logged in as a student, you could submit an exercise solution, and get some feedback.)
