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. The Sales Forecasting spreadsheet created for this section should mirror Form A from the textbook (page 97). 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