Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 Variable Variance To Variable Standard Driver Actual Budget Budget S Covers 25 200 26,000.00 Average Check 42.50 42 0 Revenue 1,071,000 1,092,0 00 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 75 6 Culinary 0.16 Man Hours Per Cover 4,032 4,1 60 Seners 0.30 Man Hours Per Cover 7,560 7800 Samita tion 0.08 Man Hours Per Cover 2,016 21080 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 Seners 10.25 Per Hour 77 490 79.950 Sanitation 12.50 Per Hour 25,200 26.000 Total Wage Experse 202 290 18.89% S 208,183 Tax and Benefit Expense 51% Total Wages 105 191 9.82% $ 106,173 Total Payroll Expense 307 481 28.71 $ 314356 Cast of Food $12.60 Per Cover S 322,560 327/600 Direct Expenses China 1.85 CPC 47 880 4.47% 48,100100 Glass 1.10 CPC 26.460 2.47% 28.600100 Sher 1.05 CPC 30 240 2.82% 27 300100 Linen 0.75 CPC 21,420 20035 19.500100 Cleaning Supplies 0.95 CPC 21 250 198% 24 700100 Paper Supplies 0.50 CPC 12,60 0 1.18% 13,000.00 Menu Experse 350.00 Fixed 275 0.03% $ 350 Total Direct Expense 160 125 1495% $ 161.550 Total Experse $ 790,166 73.78% S 803.506 73.58% Food Departmental Profit S 230,834 26.22% $ 288,494 26.4295 Required: Create a Variable Budget in Colums ] and K Create a Variance between Actual and the Variable Budget in Columns Man N

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Advanced Accounting In Canada

Authors: Murray Hilton

6th Edition

0070001537, 978-0070001534

More Books

Students also viewed these Accounting questions

Question

Wear as little as possible

Answered: 1 week ago

Question

Be relaxed at the hips

Answered: 1 week ago