Expert answer:Cost–Volume–Profit Analysis

Solved by verified expert:Module 2 – CaseCost–Volume–Profit AnalysisAssignment OverviewThe Annie Smith Dance CenterThe 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 understanding of the profitability of the concerts
and the organization as a whole.The Annie Smith professional group features three styles of dance
concerts each year. Two of the dance concerts showcase a different
genre. The third performance is a Christmas Spectacular, which is the
most popular and is therefore scheduled every year. The table below
provides information about expected ticket sales for the performances.

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%

Christmas Spectacular
150
$125
100%
450
$50
100%

Ms. Smith has prepared a tentative schedule for the coming season.
The table below also shows the type and number of performances and
direct cost per type of concert.

Descriptions
Number of Performances
Cost per Dance Concert(direct fixed costs)*

Hip-Hop Concert
10
$48,000

Jazz and Tap Dance
5
86,000

Christmas Spectacular
20
22,000

Total Direct Fixed Costs

$156,000

*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 concerts. This amount does not
change with the number of performances.Additional costs:Variable costs associated with each performance are shown below.

Musicians
$6,100

Rental of auditorium
2,500

Dancers’ compensation
6,700

Annual general administrative and operating costs for the dance center are:

Administrative staff
$185,000

Insurance
25,000

Marketing
115,000

General office expenses
90,000

Case AssignmentRequired:Computations (use Excel)Summarize key financial information in a table as shown below.

Title

Name of Dance Concert
Revenues/Performance
Variable Costs/Performance
Contribution Margin/Performance
Number of Performances
Total Contribution/Type of Dance Concert
Direct Fixed Costs
Segment Margin/Type of Concert

1.

2.

3.

Total

Use the information in the table you completed to compute the number
of performances required to break even for each concert. Do not include
general and administrative expenses. These are separate computations
for each dance concert.Compute break even for the organization as a whole (include all
fixed expenses) and express the result in revenues instead of the number
of performances.Ms. Smith wants the Dance Center to generate at least $200,000 in
operating profit. What level of revenues does the performance group need
to achieve to meet this goal? Prepare an income statement in good
format to support the computations.Give a recommendation about changes Ms. Smith can implement to achieve the target profit. Support your idea with computations.Memo (use Word)Write a 4- or 5-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.Short Essay (use Word)Start with an introduction and end with a summary or conclusion. Use headings.What are some shortcomings of multi-product even analysis?How does demand and resource constraints affect this type of analysis.Assignment ExpectationsEach submission should include two files: (1) An Excel file and (2) a
Word document. The Word document shows the memo first and short essay
last. Assume a knowledgeable business audience and use required format
and length. Individuals in business are busy and want information
presented in an organized and concise manner.

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades