Labor Analysis Please use the information below to answer the questions. Revenue $ $ 52.2% Dining Room Food Catering Food 158,800.00 70,500.00 $ 23.296 75.4% Total Food $ $ 11.196 Dining Room Beverage Catering Beverage Bar Beverage $ TA 229.300.00 33,625.00 17.250.00 23.980.00 74,855.00 5.7% $ 7.9% Total Beverage $ 24.6% TOTAL REVENUE $ 304,155.00 100.0% Guest Covers Sold Dining Room (125 seats) Catering Bar 6,000 2,685 1,550 10,235 TOTAL Labor Work Hours and Costs Bar 1.550 10,235 TOTAL Labor Work Hours and Costs Hours $ 630 $ 7.560.00 Kitchen - Utility Kitchen - Preparation 735 $ 13,597.50 Kitchen Storeroom 315 $ 3.937.50 Kitchen Total 1.680 $ 25.095.00 950 $ 11,875.00 Dining Room Servers Dining Room Bussers Dining Room Cashiers 1,125 $ 11,812.50 420 $ 5,880.00 Dining Room Total 2,495 $ 29.567.50 Bar Bartenders 735 $ 12.862.50 Bar Servers 672 $ 6,720.00 Bar Total 1,407 $ 19.582.50 Catering (all positions) 960 $ 9.600.00 TOTAL 6,542 $ 83,845.00 1. What is the seat vacancy factor if there are 21 empty seats, all the tables are filled and guests are waiting? 2. What is the direct wages payroll cost percentage? Canvas Catering (all positions) 960 $ 9,600.00 TOTAL 6,542 $ 83,845.00 1. What is the seat vacancy factor if there are 21 empty seats, all the tables are filled and guests are waiting? 2. What is the direct wages payroll cost percentage? 3. If management wages are $145,000 per year and fringe payroll costs are 9.0% of direct wages, what is the total payroll costs percentage%? 4. What is the COGS (percentage%) if food cost is 35.5% and beverage cost is 19.85%? 5. What is the prime cost percentage%? 6. What is the fringe payroll cost percentage%? 7. What is the management payroll cost percentage%? 8. What is the sales per labor hour for the dining room? 9. What is the sales per labor hour for the bar? 10. What is the sales per labor hour for catering? Labor Analysis Please use the information below to answer the questions. Revenue $ $ 52.2% Dining Room Food Catering Food 158,800.00 70,500.00 $ 23.296 75.4% Total Food $ $ 11.196 Dining Room Beverage Catering Beverage Bar Beverage $ TA 229.300.00 33,625.00 17.250.00 23.980.00 74,855.00 5.7% $ 7.9% Total Beverage $ 24.6% TOTAL REVENUE $ 304,155.00 100.0% Guest Covers Sold Dining Room (125 seats) Catering Bar 6,000 2,685 1,550 10,235 TOTAL Labor Work Hours and Costs Bar 1.550 10,235 TOTAL Labor Work Hours and Costs Hours $ 630 $ 7.560.00 Kitchen - Utility Kitchen - Preparation 735 $ 13,597.50 Kitchen Storeroom 315 $ 3.937.50 Kitchen Total 1.680 $ 25.095.00 950 $ 11,875.00 Dining Room Servers Dining Room Bussers Dining Room Cashiers 1,125 $ 11,812.50 420 $ 5,880.00 Dining Room Total 2,495 $ 29.567.50 Bar Bartenders 735 $ 12.862.50 Bar Servers 672 $ 6,720.00 Bar Total 1,407 $ 19.582.50 Catering (all positions) 960 $ 9.600.00 TOTAL 6,542 $ 83,845.00 1. What is the seat vacancy factor if there are 21 empty seats, all the tables are filled and guests are waiting? 2. What is the direct wages payroll cost percentage? Canvas Catering (all positions) 960 $ 9,600.00 TOTAL 6,542 $ 83,845.00 1. What is the seat vacancy factor if there are 21 empty seats, all the tables are filled and guests are waiting? 2. What is the direct wages payroll cost percentage? 3. If management wages are $145,000 per year and fringe payroll costs are 9.0% of direct wages, what is the total payroll costs percentage%? 4. What is the COGS (percentage%) if food cost is 35.5% and beverage cost is 19.85%? 5. What is the prime cost percentage%? 6. What is the fringe payroll cost percentage%? 7. What is the management payroll cost percentage%? 8. What is the sales per labor hour for the dining room? 9. What is the sales per labor hour for the bar? 10. What is the sales per labor hour for catering
