10. Each answer, a) and b) is worth .5. In answer b), each number is worth .1. Using the Excel Spreadsheet providedseparately, do the following:

a) Prepare the Sunshine Pubs Income Statement and copy and paste your result below.

b) Determine the following percentages:

1) Food cost percent

2) Labor cost percent (payroll, plus employee benefits)

3) Beverage cost percent

4) Percentage of profit before income taxes

5) Assuming the restaurant has 75 seats, determine food sales per seat for the year.

please consider all the points in the question.

Thank you

Exercise 2.1 Exercise 2.2 Sheet3 CD-ROM Exercise 2.2 Use the figures given below to complete the statement of income for the Sunshine Pub Depreciation, $25.000 Food sales, $375,000 Cost of beverages sold, 530,000 Other controllable expenses. $60.000 Salaries and wages, $130,000 Beverage sales, $125,000 Employee benefits, $20,000 Cost of food sold, S127.500 Occupancy costs, S55,000 $ Sunshine Pub INCOME STATEMENT YEAR ENDED DECEMBER 31, 20XX Sales Food s Beverage $ Total Sales Cost of Sales Food $ Beverage Total Cost of Sales Gross Profit Controllable Expenses Salaries and Wages $ Employee Benefits s Other Controllable Expenses $ Total Controllable Expenses Income Before Occupancy costs Interest, Depreciation, and Income Taxes Occupancy Costs $ Depreciation $ Total Restaurant Profit $ $ $ $ $ Exercise 2.1 Exercise 2.2 Sheet3 Exercise 2.1 BARNABY'S HIDEAWAY INCOME STATEMENT NDED DECI BER 31, 200X 1,120,964 465,200 Change Upcoming Year 56,048.2 1,177,0122 23,260 488,460 79,308.2 1,665,472.2 1.586.164 392,337 102,344 19,61727 5.117 2 24 734 47 54,573.73 411,954 27 107,461.2 519.415.47 1,146,056.73 494,681 1,091,483 Sales Food Beverage Total Sales Cost of Sales Food Beverage Total Cost of Sales Gross Profit Controllable Expenses Salaries and Wages Employee Benefits Other Controllable Expenses Total Controllable Expenses Income Before Occupanape Costs, Interest, Depreciation and Income Taxes Occupancy Costs Interest Depreciation Total Restaurant Profit 396,541 99,135 275,330 15,861.64 3,965.66 6,500 26,3273 412.402.64 103, 100.66 281,830 7973333 348.723.43 771.006 320.477 2,000 75,230 25,600 79,099 77.230 25,600 79,099 181.929 166,794.43 179.929 140,548 $1.984.400 A Taste of Tuscany Income Statement, Year Ended December 31, 20XX Sales Food $1,686,740 Beverage S297,660 Total sales Cost of Sales Food 5708,431 Beverage 595.251 Total cost of sales Gross Profit Controllable Expenses Salaries and wages 5535.788 Employee benefits $133,947 Other controllable expenses $242.660 Total Controllable Expenses Income before Occupancy Costs, Interest Denreciation and Income Taxes $803,682 S1,180,718 S912.395 $268.323 5891.687 5157.356 $1.049,043 The Grandview Bistro Income Statement, Year Ended December 31, 20XX Sales Food Beverage Total Sales Cost of Sales Food Beverage Total Cast of Sales Gross Profit Controllable Expenses Salaries and wages Employee benefits Other controllable expenses Total Controllable Expenses Income before Occupancy Costs, $312.090 $39,339 $351,429 S697.614 S209.809 547.207 $162,602 5419,618 $277,996