Name : Student ID: Exercise 11.1

Complete the pro-forma for the upcoming year with the following projections.

You will need calculate the changethe projected sales, and the percentage of sale for each category

1. Both food and beverage sales are expected to increase by 5%

2. Food and beverage cost % will remain the same

3. Salaries and wages will increase by 4%.

4. The cost of employee benefits will increase at the same rate of salaries and wages.

5. Other controllable costs will increase by 6,500

6. Occupancy costs will increase by 2,000 .

7. Interest and depreciation will remain the same.

Instruction Sheet Exercise 11.1 Exercise 11.1 MINION CAF Pro-Forma Income Statement Change Current Year (%) Upcoming Year (5) Sales Food Beverage Total Sales 12,33,060.4 5.11,720 17.44.780.4 Cost of Sales Food Beverage Total COGS 4.31.570.7 1,12,578.4 5,44,149.1 12,00,631.3 Gross Profit Controllable Expenses Salaries & Wages Employee Benefits Other Controllable Expenses Total Controllable Expenses Income Before Occupancy Costs 4,36,195.1 1,09,048.5 3,02,863 8,48,106.6 3.52.524.7 82,753 25,160 Interest, Depreciation and Income Taxes Occupancy Costs Interest Depreciation Total Operating Profit/Loss 87.0089 1.97.921.9 1,54,602.8