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%