The URL can be used to link to this page

Home My WebLink About20161219PAC to Staff Attachment 12.pdfRSDR 12/12/16 Jump to.: ____ Customer Cost Setup / Maintenance 08:52:26 COMMAND.: ________ P12768 CC# 11471 WO 05549992 Title CITY OF REXBURG OH TO UG CONVERSION Version 1 I & R Cost Salvage Net Line Length Ftg ______ Ft. No Exc Ln Ext $57,891 $4,500 $53,392 Net Ln. Ext. $53,392 (T) Trans Cost Per Ft of Line (M) Meter Total Cost - (X+G) $53,392 (S) Service T, M, S Exclusions _________ (G) General Max Potential Allow. _________ (X) Exten CAC/Depreciation Crdt ___$2,068 Total Less Salvage ..... $53,392 Advance/Net Cost ... $51,324 ------------------------------------------------------------------------------- Income-Advances/Reimbursements Non Refund Refund Other Non Refund New Extensions ............: _________ _________ _________ Accommodation Tariff ......: __$51,324 Cap 100.00 % O&M % Accommodation Non Tariff...: _________ ER Advance ................: $51,324 Removed PRU Install Value $14,802 Facilities Charge Buyout ..: _________ Betterment Amt __________ Prev Ext Reimbursement ....: _________ Ttl Netwk Upgr __________ Total Customer Advance ....: $51,324 Last Calculated 07/29/2011 RSDT 12/12/16 Jump to.: ____ Expenditure Requisition 08:53:35 COMMAND.: ________ P12768 CC#......: 11471 CC Name Rexburg Customer Collections WO#......: 05549992 Title CITY OF REXBURG OH TO UG CONVERSION Version#.: 1 Description Circuit..: RXB12 Superior Project Func Group D Loc# 5303 Blanket/Proj DM2 Effective Date 07/28/2011 Budg Func WO Exists Y Capital Est Comp Date 12/31/2011 Proj/WO Type Project N O & M Cust Req Date 05/24/2011 Multi-year Project N Superior N Other In-Service Date 12/11/2011 Single Yr Const Qtr ------------------------------------------------------------------------------- Description: OH TO UG CONVERSION, INSTALL 2 3PH SECTIONALIZERS, 167 KVA 120/240 XFMR, 1-PRIMARY RISER POLE DOWNFEED AND 1 PRIMARY RISER POLE W/UPFEED. INSTALL 25 KVA 120/240 XFMR.___________ REMOVE 3 OH POLES AND CONDUCTORS____________________________ ------------------------------------------------------------------------------- Purpose and ACC-OH TO UG CONVERSION Necessity: TOTAL COST-$57891 SALVAGE-$4500 DEP CREDIT-$2068 ADVANCE-$51324 ------------------------------------------------------------------------------- Total Capital ER Estimate - Direct Costs Labor $25,107 Material $18,542 PS $0 Other $0 Sub-Total $43,648 Adv/Reim $51,324 JO $0 Net $7,676- ID PAC-E-16-13 IPUC 12 Attachment IPUC 12 1 of 5 RSWD 12/12/16 Jump to.: ____ Account Translation Review 08:57:07 COMMAND.: ________ P12768 CC# 11471 WO 05549992 Title CITY OF REXBURG OH TO UG CONVERSION SCR: PAGE Version ..... 1 Last Calculated 07/29/2011 Account Hours Labor Material Vehicle Contract Other 108 2 % $4,500- 108 36 45.16 22.84 % $7,428 364 14.90 7.54 % 10.97 % $2,451 $2,781 365 40.99 20.73 % 8.66 % $6,742 $2,196 366 15.26 7.72 % 18.38 % $2,510 $4,663 367 46.94 23.74 % 36.33 % $7,721 $9,215 368 17.63 8.91 % 23.26 % $2,899 $5,899 369 2 16.88 8.53 % 2.40 % $2,776 $610 -------------------------------------------------------------------------------- Total Percent 100.00 % 100.00 % 0.00 % 0.00 % 0.00 % Total Amount $32,528 $20,864 $00 $00 $00 Total Hours 197.76 Total Job $53,392 LINES 7 TO 12 OF 60 RSEL 12/12/16 Jump to.: ____ CU/BA/SI/NS Point List 09:05:27 COMMAND.: ________ P12768 SCR: PAGE CC# 11471 WO 05549992 TTL CITY OF REXBURG OH TO UG CONVERSION Version .... 1 DESC START SEQ#.. __10 SEQ# ACT QTY Type CU/BA/SI/NS Description 10 A 2011 CU J1473EZ CABLE ONE 10 I 160 CU GB102B CABLE,PRIM URD,TRI-PRL,W/LABOR 10 I 4 CU EJ902ACRR ATCH FOR NON-STD COND,GRP 2,3P 10 I 1 CU GE206GAAGA PRIM RISE POLE ASSY 200AMP PVC 10 I 1 CU EJ852BBTEZ RAP AREA DE,2-10'XARM/DE,3PH 10 I 1 BA EG411AA DISK ANCHOR,16" DIA,CRST 10 I 1 BA EZ251H OH LABOR, XFR DE 600V+,4- -795 10 I 1 BA EB401CQ WOOD POLE,45',CL 3, W/HOLE 10 I 2 BA EG661A GUYING KIT,PRIMARY,5/16EHS,15K 20 I 120 CU GB103AAB CABLE--PRIMARY URD 20 I 200 CU GB102A 20 I 220 CU GB102B CABLE,PRIM URD,TRI-PRL,W/LABOR 20 I 1 CU GK122DDA 3-PH SECTIONALIZING ENCL,ALUM 20 I 1 BA DG401DBAC 1PH SECTLZR GND,BXPD,ROD,3CKT 20 I 3 BA GZ106D URD LABOR,TRANSFORMERS,1 MH 20 I 1 BA GB301AA LB ELBOW,200A,15KV, #2SOL 175M 20 I 9 BA GB301AC LB ELBOW,200A,15KV,4/0STR 175M 20 I 7 BA GB501A SHLD FAULT INDR,TEST PT,300A 20 I 3 BA GB311ADA JCT,UG,LDBRK,15/25KV,5POS 25 R 150 CU EC911APP OH PRIMARY EXISTING CONDUCTOR 25 R 150 CU EC911BII OH PRIMARY EXISTING CONDUCTOR 25 R 1 CU EJ101BATEZ PREF TAN,8'SGL ARM/PIN,3PH PRU 25 R 2 CU EJ201BASSZ PREF 1-DIRCTION TAP 3-PH PRI 25 C 2011 CU J1473EE CABLE ONE 30 I 1 CU GH111DBCDA 1-PH PADMOUNTED TRANSF ASSY ID PAC-E-16-13 IPUC 12 Attachment IPUC 12 2 of 5 30 I 1 BA DG402AAF GROUNDING,PADMOUNTED EQUIPMENT 30 I 3 BA GZ106D URD LABOR,TRANSFORMERS,1 MH 30 I 50 BA GS101BBB UGND SERV CABLE,1/0 TRX,CND 30 I 1 BA GB301AA LB ELBOW,200A,15KV, #2SOL 175M 35 R 1 CU EL202DEEJA OH 1-PH GRD/Y TRANS W/INT ARR 35 R 1 CU EH131BAVDA VERTICAL DEADEND STRUCTURE,1PH 35 R 1 BA EG411AA DISK ANCHOR,16" DIA,CRST 35 R 1 BA EG661D GUYING KIT,PRIMARY,7/16 UG,21K 40 I 1 CU EI161BBODN 3-WIRE DE,SLACK SPAN,PRIMARY 40 I 1 CU GE206BCACA PRIM RISE POLE ASSY 200AMP PVC 50 H 2011 CU J1473ZE CABLE ONE 50 R 1 CU EJ101BAJDZ PREF TAN,8'SGL ARM/PIN,3PH PRU 50 R 1 CU EL262DGDHA OPN 3PH GRDY-DEL TRAN W/INT AR 50 H 2011 CU J0947ZE QWEST,TELCO,ID 50 R 200 BA ET101CA OH SERVICES CABLE,#2 TRX 55 R 1 CU EJ151BATDZ PREF DE,8' DBL ARM,3PH,PRI 55 H 2011 CU J1473ZE CABLE ONE 55 R 1 CU GE206GAAGC PRIM RISE POLE ASSY 200AMP PVC 55 R 1 BA EG661A GUYING KIT,PRIMARY,5/16EHS,15K 55 R 1 BA EG411AA DISK ANCHOR,16" DIA,CRST 60 I 1 CU GK122BDA 3-PH SECTIONALIZING ENCL,ALUM 60 I 40 CU GB103AAB CABLE--PRIMARY URD 60 I 1 BA DG401DBAC 1PH SECTLZR GND,BXPD,ROD,3CKT 60 I 1 BA GB301AA LB ELBOW,200A,15KV, #2SOL 175M 60 I 3 BA GZ106D URD LABOR,TRANSFORMERS,1 MH 60 I 4 BA GB501A SHLD FAULT INDR,TEST PT,300A 60 I 6 BA GB301AC LB ELBOW,200A,15KV,4/0STR 175M 70 I 1 CU GH111DECDA 1-PH PADMOUNTED TRANSF ASSY 70 I 200 BA GS101BBB UGND SERV CABLE,1/0 TRX,CND 70 I 120 BA GS101DBB UGND SERV CABLE,350 TRX,CND 70 I 1 BA DG402AAF GROUNDING,PADMOUNTED EQUIPMENT 70 I 1 BA GB301AA LB ELBOW,200A,15KV, #2SOL 175M 80 I 1 BA GS301CBA UGND SEC JBOX,1PH,8POSN,IT 80 I 100 BA GS101BBB UGND SERV CABLE,1/0 TRX,CND 80 I 5 BA GZ106C URD LABOR,SERVICES,1 MH ID PAC-E-16-13 IPUC 12 Attachment IPUC 12 3 of 5 RSDR 12/12/16 Jump to.: ____ Customer Cost Setup / Maintenance 15:44:40 COMMAND.: ________ P12768 CC# 11471 WO 06277183 Title BLS11-ROBISON FARMS-URD CONVERSION SOUTH Version 1 I & R Cost Salvage Net Line Length Ftg ______ Ft. No Exc Ln Ext $33,461 $148 $33,313 Net Ln. Ext. $33,313 (T) Trans Cost Per Ft of Line (M) Meter Total Cost - (X+G) $33,313 (S) Service T, M, S Exclusions _________ (G) General Max Potential Allow. _________ (X) Exten CAC/Depreciation Crdt ___$3,461 Total Less Salvage ..... $33,313 Advance/Net Cost ... $29,852 ------------------------------------------------------------------------------- Income-Advances/Reimbursements Non Refund Refund Other Non Refund New Extensions ............: _________ _________ _________ Accommodation Tariff ......: __$29,852 Cap 100.00 % O&M % Accommodation Non Tariff...: _________ ER Advance ................: $29,852 Removed PRU Install Value $12,080 Facilities Charge Buyout ..: _________ Betterment Amt __________ Prev Ext Reimbursement ....: _________ Ttl Netwk Upgr __________ Total Customer Advance ....: $29,852 Last Calculated 12/01/2016 RSDT 12/12/16 Jump to.: ____ Expenditure Requisition 15:46:43 COMMAND.: ________ P12768 CC#......: 11471 CC Name Rexburg Customer Collections WO#......: 06277183 Title BLS11-ROBISON FARMS-URD CONVERSION SOUTH Version#.: 1 Description Circuit..: BLS11 Superior Project Func Group D Loc# 5303 Blanket/Proj DM2 Effective Date 11/15/2016 Budg Func WO Exists Y Capital Est Comp Date 05/01/2017 Proj/WO Type Project N O & M Cust Req Date 11/15/2016 Multi-year Project N Superior N Other In-Service Date 00/00/0000 Single Yr Const Qtr ------------------------------------------------------------------------------- Description: REMOVE 9-40' POLES, 3610' 3-PHASE OVERHEAD #2ASCR, 1-PRIMARY RISER. INSTALL 2=45' POLES, 2-PRIMARY RISERS, 1-3-PHASE GROUND SLEEVE, 2800' #2-15KV URD CABLE, 1100- 4/0-URD 15KV CABLE. ------------------------------------------------------------------------------- Purpose and TO BURY A PORTION OF OVERHEAD DISTRIBUTION LINE AT CUSTOMER Necessity: REQUEST TO ACCOMMODATE NEW IRRIGATION PIVOTS. NO NEW LOAD OR METERS. CIRCUIT IS BELSON 11. DEPRECIATED CREDIT OF $8212.00 WAS GIVEN CUSTOMER TO PAY A NON REFUNDABLE ADVANCE OF $55,438.00 ------------------------------------------------------------------------------- Total Capital ER Estimate - Direct Costs Labor $13,606 Material $11,908 PS $0 Other $0 Sub-Total $25,513 Adv/Reim $29,852 JO $0 Net $4,339- ID PAC-E-16-13 IPUC 12 Attachment IPUC 12 4 of 5 RSWD 12/12/16 Jump to.: ____ Account Translation Review 15:50:48 COMMAND.: ________ P12768 CC# 11471 WO 06277183 Title BLS11-ROBISON FARMS-URD CONVERSION SOUTH SCR: PAGE Version ..... 1 Last Calculated 12/01/2016 Account Hours Labor Material Vehicle Contract Other 108 2 % $148- 108 36 31.22 29.63 % $5,541 364 14.09 13.37 % 16.94 % $2,501 $2,500 365 10.47 9.94 % 12.73 % $1,859 $1,879 366 8.68 8.23 % 3.02 % $1,540 $445 367 40.91 38.83 % 67.31 % $7,262 $9,935 ------------------------------------------------------------------------------- Total Percent 100.00 % 100.00 % 0.00 % 0.00 % 0.00 % Total Amount $18,702 $14,611 $00 $00 $00 Total Hours 105.37 Total Job $33,313 LINES 1 TO 6 OF 60 RSEL 12/12/16 Jump to.: ____ CU/BA/SI/NS Point List 15:53:12 COMMAND.: ________ P12768 SCR: PAGE CC# 11471 WO 06277183 TTL BLS11-ROBISON FARMS-URD CONVERSION SOUTH Version .... 1 DESC START SEQ#.. __10 SEQ# ACT QTY Type CU/BA/SI/NS Description 10 I 1950 CU GB103ACA CABLE--PRIMARY URD 10 I 1 CU GE206BAADC PRIM RISE POLE ASSY 200AMP PVC 10 R 1 CU EJ800BAPZA 3PH RAP/LGHT AREA,TAN,ANGLE,DE 10 I 1 CU EG201BPBDA GUY & ANCHOR ASSY,DEADEND 10 I 1 CU EJ800BLPZD 3PH RAP/LGHT AREA,TAN,ANGLE,DE 10 R 1850 CU EC911COO OH PRIMARY EXISTING CONDUCTOR 10 I 2 BA EF181CHBA D-END,35KV,EXSTNG, #2AL,AUTO 10 I 1 BA EF181CBBA D-END,35KV,5/8 DA, #2AL,AUTO 20 R 1 CU EJ800BAPDA 3PH RAP/LGHT AREA,TAN,ANGLE,DE 30 R 1 CU EJ800BAPDA 3PH RAP/LGHT AREA,TAN,ANGLE,DE 40 R 1 CU EJ800BAPDA 3PH RAP/LGHT AREA,TAN,ANGLE,DE 50 I 1 CU EJ800BLPED 3PH RAP/LGHT AREA,TAN,ANGLE,DE 50 I 1 CU EG201BPBDA GUY & ANCHOR ASSY,DEADEND 50 I 1 CU GE206BCADC PRIM RISE POLE ASSY 200AMP PVC 50 R 1 CU EJ800BAPDA 3PH RAP/LGHT AREA,TAN,ANGLE,DE 50 I 2 BA EF181CHBA D-END,35KV,EXSTNG, #2AL,AUTO 50 I 1 BA EF181CBBA D-END,35KV,5/8 DA, #2AL,AUTO 50 I 1 BA DG201AGB WD POLE GROUND,PLT,#6-#2AL ID PAC-E-16-13 IPUC 12 Attachment IPUC 12 5 of 5