Question
Given the Composite Deflator information below, how much of the growth rate over the 8-year period was due to inflationary pressures for all line items
Given the Composite Deflator information below, how much of the growth rate over the 8-year period was due to inflationary pressures for all line items above?
To calculate, find the percentage outlays and the real percentage outlays for all line items above from 2010-2018. With these figures calculate what percentage of outlays was due to price and wage pressures between the years listed. In 2010, the Composite Deflator number was .9544. In 2018 the Composite Deflator is 1.1028 with the Base Year in 2012.
1) General Fund Revenues
2) Expenditures/ Total Personnel Services
3) Total Contract/Professional Services Expenditures
4) Total Supply Expenditures
Town of University Village Budget Exercise | |||||||||||||
Growth Rates | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | ||
General Fund Revenues (Property Tax) | Growth Rate= 5.5% | $40,297,711.00 | $42,514,085.00 | $44,852,360.00 | $47,319,240.00 | $49,921,798.00 | $52,667,497.00 | $55,564,209.00 | $58,620,240.00 | $61,844,354.00 | $65,245,793.47 | $68,834,312.11 | |
Expenditures | |||||||||||||
Total Personnel Services | Growth Rate= 6.6% | $26,039,639.00 | $27,758,255.00 | $29,590,300.00 | $31,543,260.00 | $33,625,115.00 | $35,844,373.00 | $38,210,101.00 | $40,731,968.00 | $43,420,278.00 | $46,286,016.35 | $49,340,893.43 | |
Parks & Recreation | $716,539.00 | $763,831.00 | $814,243.00 | $867,983.00 | $925,270.00 | $986,338.00 | $1,051,437.00 | $1,120,831.00 | $1,194,806.00 | $1,273,663.20 | $1,357,724.97 | ||
Sanitation | $3,617,991.00 | $3,856,778.00 | $4,111,326.00 | $4,382,673.00 | $4,671,930.00 | $4,980,277.00 | $5,308,975.00 | $5,659,368.00 | $6,032,886.00 | $6,431,056.48 | $6,855,506.20 | ||
Police | $8,972,543.00 | $9,564,731.00 | $10,196,003.00 | $10,868,939.00 | $11,586,289.00 | $12,350,984.00 | $13,166,149.00 | $14,035,115.00 | $14,961,433.00 | $15,948,887.58 | $17,001,514.16 | ||
Other | $12,732,566.00 | $13,572,915.00 | $14,468,728.00 | $15,423,664.00 | $16,441,626.00 | $17,526,773.00 | $18,683,540.00 | $19,916,654.00 | $21,231,153.00 | $22,632,409.10 | $24,126,148.10 | ||
Total Contract/Professional Services Expenditures | Growth Rate= 8% | $4,671,352.00 | $5,045,060.00 | $5,448,665.00 | $5,884,558.00 | $6,355,323.00 | $6,863,749.00 | $7,412,849.00 | $8,005,876.00 | $8,646,347.00 | $9,338,054.76 | $10,085,099.14 | |
Parks & Recreation | $156,045.00 | $168,529.00 | $182,011.00 | $196,572.00 | $212,297.00 | $229,281.00 | $247,624.00 | $267,434.00 | $288,828.00 | $311,934.24 | $336,888.98 | ||
Sanitation | $778,380.00 | $840,650.00 | $907,902.00 | $980,535.00 | $1,058,977.00 | $1,143,696.00 | $1,235,191.00 | $1,334,007.00 | $1,440,727.00 | $1,555,985.16 | $1,680,463.97 | ||
Police | $107,834.00 | $116,461.00 | $125,778.00 | $135,840.00 | $146,707.00 | $158,444.00 | $171,119.00 | $184,809.00 | $199,593.00 | $215,560.44 | $232,805.28 | ||
Other | $3,629,093.00 | $3,919,420.00 | $4,232,974.00 | $4,571,612.00 | $4,937,341.00 | $5,332,328.00 | $5,758,914.00 | $6,219,628.00 | $6,717,198.00 | $7,254,573.84 | $7,834,939.75 | ||
Total Supply Expenditures | Growth Rate= 7% | $2,316,392.00 | $2,478,539.00 | $2,652,037.00 | $2,837,680.00 | $3,036,317.00 | $3,248,860.00 | $3,476,280.00 | $3,719,619.00 | $3,979,993.00 | $4,258,592.51 | $4,556,693.99 | |
Parks & Recreation | $76,787.00 | $82,162.00 | $87,913.00 | $94,067.00 | $100,652.00 | $107,698.00 | $115,237.00 | $123,303.00 | $131,934.00 | $141,169.38 | $151,051.24 | ||
Sanitation | $494,800.00 | $529,436.00 | $566,497.00 | $606,151.00 | $648,582.00 | $693,983.00 | $742,561.00 | $794,541.00 | $850,159.00 | $909,670.13 | $973,347.04 | ||
Police | $374,962.00 | $401,209.00 | $429,294.00 | $459,345.00 | $491,499.00 | $525,904.00 | $562,717.00 | $602,107.00 | $644,255.00 | $689,352.85 | $737,607.55 | ||
Other | $1,369,843.00 | $1,465,732.00 | $1,568,333.00 | $1,678,117.00 | $1,795,585.00 | $1,921,276.00 | $2,055,765.00 | $2,199,669.00 | $2,353,645.00 | $2,518,400.15 | $2,694,688.16 | ||
Total Expenditures | $33,027,383.00 | $35,281,855.00 | $37,691,002.00 | $40,265,498.00 | $43,016,755.00 | $45,956,981.00 | $49,099,229.00 | $52,457,464.00 | $56,046,617.00 | $59,969,880.19 | $64,167,771.80 | ||
Ending Cash Balance | $7,270,328.00 | $7,232,230.00 | $7,161,358.00 | $7,053,742.00 | $6,905,043.00 | $6,710,516.00 | $6,464,979.00 | $6,162,777.00 | $5,797,737.00 | 4638190 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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