|
Draft Cost Allocation Support Worksheet
<br />This Spreadsheet prepared for use in Cost Allocation revisions; data based on indexed CCE at Oct. 2010(FY11) Price Level - $584.0
<br />million using the same process as the May 2001 Interim Cost Allocation. Essentially, the 584.01VI CCE was modified to match the
<br />thought process used in the May 2001 Allocation. _
<br />Prepared 12/29/09 Revised: 07 -10 -10
<br />FEATURE
<br />Oct. 10 (FYI 1)
<br />Index/Source
<br />$584.0M
<br />Allocation
<br />w/May 2001
<br />Interim Process
<br />Ridges Basin Dam Specific Costs (Total)
<br />Awarded
<br />1/
<br />$ 174,579
<br />From CCE
<br />$
<br />$
<br />$
<br />174,579
<br />1,045,296
<br />117,000
<br />ALP Conservanc District S c. costs
<br />2/1$
<br />1,045,296
<br />From CCE
<br />Durango Pumping Plant (Awarded)
<br />Durango Pumping Plant Remaining
<br />3/
<br />$ 117,000
<br />Stage 2 Remaining Line Item
<br />Subtotal DPP
<br />$ 1,162,296
<br />$
<br />$
<br />1,162,296
<br />58,193
<br />Ridges Basin Dam/steel piping & valves
<br />if
<br />$ 58193
<br />From CCE
<br />Total ALP Conservancy District Spec. Costs
<br />L
<br />From CCE
<br />No Index
<br />From CCE
<br />No Index
<br />From CCE
<br />From CCE
<br />From CCE
<br />From CCE
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />1,220,489
<br />63,244,000
<br />20,058,193
<br />20,000,000
<br />58,193
<br />20,058,193
<br />20,000,000
<br />58,193
<br />23,360,000
<br />56,419,651
<br />21,411,000
<br />35,008,651
<br />13,080,129
<br />2,623,000
<br />10,457,129
<br />NNMP
<br />$ 63,244,000
<br />SUIT
<br />$ 20,058,193
<br />SUIT Tribal Resource Fund
<br />$ 20,000,000
<br />Ridges Basin Dam /steel piping & valves
<br />1/
<br />$ 58,193
<br />UMUT
<br />$ 20,058,193
<br />UMUT Tribal Resource Fund
<br />$ 20,000,000
<br />Ridges Basin Dam /steel piping & valves
<br />11
<br />$ 58,193
<br />Cultural Resources
<br />$ 23,360,000
<br />Fish, Wildlife, & Wetlands Mitigation
<br />Mitigation Features
<br />$ 21,411,000
<br />Inactive Pool
<br />41
<br />$ 35,008,651
<br />Recreational Fishery
<br />1/2 Fish Hatchery + Fisherman Access
<br />1
<br />$ 2,623,000
<br />From CCE
<br />Inactive Pool
<br />41
<br />$ 10,457,129
<br />From CCE
<br />1/ Specific costs equally assigned to the ALP District, UTMUT, SUIT $174,579/3 = 58,193; from Oct. 10 (FYI 1) indexed CCE. See plant
<br />account 151, line item (3) Over expenditure for RBD Specific Costs ($16,579; line item (5) RB Dam Spec Costs ($158,000) Contract #8064.
<br />RBD specific costs have been awarded, therefore they are not indexed.
<br />2/ From Oct. 10 (FYI 1) indexed CCE. See plant account 130, line item (4) City of Durango specific costs
<br />specific costs have been awarded, therefore they are not indexed.
<br />awarded Contract #8013. DPP
<br />3/ City of Durango specific costs remaining line item; from Oct. 10 (FYI 1) indexed CCE. See plant account 130, line item (4) remaining.
<br />Remaining costs are indexed.
<br />4/ Ratio to Compute Ridges Basin Dam Inactive Pool From FSEIS No Pre1999 Sunk Costs Included in RBD Costs _
<br />90,000 of w/o rec. Ml $119_600.000 X
<br />120,000 of w /rec. pool $144,600,000 $262,974,069 RBD less sunks
<br />Solved X = 217,508,289 $262,974,069 - 217,508,289 = $45,465,780 = 30,000 of Inactive Pool Cost
<br />45,465,780 0.77 = $35,008,651
<br />From FSEIS 77% of Inactive Pool is allocated to Water Quality
<br />45,465,780 0.23 = $10,457,129
<br />From FSEIS 23% of Inactive Pool is allocated to Fishery Enhancement
<br />-
<br />Wexcel \Interim Cost Allocation \FY11 \Draft OCT10 FY11 $584.OM Cost Alloc. Support Wrksht ry 07- 07- 10.xls
<br />
|