Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

solve it with step by step please and how each number is calculated Southwestern University (SWU), a large state college in Stephenville, Texas enrolls close

solve it with step by step please and how each number is calculated

Southwestern University (SWU), a large state college in Stephenville, Texas enrolls close to 20,000 students. It is the dominant force in the small city, with more students during fall and spring than permanent residents.

A longtime football powerhouse, the University s a member of the Big Eleven conference and is usually in the top 20 in college football rankings. To bolster its chances of reaching the elusive and long-desired number-one ranking, in 2013 the University hired the legendary Billy Bob Dillon as its head coach. Although the number-one ranking remained out of reach, attendance at the six Saturday home games each year increased. Prior to Dillons arrival, attendance generally averaged 30,00035,000. Season ticket sales bumped up by 15,000 just with the announcement of the new coachs arrival. Stephenville and the University were ready to move to the big time!

With the growth in attendance came more fame, the need for a bigger stadium, and more complaints about seating, parking, long lines, and concession stand prices. The Universitys president was concerned not only about the cost of expanding the existing stadium versus building a new stadium but also about the ancillary activities. He wanted to be sure that these various support activities generated revenue adequate to pay for themselves. Consequently, he wanted the parking lots, game programs, and food service to all be handled as profit centers. At a recent meeting discussing the new stadium, the Universitys president told the stadium manager to develop a break-even chart and related data for each of the centers. He instructed the stadium manager to have the food service area break-even report ready for the next meeting. After discussion with other facility managers and his subordinates, the stadium manager developed the following table showing the suggested selling prices, his estimate of variable costs, and his estimate of the percentage of the total revenues that would be expected for each of the items based on historical sales data.

Item

Selling Price/Unit

$

Variable Cost/Unit

$

Percent Revenue

%

Soft drink

1.00

0.45

15%

Coffee

3.00

0.60

30%

Hot dogs

3.50

0.85

25%

Burgers

4.50

1.50

18%

Misc. Snacks

2.00

0.90

12%

The stadium managers fixed costs are interesting. He estimated that the prorated portion of the stadium cost would be as follows: salaries for food services at $360,000 ($60,000 for each of the six home games); 2,400 square feet of stadium space at $ 8 per square foot per game; and six people per booth in each of the six booths for 5 hours at $15 an hour. These fixed costs will be proportionately allocated to each of the products based on the percentages provided in the table. For example, the revenue from soft drinks would be expected to cover 20 % of the total fixed costs.

The stadium manager wants to be sure that he has a number of things for the University President: (1) the total fixed cost that must be covered at each of the games; (2) the portion of the fixed cost al- located to each of the items; (3) what his unit sales would be at breakeven for each itemthat is, what sales of soft drinks, coffee, hot dogs, hamburgers, and snacks are necessary to cover the portion of the fixed cost allocated to each of these items; (4) what the dollar sales for each of these would be at these break-even points; and (5) realistic sales estimates per attendee for attendance of 60,000 and 35,000. (In other words, he wants to know how many dollars each attendee is spending on food at his projected break-even sales at present and if attendance grows to 60,000.) He felt this last piece of information would be helpful to understand how realistic the assumptions of his model are, and this information could be compared with similar figures from previous seasons.

Calculate

  1. The total fixed cost per game and the allocated cost to each food item
  2. Calculate the Break-Even-Point (BEP) for each of these items
  3. Determine the total sales for each item that is required to each BEP
  4. Write your conclusion whether we break even or not if the attendance

is 35000 people or 60000 people.

  1. Prepare a brief report for the University President that covers the items noted.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing IT Infrastructures For Compliance

Authors: Robert Johnson, Marty Weiss, Michael G. Solomon

3rd Edition

1284236609, 9781284236606

More Books

Students also viewed these Accounting questions

Question

7. e u ea

Answered: 1 week ago