Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed
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 LO

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

Managerial Decision Modeling Business Analytics With Spreadsheet

Authors: Nagraj Balakrishnan, Barry Render, Ralph Stair, Charles Munson

4th Edition

1501515101, 978-1501515101

More Books

Students also viewed these Accounting questions

Question

Define coefficient of variation.

Answered: 1 week ago

Question

Differentiate tan(7x+9x-2.5)

Answered: 1 week ago

Question

Explain the sources of recruitment.

Answered: 1 week ago

Question

Differentiate sin(5x+2)

Answered: 1 week ago

Question

Compute the derivative f(x)=1/ax+bx

Answered: 1 week ago