Johns Steak House had the following results for January. John, the owner, has asked you to...

Transcribed Image Text:

Johns Steak House had the following results for January. John, the owner, has asked you to prepare a variable budget and compare the actual results to that variable budget. Covers Average Check Revenue Standard Driver Fixed Actual % Budget % 25,200 $ 42.50 $ 1,071,000 $ 26,000.00 42.00 $ 1,092,000 Payroll and Benefits NOTE: The calculations on rows 11-14 are for man hours per cover. These are then multiplied by the wage rate to determine cost. Host 0.03 Man Hours Per Cover 756 Culinary 0.16 Man Hours Per Cover 4,032 Servers 0.30 Man Hours Per Cover 7,560 Sanitation 0.08 Man Hours Per Cover 2,016 780 4,160 7,800 2,080 Management $ 16,667 Per Month $ 16,667 $ 16,667 Host $ 14.50 Per Hour $ 10,962 $ 11,310 Culinary $ 17.85 Per Hour $ 71,971 $ 74,256 Servers $ 10.25 Per Hour $ 77,490 $ 79,950 Sanitation $ 12.50 Per Hour $ 25,200 $ 26,000 Total Wage Expense $ 202,290 18.89% $ 208,183 Tax and Benefit Expense 51% Total Wages $ 105,191 9.82% $ 106.173 Total Payroll Expense $ 307, 481 28.71% $ 314,356 Cast of Food $12.60 Per Cover $ 322,560 327,600 Direct Expenses China $ 1.85 CPC $ 47,880 4.47% 48,100.00 Glass $ 1.10 CPC $ 26,460 2.47% 28,600.00 Siver $ 1.05 CPC $ 30,240 2.82% 27,300.00 Linen $ 0.75 CPC $ 21,420 2.00% 19,500.00 Cleaning Supplies $ 0.95 CPC $ 21,250 1.98% 24,700.00 Paper Supplies $ 0.50 CPC $ 12,600 1.18% 13,000.00 Menu Expense $ 350.00 Fixed $ 275 0.03% $ 350 Total Direct Expense $ 160,125 14.95% $ 161,550 Total Expense $ 790,166 73.78% $ 803,506 73.58% Food Departmental Profit $ 280,834 26.22% $ 288,494 26.42% Required: Create a Variable Budget in Colums J and K Create a Variance between Actual and the Variable Budget in Columns Man N Variance To Variable Variable % $ Budget % Johns Steak House had the following results for January. John, the owner, has asked you to prepare a variable budget and compare the actual results to that variable budget. Covers Average Check Revenue Standard Driver Fixed Actual % Budget % 25,200 $ 42.50 $ 1,071,000 $ 26,000.00 42.00 $ 1,092,000 Payroll and Benefits NOTE: The calculations on rows 11-14 are for man hours per cover. These are then multiplied by the wage rate to determine cost. Host 0.03 Man Hours Per Cover 756 Culinary 0.16 Man Hours Per Cover 4,032 Servers 0.30 Man Hours Per Cover 7,560 Sanitation 0.08 Man Hours Per Cover 2,016 780 4,160 7,800 2,080 Management $ 16,667 Per Month $ 16,667 $ 16,667 Host $ 14.50 Per Hour $ 10,962 $ 11,310 Culinary $ 17.85 Per Hour $ 71,971 $ 74,256 Servers $ 10.25 Per Hour $ 77,490 $ 79,950 Sanitation $ 12.50 Per Hour $ 25,200 $ 26,000 Total Wage Expense $ 202,290 18.89% $ 208,183 Tax and Benefit Expense 51% Total Wages $ 105,191 9.82% $ 106.173 Total Payroll Expense $ 307, 481 28.71% $ 314,356 Cast of Food $12.60 Per Cover $ 322,560 327,600 Direct Expenses China $ 1.85 CPC $ 47,880 4.47% 48,100.00 Glass $ 1.10 CPC $ 26,460 2.47% 28,600.00 Siver $ 1.05 CPC $ 30,240 2.82% 27,300.00 Linen $ 0.75 CPC $ 21,420 2.00% 19,500.00 Cleaning Supplies $ 0.95 CPC $ 21,250 1.98% 24,700.00 Paper Supplies $ 0.50 CPC $ 12,600 1.18% 13,000.00 Menu Expense $ 350.00 Fixed $ 275 0.03% $ 350 Total Direct Expense $ 160,125 14.95% $ 161,550 Total Expense $ 790,166 73.78% $ 803,506 73.58% Food Departmental Profit $ 280,834 26.22% $ 288,494 26.42% Required: Create a Variable Budget in Colums J and K Create a Variance between Actual and the Variable Budget in Columns Man N Variance To Variable Variable % $ Budget %