Read the entire Case

Prepare the Assumptions sections of the Budget Template to familiarize yourself with SETU's Cost Structure.

Complete the rest of the budget template (that responds to Case Question #1)

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)

Copy your completed Schedules on the Solution 2-a-b tab to the Solution 2x 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 proper cells so you can reply on the results.

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.

Copy your completed schedules on the Solution 2a-b tab to the Solution 2e tab

a. Now include the revenue from donations in breakeven calculations

b. Confirm that all of your previous formulas are linked to proper cells so you can reply on the results.

Enter your explanation to question 2f on the Solution 2f tab

Use the template on the Solution 3a-c tab. Complete the cells in accordance with color codes.