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 Standard Variable Budget Variance To Variable % Driver Actual % % Covers Average Check Revenue $ $ 25,200 42.50 1,071,000 26,000.00 $ 42.00 $ 1,092,000 Host 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. 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 7,800 Sanitation 0.08 Man Hours Per Cover 2,016 2,080 $ Management Host Culinary Servers Sanitation $ $ S $ S $ S 16,667 Per Month 14.50 Per Hour 17.85 Per Hour 10.25 Per Hour 12.50 Per Hour $ $ $ $ $ $ 16,667 10,962 71,971 77,490 25,200 $ $ $ S $ $ S $ 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 Silver 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% $ 48,100.00 28,600.00 27,300.00 19,500.00 24,700.00 13,000.00 350 161,550 14.95% $ 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) 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 Standard Variable Budget Variance To Variable % Driver Actual % % Covers Average Check Revenue $ $ 25,200 42.50 1,071,000 26,000.00 $ 42.00 $ 1,092,000 Host 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. 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 7,800 Sanitation 0.08 Man Hours Per Cover 2,016 2,080 $ Management Host Culinary Servers Sanitation $ $ S $ S $ S 16,667 Per Month 14.50 Per Hour 17.85 Per Hour 10.25 Per Hour 12.50 Per Hour $ $ $ $ $ $ 16,667 10,962 71,971 77,490 25,200 $ $ $ S $ $ S $ 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 Silver 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% $ 48,100.00 28,600.00 27,300.00 19,500.00 24,700.00 13,000.00 350 161,550 14.95% $ 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) and K Create a Variance between Actual and the Variable Budget in Columns Man N