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 0 DE sohns 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 Standard Driver Actual % Budget * Variable Budget Variance To Variable NOWN 4032 Covers 25,200 26,000.00 Average Check $ 42.50 $ 42.00 Revenue 51,071,000 5 1,092,000 9 Payroll and Benefits 10 NOTE: The calculations on rows 11-14 are for man hours per cover. These are then multiplied by the wage rate to determine cost 11 Host 0.03 Man Hours Per Cover 756 780 12 Culinary 0.16 Man Hours Per Cover 4.160 13 Servers 0 30 Man Hours Per Cover 7.560 7.800 14 Sanitation 0.08 Man Hours Per Cover 2,016 2,080 15 16 Management $ 16,667 Per Month $ 16,667 $ 16,667 17 Host $ 14.50 Per Hour $ 10,962 $ 11310 18 Culinary $ 17 85 Per Hour $ 71.971 $ 74.256 19 Servers $ 10.25 Per Hour 77490 5 79,950 20 Sanitation $ 12.50 Per Hour $ 25,200 $ 26,000 21 22 Total Wage Expense $ 202,290 18.89% $ 208,183 23 Tax and Benefit Experte 51% Total Wages $ 105 191 9.82% 106.17 24 TotalPayroll $ 307 A81 28.71% 5 314.356 25 26 Cost of Food $12.60 Per Cover $ 322,560 327.500 27 28 Direct Expenses 29 China $ 1.85 CPC $ 47880 4.47% 48,100.00 30 Glass $ 1.10 CPC $ 26,460 2.47% 28,600.00 31 Silver 5 1.05 CPC $ 30,240 2.82% 27,300.00 32 Linen $ 0.75 CPC $ 21420 2.00% 19,500.00 33 Cleaning Supplies $ 0.95 CPC $ 21.250 1.98% 24,700.00 34 Paper Supplies $ 050 OPC $ 12,600 1.18 13,000.00 35 Menutypeme 150.00 275 0.0 36 Total Dressere ES 160125 14.95 161.550 37 Totalt pense S 720166 71.78% 801 506 21.58 390 26,22% 288434 26.42 40 Food Departmental Profil 280814 41 42 4 Required 44 Create a Variable Budget in Columns and Create a Varance between Actual and the Variable ludert in Columns Mann 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 0 DE sohns 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 Standard Driver Actual % Budget * Variable Budget Variance To Variable NOWN 4032 Covers 25,200 26,000.00 Average Check $ 42.50 $ 42.00 Revenue 51,071,000 5 1,092,000 9 Payroll and Benefits 10 NOTE: The calculations on rows 11-14 are for man hours per cover. These are then multiplied by the wage rate to determine cost 11 Host 0.03 Man Hours Per Cover 756 780 12 Culinary 0.16 Man Hours Per Cover 4.160 13 Servers 0 30 Man Hours Per Cover 7.560 7.800 14 Sanitation 0.08 Man Hours Per Cover 2,016 2,080 15 16 Management $ 16,667 Per Month $ 16,667 $ 16,667 17 Host $ 14.50 Per Hour $ 10,962 $ 11310 18 Culinary $ 17 85 Per Hour $ 71.971 $ 74.256 19 Servers $ 10.25 Per Hour 77490 5 79,950 20 Sanitation $ 12.50 Per Hour $ 25,200 $ 26,000 21 22 Total Wage Expense $ 202,290 18.89% $ 208,183 23 Tax and Benefit Experte 51% Total Wages $ 105 191 9.82% 106.17 24 TotalPayroll $ 307 A81 28.71% 5 314.356 25 26 Cost of Food $12.60 Per Cover $ 322,560 327.500 27 28 Direct Expenses 29 China $ 1.85 CPC $ 47880 4.47% 48,100.00 30 Glass $ 1.10 CPC $ 26,460 2.47% 28,600.00 31 Silver 5 1.05 CPC $ 30,240 2.82% 27,300.00 32 Linen $ 0.75 CPC $ 21420 2.00% 19,500.00 33 Cleaning Supplies $ 0.95 CPC $ 21.250 1.98% 24,700.00 34 Paper Supplies $ 050 OPC $ 12,600 1.18 13,000.00 35 Menutypeme 150.00 275 0.0 36 Total Dressere ES 160125 14.95 161.550 37 Totalt pense S 720166 71.78% 801 506 21.58 390 26,22% 288434 26.42 40 Food Departmental Profil 280814 41 42 4 Required 44 Create a Variable Budget in Columns and Create a Varance between Actual and the Variable ludert in Columns Mann