Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I dont know how toa analysis as a financial overview of the operation. Ie: did you make/lose money year over year and why Your Name
I dont know how toa analysis as a financial overview of the operation. Ie: did you make/lose money year over year and why
Your Name Here GRouP 5 FOOD DEPARTMENT SALES 1231/21 DINING ROOM REVENUE-BREAKFAST DINING ROOM REVENUE LUNCH DINING ROOM REVENUE - DINNER. BANQUET FOOD REVENUE TOTAL FOOO REVENUE OTHER REVENUE - MEETING ROCMS OTHER REVENUE - AUDIO VISUAL OTHER REVENUE- BANOUET SERVICE CHG TOTAL OTHER REVENUE TOTAL FOCO DEPARTMENT REVENUE \begin{tabular}{|r|r|r|r|r|r|} \hline 453,300 & 22.25% & 433,985 & 22.73% & 342,954 & 20.43% \\ \hline 238,235 & 11.69% & 173.594 & 9.09% & 171,477 & 10.21% \\ \hline 687,435 & 33.74% & 694,376 & 3636% & 600,170 & 35.75% \\ \hline 658.275 & 32.31% & 607,579 & 31.62% & 564,150 & 33.61% \\ \hline \end{tabular} COST OF GO00S SOLD COST OF FOOD USED LESS: EMPLOVEE MEALS CREDIT NET COST OF GOODS SOLD 2.037,243 90.65% 1,678,76089.28% \begin{tabular}{|r|r|r|r|r|r|} \hline 170.135 & 7.57% & 158.839 & 752% & 156,901 & 8.34% \\ \hline 24,180 & 1.08% & 32.115 & 1.52% & 31,723 & 1.69% \\ \hline 15.749 & 0.70% & 13.020 & 0.62% & 12.861 & 0.68% \\ \hline 210.064 & 9.35% & 203.974 & 9.65% & 201.455 & 10.72% \\ \hline 2.247.312 & 100.00% & 2.113.500 & 10000% & 1.800.245 & 100.00% \\ \hline \end{tabular} FOOO DEPARTMENT EXPENSES PAYROLL ANO RELATED Your Name Here GRCUPS BEVERAGE DEPARTMENT SALES BEVERAGE REVENUE - LOUNGE BEVERAGE REVENUE - RESTAURANT BEVERAGE REVENUE - BANDUET TOTAL BEVERAGE REVENUE COST OF GOODS SOLD COST OF BEVERAGE NET COST OF OOODS SOLD 199.51727.87% BEVERAGE DEPARTMENT EXPENSES PAYROCLL AND RELATED SALARIES AND WAGES PAYROLL TAXES EMPLOYEE BENEFITS TOTAL PAYROLL AND RELATED OPERATING EXPENSES CHINA, GLASS \& SILVER CONTRACT SERVICES LICENSES MUSIC \& ENTERTAINMENT TELEPHONE TRAINING UNIFORMS OTHER \begin{tabular}{|r|r|r|r|r|r|} \hline 71.427 & 9.95% & 71,174 & 10.06% & 70.306 & 10.83% \\ \hline 7.065 & 0.99% & 6,944 & 0.98% & 6,859 & 1.06% \\ \hline 7.857 & 1.10% & 7,829 & 1.11% & 7,734 & 1.19% \\ \hline 86.350 & 12.05% & 85,947 & 12.15% & 84.899 & 13.08% \\ \hline \end{tabular} TOTAL OPERATING EXPENSES TOTAL BEVERAGE DEPARTMENT EXPENSES BEVERAGE DEPARTMENT PROFIT \begin{tabular}{|r|r|r|r|r|r|} \hline 353 & 0.05% & 868 & 0.12% & 857 & 0.13% \\ \hline 0 & 0.00% & 0 & 0.00% & 251 & 0.044 \\ \hline 767 & 0.11% & 1,736 & 0.25% & 1,715 & 0.26% \\ \hline 29.581 & 4.13% & 21,699 & 3.07% & 21,435 & 3.30% \\ \hline 200 & 0.03% & 200 & 0.03% & 200 & 0.03% \\ \hline 0 & 0.00% & 0 & 0.00% & 0 & 0.00% \\ \hline 5.653 & 0.79% & 6.076 & 0.86% & 6.002 & 0.92% \\ \hline 0 & 0.00% & 0 & 0.00% & 251 & 0.04% \\ \hline & & & & & \\ \hline 36.614 & 5.11% & 30,579 & 4.32% & 30.711 & 4.73% \\ \hline & & & & & \\ \hline 322.481 & 45.05% & 314.597 & 44.47% & 310,851 & 47.89% \\ \hline & & & & & \\ \hline 393.353 & 54.95% & 392,799 & 55.53% & 338,189 & 52.11% \\ \hline \end{tabular} TELEPHONE DEPARTMENT SALES TELEPHONE REVENUE TOTAL TELEPHONE REVENUE COST OF TELEPHONE CALLS COST OF TELEPHONE CALLS NET COST OF PHONE CALLS 33., 107 3545% 20.68530.00% 29.32330.00% TELEPHONE DEPARTMENT EXPENSES PAYROLL AND RELATED SALARIES AND WAGES PAYROLL. TAXES EMPLOYEE BENEFITS TOTAL PAYROLL AND RELATED OPERATING EXPENSES oPERATING SUPPLLES TELEPHONE REPAIRS OTHER EXPENSES \begin{tabular}{|r|r|r|r|r|r|r|} \hline 18.815 & 20.15% & 19.953 & 20.18% & 19,720 & 20.18% \\ \hline 1.767 & 0.00% & 1,735 & 0.00% & 1,715 & 0.00% \\ \hline 1.693 & 1.51% & 1.797 & 1.82% & 1,775 & 1.82% \\ \hline 22275 & 23.55% & 23.496 & 23.75% & 23.210 & 23.75% \\ \hline \end{tabular} TOTAL ORERATING EXPENSES TOTAL. TELEPHONE DEPARTMENT EXPENSES TELERHONE DEPARTMENT PROFIT 31.0263322% Your Name Here GROUP 5 MISCELLANEOUS DEPARTMENT SALES MISCELLANEOUS REVENUE TOTAL MISCELLANEOUS REVENUE CPERATING EXPENSES OPERATING SUPPLIES TOTAL OPERATING EXPLLNES MISCELLANEOUS DEPARTMENT PROFIT 89.568 52.65% 70.419 50.00% 78.4515000% Your Name Here GROUP 5 ADMNISTRATIVE DEPARTMENT PAYROLL AND RELATED SALES AND MARUETING DEPARTMENT PAYROLL AND RELATED Your Name Here GfouP 5 MAINTENANCE DEPARTMENT PAYROLL ANO RELATED SALARIES AND WAGES PAYROLL. TAXES EMPLOYEE BENEFITS TOTAL PAYROLL ANO RELATED OPERATING EXPENSES BUILDING SUPPLLES CONTRACT SERVICES CURTAINS I DEAPES ELECTRICAL $ MECHANICAL ELEVATORS ENGINEERING SUPPLIES FLOOR COVERINGS FUPNITURE GROUNOS $ LANDSCAPING HVAC KITCHEN EQUIPMENT LAUNDRY EQUIPMENT LIGHT BULBS LOCKS \& KEYS OPERATING SUPPLIES PAINTING \& DECOFATING SWMMING POOL TELEPHONE TRAINING UNIFORMS VEPECUE MAINTENANCE WASTE REMONAL OTHER 12/31/21% 12/31/20% 12/1179 \% OTHER \begin{tabular}{|r|r|r|r|r|r|r|} \hline 177.069 & 1.46% & 151,685 & 1.37% & 154.402 & 1.42% \\ \hline 17.707 & 0.15% & 15,190 & 0.14% & 15,440 & 0.14% \\ \hline 21.248 & 0.18% & 17.468 & 0.16% & 16.984 & 0.16% \\ \hline 216.024 & 1.79% & 184.552 & 1.66% & & \\ \hline \end{tabular} TOTAL OTHER EXPENSES TOTAL DEPARTMENT EXPENSES Your Name Here GROUP S UTILITES MARKETING DEPARTMENT UTILITY EXPENSES ELECTRICITY GAS WATER \& SEWER TOTAL DEPARTMENT EXPENSES 12/31/21 12/31/207 1231/195 Your Name Here GROUP 5 BALANCE SHEET STATEMENTS OF RETAINED EARNINGS FOR THE YEAR ENDED 12/31/19 RETAINED EARNINGS BALANCE \begin{tabular}{|l|l|} \hline 12/31/18 & 650.000 \\ \hline \end{tabular} ADD (SUBTRACT): NET INCOME(LOSS) LESS: DIVDENDS DECLARED RETAINED EARNINGS BALANCE FOR THE YEAR ENDED 12/31/20 RETAINED EARTUNGS BALANCE ADO (SUBTRACT) NET INCOME(LOSS) 12/31/19 2.009.881.434 LESS: DIVDENDS DECLARED RETAINED EARNENGS BALANCE FOR THE YEAR ENDED 12/31/21 RETAINED EARNINOS BALANCE \begin{tabular}{|l|l|r|} \hline & & \\ \hline LESS: DIVIDENDS DECLARED & & 3,556.742.856 \\ \hline \end{tabular} 0 Step 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