Question 10. Each answer, a) and b) is worth 1 point. In answer b), each number is worth .2. Using the Excel Spreadsheet provided separately, 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.

use the data from the given sheets.

$1,984,400 $803,682 $1,180,718 A Taste of Tuscany Income Statement, Year Ended December 31, 20XX Sales Food $1,686,740 Beverage $297,660 Total sales Cost of Sales Food $708,431 Beverage $95,251 Total cost of sales Gross Profit Controllable Expenses Salaries and wages $535,788 Employee benefits $133,947 Other controllable expenses $242,660 Total Controllable Expenses Income before Occupancy Costs, Interest, Depreciation, and Income Taxes Occupancy Costs $132,608 Interest $27,060 Depreciation $60,200 Total Restaurant Profit $912,395 $268,323 $219,868 $48,455 $891,687 $157,356 $1,049,043 $312,090 $39,339 $351,429 $697,614 The Grandview Bistro Income Statement, Year Ended December 31, 20XX 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 Occupancy Costs, Interest, Depreciation, and Income Taxes Occupancy Costs Interest Depreciation Total occupancy costs, interest, and depreciation Restaurant Profit $209,809 $47,207 $162,602 $419,618 $277,996 $89,169 $13,875 $46,250 $149,294 $128,702 E ta $ $ $ A 2 Sales 3 Food 1 Beverage 5 Total Sales 5 Cost of Sales 7 Food 3 Beverage Total Cost of Sales Gross Profit 1 Controllable Expenses 2 Salaries and Wages B Employee Benefits Other Controllable Expenses 5 Total Controllable Expenses Income Before Occupancy costs - Interest, Depreciation, and Income Taxes 3 Occupancy Costs Depreciation Total 1 Restaurant Profit 2 1 $ $ $ $1,984,400 $803,682 $1,180,718 A Taste of Tuscany Income Statement, Year Ended December 31, 20XX Sales Food $1,686,740 Beverage $297,660 Total sales Cost of Sales Food $708,431 Beverage $95,251 Total cost of sales Gross Profit Controllable Expenses Salaries and wages $535,788 Employee benefits $133,947 Other controllable expenses $242,660 Total Controllable Expenses Income before Occupancy Costs, Interest, Depreciation, and Income Taxes Occupancy Costs $132,608 Interest $27,060 Depreciation $60,200 Total Restaurant Profit $912,395 $268,323 $219,868 $48,455 $891,687 $157,356 $1,049,043 $312,090 $39,339 $351,429 $697,614 The Grandview Bistro Income Statement, Year Ended December 31, 20XX 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 Occupancy Costs, Interest, Depreciation, and Income Taxes Occupancy Costs Interest Depreciation Total occupancy costs, interest, and depreciation Restaurant Profit $209,809 $47,207 $162,602 $419,618 $277,996 $89,169 $13,875 $46,250 $149,294 $128,702 E ta $ $ $ A 2 Sales 3 Food 1 Beverage 5 Total Sales 5 Cost of Sales 7 Food 3 Beverage Total Cost of Sales Gross Profit 1 Controllable Expenses 2 Salaries and Wages B Employee Benefits Other Controllable Expenses 5 Total Controllable Expenses Income Before Occupancy costs - Interest, Depreciation, and Income Taxes 3 Occupancy Costs Depreciation Total 1 Restaurant Profit 2 1 $ $ $