Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions