Data from the case and Exhibits has been entered into the boxes below. To facilitate your calculations and analysis, reorganize the data into information related to assumptions related to ticket receipts, variable costs, step costs and fixed costs. Hidden costs (for Case Analysis Q4 are already identified. Hint: use column C to classify the items as Reciepts), Variable), Step) or Fixed). Save your work. Use Data Sort to reorganize the information. Be sure to capture the label, classifciation, #, and additional information in your sort. Assumptions 50% $150 $200 Average occupancy per show Brochures and printing Copyright payment Estimated number of shows Estimated percentage of adult ticket Estimated percentage of student and senior ticket Facility fees Food during performances and rehearsals Hall rental per week, including practices and performance House management Lighting and sound Maximum capacity Number of sound technician hours per show Number of technical support hours per show One-time ticket set-up fee Price per ticket - adult Price per ticket - student and senior Publcity for various ads, interviews, Facebook ads, etc. Rental for rehearsal Sound technician (4-hour minimum) Technical support and lighting (4-hour minimum) Ticket convenience charges Hidden Costs Transporting stage dcor furniture Bookkeeping for production Marketing on social media service Graphic design for Kamala poster Rental cost of furniture Stage decoration service 70% 30% $2.lper ticket $575 Food for rehearsals + Food in-kind donation from Russo Farms $1,000 $60 per show $500 90 seats 1.5 hours per show 1.5 hours per show $30 $25 including $5 in fees $22 including $5 in fees $360 $300 $30 per hour $30 per hour $3 per ticket $500 $300 $300 $500 $200 $500 2 Estimated Ticket Sales 3 Ticket sales - # of adult tickets Ticket sales - # of student and senior tickets 5 Weighted Average number of tickets per show 35.0 [Display to 1 decimal point] 15.0 [Display to 1 decimal point] 50 [Display to nearest whole ticket] $25 $22 $23.50 (Display to nearest $.01 (one cent) [Display to nearest $1 (one dollar) 7 Estimated Ticket Revenues 8 Ticket receipts - per 1 adult ticket 9 Ticket receipts - per 1 student or senior ticket 10 Weighted Average Price per ticket 11 Total Ticket Receipts per show 12 13 Expenditures 14 Variable costs 15 Insert as many rows as needed to calculate variable costs Total Variable Costs per ticket 17 Total Variable Costs per show 18 19 Contribution margin per ticket 20 Contribution margin per show [Display to nearest $.01 (one cent) [Display to nearest $1 (one dollar)] [Display to nearest $.01 (one cent)] 22 Step costs (Etimate, then treat like Fixed Costs in CVP) Insert as many rows as needed to calculate step costs 24 Total Step Costs per show [Display to nearest $1 (one dollar)] 25 Fixed costs 28 Insert as many rows as needed to calculate fixed costs 29 Total fixed costs [Display to nearest $1 (one dollar)] 31 Cash and in-kind donation 32 Cash donation 33 Food in-kind donation 34 Total donations [Display to nearest $1 (one dollar)]
