Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need a financial statement overview based on this Home Insert Draw Page Layout Formulas Data Review View Tell me Aria v 12 - A
I need a financial statement overview based on this
Home Insert Draw Page Layout Formulas Data Review View Tell me Aria v 12 - A A 29 Wrap Text Percentage Paste B I U . | BIG A - Merge & Center $1 % 9 1 $78 -98 Conc X V . D F G I L . Your Name Here GROUP 5 FOOD DEPARTMENT 12/31/21 1% 12/31/20 1/% 12/31/19 1%% SALES DINING ROOM REVENUE-BREAKFAST 453,300 22.25% 433,985 22.73% 342,954 20.43% DINING ROOM REVENUE LUNCH 238,235 11.69% 173,594 9.09% 171,477 10.21% DINING ROOM REVENUE - DINNER 687,438 33.74% 694,376 36.36% 600, 170 35.75% BANQUET FOOD REVENUE 658,275 32.31% 607,579 31.82% 564,159 33.61% 17 TOTAL FOOD REVENUE 2,037,248 90.65% 1,909,534 90.35% 1,678,760 89.28% 19 OTHER REVENUE - MEETING ROOM 170,135 1.57 7% 158,839 7.52% 156,901 8.34% 20 OTHER REVENUE - AUDIO VISUAL 24, 180 1.08% 32, 115 1.52% 31,723 1.69% OTHER REVENUE- BANQUET SERVICE CHG 15,749 0.70% 13,020 0.62% 12,861 0.68% 23 TOTAL OTHER REVENUE 210,064 9.35% 203,974 9.65% 201,485 10.72% 25 TOTAL FOOD DEPARTMENT REVENUE 2,247,312 100.00% 2,113,508 100.00% 1,880,245 100.00% 26 COST OF GOODS SOLD 28 COST OF FOOD USED 761,568 37.380 706,528 37.00% 637,929 38.00% 29 LESS: EMPLOYEE MEALS CREDIT NET COST OF GOODS SONOCO -1.41% (21,699) -1.14% (21,435) -1.28% 30 31 35.97% 684,829 35.86% 616,4948 236.72% 32 33 FOOD DEPARTMENT EXPENSES 34 35 PAYROLL AND RELATED 36 37 SALARIES AND WAGES 334, 138 16.40% 303,790 15.91% 294,083 17.52% 38 PAYROLL TAXES 31,14 1.53% 25, 171 1.32% 24,864 1.48% 39 EMPLOYEE BENEFITS 18,432 0.90% 19,095 1.00% 18,862 1.12% 40 41 TOTAL PAYROLL AND RELATED 383,714 18.83% 348,056 18.23% 337,809 20.12% 42 43 OPERATING EXPENSES 44 45 CHINA, GLASS & SILVER 6,68 0.30% 6,076 0.29% 6,002 0.32 CONTRACT CEDVICES OFAO 0 121 4 SUMM rooms A food bev tel misc adm sales maint Ready K?Accessibility: Unavailable 19 MacBook Air esc 982 no 12 F6 # Of LOStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started