The budgeted income statement for Barnaby s Hideaway is produced on your Excel spreadsheet. Assume that the following constitute the fixed and variable costs for the upcoming year: Fixed Costs for the Upcoming Year

1. 40 percent of salaries and wages

2. Employee benefits 40 percent of employee benefits

3. Other controllable expenses

4. Occupancy costs

5. Interest expense

6. Depreciation

Variable Costs for the Upcoming Year

1. Cost of food

2. Cost of beverages

3. 60 percent of salaries and wages

4. Employee benefits 60 percent of employee benefits

Using the Excel spreadsheet:

1. Calculate total fixed costs for the upcoming year.

2. Calculate total variable costs for the upcoming year.

3. Calculate the variable rate for the upcoming year.

4. Calculate the break- even point for Barnaby s Hideaway for the upcoming year.

5. Assuming that the average contribution margin per unit is $14.50, calculate the number of customers necessary to break even.

HW 3 - Saved Brianna Nicole Phillips - x Comments Share AutoSave CH H File Home Insert X Cut Per Copy - - Format Painter Clipboard C30 X e : DrawPage Layout Nial - 10 BIU - . Fom Box C D Formulas Data Review AA ===> - A E View Help 2 Wrap Text - Merge & Center - Tell me what you want to do General E2 B 0.00 588 Conditional Formatas Cell $ -% Formatting Table Styles Styles B Insert Delete Format un: * Sort & Find & Clear Filler Select Aignment Cels Eding E F G H I J K L M N O P Q R S T U V W X Y Z M L A 6 Sales Upcoming Yuhr 511//01220 Beverage 488.460.00 Total RAR 1 665 472 20 10 Cost Sales 411.954.27 Haverage 107 461.20 Total Cost of Sales 519,415.47 14 u Pulit 1.146 056.73 15 Controlable Expenses Salaries and Wage 412 402.64 Employee Herelts 103 100 65 Other Controllable Expe_ 201,320.00 19 Total Controlle Expenses 797.333.30 20 Income Huancy Casts 348 723 43 21 Interest Depreciation, and income Taxes 22 Occupancy Costs 77.280.00 23 Interest 25.000.00 24 Depreciation 79089.00 25 Total 26 Restaurant Profit 1GG,794.43 29 Exed Canta 30 Salaries and Wages 31 Employee Lents 32 Oiher Controllable Expenses 30 Occupancy Cests 34 Interest 35 Deprecision 36 Totalred Costs 38 Vanabia Costa 39 Cost of Food 10 Conn ages 41 Salenes and Wages 42 Employee Benefits 43 Total Vanabi Costs Sheet1 Sheet2 Sheet3 # # 1 - + 90% # Type here to search o 9 e x] w A x 1:47 PM HW 3 - Saved Brianna Nicole Phillips - x Comments Share AutoSave CH H File Home Insert X Cut Per Copy - - Format Painter Clipboard C30 X e : DrawPage Layout Nial - 10 BIU - . Fom Box C D Formulas Data Review AA ===> - A E View Help 2 Wrap Text - Merge & Center - Tell me what you want to do General E2 B 0.00 588 Conditional Formatas Cell $ -% Formatting Table Styles Styles B Insert Delete Format un: * Sort & Find & Clear Filler Select Aignment Cels Eding E F G H I J K L M N O P Q R S T U V W X Y Z M L A 6 Sales Upcoming Yuhr 511//01220 Beverage 488.460.00 Total RAR 1 665 472 20 10 Cost Sales 411.954.27 Haverage 107 461.20 Total Cost of Sales 519,415.47 14 u Pulit 1.146 056.73 15 Controlable Expenses Salaries and Wage 412 402.64 Employee Herelts 103 100 65 Other Controllable Expe_ 201,320.00 19 Total Controlle Expenses 797.333.30 20 Income Huancy Casts 348 723 43 21 Interest Depreciation, and income Taxes 22 Occupancy Costs 77.280.00 23 Interest 25.000.00 24 Depreciation 79089.00 25 Total 26 Restaurant Profit 1GG,794.43 29 Exed Canta 30 Salaries and Wages 31 Employee Lents 32 Oiher Controllable Expenses 30 Occupancy Cests 34 Interest 35 Deprecision 36 Totalred Costs 38 Vanabia Costa 39 Cost of Food 10 Conn ages 41 Salenes and Wages 42 Employee Benefits 43 Total Vanabi Costs Sheet1 Sheet2 Sheet3 # # 1 - + 90% # Type here to search o 9 e x] w A x 1:47 PM