Reference no: EM131015099
The Director of Annie Smith Dance Center is asking for assistance with the financial aspects of running a professional group of performers. She wants financial information presented in an easy to read format and a better understand of the profitability of the concerts and the organization as a whole.
The Annie Smith professional group features four dance concerts each year. Three of the dance concerts showcase a different genre. The fourth performance is a Christmas Spectacular, which is the most popular dance concert and is therefore scheduled every year. Ms. Smith has tentatively scheduled the following four dance concerts for the coming season. The schedule below shows the type and number of performances and direct cost per type of concert. Examples of direct fixed costs are costumes, rehearsals, royalties, guest artist fees, choreography, and salaries of production staff, music, and wardrobe for each of the four concerts.
Descriptions
|
Number of Performances
|
Cost per Dance Concert (direct fixed costs)
|
Hip Hop Concert
|
10
|
$45,000
|
Jazz and Tap Dance
|
5
|
88,000
|
Modern Dance
|
10
|
95,000
|
Christmas Spectacular
|
20
|
25,000
|
|
|
|
|
|
$253,000
|
Additional costs:
Variable costs associated with each performance are shown below.
Musicians
|
$7,500
|
Rental of auditorium
|
2,500
|
Dancers' compensation
|
7,000
|
Administrative staff
|
$185,000
|
Insurance
|
25,000
|
Marketing
|
215,000
|
General office expenses
|
90,000
|
|
Lower Orchestra Section (A)
|
Upper Orchestra Section (B)
|
Descriptions
|
No. of Seats
|
Ticket Price
|
Tickets Sold per Performance
|
No. of Seats
|
Ticket Price
|
Tickets Sold per Performance
|
Hip Hop Performance
|
150
|
$85
|
100%
|
450
|
$50
|
90%
|
Jazz and Tap Dance
|
150
|
$85
|
100%
|
450
|
$50
|
60%
|
Modern Dance
|
150
|
$85
|
100%
|
450
|
$50
|
95%
|
Christmas Spectacular
|
150
|
$125
|
100%
|
450
|
$50
|
100%
|
Required:
Computations (use Excel)
• Summarize key financial information in a table as shown below.
General administrative and operating costs for the dance center are:
Title
|
Name of Dance Concert
|
Revenues/Performance
|
Variable Costs/Performance
|
Contribution Margin/Performance
|
Total Contribution/Type of Dance Concert
|
Direct Fixed Costs
|
Segment Margin/Type of Concert
|
1.
|
|
|
|
|
|
|
2.
|
|
|
|
|
|
|
3.
|
|
|
|
|
|
|
4.
|
|
|
|
|
|
|
Total
|
|
|
|
|
|
|
• Prepare a segmented income statement in good format.
• Compute the number of performances required to break even for each concert. These are separate computations for each dance concert.
• Compute break even for the organization as a whole and express the result in revenues instead of the number of performances.
• Ms. Smith wants to performance group to show at least $150,000 in operating profit. What level of revenues does the performance group need to achieve to meet this goal?
• Give a recommendation about changes Ms. Smith can make to achieve the target profit. Support your idea with computations.
Memo (use Word)
Write a four or five paragraph memo to the owner of the dance center to assist her in interpreting the financial analysis. Start with an introduction and end with a recommendation. Each of the four or five paragraphs should have a heading.
Sketch the curve represented by the vector-valued function
: Sketch the curve represented by the vector-valued function and give the orientation of the curve r(t) = 2sin ti + tj + 3cos tk.
|
Problem regarding the treatment combinations
: A second experiment on the lens coating discussed in Problem 1 was run to study the effects of both the pH level and the catalyst level on the adhesion. Three levels of pH were studied along with two levels of catalyst. Five mea surements were ta..
|
Define semi-definite system
: Define semi-definite system - semi-definite system in simple harmonic motion
|
What is the domain of s
: (Sundstrom) Let S be the function that associates with each natural number the set of its natural number divisors. For example, S(6) = {1, 2, 3, 6} and S(10) = {1, 2, 5, 10}. What is the domain of S? Determine an appropriate codomain of S
|
Prepare a segmented income statement in good format
: Compute the number of performances required to break even for each concert. These are separate computations for each dance concert. Compute break even for the organization as a whole and express the result in revenues instead of the number of perfor..
|
Find the value of damping factor
: Vibrometer shows 2 percent error in measuring and its natural frequency is 5 hz. If the lowest frequency that can be measured is 40 hz, find the value of damping factor?
|
Measurements within and between the labs
: The data set labcomp .txt is the result of an "inter-lab" study where multiple labs, in this case each located at a different plant, participate in a study to compare measurements within and between the labs.
|
Give the open interval where the function is decreasing
: Give the open interval(s) where the function is decreasing. Give the open interval(s) where the function is concave down. Name the x-value where the absolute max occurs (if it exists).
|
Compare the effect of ph on the adhesive qualities
: An experiment was performed to compare the effect of pH on the adhe sive qualities of a lens coating. The test procedure for measuring adhesion is "noisy", that is, there is a large amount of test error in the measurement. For that reason, 10..
|