Question

Project Sections

Section I: Sales Forecasting (Spreadsheet Only)

Create an Excel spreadsheet for sales forecasting. The spreadsheet should clearly show the forecasting/projected total sales and other necessary elements explaining how the total sales are calculated. Build the spreadsheet based on the data below.

• Your facility is the multi-purpose stadium in Charlotte, NC.
• The stadium hosts various sport and cultural events annually.
• The events and the expected attendance are illustrated in the table below.
• You manage the concession stands in the stadium.
• Based on the last five years’ data, per capita spending for each type of event is projected as follows:
  • Pro football: $21.00
  • College football: $9.50
  • Professional baseball: $9.25
  • College baseball: $7.50
  • Concert: $16.00
  • Rentals: $9.00

Type of Event	Number of Events	Average Attendance
Professional Football	10	65,000
College Football	6	40,000
Professional Baseball	40	22,000
College Baseball	15	15,000
Concerts	5	55,000
Rentals	1	24,000

Section II: Cost of Sales (Spreadsheet Only)

Create an Excel spreadsheet for the cost of sales. The spreadsheet should clearly show the total cost of sales for all items as well as the cost of sales for each item. This spreadsheet should also include all necessary elements explaining how the total cost of sales is calculated. Build the spreadsheet based on the data. Items, percentage of sales, and product cost are summarized below.

Product Line	% of Sales	Product Cost %
Hot Dogs	19%	22%
Pizza	5%	30%
Soft Drinks	24%	12%
Draft Beer	28%	17%
Hot Drinks	2%	18%
Nacho Chips	7%	28%
Popcorn	4%	16%
Peanuts	4%	20%
Ice cream	2%	21%
Others	5%	23%

Answer 1

Solution-I
		(A)	(B)	(C)
	Type of event	Number of Event (A)	Average Attendance (per Event)	Per capita spending	Total spending (A*B*C)
	Professional Football	10	65,000	$                          21.00	$       136,50,000
	College Football	6	40,000	$                             9.50	$          22,80,000
	Professional Baseball	40	22,000	$                             9.25	$          81,40,000
	College Baseball	15	15,000	$                             7.50	$          16,87,500
	Concerts	5	55,000	$                          16.00	$          44,00,000
	Rentals	1	24,000	$                             9.00	$            2,16,000
					$       303,73,500
	The total expenditure is around $303,73,500 . The company is required to cover atleast the per head spending. The company is required to select the required profit and add in the spending and then find out the per head ticket price in order to recover the total cost and required profit element.