Cost Behavior Analysis

Anonymous
timer Asked: Apr 19th, 2017

Question description

I ONLY NEED THE CALCULATIONS, THE SLIDES HAVE BEEN DONE. SHOW YOUR CALCULATIONS FOR THE THREE QUESTIONS EITHER IN WORD OR EXCEL Create 4-PowerPoint slides, including detailed speaker notes, as the committee's consultation team and respond to the following:

  • Shelley, Jonathan, and Adrian Stein, the Fundraising Chairperson, are beginning to make plans for next year's rodeo. Shelley believes by negotiating with local feed stores, inn- keepers, and other business owners, costs can be cut dramatically. Jonathan agrees. After carefully analyzing costs, Jonathan has estimated the fixed expenses can be pared to approximately $51,000. In addition, Jonathan estimates variable costs are 4% of total gross receipts. After talking with business owners who attended the rodeo, Adrian is confident the funds solicited from sponsors will increase. Adrian is comfortable in budgeting revenue from sponsors at $25,600. The local youth group is unwilling to provide concessions to the audience unless they receive all of the profits. Not having the personnel to staff the concession booth, members of the Circular Club reluctantly agree to let the youth group have 100% of the profits from the concessions. In addition, members of the rodeo committee, recognizing the net income from programs was only $100, decide not to sell rodeo programs next year.
    • Compute the break-even point in dollars of ticket sales assuming Adrian and Jonathan are correct in their assumptions.
  • Shelley has just learned you are calculating the break-even point in dollars of ticket sales. She is still convinced the Club can make a profit using the assumptions above (second bullet point above).
    • Calculate the dollars of ticket sales needed to earn a target profit of $6,000.
    • Calculate the dollars of ticket sales needed to earn a target profit of $12,000.
  • Are the facilities at the fairgrounds adequate to handle crowds needed to generate ticket revenues calculated above (third bullet point above) to earn a $6,000 profit? Show calculations to support your answers.

Show your work in Microsoft® Word or Excel®.

Complete calculations/computations using Microsoft® Word or Excel®.

Format the assignment consistent with APA guidelines.

I only need these three bulletins done. 4 slides and the calculation/computation using word or excel.

The attachment is only the scenario and numbers needed to complete the three bulletins above.

Tutor Answer

(Top Tutor) Studypool Tutor
School: New York University
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors