|
0 AtWent 3
<br />Indexing the PRRIP
<br />Index Calculation'
<br />Index Application
<br />A
<br />Original Program
<br />Budget2
<br />B
<br />Expenditures
<br />Through 9/30/2009
<br />C D
<br />Budget Remaining Index Applied
<br />As of 10/1/09 on 10/1/2009
<br />(A minus B) (C times Index)
<br />E
<br />October 2008
<br />October 2009
<br />Index Factor to Apply
<br />Change
<br />Ceiling
<br />(D minus C)
<br />on 10/1/09
<br />Land Index (Nebraska Land Index)
<br />309 -
<br />369
<br />= 1.19
<br />Water Index (General Property Index)
<br />317 -
<br />305
<br />= 0.96
<br />Other Cost Index (Federal Salary Index)
<br />316 -
<br />328
<br />= 1.04
<br />Index Application
<br />A
<br />Original Program
<br />Budget2
<br />B
<br />Expenditures
<br />Through 9/30/2009
<br />C D
<br />Budget Remaining Index Applied
<br />As of 10/1/09 on 10/1/2009
<br />(A minus B) (C times Index)
<br />E
<br />F
<br />Total Budget
<br />New Program
<br />Change
<br />Ceiling
<br />(D minus C)
<br />(E plus A)
<br />Land (Index 1.19)
<br />$22,900,000.00
<br />$3,516,024.28
<br />$19,383,975.72
<br />$23,066,931.11
<br />$3,682,955.39
<br />$26,582,955.39
<br />Water (Index 0.96)
<br />$90,140,000.00
<br />$383,963.63
<br />$89,756,036.37
<br />$86,165,794.92
<br />- $3,590,241.45
<br />$86,549,758.55
<br />Other (Index 1.04)
<br />$74,100,000.00
<br />$7,077,405.95
<br />$67,022,594.05
<br />$69,703,497.81
<br />$2,680,903.76
<br />$76,780,903.76
<br />Total
<br />$187,140,000.00
<br />$10,977,393.86
<br />$176,162,606.14
<br />$178,936,223.84
<br />$2,773,617.70
<br />$189,913,617.70
<br />State & Federal Shares - Original Total Program Cash Budget of $187,140,0002 - New Ceiling of $189,913,617.70
<br />Colorado
<br />$24,000,000.00 _
<br />0.1282
<br />$187,140,000.00
<br />Wyoming
<br />$6,000,000.00 _
<br />0.0321
<br />$187,140,000.00
<br />Federal
<br />$157,140,000.00 _
<br />0.8397
<br />$187,140,000.00
<br />Parties Share of
<br />New Ceiling
<br />Parties Share
<br />New Ceiling
<br />Colorado
<br />$189,913,617.70 X
<br />0.1282
<br />$24,346,925.79
<br />Wyoming
<br />$189,913,617.70 X
<br />0.0321
<br />= $6,096,227.13
<br />Federal
<br />$189,913,617.70 X
<br />0.8397
<br />= $159,470,464.78
<br />
|