The 2004 Springdale High School Spring Musical-Theatre Production Budget:

A theatre production exercise in budgeting production expenses and income projections using spreadsheets and graphs.

Student Instructions: Use the table on the back of this handout, listing expenses and income for our musical theatre production, to create a budget spreadsheet using MS Excel.

1)Use the data and the required calculations to enter the specific items into a spreadsheet, calculate totals, and answer the questions.

2)How you enter data in the spreadsheet may be determined by your answers to the questions so look the questions over first, determine what specific information (totals, projections, outcomes) the questions are asking for.

Then determine how to set up your spreadsheet.

3)Highlight your answers to questions and all calculated totals with a highlighter marker on your printed spreadsheet. Record answers to questions on the blanks provided.

4) Save the file to add post-production calculations based on actual ticket sales.

Student Questions: “What’s and what ifs…”

  1. What is the total production expense? ______
  2. What is the total projected income? ______
  3. What percentage of the total expense is each expense category?(on spreadsheet)
  4. What percentage of the total projected income is each income category?
  5. What percentage of the total projected income is the starting-funds amount? ______
  6. What item, total, and percentage of the projected income is not yet known?______, ______, ______
  7. What is the projectedprofit. ______
  8. Two expenses are listed as optional, if they were donated instead. Calculate the affect each of these donated items would have upon the total expenses and the total income.A. ______, ______/______

B. ______, ______/______

  1. Graph the income projections including the options as income (% of adjusted Gross).
  2. Calculate how these donated options affect the total projected profit. ______
  3. Post-production calculations: What were the total ticket sales? ______What percentage of the actual total income is this? ______
  4. What is the actual profit (next season’s starting funds)?______

Data

Production Expenses
Scenery (rental, materials, and construction) / $1000
Costume (rental, materials, and
construction) / $1000
Props (rental, materials and construction) / $1000
Tech equipment rental
(lights & sound) / $500
Makeup (bought) / $200
Scripts and Performance Rights / $300
Publicity (printing programs, posters, newspaper ads) / $600
Salaries (technician, choreographer, acting coach) / $1500
Refreshments (bought) / $400

Projected Production Income

Starting Funds (school, past profits) / $3500
Donations & Fundraising
Makeup (use own) / $2000
($200)
Program Advertising
/ $500
Refreshments (donated & sold) / $400-$600
Projected Ticket Sales (75% of all seating, 3 shows, 375 seats/show) / $5625