Budget Revisions
QuTee1
mayot_unit_7_assignment.xlsxJAN
| CRAC BUDGET | |||||||||||||||||
| EXPENDITURES | REVENUE | ||||||||||||||||
| CATEGORY | BUDGETED $ ACTUAL $ % | SOURCE | BUDGETED $ ACTUAL$ % | ||||||||||||||
| Salaries | $732,000 | $924,000 | 21.5913578487 | Taxes | $987,000 | $925,339 | 21.6226466238 | ||||||||||
| Benefits | $204,300 | $277,200 | 6.4774073546 | Licenses, Permits, Franchises, and Fines | $561,230 | $593,760 | 13.8745504721 | ||||||||||
| Building Occupancy | $123,000 | $108,000 | 2.5236652031 | Money and Property | $623,000 | $718,740 | 16.7949919266 | ||||||||||
| Management & general | $64,000 | $56,410 | 1.3181477232 | Rents and Concessions | $317,000 | $382,600 | 8.9403176547 | ||||||||||
| Audit | $21,750 | $23,102 | 0.5398306808 | Intergovernmental Revenues | $413,100 | $426,745 | 9.9718658064 | ||||||||||
| Office supplies | $3,110 | $2,300 | 0.0537447219 | Charges for Services | $472,185 | $629,740 | 14.7153048611 | ||||||||||
| Postage/Printing | $1,090 | $1,640 | 0.0383223235 | Prior Year Fund Balance | $602,566 | $602,566 | 14.0803226553 | ||||||||||
| Computer | $41,275 | $36,450 | 0.851737006 | Total Revenue | $3,976,081 | $4,279,490 | 100% | ||||||||||
| Staff training | $31,920 | $21,350 | 0.498891223 | ||||||||||||||
| Equipment maintenance | $87,540 | $69,475 | 1.623441111 | ||||||||||||||
| Insurance | $11,440 | $10,118 | 0.2364300419 | ||||||||||||||
| Vehicle maintenance | $9,850 | $7,490 | 0.1750208553 | ||||||||||||||
| C16 | |||||||||||||||||
| Utilities | $3,576 | $3,115 | 0.0727890473 | ||||||||||||||
| Legal Services | $6,150 | $4,190 | 0.097908863 | ||||||||||||||
| Equipment | $824,000 | $700,000 | 16.3570892793 | ||||||||||||||
| Communications | $6,780 | $3,500 | 0.0817854464 | ||||||||||||||
| Transportation and Travel | $3,500 | $2,150 | 0.0502396314 | ||||||||||||||
| Fixed Assets | $1,108,000 | $1,280,000 | 29.9101061108 | ||||||||||||||
| Capital Assets | $692,800 | $749,000 | 17.5020855289 | ||||||||||||||
| Total Expenditures | $3,976,081 | $4,279,490 | 100% | ||||||||||||||
FEB
| CRAC BUDGET | |||||||||||||||||
| EXPENDITURES | REVENUE | ||||||||||||||||
| CATEGORY | BUDGETED $ ACTUAL $ % | SOURCE | BUDGETED $ ACTUAL$ % | ||||||||||||||
| Salaries | $670,000 | $681,000 | 21.0968830207 | Taxes | $872,000 | $912,300 | 28.2623882229 | ||||||||||
| Benefits | $201,000 | $204,300 | 6.3290649062 | Licenses, Permits, Franchises, and Fines | $481,002 | $413,290 | 12.8034225898 | ||||||||||
| Building Occupancy | $100,000 | $110,000 | 3.4077197243 | Money and Property | $372,304 | $278,900 | 8.6401184647 | ||||||||||
| Management & general | $57,700 | $52,900 | 1.6388033947 | Rents and Concessions | $234,600 | $212,200 | 6.573801141 | ||||||||||
| Audit | $21,930 | $18,300 | 0.5669206451 | Intergovernmental Revenues | $320,123 | $290,800 | 9.0087717804 | ||||||||||
| Office supplies | $3,290 | $3,000 | 0.0929378107 | Charges for Services | $361,880 | $517,909 | 16.0444428611 | ||||||||||
| Postage/Printing | $1,500 | $1,440 | 0.0446101491 | Prior Year Fund Balance | $602,566 | $602,566 | 18.6670549402 | ||||||||||
| Computer | $41,250 | $48,000 | 1.4870049706 | Total Revenue | $3,244,475 | $3,227,965 | 100% | ||||||||||
| Staff training | $30,500 | $17,800 | 0.5514310099 | ||||||||||||||
| Equipment maintenance | $45,870 | $29,475 | 0.9131139898 | ||||||||||||||
| Insurance | $7,420 | $6,000 | 0.1858756213 | ||||||||||||||
| Vehicle maintenance | $12,100 | $13,690 | 0.4241062093 | ||||||||||||||
| C16 | |||||||||||||||||
| Utilities | $2,150 | $3,450 | 0.1068784823 | ||||||||||||||
| Legal Services | $2,165 | $3,310 | 0.1025413844 | ||||||||||||||
| Equipment | $400,000 | $325,000 | 10.0682628219 | ||||||||||||||
| Communications | $3,400 | $4,500 | 0.139406716 | ||||||||||||||
| Transportation and Travel | $4,200 | $3,800 | 0.1177212268 | ||||||||||||||
| Fixed Assets | $750,000 | $950,000 | 29.4303067103 | ||||||||||||||
| Capital Assets | $890,000 | $752,000 | 23.2964112064 | ||||||||||||||
| Total Expenditures | $3,244,475 | $3,227,965 | 100% | ||||||||||||||
MARCH
| CRAC BUDGET | |||||||||||||||||
| EXPENDITURES | REVENUE | ||||||||||||||||
| CATEGORY | BUDGETED $ ACTUAL $ % | SOURCE | BUDGETED $ ACTUAL$ % | ||||||||||||||
| Salaries | $725,300 | $810,820 | 18.605938333 | Taxes | $871,000 | $901,500 | 20.6867780854 | ||||||||||
| Benefits | $217,590 | $243,246 | 5.5817814999 | Licenses, Permits, Franchises, and Fines | $587,200 | $602,620 | 13.8283596337 | ||||||||||
| Building Occupancy | $120,000 | $90,000 | 2.065235749 | Money and Property | $650,800 | $510,950 | 11.7248022881 | ||||||||||
| Management & general | $61,200 | $59,900 | 1.3745291262 | Rents and Concessions | $520,115 | $621,046 | 14.2511822327 | ||||||||||
| Audit | $17,850 | $20,000 | 0.4589412775 | Intergovernmental Revenues | $421,750 | $387,690 | 8.8963471946 | ||||||||||
| Office supplies | $3,790 | $2,900 | 0.0665464852 | Charges for Services | $439,939 | $731,484 | 16.7854100732 | ||||||||||
| Postage/Printing | $980 | $1,630 | 0.0374037141 | Prior Year Fund Balance | $602,566 | $602,566 | 13.8271204923 | ||||||||||
| Computer | $34,210 | $36,200 | 0.8306837124 | Total Revenue | $4,093,370 | $4,357,856 | 100% | ||||||||||
| Staff training | $37,620 | $21,000 | 0.4818883414 | ||||||||||||||
| Equipment maintenance | $61,200 | $89,475 | 2.0531885404 | ||||||||||||||
| Insurance | $12,390 | $11,700 | 0.2684806474 | ||||||||||||||
| Vehicle maintenance | $9,700 | $9,690 | 0.222357049 | ||||||||||||||
| C16 | |||||||||||||||||
| Utilities | $1,800 | $4,975 | 0.1141616428 | ||||||||||||||
| Legal Services | $6,230 | $6,170 | 0.1415833841 | ||||||||||||||
| Equipment | $751,000 | $1,000,000 | 22.9470638773 | ||||||||||||||
| Communications | $7,100 | $8,200 | 0.1881659238 | ||||||||||||||
| Transportation and Travel | $5,100 | $6,950 | 0.1594820939 | ||||||||||||||
| Fixed Assets | $1,310,000 | $1,100,000 | 25.241770265 | ||||||||||||||
| Capital Assets | $710,310 | $835,000 | 19.1607983375 | ||||||||||||||
| Total Expenditures | $4,093,370 | $4,357,856 | 100% | ||||||||||||||
APRIL
| CRAC BUDGET | |||||||||||||||||
| EXPENDITURES | REVENUE | ||||||||||||||||
| CATEGORY | BUDGETED $ ACTUAL $ % | SOURCE | BUDGETED $ ACTUAL$ % | ||||||||||||||
| Salaries | $750,000 | $954,000 | 23.5483456917 | Taxes | $961,000 | $755,130 | 18.6394782832 | ||||||||||
| Benefits | $225,000 | $286,200 | 7.0645037075 | Licenses, Permits, Franchises, and Fines | $590,759 | $593,414 | 14.647712799 | ||||||||||
| Building Occupancy | $120,000 | $111,000 | 2.7399018572 | Money and Property | $760,300 | $678,900 | 16.7578321699 | ||||||||||
| Management & general | $54,000 | $62,900 | 1.5526110524 | Rents and Concessions | $338,920 | $483,500 | 11.9346175492 | ||||||||||
| Audit | $23,750 | $23,300 | 0.575132552 | Intergovernmental Revenues | $465,100 | $483,230 | 11.9279529231 | ||||||||||
| Office supplies | $3,450 | $2,000 | 0.049367601 | Charges for Services | $415,546 | $454,500 | 11.2187873342 | ||||||||||
| Postage/Printing | $1,290 | $1,340 | 0.0330762927 | Prior Year Fund Balance | $602,566 | $602,566 | 14.8736189414 | ||||||||||
| Computer | $43,275 | $38,000 | 0.9379844196 | Total Revenue | $4,134,191 | $4,051,240 | 100% | ||||||||||
| Staff training | $32,760 | $21,000 | 0.5183598108 | ||||||||||||||
| Equipment maintenance | $78,540 | $89,475 | 2.2085830511 | ||||||||||||||
| Insurance | $9,420 | $10,100 | 0.2493063852 | ||||||||||||||
| Vehicle maintenance | $10,000 | $7,690 | 0.189818426 | ||||||||||||||
| C16 | |||||||||||||||||
| Utilities | $2,356 | $3,215 | 0.0793584187 | ||||||||||||||
| Legal Services | $5,350 | $4,370 | 0.1078682083 | ||||||||||||||
| Equipment | $894,000 | $900,000 | 22.2154204639 | ||||||||||||||
| Communications | $5,700 | $3,500 | 0.0863933018 | ||||||||||||||
| Transportation and Travel | $3,000 | $4,150 | 0.1024377721 | ||||||||||||||
| Fixed Assets | $1,200,000 | $980,000 | 24.1901245051 | ||||||||||||||
| Capital Assets | $672,300 | $549,000 | 13.551406483 | ||||||||||||||
| Total Expenditures | $4,134,191 | $4,051,240 | 100% | ||||||||||||||
MAY
| CRAC BUDGET | |||||||||||||||||
| EXPENDITURES | REVENUE | ||||||||||||||||
| CATEGORY | BUDGETED $ ACTUAL $ % | SOURCE | BUDGETED $ ACTUAL$ % | ||||||||||||||
| Salaries | $720,000 | $754,000 | 20.8331606447 | Taxes | $621,000 | $618,300 | 17.0837443324 | ||||||||||
| Benefits | $216,000 | $226,200 | 6.2499481934 | Licenses, Permits, Franchises, and Fines | $470,780 | $465,800 | 12.8701408863 | ||||||||||
| Building Occupancy | $90,000 | $101,000 | 2.7906488397 | Money and Property | $610,300 | $600,500 | 16.5919270121 | ||||||||||
| Management & general | $41,000 | $52,900 | 1.4616368675 | Rents and Concessions | $345,700 | $338,700 | 9.3583441782 | ||||||||||
| Audit | $21,750 | $19,300 | 0.5332626001 | Intergovernmental Revenues | $491,000 | $443,103 | 12.2430185426 | ||||||||||
| Office supplies | $7,890 | $6,000 | 0.1657811192 | Charges for Services | $459,747 | $550,261 | 15.2038140709 | ||||||||||
| Postage/Printing | $2,210 | $1,940 | 0.0536025619 | Prior Year Fund Balance | $602,566 | $602,566 | 16.6490109775 | ||||||||||
| Computer | $35,295 | $36,500 | 1.0085018084 | Total Revenue | $3,601,093 | $3,619,230 | 100% | ||||||||||
| Staff training | $29,760 | $28,000 | 0.7736452229 | ||||||||||||||
| Equipment maintenance | $71,600 | $79,475 | 2.1959090746 | ||||||||||||||
| Insurance | $11,200 | $9,190 | 0.2539214142 | ||||||||||||||
| Vehicle maintenance | $9,820 | $8,190 | 0.2262912277 | ||||||||||||||
| C16 | |||||||||||||||||
| Utilities | $3,118 | $3,415 | 0.094357087 | ||||||||||||||
| Legal Services | $6,150 | $5,370 | 0.1483741017 | ||||||||||||||
| Equipment | $774,000 | $800,000 | 22.1041492251 | ||||||||||||||
| Communications | $6,100 | $5,600 | 0.1547290446 | ||||||||||||||
| Transportation and Travel | $2,900 | $3,150 | 0.0870350876 | ||||||||||||||
| Fixed Assets | $980,000 | $880,000 | 24.3145641476 | ||||||||||||||
| Capital Assets | $572,300 | $599,000 | 16.5504817323 | ||||||||||||||
| Total Expenditures | $3,601,093 | $3,619,230 | 100% | ||||||||||||||
JUNE
| CRAC BUDGET | |||||||||||||||||
| EXPENDITURES | REVENUE | ||||||||||||||||
| CATEGORY | BUDGETED $ ACTUAL $ % | SOURCE | BUDGETED $ ACTUAL$ % | ||||||||||||||
| Salaries | $730,000 | $754,000 | 20.9891630223 | Taxes | $632,000 | $635,130 | 17.6801685814 | ||||||||||
| Benefits | $219,000 | $226,200 | 6.2967489067 | Licenses, Permits, Franchises, and Fines | $421,200 | $434,700 | 12.100781387 | ||||||||||
| Building Occupancy | $85,000 | $91,000 | 2.5331748475 | Money and Property | $360,500 | $378,900 | 10.547471975 | ||||||||||
| Management & general | $53,900 | $52,900 | 1.4725818619 | Rents and Concessions | $512,930 | $542,600 | 15.1044029919 | ||||||||||
| Audit | $20,800 | $21,300 | 0.5929299368 | Intergovernmental Revenues | $515,420 | $483,230 | 13.4517151821 | ||||||||||
| Office supplies | $4,450 | $4,590 | 0.1277722258 | Charges for Services | $467,385 | $515,204 | 14.3417781774 | ||||||||||
| Postage/Printing | $1,340 | $1,530 | 0.0425907419 | Prior Year Fund Balance | $602,566 | $602,566 | 16.7736817052 | ||||||||||
| Computer | $42,905 | $40,100 | 1.1162671581 | Total Revenue | $3,512,001 | $3,592,330 | 100% | ||||||||||
| Staff training | $31,600 | $29,100 | 0.8100592095 | ||||||||||||||
| Equipment maintenance | $75,540 | $79,475 | 2.2123524286 | ||||||||||||||
| Insurance | $9,720 | $8,100 | 0.2254803985 | ||||||||||||||
| Vehicle maintenance | $12,110 | $12,690 | 0.3532526243 | ||||||||||||||
| C16 | |||||||||||||||||
| Utilities | $3,076 | $3,815 | 0.106198484 | ||||||||||||||
| Legal Services | $4,980 | $5,880 | 0.1636820671 | ||||||||||||||
| Equipment | $704,000 | $700,000 | 19.4859603656 | ||||||||||||||
| Communications | $5,300 | $4,500 | 0.1252668881 | ||||||||||||||
| Transportation and Travel | $2,980 | $3,150 | 0.0876868216 | ||||||||||||||
| Fixed Assets | $963,000 | $995,000 | 27.6979008053 | ||||||||||||||
| Capital Assets | $542,300 | $559,000 | 15.5609312062 | ||||||||||||||
| Total Expenditures | $3,512,001 | $3,592,330 | 100% | ||||||||||||||
JULY
| CRAC BUDGET | |||||||||||||||||
| EXPENDITURES | REVENUE | ||||||||||||||||
| CATEGORY | BUDGETED $ ACTUAL $ % | SOURCE | BUDGETED $ ACTUAL$ % | ||||||||||||||
| Salaries | $710,000 | $754,000 | 20.6983638959 | Taxes | $720,800 | $695,130 | 19.0822993302 | ||||||||||
| Benefits | $213,000 | $226,200 | 6.2095091688 | Licenses, Permits, Franchises, and Fines | $345,700 | $393,210 | 10.7941693203 | ||||||||||
| Building Occupancy | $109,000 | $110,000 | 3.0196552103 | Money and Property | $760,300 | $618,600 | 16.9814428462 | ||||||||||
| Management & general | $49,000 | $42,870 | 1.1768419897 | Rents and Concessions | $328,620 | $332,100 | 9.1166135939 | ||||||||||
| Audit | $20,720 | $23,300 | 0.6396178764 | Intergovernmental Revenues | $415,400 | $473,030 | 12.9853409465 | ||||||||||
| Office supplies | $3,050 | $3,090 | 0.08482486 | Charges for Services | $519,471 | $528,164 | 14.4988470407 | ||||||||||
| Postage/Printing | $1,070 | $1,240 | 0.0340397496 | Prior Year Fund Balance | $602,566 | $602,566 | 16.5412869221 | ||||||||||
| Computer | $40,200 | $38,700 | 1.0623696058 | Total Revenue | $3,692,857 | $3,642,800 | 100% | ||||||||||
| Staff training | $31,240 | $28,800 | 0.7906006369 | ||||||||||||||
| Equipment maintenance | $68,240 | $59,675 | 1.6381629516 | ||||||||||||||
| Insurance | $7,920 | $9,100 | 0.2498078401 | ||||||||||||||
| Vehicle maintenance | $8,800 | $7,870 | 0.2160426046 | ||||||||||||||
| C16 | |||||||||||||||||
| Utilities | $2,656 | $3,925 | 0.1077467882 | ||||||||||||||
| Legal Services | $4,971 | $4,370 | 0.1199626661 | ||||||||||||||
| Equipment | $982,000 | $875,000 | 24.0199846272 | ||||||||||||||
| Communications | $5,250 | $3,510 | 0.0963544526 | ||||||||||||||
| Transportation and Travel | $3,140 | $4,150 | 0.1139233557 | ||||||||||||||
| Fixed Assets | $800,300 | $798,000 | 21.90622598 | ||||||||||||||
| Capital Assets | $632,300 | $649,000 | 17.8159657406 | ||||||||||||||
| Total Expenditures | $3,692,857 | $3,642,800 | 100% | ||||||||||||||
AUG
| CRAC BUDGET | |||||||||||||||||
| EXPENDITURES | REVENUE | ||||||||||||||||
| CATEGORY | BUDGETED $ ACTUAL $ % | SOURCE | BUDGETED $ ACTUAL$ % | ||||||||||||||
| Salaries | $710,660 | $692,000 | 21.8009541383 | Taxes | $656,300 | $655,230 | 20.6425421677 | ||||||||||
| Benefits | $213,198 | $207,600 | 6.5402862415 | Licenses, Permits, Franchises, and Fines | $395,700 | $393,304 | 12.3907550093 | ||||||||||
| Building Occupancy | $123,100 | $120,900 | 3.8088661204 | Money and Property | $352,850 | $378,500 | 11.9243658112 | ||||||||||
| Management & general | $51,700 | $52,700 | 1.6602749756 | Rents and Concessions | $291,520 | $311,300 | 9.8072789353 | ||||||||||
| Audit | $19,950 | $20,100 | 0.6332358066 | Intergovernmental Revenues | $375,100 | $383,230 | 12.0733810035 | ||||||||||
| Office supplies | $4,050 | $4,100 | 0.1291675028 | Charges for Services | $390,053 | $450,043 | 14.1782757273 | ||||||||||
| Postage/Printing | $1,580 | $1,420 | 0.044736062 | Prior Year Fund Balance | $602,566 | $602,566 | 18.9834013458 | ||||||||||
| Computer | $48,015 | $49,700 | 1.5657621686 | Total Revenue | $3,064,089 | $3,174,173 | 100% | ||||||||||
| Staff training | $30,950 | $31,000 | 0.9766323386 | ||||||||||||||
| Equipment maintenance | $51,540 | $59,550 | 1.8760792181 | ||||||||||||||
| Insurance | $7,310 | $9,100 | 0.2866888478 | ||||||||||||||
| Vehicle maintenance | $13,400 | $16,690 | 0.5258062494 | ||||||||||||||
| C16 | |||||||||||||||||
| Utilities | $2,786 | $2,968 | 0.0935046704 | ||||||||||||||
| Legal Services | $5,900 | $6,395 | 0.2014698002 | ||||||||||||||
| Equipment | $210,000 | $250,000 | 7.8760672465 | ||||||||||||||
| Communications | $5,250 | $5,600 | 0.1764239063 | ||||||||||||||
| Transportation and Travel | $5,600 | $5,150 | 0.1622469853 | ||||||||||||||
| Fixed Assets | $870,000 | $980,000 | 30.8741836062 | ||||||||||||||
| Capital Assets | $689,100 | $659,200 | 20.7676141156 | ||||||||||||||
| Total Expenditures | $3,064,089 | $3,174,173 | 100% | ||||||||||||||
SEPT
| CRAC BUDGET | |||||||||||||||||
| EXPENDITURES | REVENUE | ||||||||||||||||
| CATEGORY | BUDGETED $ ACTUAL $ % | SOURCE | BUDGETED $ ACTUAL$ % | ||||||||||||||
| Salaries | $670,000 | $684,000 | 18.1883934649 | Taxes | $861,000 | $755,130 | 20.079826838 | ||||||||||
| Benefits | $201,000 | $205,200 | 5.4565180395 | Licenses, Permits, Franchises, and Fines | $490,787 | $465,780 | 12.3856577604 | ||||||||||
| Building Occupancy | $122,000 | $120,650 | 3.208230514 | Money and Property | $512,300 | $578,700 | 15.3883381552 | ||||||||||
| Management & general | $51,000 | $52,900 | 1.4066754595 | Rents and Concessions | $308,900 | $414,934 | 11.0336006637 | ||||||||||
| Audit | $20,760 | $20,300 | 0.5398017359 | Intergovernmental Revenues | $395,100 | $383,530 | 10.1985300374 | ||||||||||
| Office supplies | $3,150 | $2,900 | 0.0771145337 | Charges for Services | $423,908 | $560,000 | 14.891082369 | ||||||||||
| Postage/Printing | $1,890 | $1,640 | 0.0436095984 | Prior Year Fund Balance | $602,566 | $602,566 | 16.0229641763 | ||||||||||
| Computer | $42,175 | $34,500 | 0.9173970388 | Total Revenue | $3,594,561 | $3,760,640 | 100% | ||||||||||
| Staff training | $31,260 | $32,800 | 0.8721919673 | ||||||||||||||
| Equipment maintenance | $76,240 | $82,475 | 2.1931107471 | ||||||||||||||
| Insurance | $9,740 | $11,150 | 0.2964920865 | ||||||||||||||
| Vehicle maintenance | $11,500 | $17,690 | 0.4703986555 | ||||||||||||||
| C16 | |||||||||||||||||
| Utilities | $3,656 | $4,215 | 0.112081986 | ||||||||||||||
| Legal Services | $5,270 | $5,770 | 0.1534313308 | ||||||||||||||
| Equipment | $824,000 | $905,000 | 24.065052757 | ||||||||||||||
| Communications | $4,900 | $5,500 | 0.1462517018 | ||||||||||||||
| Transportation and Travel | $3,220 | $4,950 | 0.1316265317 | ||||||||||||||
| Fixed Assets | $890,000 | $920,000 | 24.4639210347 | ||||||||||||||
| Capital Assets | $622,800 | $649,000 | 17.2577008169 | ||||||||||||||
| Total Expenditures | $3,594,561 | $3,760,640 | 100% | ||||||||||||||
OCT
| CRAC BUDGET | |||||||||||||||||
| EXPENDITURES | REVENUE | ||||||||||||||||
| CATEGORY | BUDGETED $ ACTUAL $ % | SOURCE | BUDGETED $ ACTUAL$ % | ||||||||||||||
| Salaries | $720,000 | $681,000 | 21.4919042427 | Taxes | $870,000 | $882,300 | 27.8447975232 | ||||||||||
| Benefits | $216,000 | $204,300 | 6.4475712728 | Licenses, Permits, Franchises, and Fines | $481,002 | $473,290 | 14.936715652 | ||||||||||
| Building Occupancy | $100,000 | $110,000 | 3.4715263828 | Money and Property | $371,334 | $278,900 | 8.801897347 | ||||||||||
| Management & general | $59,200 | $62,500 | 1.9724581721 | Rents and Concessions | $339,773 | $312,200 | 9.852823061 | ||||||||||
| Audit | $21,930 | $19,300 | 0.6090950835 | Intergovernmental Revenues | $330,120 | $299,800 | 9.4614873597 | ||||||||||
| Office supplies | $3,990 | $3,000 | 0.0946779923 | Charges for Services | $376,880 | $319,579 | 10.0856993627 | ||||||||||
| Postage/Printing | $1,680 | $1,440 | 0.0454454363 | Prior Year Fund Balance | $602,566 | $602,566 | 19.0165796944 | ||||||||||
| Computer | $45,280 | $48,000 | 1.5148478761 | Total Revenue | $3,371,675 | $3,168,635 | 100% | ||||||||||
| Staff training | $30,120 | $17,800 | 0.5617560874 | ||||||||||||||
| Equipment maintenance | $46,870 | $39,475 | 1.2458045815 | ||||||||||||||
| Insurance | $8,590 | $6,000 | 0.1893559845 | ||||||||||||||
| Vehicle maintenance | $12,100 | $13,690 | 0.432047238 | ||||||||||||||
| C16 | |||||||||||||||||
| Utilities | $2,150 | $3,450 | 0.1088796911 | ||||||||||||||
| Legal Services | $2,165 | $3,380 | 0.1066705379 | ||||||||||||||
| Equipment | $490,000 | $325,000 | 10.2567824947 | ||||||||||||||
| Communications | $37,400 | $4,500 | 0.1420169884 | ||||||||||||||
| Transportation and Travel | $4,200 | $3,800 | 0.1199254569 | ||||||||||||||
| Fixed Assets | $680,000 | $770,000 | 24.3006846797 | ||||||||||||||
| Capital Assets | $890,000 | $852,000 | 26.8885498014 | ||||||||||||||
| Total Expenditures | $3,371,675 | $3,168,635 | 100% | ||||||||||||||
NOV
| CRAC BUDGET | |||||||||||||||||
| EXPENDITURES | REVENUE | ||||||||||||||||
| CATEGORY | BUDGETED $ ACTUAL $ % | SOURCE | BUDGETED $ ACTUAL$ % | ||||||||||||||
| Salaries | $705,300 | $810,820 | 18.9680760276 | Taxes | $851,000 | $871,500 | 20.3876054588 | ||||||||||
| Benefits | $211,590 | $243,246 | 5.6904228083 | Licenses, Permits, Franchises, and Fines | $587,200 | $662,620 | 15.5011303834 | ||||||||||
| Building Occupancy | $109,000 | $90,000 | 2.1054325775 | Money and Property | $650,800 | $510,950 | 11.9530086164 | ||||||||||
| Management & general | $61,200 | $59,900 | 1.4012823488 | Rents and Concessions | $498,115 | $585,000 | 13.6853117537 | ||||||||||
| Audit | $14,650 | $20,000 | 0.4678739061 | Intergovernmental Revenues | $421,750 | $487,690 | 11.4088712636 | ||||||||||
| Office supplies | $3,790 | $2,900 | 0.0678417164 | Charges for Services | $446,739 | $554,330 | 12.9678271187 | ||||||||||
| Postage/Printing | $980 | $1,630 | 0.0381317233 | Prior Year Fund Balance | $602,566 | $602,566 | 14.0962454055 | ||||||||||
| Computer | $34,210 | $36,200 | 0.8468517701 | Total Revenue | $4,058,170 | $4,274,656 | 100% | ||||||||||
| Staff training | $39,620 | $31,700 | 0.7415801412 | ||||||||||||||
| Equipment maintenance | $61,200 | $89,475 | 2.0931508875 | ||||||||||||||
| Insurance | $15,390 | $13,700 | 0.3204936257 | ||||||||||||||
| Vehicle maintenance | $9,700 | $9,690 | 0.2266849075 | ||||||||||||||
| C16 | |||||||||||||||||
| Utilities | $1,800 | $2,075 | 0.0485419178 | ||||||||||||||
| Legal Services | $6,230 | $6,170 | 0.1443391 | ||||||||||||||
| Equipment | $751,000 | $907,000 | 21.2180816421 | ||||||||||||||
| Communications | $7,100 | $8,200 | 0.1918283015 | ||||||||||||||
| Transportation and Travel | $5,100 | $6,950 | 0.1625861824 | ||||||||||||||
| Fixed Assets | $1,310,000 | $1,100,000 | 25.7330648361 | ||||||||||||||
| Capital Assets | $710,310 | $835,000 | 19.5337355801 | ||||||||||||||
| Total Expenditures | $4,058,170 | $4,274,656 | 100% | ||||||||||||||
DEC
| CRAC BUDGET | |||||||||||||||||
| EXPENDITURES | REVENUE | ||||||||||||||||
| CATEGORY | BUDGETED $ ACTUAL $ % | SOURCE | BUDGETED $ ACTUAL$ % | ||||||||||||||
| Salaries | $970,000 | $1,000,000 | 23.0844521598 | Taxes | $990,800 | $975,330 | 22.514958725 | ||||||||||
| Benefits | $291,000 | $300,000 | 6.9253356479 | Licenses, Permits, Franchises, and Fines | $761,030 | $693,800 | 16.0159929085 | ||||||||||
| Building Occupancy | $123,000 | $105,000 | 2.4238674768 | Money and Property | $583,000 | $618,740 | 14.2832739293 | ||||||||||
| Management & general | $64,000 | $66,410 | 1.5330384679 | Rents and Concessions | $387,000 | $422,094 | 9.7438087499 | ||||||||||
| Audit | $21,750 | $22,102 | 0.5102125616 | Intergovernmental Revenues | $419,100 | $436,850 | 10.084442926 | ||||||||||
| Office supplies | $4,510 | $2,300 | 0.05309424 | Charges for Services | $560,585 | $582,540 | 13.4476167612 | ||||||||||
| Postage/Printing | $1,090 | $1,270 | 0.0293172542 | Prior Year Fund Balance | $602,566 | $602,566 | 13.9099060001 | ||||||||||
| Computer | $42,375 | $36,450 | 0.8414282812 | Total Revenue | $4,304,081 | $4,331,920 | 100% | ||||||||||
| Staff training | $31,920 | $31,350 | 0.7236975752 | ||||||||||||||
| Equipment maintenance | $87,540 | $89,475 | 2.065481357 | ||||||||||||||
| Insurance | $11,440 | $10,118 | 0.233568487 | ||||||||||||||
| Vehicle maintenance | $9,850 | $8,490 | 0.1959869988 | ||||||||||||||
| C16 | |||||||||||||||||
| Utilities | $3,576 | $3,115 | 0.0719080685 | ||||||||||||||
| Legal Services | $6,950 | $5,190 | 0.1198083067 | ||||||||||||||
| Equipment | $824,000 | $710,000 | 16.3899610334 | ||||||||||||||
| Communications | $6,780 | $7,500 | 0.1731333912 | ||||||||||||||
| Transportation and Travel | $3,500 | $4,150 | 0.0958004765 | ||||||||||||||
| Fixed Assets | $1,108,000 | $1,280,000 | 29.5480987645 | ||||||||||||||
| Capital Assets | $692,800 | $649,000 | 14.9818094517 | ||||||||||||||
| Total Expenditures | $4,304,081 | $4,331,920 | 100% | ||||||||||||||
SUMMARY
| Fiscal Year | Projected Revenues | Projected Expenditures | Projected Net Cost | Actual Revenues | Actual Expenditures | Actual Net Cost |
| January | $3,976,081 | $3,976,081 | 0 | $4,279,490.00 | $4,279,490.00 | $0.00 |
| Februrary | $3,244,475 | $3,244,475 | 0 | $3,227,965.00 | $3,227,965.00 | $0.00 |
| March | $4,093,370 | $4,093,370 | 0 | $4,357,856.00 | $4,357,856.00 | $0.00 |
| April | $4,134,191 | $4,134,191 | 0 | $4,051,240.00 | $4,051,240.00 | $0.00 |
| May | $3,601,093 | $3,601,093 | 0 | $3,619,230.00 | $3,619,230.00 | $0.00 |
| June | $3,512,001 | $3,512,001 | 0 | $3,592,330.00 | $3,592,330.00 | $0.00 |
| July | $3,692,857 | $3,692,857 | 0 | $3,642,800.00 | $3,642,800.00 | $0.00 |
| August | $3,064,089 | $3,064,089 | 0 | $3,174,173.00 | $3,174,173.00 | $0.00 |
| September | $3,594,561 | $3,594,561 | 0 | $3,760,640.00 | $3,760,640.00 | $0.00 |
| October | $3,371,675 | $3,371,675 | 0 | $3,168,635.00 | $3,168,635.00 | $0.00 |
| November | $4,058,170 | $4,058,170 | 0 | $4,275,656.00 | $4,275,656.00 | $0.00 |
| December | $4,304,081 | $4,304,081 | 0 | $4,331,920.00 | $4,331,920.00 | $0.00 |
| Total | $44,646,644.00 | $44,646,644.00 | 0 | $45,481,935.00 | $45,481,935.00 | $0.00 |
| FUND TYPE (check one) | ||||||
| General | X | |||||
| Special Revenue | ||||||
| Enterprise | ||||||
| Internal Service | ||||||
| Debt Service | ||||||
| RESTRICTED/UNRESTRICTED | ||||||
| (Specify "R" or "U") | ||||||
| R |
