Excel homework
Alex0317
Song_MOS19_XL_PROJ5_Charts.xlsxExpenses
| City Government | ||||||
| Expenses | ||||||
| Department | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Department Total | Percent of Expenses |
| Legislative | $ 321,816 | $ 335,809 | $ 363,792 | $ 377,785 | $ 1,399,202 | 4.6% |
| City Manager | 806,680 | 841,752 | 911,899 | 946,971 | 3,507,302 | 11.5% |
| City Development | 701,156 | 731,641 | 792,611 | 823,095 | 3,048,502 | 10.0% |
| City Services | 2,472,333 | 2,123,305 | 2,292,524 | 2,076,218 | 8,964,380 | 29.4% |
| Engineering | 410,228 | 428,064 | 463,737 | 481,572 | 1,783,602 | 5.9% |
| Finance | 983,228 | 1,025,977 | 1,111,475 | 1,154,223 | 4,274,903 | 14.0% |
| Public Works | 637,261 | 664,969 | 720,382 | 748,089 | 2,770,702 | 9.1% |
| Capital Projects | 390,471 | 407,448 | 441,403 | 3,458,380 | 4,697,702 | 15.4% |
| Total Expenses | $ 6,723,174 | $ 6,558,964 | $ 7,097,822 | $ 10,066,334 | $ 30,446,294 | |
1st Quarter Legislative City Manager City Development City Services Engineering Finance Pub lic Works Capital Projects 321816.32 806679.54 701155.87 2472333.13 410228.46 983227.79 637261.33 390471.26 2nd Quarter Legislative City Manager City Development City Services Engineering Finance Public Works Capital Projects 335808.58 841752.34 731640.67 2123304.91 428064.26 1025976.59 664968.83 407448.24 3rd Quarter Legislative City Manager City Development City Services Engineering Finance Public Works Capital Projects 363792.27 911898.58 792610.52 2292524.35 463736.68 1111474.92 720382.24 441402.72
