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. Fixed Budget Variable Budget Variance To Variable $ % Standard Driver Actual % % % % Covers Average Check Revenue 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 780 Culinary 0.16 Man Hours Per Cover 4,032 4,160 Servers 0.30 Man Hours Per Cover 7,560 Sanitation 0.08 Man Hours Per Cover 2,016 7,800 2,080 Management Host Culinary Servers Sanitation $ 16,667 Per Month $ 14.50 Per Hour $ 17.85 Per Hour $ 10.25 Per Hour $ 12.50 Per Hour S $ $ $ $ $ 16,667 10,962 71,971 77,490 25,200 $ $ $ $ $ 16,667 11,310 74,256 79,950 26,000 Total Wage Expense Tax and Benefit Expense Total Payroll Expense 51% Total Wages $ $ $ 202,290 105,191 307,481 18.89% $ 9.82% $ 28.71% $ 208,183 106,173 314,356 Cost of Food $12.60 Per Cover $ 322,560 327,600 Direct Expenses China Glass olds Silver ver Linen Cleaning Supplies Paper Supplies Menu Expense Total Direct Expense $ $ $ $ $ $ $ $ $ 1.85 CPC 1.10 CPC 1.05 CPC 0.75 CPC 0.95 CPC 0.50 CPC 350.00 Fixed $ $ $ $ $ $ $ $ $ $ 47,880 26,460 30,240 21,420 21,250 12,600 275 160,125 4.47% 2.47% 2.82% 2.00% 1.98% 1.18% 0.03% $ 14.95% s 48,100.00 28,600.00 27,300.00 19,500.00 24,700.00 13,000.00 350 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 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. Fixed Budget Variable Budget Variance To Variable $ % Standard Driver Actual % % % % Covers Average Check Revenue 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 780 Culinary 0.16 Man Hours Per Cover 4,032 4,160 Servers 0.30 Man Hours Per Cover 7,560 Sanitation 0.08 Man Hours Per Cover 2,016 7,800 2,080 Management Host Culinary Servers Sanitation $ 16,667 Per Month $ 14.50 Per Hour $ 17.85 Per Hour $ 10.25 Per Hour $ 12.50 Per Hour S $ $ $ $ $ 16,667 10,962 71,971 77,490 25,200 $ $ $ $ $ 16,667 11,310 74,256 79,950 26,000 Total Wage Expense Tax and Benefit Expense Total Payroll Expense 51% Total Wages $ $ $ 202,290 105,191 307,481 18.89% $ 9.82% $ 28.71% $ 208,183 106,173 314,356 Cost of Food $12.60 Per Cover $ 322,560 327,600 Direct Expenses China Glass olds Silver ver Linen Cleaning Supplies Paper Supplies Menu Expense Total Direct Expense $ $ $ $ $ $ $ $ $ 1.85 CPC 1.10 CPC 1.05 CPC 0.75 CPC 0.95 CPC 0.50 CPC 350.00 Fixed $ $ $ $ $ $ $ $ $ $ 47,880 26,460 30,240 21,420 21,250 12,600 275 160,125 4.47% 2.47% 2.82% 2.00% 1.98% 1.18% 0.03% $ 14.95% s 48,100.00 28,600.00 27,300.00 19,500.00 24,700.00 13,000.00 350 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