Excel File Edit View Insert Format Tools Data Window Help OO AutoSave OFF A H P 5 . G ... GROUP 5 FINANCIAL STATEMENT FALL 22.xls - Compatibili Home Insert Draw Page Layout Formulas Data Review View Tell me Arial v 12 ~ A" A " ab Wrap Text Percentage Paste B I U . | EF . | GA Merge & Center $ 1 % 9 1 508 :98 16 X V fx A B C D E F G H J K PAYROLL AND RELATED SALARIES AND WAGES 341,975 2.83% 320,910 2.89% 282,929 2.61% PAYROLL TAXES 35,907 0.30% 33,696 0.30% 29,708 0.27% EMPLOYEE BENEFITS 42,747 0.35% 40,114 0.36% 35,366. 0.33% TOTAL PAYROLL AND RELATED 420,629 3.48% 394,719 3.55% 348,003. 3.21% OPERATING EXPENSES BANK CHARGES 100 0.00% 100 0.00% 100 0.00% CASH OVER/SHORT Pag 500 0.00% 500 0.00% 500 0.00% CONTRACT SERVICES 500 0.05% 5,500 0.05% 5,500 0.05% CREDIT AND COLLECTION 000 0.01% 1,000 0.01% 1,000 0.01% CREDIT CARD COMMISSIONS 29,966 0.25% 12,567 0.20% 22,292 0.21% DONATIONS 2,500 0.02% 2,500 0.02% 2,500 0.02% DUES AND SUBSCRIPTIONS 1,533 0.01% 4,340 0.04% 3,430 0.03% HUMAN RESOURCES 383 0.00% 868 0.01% 857 0.01% INFORMATION SYSTEMS 17,449 0. 14% 17,812 0. 16% 7,716 0.16% NTERNAL AUDIT 2,000 0.02% 2,000 0.02% 2,000 0.02% LOSS AND DAMAGE 0.00% 0 0.00% 0 1 0.00% MEALS AND ENTERTAINMENT 2, 150 0.02% 2,604 0.02% 2,572 0.02% OPERATING SUPPLIES 8,432 0.15% 9,095 0.17% 8,862 0.17% POSTAGE 1,767 0.01% 1,736 0.02% 1,715 0.02% PRINTING & STATIONERY 4,916 0.04% 4,340 0.04% ,287 1 0.04% PROFESSIONAL FEES 383 0.00% 868 0.01% 857 0.01% PROVISION FOR DOUBTFUL ACCTS 1,150 0.01% 2,604 0.02% 2,572 0.02% SECURITY 37,500 0.31% 30,379 0.27% 29,021 0.27% TELEPHONE 200 0.00% 200 0.00% 200 0.00% TRAINING 5,916 0.05% 4,340 0.04% 5,144 0.05% TRAVEL 2, 150 0.02% 2,604 0.02% 2,572 0.02% OTHER 307 0.00% 673 0.01% 643 - 0.01% TOTAL OTHER EXPENSES 135,801 1. 12% 126,630 1.14% 124,340 1.15% TOTAL DEPARTMENT EXPENSES 556,430 4.60% 521,349 4.69% 472,3431 4.36% A SUMM rooms food bev tel misc & adm sales mair ady K?Accessibility: Unavailable MacBook AirLE aste B I U VEY Merge & Center $ % 9 1 78 98 X V fx | =+G37/SUMMIG17 A B C D E F G H J K Your Name Here GROUP 5 ADMINISTRATIVE DEPARTMENT 12/31/21 1% 12/31/20 1%% 12/31/19 % PAYROLL AND RELATED SALARIES AND WAGES 341,975 2.83% 320,910 2.89% 282,929 2.61% PAYROLL TAXES 35,907 0.30% 33,696 0.30% 29,708 ! 0.27% EMPLOYEE BENEFITS 42,747 0.35% 40,114 0.36% 35,366. 0.33% TOTAL PAYROLL AND RELATED 420,629 3.48% 394,719 3.55% 348,003, 3.21% OPERATING EXPENSES BANK CHARGES 100 0.00% 100 0.00% 100 0.00% CASH OVER/SHORT Pag 500 0.00% 500 0.00% 500 0.00% CONTRACT SERVICES 500 0.05% 5,500 0.05% 5,500 0.05% CREDIT AND COLLECTION 10 .01% 1,000 0.01% 1,000 0.01% CREDIT CARD COMMISSIONS 9,965 0.25% 22,567 0.20% 22,292 0.21% DONATIONS 2,500 0.02% 2,500 0.02% 2,500 ! 0.02% DUES AND SUBSCRIPTIONS 1,533 0.01% 4,340 0.04% 3,430 0.03% HUMAN RESOURCES 383 0.00% 0.01% 857 0.01% INFORMATION SYSTEMS 17,449 0. 14% 17,812 0. 16% 17,716 0.16% INTERNAL AUDIT 2,000 0.02% 2,000 0.02% 2,000 0.02% LOSS AND DAMAGE 0.00% 0 0.00% 0 0.00% MEALS AND ENTERTAINMENT 2,150 0.02% 2,604 CL2% 2,572 0.02% OPERATING SUPPLIES 18,432 0. 15% 19,095 0.17% 8,862 0.17% POSTAGE 1,767 0.01% 1,736 0.02% 1,715 1 0.02% PRINTING & STATIONERY 4,916 0.04% 4,340 0.04% 4,287 0.04% PROFESSIONAL FEES 383 0.00% 868 0.01% 857 0.01% PROVISION FOR DOUBTFUL ACCTS 1,150 0.01% 2,604 0.02% 2,572 0.02% SECURITY 37,500 0.31% 30,379 0.27% 29,021 0.27% TELEPHONE 200 0.00% 200 0.00% 200 ! 0.00% TRAINING 5,916 0.05% 4,340 0.04% 5,144 0.05% TRAVEL 2;150 0.02% 2,604 0.02% 2,572 0.02% OTHER 307 0.00% 673 0.01% 643 0.01% SUMM & rooms food bev tel misc & adm sales ma Ready K?Accessibility: Unavailable NOV 19 MacBook Air 20 F3 F4 F5 F6 % N 4 5 6