Build an Excel spreadsheet for operating expenses. The spreadsheet should clearly display the total operating expenses, other expenses, and total expenses. There are both fixed cost and variable cost items listed. First, the fixed costs are as follows:

Item	Annual Cost
Vehicle Expense	$12,600.00
Repairs & Maintenance	$32,700.00
Taxes & Licenses	$4,600.00
Trash Removal	$18,800.00
Exterminator	$11,800.00
Insurance	$46,320.00
Equipment Rentals	$10,900.00
Armored Car Service	$15,400.00
Telephone	$2,575.00
Utilities	$30,500.00
Other Fixed Costs	$52,000.00

Second, the variable costs consist of:

Item	Annual Cost
Laundry & Uniforms	0.6%
Paper Goods	0.4%
Cleaning Supplies	0.5%
Other Variable Costs	2.1%

In addition to fixed and variable costs, the stadium should consider rent for running the concession stands. The rent is 41% of annual sales.

The Operating Expenses spreadsheet created for this section should mirror Forms D & E from the textbook (pages 105 & 107).

FORM D OPERATING EXPENSES (A) Annual Sales $. (1) (2) Variable Cost% (3) Fixed Cost Dollars Total Cost For Category Item Vehicle Expense Licenses Insurance Trash Removal Supplies Office Expense Exterminator Misc. Other % (C) $ (D) $ Total Cost Total Dollars (B) (B$) INSTRUCTIONS (A) (1) (2) (3) Enter total sales from Form A. Enter all categories. Enter percentage amount for variable categories. Enter dollar amount for fixed categories Summarize. (Calculate) where semi-variable. Summarize variable cost percentage. Multiply by sales (A). Enter. Summarize fixed cost dollars. Summarize variable and fixed cost dollars. Fundamentals of Recreational Foodservice Management 105 FORME OTHER CHARGES (A) Projected Sales $ I. Rent % Sales S % = $ Sales $ Sales $ Sales $ @ @ @ @ % = $ % = $ % = $ Total Sales $ Total Rent $ % $ % II. Other Depreciation $1,000,000/10 years Amortization Admin. Charges Other Charges Total $ % $ % $ % % INSTRUCTIONS Enter gross sales from Form A. (A) Rent: Calculate the various categories according to your lease arrangements. If self-operated. Leave blank. II. Other. List any other charges not shown on Form C. Summarize and calculate percentages. Fundamentals of Recreational Foodservice Management 107 FORM D OPERATING EXPENSES (A) Annual Sales $. (1) (2) Variable Cost% (3) Fixed Cost Dollars Total Cost For Category Item Vehicle Expense Licenses Insurance Trash Removal Supplies Office Expense Exterminator Misc. Other % (C) $ (D) $ Total Cost Total Dollars (B) (B$) INSTRUCTIONS (A) (1) (2) (3) Enter total sales from Form A. Enter all categories. Enter percentage amount for variable categories. Enter dollar amount for fixed categories Summarize. (Calculate) where semi-variable. Summarize variable cost percentage. Multiply by sales (A). Enter. Summarize fixed cost dollars. Summarize variable and fixed cost dollars. Fundamentals of Recreational Foodservice Management 105 FORME OTHER CHARGES (A) Projected Sales $ I. Rent % Sales S % = $ Sales $ Sales $ Sales $ @ @ @ @ % = $ % = $ % = $ Total Sales $ Total Rent $ % $ % II. Other Depreciation $1,000,000/10 years Amortization Admin. Charges Other Charges Total $ % $ % $ % % INSTRUCTIONS Enter gross sales from Form A. (A) Rent: Calculate the various categories according to your lease arrangements. If self-operated. Leave blank. II. Other. List any other charges not shown on Form C. Summarize and calculate percentages. Fundamentals of Recreational Foodservice Management 107