The budgeted income statement for Barnaby's Hideaway is produced on your Excel spreadsheet. Assume that the...

 

Transcribed Image Text:

The budgeted income statement for Barnaby's Hideaway is produced on your Excel spreadsheet. Assume that the following constitute the fixed and vari- able 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 yeat 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 $1450, cal- culate the number of customers necessary to break even. Change Upcoming Sales Year $ 56,048.20 $1,177,012.20 $ 23,200.00 S 488,460.00 $1,120,964.00 $ 465,200.00 1,586,164.00 S 79,308 20 $1,665,472 20 Cost of Sales food beverage total cost of sales $ 392,337.00 $ 102,344 00 $ 19,617.27 S 411,954 27 $ 5.117. 20 S 107 461 20 494,681.00 $ 24.734 47 $ 519.415 47 1,091,483.00$ 54,573.73 $1.146,056.73 Gross Profit Controllable Expenses $ 15,861.64 S 412,402.64 $ 3.965.66 $ 103,100 66 $ 6.500.00 $ 281 830 00 771.006.00 $ 26.327 30 $ 797 333 30 $ 348,723.43 Salaries and Wages Employee Benefits Other Controllable Expenses $ 275,330.00 $ 396,541.00 $ 99,135.00 Total Controllable Expenses Income Brancy Costs, Interest, Depreciation, and Income Taxes Occupancy Costs Interest Deneciation 320,477.00 $ 75,230.00 25,600.00 $ 2,000.00 $ 77.230.00 $ 25,600.00 79 099 00 79 099 00 SSS 25 Total 26 Restaurant Profit 179.929 00 140,548.00 5 181.929 00 $ 106,794 43 128 29 Fixed Costs 30 Salaries and Wages I Employee Benefits 2 Other Controilable Expenses 3 Occupancy Costs 34 Interest 35 Depreciation 36 Total Fixed Costs 37 38 Variable Costs 39 Cost of Food Cost of Beveerages 41 Salaries and Wages 2 Employee Benefits Total Variable Costs 164,061.06 41 240 26 281,830 00 77.230.00 25,600.00 79.099.00 669.960 32 411.954 27 107 461 20 247 441.58 81,880 40 828,71745 The budgeted income statement for Barnaby's Hideaway is produced on your Excel spreadsheet. Assume that the following constitute the fixed and vari- able 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 yeat 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 $1450, cal- culate the number of customers necessary to break even. Change Upcoming Sales Year $ 56,048.20 $1,177,012.20 $ 23,200.00 S 488,460.00 $1,120,964.00 $ 465,200.00 1,586,164.00 S 79,308 20 $1,665,472 20 Cost of Sales food beverage total cost of sales $ 392,337.00 $ 102,344 00 $ 19,617.27 S 411,954 27 $ 5.117. 20 S 107 461 20 494,681.00 $ 24.734 47 $ 519.415 47 1,091,483.00$ 54,573.73 $1.146,056.73 Gross Profit Controllable Expenses $ 15,861.64 S 412,402.64 $ 3.965.66 $ 103,100 66 $ 6.500.00 $ 281 830 00 771.006.00 $ 26.327 30 $ 797 333 30 $ 348,723.43 Salaries and Wages Employee Benefits Other Controllable Expenses $ 275,330.00 $ 396,541.00 $ 99,135.00 Total Controllable Expenses Income Brancy Costs, Interest, Depreciation, and Income Taxes Occupancy Costs Interest Deneciation 320,477.00 $ 75,230.00 25,600.00 $ 2,000.00 $ 77.230.00 $ 25,600.00 79 099 00 79 099 00 SSS 25 Total 26 Restaurant Profit 179.929 00 140,548.00 5 181.929 00 $ 106,794 43 128 29 Fixed Costs 30 Salaries and Wages I Employee Benefits 2 Other Controilable Expenses 3 Occupancy Costs 34 Interest 35 Depreciation 36 Total Fixed Costs 37 38 Variable Costs 39 Cost of Food Cost of Beveerages 41 Salaries and Wages 2 Employee Benefits Total Variable Costs 164,061.06 41 240 26 281,830 00 77.230.00 25,600.00 79.099.00 669.960 32 411.954 27 107 461 20 247 441.58 81,880 40 828,71745

Answer rating: 100% (QA)

1st part Fixed costs for the upcoming year 40 of salari... View the full answer