COST–VOLUME–PROFIT ANALYSIS Assignment Overview The Annie Smith Dance Center 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 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)DescriptionsNo. of Seats.Ticket PriceTickets sold per performanceNo. of seatsTicket PriceTickets sold per performanceHip-Hop Performance150$85100%450$5090%Jazz and Tap Dance150$85100%450$5060%Christmas Spectacular150$125100%450$50100% 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. DescriptionsNumber of PerformancesCost per Dance Concert (direct fixed costs)*Hip-Hop Concert10$48,000Jazz and Tap Dance586,000Christmas Spectacular2022,000Total 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,100Rental of auditorium2,500Dancers' compensation6,700 Annual general administrative and operating costs for the dance center are: Administrative staff$185,000Insurance25,000Marketing115,000General office expenses90,000 Case Assignment Required: Computations (use Excel) Summarize key financial information in a table as shown below. TitleName of Dance ConcertRevenues/ PerformanceVariable Costs/ PerformanceContribution Margin/ PerformanceNumber of PerformancesTotal Contribution/ Type of Dance ConcertDirect Fixed CostsSegment Margin/ Type of Concert1.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 Expectations Each 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.  Module 2 - Background COST-VOLUME-PROFIT ANALYSIS Modular Learning Objectives Keep the following objectives in mind as you work through the material in this module: Define of cost-volume-profit. Understand the relationship between variable costing and cost-volume-profit analysis. Apply and analyze break-even. Compute break-even in units. Compute break-even in sales. Analyze target profit. Required Reading Variable and fixed costs were introduced in the prior module. Now it is time to examine cost behavior in more detail by familiarizing yourself with the following while keeping the above six objectives in mind. Click on the three arrows to explore each topic in more detail. Check Your Understanding Check your understanding to make sure that you have a good grasp of the background material. If you are not comfortable with the concepts, review some of the material again or go to the optional resource for more examples. Click on the quiz icon for an ungraded, 20-question true-or-false self-study quiz to check your progress. If you are not satisfied with the score, review some of the material again. For more in-depth information, review materials listed under optional reading at the bottom of this page. Final Thoughts Cost-Volume-Profit (CVP) analysis is a computational method that analyzes the effect of sales and product costs on the operating income of a business. Specifically, it assesses the effect of changes in variable costs, fixed costs and selling price on operating income. Break-even analysis (with or without a target profit) is a common CVP approach. Another definition of break-even is where the total contribution margin equals total costs. A contribution margin income statement shows zero income at break-even. Several assumptions underlie CVP analysis: All cost can be categorized as variable or fixed. Sales price per unit, variable cost per unit, and total fixed cost are constant. Mixed costs must be split into their fixed and variable component by an estimation process. Understanding the behavior of costs makes cost-volume-profit analysis possible. Optional Reading For further detail refer to Dr. Walther’s accounting text and videos. Walther, L. (2017). Chapter 18: Cost-Volume-Profit and Business Scalability. LICENSES AND ATTRIBUTIONS

Data visualization methods offer a different landscape for explaining situations using data. Graphical representations of information, if created properly, can make vital information more intuitive, contextualized, and accessible. Visualization plays an essential part in analyzing big data and simplifying complex data-intensive scenarios. In this discussion, using the Viz of the Day webpage, select a business-focused visualization to debate in your post (you may have to toggle to more than one page to see business-specific visualizations). Consider the audience and purpose of the visualization you selected, and think about the strategy used to present the information and analysis visually. In your initial post, make sure to include the link to the visualization you selected, and address the following: Why have you selected this one? How does the author of the visualization address the audience? How is the purpose of the visualization conveyed? How does the visualization use color, ordering, layout, and hierarchy to prioritize information? In response to at least two of your peers, address the following: Can you describe ways in which data visualizations make information more accessible to their audience? What would you recommend to make key insights in visualizations more digestible to your audience? What would you avoid? Here is the #VID link just incase you can't open https://public.tableau.com/en-us/gallery/?tab=viz-...  One Peer Post: Hello All, The visualization I chose was titled, "What do Americans think about Abortion?" I selected this one because it has been the topic of the week, for several weeks in one of my online social groups and because I fully support a woman's right to choose what's right for her body. The visualization is broken down into four colors that represent the different opinions on what people think should be the case for an abortion. Red represents "Illegal in all circumstances," light blue representing "Legal in some cases," dark blue repping "Legal under any circumstances," and white, indicating "No opinion." The author uses both a bar and line graph to break down the percentages of each group's opinion. It is a simple layout that is easy to read and understand. The line graph with each opinion is next to each other, allowing the reader to compare the data simply without and real effort. Komissarova, A. (2021, September 10). Gallery: Tableau public. Gallery | Tableau Public. Retrieved September 17, 2021, from https://public.tableau.com/en-us/gallery/what-do-americans-think-about-abortion?tab=viz-of-the-day&type=viz-of-the-day.  2nd Peer Post: 3-2 Discussion: The Importance of Data Visualizations Contains unread posts Trevor Toews posted Sep 15, 2021 7:35 PM Subscribe Why have you selected this one? I chose the visualization “how common is your birthday”. I chose this for two reasons 1) I thought it was one of the best to look at and easiest to read and understand 2) It is a data set that everyone can relate to How does the author of the visualization address the audience? The author addresses the audience with a large text of the subject of the data “Birthday(s)” and then gives a small description of what the visualization is describing. Underneath that, there is a simple, yet detailed explanation of how to read the data and the anomalies. How is the purpose of the visualization conveyed? The purpose of the visualization is to plot birthdays by month and more specifically by day and show how common that day is compared to the other days of the year. How does the visualization use color, ordering, layout, and hierarchy to prioritize information? The visualization is organized by horizontal lines showing the different months vertically. Each day is then shown as a dot with the corresponding position of the day in the month vertically in the row. They then place the dot either further left (uncommon) or right (common) in the row to show the commonality. Past that, they highlight the top and bottom ten birthdays with a different color. The visualization is easy to read and labelled very well so that it is quick to understand. https://public.tableau.com/en-us/gallery/how-common-your-birthday-0?tab=viz-of-the-day&type=viz-of-the-day