Module 2 Excel Exercise (1)

Exercise 2.1 The Local Bistro Income Statement For year ending 20XX Current Year (%) Sales Food $970,028.12 77.33% Beverage $284,337.68 22.67% Total Sales $1,254,365.79 100.00% Cost of Sales Food $356,607.56 36.76% Beverage $72,724.82 25.58% Salaries & Wages $300,443.40 23.95% Total COGS $729,775.78 58.18% Gross Profit $524,590.02 41.82% Other Controllable Expenses Direct Operating Expenses $194,315.26 15.49% Employee Benefits $19,288.63 1.54% Total Controllable Expenses $213,603.89 17.03% Controllable Income $310,986.13 24.79% Non-Controllable Expenses Occupancy Costs $57,277.25 4.57% Interest $27,821.47 2.22% Depreciation $95,576.14 7.62% Total Non-Controllables $180,674.86 14.40% Operating Profit/Loss $130,311.27 10.39%

ven Formula Step-By-Step Fixed Cost Contribution Margin Index (Total Sales - Total COGS - Total Controllable Expenses) Total Sales Non-Controllable Expenses Contribution Margin Index Occupancy + Interest + Depreciation Contribution Margin Index 310986.13 1254365.79 0.25 180674.86 0.25 728753.93