Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF 19 - C ... GROUP 5 FINANCIAL STATEMENT FALL 22.xls - Compatibility Home Insert Draw Page Layout Formulas Data Review View Tell me Arial 12 A ag Wrap Text v Percentage Paste B BE Merge & Center $ % 9 1 58 28 Col A1 B C D E F G H 1 Your Name Here GROUP 5 HOW YOU A W N - SALES AND MARKETING DEPARTMENT 12/31/21 1% 12/31/20 1% 12/31/19 1% 12 PAYROLL AND RELATED 15 SALARIES AND WAGES 183,932 1.52% 210,085 1.89% 187,767 1.73% 16 PAYROLL TAXES 18,393 0.15% 21,009 0.19% 18,777 0.17% 17 EMPLOYEE BENEFITS 20,233 0.17% 23, 109 0.21% 20,654 0. 19% 18 19 TOTAL PAYROLL AND RELATED Page 254,203 2.29% 227, 198 2.10% Page 2 20 21 OPERATING EXPENSES 22 23 BROCHURES 7,683 0.06% 6,076 0.05% 6,002 0.06% 24 CONTRACT SERVICES 3,000 0.02% 3,000 0.03% 3,000 0.03% 25 DIRECT MAIL 1,916 0.02% 4,340 0.04% 4,287 0.04%1 26 DUES & SUBSCRIPTIONS 2,000 0.02% 2,000 0.02% 2,000 0.02% 27 FREQUENT STAY PROGRAMS 243,802 2.02% 200,827 1.81% 61, 120 1.49% 28 MARKETING FEES 265,966 - 2.20% 240,992 2. 17% 241,680 2.23% 29 OUTDOOR ADVERTISING 27,500 0.23% 17,500 0. 16% 17,500 0. 16% 30 PRODUCTION 3, 150 0.03% 2,604 0.02% 2,572 0.02% 31 SPECIAL PROMOTIONS 383 0.00% 868 0.01% 857 0.01% 32 TELEPHONE 603 0.00% 603 0.01% 603 0.01% 33 OTHER SALES EXPENSES 0.00% 0.00% 93 0.00% 34 35 TOTAL OTHER EXPENSES 556,003 4.60% 478,809 4.31% 439,714 4.06% 36 37 TOTAL DEPARTMENT EXPENSES 778,561 6.44% 733,012 6.60% 666,912 6.15% 38 39 40 41 42 43 44 45 SUMM rooms food bev tel misc adm siles maint Ready K? Accessibility: Unavailable MacBook Air est 20 F3 FA F5 S %