Question
Hints for completing Assignment #1: The Show Must Go On. 1. Read the entire case 2. Prepare the Assumptions section of the Budget Template
Hints for completing Assignment #1: The Show Must Go On. 1. Read the entire case 2. Prepare the Assumptions section of the Budget Template to familiarize yourself with SETU's cost structure. 3. Complete the rest of the budget template (that responds to Case Question #1) 4. Use the template on the Solution 2a-b tab. Complete the cells in accordance with the color codes. Be sure and leave any revenue from donations OUT of the breakeven calculation (ticket revenue only). 5. Copy your completed schedules on the Solution 2-a-b tab to the Solution 2c tab and then a. Change the number of shows to 3 instead of 4 b. Confirm that all of your previous formulas are linked to the proper cells so you can reply on the results 6. Copy your completed schedules on the Solution 2a-b tab to the Solution 2d tab a. Now include the revenue from donations in the breakeven calculation b. Confirm that all of your previous formulas are linked to the proper cells so you can reply on the results 7. Copy your completed schedules on the Solution 2c tab to the Solution 2e tab a. Now include the revenue from donations in the breakeven calculation b. Confirm that all of your previous formulas are linked to the proper cells so you can reply on the results 8. Enter your explanation to question 2f on the Solution 2f tab. 9. Use the template on the Solution 3a-c tab. Complete the cells in accordance with the color codes. 10. You are done. You do not need to complete any other questions.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started