For a Golf Course.

Create a schedule to track your decisions, the values, and the comparison to your competitors for the following KPIs:

General Manager:

1. Share Value

2. Overall Social Responsibility Index

3. Total Revenue

4. Gross Profit [loss]

5. Gross Margin

6. Net Income [loss]

7. Net Margin

Golf Course Superintendent:

1. Rounds played by course

2. Revenue by fee categories

3. Maintenance costs by course

Head Professional (in charge of the Pro Shop):

1. Total Revenue of Pro Shop

2. Gross profit by product categories

3. Items sold at full, end-of-season, and clearance price

Executive Chef:

1. Number of covers sold in the restaurant

2. Restaurant profit margin

3. Bar revenues

In excel