ACCTG University of Phoenix Accounting Management Case Project Worksheet I need someone to answer one question for my group project and its 2F. Here are th

ACCTG University of Phoenix Accounting Management Case Project Worksheet I need someone to answer one question for my group project and its 2F. Here are the instructions Please read over them. Its only one part of the group project and its very short. Please review Exhibit 1. Summary of the Contract With Mosesian Center for the Arts Black Box Theat
Service
Hall rental per week, including practices and performance
One-time ticket set-up fee
Technical support and lighting (4-hour minimum)
Sound techinician (4-hour minimum)
House management
Facility fees
Ticket convenience charges
Fee
$1,000
$30
$30
$30
$60
$2
$3
*SETU would have to pay a minimum of 4 hours ($120) even if SETU does not use 4 hours of technical support and lighting.
**SETU would have to pay minimum of 4 hours ($120) even if SETU does not use 4 hours of sound technician.
Center for the Arts Black Box Theater
Hours per show
per hour
per hour
per show
per ticket
per ticket
s of technical support and lighting.
s of sound technician.
1.5 *
1.5 **
Exhibit 3. Assumptions for Estimating Ticket Sales and Receipts
Estimated number of shows
Price per ticket – adult
Price per ticket – student and senior
Estimated percentage of adult ticket
Estimated percentage of student and senior ticket
Maximum capacity
Average occupancy per show
4
$25 including $5 in fees
$22 including $5 in fees
70%
30%
90 seats
50%
Color Scheme for Exhibit TN1
Data Entry
For cells in this color, find the numerical information in
the case and enter the correct number.
Calculations
For cells in this color, calculate the answer based on
information found in other colored cells.
Assumptions
Ticket sales assumptions
Estimated number of shows
Price per ticket – adult
Price per ticket – student and senior
Estimated percentage of adult ticket
Estimated percentage of student and senior ticket
Maximum capacity
Average occupancy per show
Variable costs assumptions
Facility fees
Ticket convenience charges
Step costs assumptions
Technical support and lighting (4-hour minimum)
Number of technical support hours per show
Sound technician (4-hour minimum)
Number of sound technician hours per show
House management
4
$25 including $5 in fees
$22 including $5 in fees
70%
30%
90 seats
50%
$2 per ticket
$3 per ticket
$30 per hour
1.5
$30 per hour
1.5
$60 per show
Budgeted Statement Based on Four Shows
SETU (Stage Ensemble Theater Unit, Inc.)
Kamala at the Mosesian Center for the Arts Black Box Theater – March 31, April 1, and Apr
RECEIPTS
Black Box Theater, including adults, students, and seniors
TOTAL ESTIMATED TICKET RECEIPTS
Budget
$4,338
$4,338
Actual
Cash donation
In-kind food donation
Cash and In-Kind Food Donations Total
TOTAL BUDGETED RECEIPTS
$200
$300
$500
$4,338
ch 31, April 1, and April 2, 2017
EXPENDITURE
Total Variable Costs
Budget
$ 900
Total Contribution Margin
$ 3,438
Step Costs: From Solution to Question 2b
Technical support and lighting (4-hour minimum)
Sound technician (4-hour minimum)
House management
Total Step Costs
Fixed Costs:
Hall rental per week, including practices and performance
One-time ticket set-up fee
Rental for rehearsal
Stage decoration and transportation of décor
Additional light and sound
Brochures and printing
Publcity for various ads, interviews, Facebook ads, etc.
Make-up
Food during performances and rehearsals
Copyright payment
Other
180
180
240
$
600
1,000
$30
$300
$500
$150
$360
$275
$200
Total step and fixed costs
$ 3,415
Operating Income Before Donations
$
23
NET OPERATING INCOME ESTIMATED
$
523
Actual
Appendix TN2. Solutions for Questions 2a and 2b
Service
Fixed Costs assumptions
Hall rental per week, including practices and performance
One-time ticket set-up fee
Step costs assumptions
Technical support and lighting (4-hour minimum)
Sound techinician (4-hour minimum)
House management
Variable costs assumptions
Facility fees
Ticket convenience charges
From Case Exhibit 1
$1,000
$30
hrs per show
$30 per hour
1.5 *
$30 per hour
1.5 **
$60 per show
$2 per ticket
$3 per ticket
Ticket sales assumptions
Estimated number of shows
Price per ticket – adult
Price per ticket – student and senior
Estimated percentage of adult ticket
Estimated percentage of student and senior ticket
Maximum capacity
Average occupancy per show
From Case Exhibit 3
4
$25
$22
70%
30%
90 seats
50%
Budget
Ticket sales – adult
Ticket sales – student and senior
Total number of tickets
Calculated based on information provided in Case Exhibits 1 an
126
54
180
Receipts
Ticket receipts – adult
Ticket receipts – student and senior
Total Receipts
Expenditures
Variable costs
Facility fees
Ticket convenience charges
Total Variable Costs
Contribution margin
Step costs
Technical support and lighting (4-hour minimum)
Sound technician (4-hour minimum)
3,150
1,188
$4,338
360
540
$900
$3,438 Total Receipts – Total Variable Costs
180 From Case Exhibit 1 ($30 per hour × 1.5 hours per sh
180 Use the formula in the cell above to help you determ
House management
Fixed costs
Hall rental per week, including practices and performance
One-time ticket set-up fee
Rental for rehearsal
Stage decoration and transportation of décor
Additional light and sound
Brochures and printing
Publcity for various ads, interviews, Facebook ads, etc.
Make-up
Food during performances and rehearsals
Copyright payment
Other
Total step and fixed costs
Operating Income Before Donations
Cash and in-kind donation
Cash donation
Food in-kind donation
Total donations
Net operating income
Calculate breakeven
Average price per ticket
Average variable cost per ticket
Average contribution margin
Number of tickets needed to break even
Ticket receipts needed to break even
Average number of tickets needed to break even per show
Break-even occupancy
240
From Case Descriptions
$1,000
$30
$300
0
$500
$150
$360
0
$275
$200
$0
$3,415
$23 Contribution Margin – Total Step and Fixed Costs
$0
$0
$0
$23 Operating income before donations + Total donation
$24.10
$5.00
$19.10
179
$4,314
44.75
50%
Get information from Case Exhibit 1 (use formulas, do not retype amounts)
Get information from Case Exhibit 3 (use formulas, do not retype amounts)
Use information on this sheet to prepare a formula to compute this amount
Get information from the text of the case (you’ll need to type these amounts)
n provided in Case Exhibits 1 and 3
$30 per hour × 1.5 hours per show × 4 shows)
e cell above to help you determine the formula for this cell
Breakeven point in # of tix for three shows: 59.667
Breakeven point in USD:
Service
Fixed Costs assumptions
Hall rental per week, including practices and performance
One-time ticket set-up fee
Step costs assumptions
Technical support and lighting (4-hour minimum)
Sound techinician (4-hour minimum)
House management
Variable costs assumptions
Facility fees
Ticket convenience charges
(60 tickets must be sold per show)
1146 ($1146 USD in ticket sales must be sold per show)
From Case Exhibit 1
$1,000
$30
hrs per show
$30 per hour
1.5 *
$30 per hour
1.5 **
$60 per show
$2 per ticket
$3 per ticket
Ticket sales assumptions
Estimated number of shows
Price per ticket – adult
Price per ticket – student and senior
Estimated percentage of adult ticket
Estimated percentage of student and senior ticket
Maximum capacity
Average occupancy per show
From Case Exhibit 3
3
$25
$22
70%
30%
90 seats
50%
Budget
Ticket sales – adult
Ticket sales – student and senior
Total number of tickets
Calculated based on information provided in Case Exhibits 1 an
95
41
135
Receipts
Ticket receipts – adult
Ticket receipts – student and senior
Total Receipts
Expenditures
Variable costs
Facility fees
Ticket convenience charges
Total Variable Costs
Contribution margin
Step costs
Technical support and lighting (4-hour minimum)
Sound technician (4-hour minimum)
2,363
891
$3,254
270
405
$675
$2,579 Total Receipts – Total Variable Costs
135 From Case Exhibit 1 ($30 per hour × 1.5 hours per sho
135 Use the formula in the cell above to help you determ
House management
Fixed costs
Hall rental per week, including practices and performance
One-time ticket set-up fee
Rental for rehearsal
Stage decoration and transportation of décor
Additional light and sound
Brochures and printing
Publcity for various ads, interviews, Facebook ads, etc.
Make-up
Food during performances and rehearsals
Copyright payment
Other
Total step and fixed costs
Operating Income Before Donations
Cash and in-kind donation
Cash donation
Food in-kind donation
Total donations
Net operating income
Calculate breakeven
Average price per ticket
Average variable cost per ticket
Average contribution margin
Number of tickets needed to break even
Ticket receipts needed to break even
Average number of tickets needed to break even per show
Break-even occupancy
180
From Case Descriptions
$1,000
$30
$300
0
$500
$150
$360
0
$275
$200
$0
$3,265
($687) Contribution Margin – Total Step and Fixed Costs
$0
$0
$0
($687) Operating income before donations + Total donations
$24.10
$5.00
$19.10
171
$4,121
57.00
63%
e cell above to help you determine the formula for this cell
Service
Fixed Costs assumptions
Hall rental per week, including practices and performance
One-time ticket set-up fee
Step costs assumptions
Technical support and lighting (4-hour minimum)
Sound techinician (4-hour minimum)
House management
Variable costs assumptions
Facility fees
Ticket convenience charges
From Case Exhibit 1
$1,000
$30
hrs per show
$30 per hour
1.5 *
$30 per hour
1.5 **
$60 per show
$2 per ticket
$3 per ticket
Ticket sales assumptions
Estimated number of shows
Price per ticket – adult
Price per ticket – student and senior
Estimated percentage of adult ticket
Estimated percentage of student and senior ticket
Maximum capacity
Average occupancy per show
From Case Exhibit 3
4
$25
$22
70%
30%
90 seats
50%
Budget
Ticket sales – adult
Ticket sales – student and senior
Total number of tickets
Calculated based on information provided in Case Exhibits 1 an
126
54
180
Receipts
Ticket receipts – adult
Ticket receipts – student and senior
Total Receipts
Expenditures
Variable costs
Facility fees
Ticket convenience charges
Total Variable Costs
Contribution margin
Step costs
Technical support and lighting (4-hour minimum)
Sound technician (4-hour minimum)
3,150
1,188
$4,338
360
540
$900
$3,438 Total Receipts – Total Variable Costs
180 From Case Exhibit 1 ($30 per hour × 1.5 hours per sho
180 Use the formula in the cell above to help you determ
House management
Fixed costs
Hall rental per week, including practices and performance
One-time ticket set-up fee
Rental for rehearsal
Stage decoration and transportation of décor
Additional light and sound
Brochures and printing
Publcity for various ads, interviews, Facebook ads, etc.
Make-up
Food during performances and rehearsals
Copyright payment
Other
Total step and fixed costs
Operating Income Before Donations
240
From Case Descriptions
$1,000
$30
$300
0
$500
$150
$360
0
$275
$200
$0
$3,415
$23 Contribution Margin – Total Step and Fixed Costs
Cash and in-kind donation
Cash donation
Food in-kind donation
Total donations
$200
$300
$500
Net operating income
$523 Operating income before donations + Total donations
Calculate breakeven
Average price per ticket
Average variable cost per ticket
Average contribution margin
Number of tickets needed to break even
Ticket receipts needed to break even
Average number of tickets needed to break even per show
Break-even occupancy
$24.10
$5.00
$19.10
179
$4,314
44.75
50%
e cell above to help you determine the formula for this cell
Service
Fixed Costs assumptions
Hall rental per week, including practices and performance
One-time ticket set-up fee
Step costs assumptions
Technical support and lighting (4-hour minimum)
Sound techinician (4-hour minimum)
House management
Variable costs assumptions
Facility fees
Ticket convenience charges
From Case Exhibit 1
$1,000
$30
hrs per show
$30 per hour
1.5 *
$30 per hour
1.5 **
$60 per show
$2 per ticket
$3 per ticket
Ticket sales assumptions
Estimated number of shows
Price per ticket – adult
Price per ticket – student and senior
Estimated percentage of adult ticket
Estimated percentage of student and senior ticket
Maximum capacity
Average occupancy per show
From Case Exhibit 3
3
$25
$22
70%
30%
90 seats
50%
Budget
Ticket sales – adult
Ticket sales – student and senior
Total number of tickets
Calculated based on information provided in Case Exhibits 1 an
95
41
135
Receipts
Ticket receipts – adult
Ticket receipts – student and senior
Total Receipts
Expenditures
Variable costs
Facility fees
Ticket convenience charges
Total Variable Costs
Contribution margin
Step costs
Technical support and lighting (4-hour minimum)
Sound technician (4-hour minimum)
2,363
891
$3,254
270
405
$675
$2,579 Total Receipts – Total Variable Costs
135 From Case Exhibit 1 ($30 per hour × 1.5 hours per sh
135 Use the formula in the cell above to help you determ
House management
Fixed costs
Hall rental per week, including practices and performance
One-time ticket set-up fee
Rental for rehearsal
Stage decoration and transportation of décor
Additional light and sound
Brochures and printing
Publcity for various ads, interviews, Facebook ads, etc.
Make-up
Food during performances and rehearsals
Copyright payment
Other
Total step and fixed costs
Operating Income Before Donations
Cash and in-kind donation
Cash donation
Food in-kind donation
Total donations
Net operating income
Calculate breakeven
Average price per ticket
Average variable cost per ticket
Average contribution margin
Number of tickets needed to break even
Ticket receipts needed to break even
Average number of tickets needed to break even per show
Break-even occupancy
180
From Case Descriptions
$1,000
$30
$300
0
$500
$150
$360
0
$275
$200
$0
$3,265
($687) Contribution Margin – Total Step and Fixed Costs
$200
$300
$500
($187) Operating income before donations + Total donation
$24.10
$5.00
$19.10
171
$4,121
57.00
63%
e cell above to help you determine the formula for this cell
Enter your explanation for Question 2f here. As you type the text lines will scroll upward.
Appendix TN6. Solution to Question 3a
Contract costs with Black Box Theater
Fixed Costs assumptions
Hall rental per week, including practices and performance
One-time ticket set-up fee
Step costs
Technical support and lighting (4-hour minimum)
Sound techinician (4-hour minimum)
House management
$1,000
$30
Get information from Case Exhibit 1 (use formulas, do not retype amounts)
Get information from Case Exhibit 3 (use formulas, do not retype amounts)
$30 per hour
$30 per hour
$60 per show
1.5 hour per show*
1.5 hour per show*
Use information on this sheet to prepare a formula to compute this amount
Get information from the text of the case (you’ll need to type these amounts)
Variable costs
Facility fees
Ticket convenience charges
Hidden costs
Transporting stage décor furniture
Bookkeeping for production
Marketing on social media service
Graphic design for Kamala poster
Rental cost of furniture
Stage decoration service
Total Hidden Costs
$2 per ticket
$3 per ticket
$500
$300
$300
$500
$200
$500
$2,300
Purchase answer to see full
attachment