Loading...
HomeMy WebLinkAbout20100809Application.pdf..../. ~ --c:z-(!-0:o Cyntha A. Melilo (ISB No. 5819) GNENS PURSLEY LLP 601 West Banock Street P.O. Box 2720 Boise, ID 83701-2720 Telephone: (208) 388-1200 Fax: (208) 388-1300 cam(fgivenspurley.com Q i: (' ¡:j: '\-L-- 9oc.# #:_ Fi.I Lk.J ZOlOAUG - 9 PH 3:44 Attorneys for Custer Telephone Cooperative, Inc. BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER OF THE APPLICATION OF CUSTER TELEPHONE COOPERATIVE, INC., FOR BROADBAND TAX CREDIT CERTIFICATION Case No. cus-T-LD-0( CUSTER TELEPHONE COOPERATIV, INC.'S APPLICATION Custer Telephone Coopetive, Inc. ("Custer Telephone"), by and thugh its attorneys, Givens Puley LLP, fies this Application for an Idaho Public Utilities Commssion ("Commssion") order cerifyng that cein telecommuncations equipment is eligible for the broadband infrstrctue ta credit authorized by Secon 63-3029, Idaho Code. In supprt ofits Application, Cuter Telephone states as follows: 1. Cuter Telephone is a prvider of basic loc exchange sece, broadband telecmmunications serce and other telecmmuncations serce in souther Idao. 2. Dug the caenar year 200, Custer Telephone made cer invesents that constitute "qualified broadban equipment" with the meanng of Secon 63-3029(1)3)(), Idah Code. E¡it A, attched hero, descrbe Cuter Telephone's qualified bradband equipment and contai the information and repentations reuire by ths Commission's Order No. 28784 in Case No. GNR-T-01-10. CUSTE TEHONE COOPERTI IN.'S APPLICATION - 1 934355_ i.ix 3. Communcations regarding ths Application should be addressed to tle following: Cyntha A. Melilo GNENS PURSLEY LLP 601 West Banock Stree P.O. Box 2720 Boise, ID 83701-2720 (208) 388-1200 cam(igivenspurley.com Teresa Westergard Custer Telephone Coopertive, Inc. 1111 South Main Street P.O. Box324 Challs, il 83226 admin(icusterel.net 4. Applicant does not believe that the public interest requies a heag on ths matter and, therefore, requests that the Commission apprve the Application by Minute Order or under Modified Procedure. In the event the Commission deterines that fuher proceedings are necessar, Applicant stands ready for immediate heargs. WHEREFORE, Custer Telephone requests that the Commssion issue its order detering that the installed equipment identified in Exhbit A constitutes qualified broadband equipment eligible for the investment tax credit authorized by Section 63-30291, Idao Code. RESPECTPULL Y SUBMITED Ths 9th day of Augut 2010. ~(l7! Cyn ~elillo GNENS PURSLEY LLP Attorneys for Custer Telephone Coopetive, Inc. CUSTE TELEHONE COOPERATIE, INC.'S APPLICATION - 2 934355_ i.ix CERTIFICATE OF SERVICE I HEREBY CERTIFY that on ths 9th day of August 2010, I caused to be sered a tre and correc copy of the foregoing by the method indicated below, and addressed to the following: Jea Jewell, Commission Secar Idaho Public Utilities Commssion 472 West Washigton Street P.O. Box 83720 Boise, il 83720-0074 o U.S. Mail rg Hand Delivered o Overght Mail o Facsimle c~i?M CUSTE TELEHONE COOPERTI, INC.'S APPLICATION - 3 934355_ i.ix Idaho Broadband Equipment Tax Credit Application Company Information 1. Name of company: 2. Address: 3. Type of company: Custer Telephone Co-op Inc. Box 324, 1101 East Main Ave., Challs Idaho 83226 Telecommunications carrier, ISP, Wireless Provider, Long Distance provider, CATV Provider Teresa Westergard, Box 324, Challs Id 83226 admincgcustertel.net 208-879-2281 4. Contact person: Equipment Description 5. Broadband services offered: 6. Network description: 7. Transmission rate: 8. Number and percentage of Idaho customers served: 9. Equipment list: ADSL and SDSL type services Fiber optic fed DLC's with 12K non loaded copper distribution cable, Fiber to the Home electronics, Fiber optic transport electronics, Fiber optic backbone and distribution cable. 128k - 512k upstream 512k - 8Mbps downstream 5 people with broadband service out of 1000 people possible See attached Broadband Equipment List I hereby certify that I have read the applicable statutes for broadband investment income tax credit and believe that the equipment listed herein qualifies for the tax credit under Idaho Code 63-30291. c- ¿ 4lluV /.L i.,¿ /I ,, / Teresa Westergard Custer Telephone Co-op Inc. Cu s t e r T e l e p h o n e C o - o p I n c . B r o a d b a n d E q u i p m e n t L i s t Ma n u f a c t u r e r l P r o v i d e r Mo d e l o r I D N o . Co s t Da t e s I n s t a l l e d Co u n t y L o c a t i o n s Co m i n g / S u p e r i o r E s s e x Fi b e r O p t i c C a b l e $ 14 , 1 5 1 . 0 7 Ap r i l 20 0 9 Cu s t e r : f o r t h e C h a l l i s Ca l i x 71 0 O N T ' s $ 4, 6 4 9 . 0 5 Ex c h a n g e WO # 2 0 0 8 - 5 4 Co r n n g / S u p e r i o r E s s e x Fi b e r O p t i c C a b l e $ 33 , 0 0 4 . 7 5 Au g u s t 2 0 0 9 Cu s t e r : f o r t h e C h a l l s Ca l i x 71 0 0 N T ' s $ 6, 5 3 2 . 8 7 Ex c h a n g e WO # 2 0 0 8 - 5 8 Co r n i n g / S u p e r i o r E s s e x Fi b e r O p t i c C a b l e $ 1, 4 5 4 . 4 8 Ap r i l 20 0 9 Le m h i : f o r t h e M a y Ca l i x 71 0 O N T ' s $ 3, 5 3 4 . 3 9 Ex c h a n g e WO # 2 0 0 8 - 6 4 Co r n i n g / S u p e r i o r E s s e x Fi b e r O p t i c C a b l e $ 6, 9 0 7 . 8 4 Ap r i l 20 0 9 Cu s t e r : f o r t h e C l a y t o n Ca l i x 71 0 0 N T ' s $ 5, 3 8 7 . 4 0 Ex c h a n g e WO # 2 0 0 8 - 7 2 AD C Sp l i t t e r M o d l x 3 2 S C / A P C $ 1, 7 2 7 . 8 5 Ja n u a r 2 0 0 9 Le m h i : f o r t h e M a y WO # 2 0 0 8 - 7 3 Ex c h a n g e AD V A 10 G I G Ne t w o r k U p g r a d e $ 77 , 7 8 1 . 7 9 Ap r i l 20 0 9 Cu s t e r : f o r t h e C h a l l s WO # 2 0 0 8 - 8 0 Ex c h a n g e Co r n i n g / S u p e r i o r E s s e x Fi b e r O p t i c C a b l e $ 51 3 , 1 4 3 . 8 2 De c e m b e r 2 0 0 9 Le m h i : f o r t h e E l k B e n d Ca l i x 71 0 0 N T ' s $ 14 8 , 4 2 5 . 3 4 Ex c h a n g e AD C lx 3 2 S p l i t t e r P a c k $ 4, 5 8 3 . 6 3 WO # 2 0 0 9 - 1 Ca l i x 71 0 & 7 1 4 O N T ' s $ 4, 0 3 0 . 7 1 Ja n u a y 2 0 0 9 Le m h i : f o r t h e M a y WO # 2 0 0 9 - 4 Ex c h a n g e Ca l i x 71 0 0 N T ' s $ 1, 2 5 3 . 1 9 Fe b r u a r y 2 0 0 9 Cu s t e r : f o r t h e C l a y t o n WO # 2 0 0 9 - 1 0 Ex c h a n g e Ci s c o 37 5 0 E t h e r n e t S w i t c h $ 9, 5 3 2 . 8 8 Ap r i l 20 0 9 Cu s t e r : f o r t h e C h a l l s WO # 2 0 0 9 - 1 1 AS R I 0 0 6 D C R o u t e r $ 11 8 , 8 6 9 . 0 3 Ex c h a n g e Su b T o t a l $ 95 4 , 9 7 0 . 0 9 Ma n u f a c t u r e r l P r o v i d e r Mo d e l o r I D N o . Co s t Da t e s I n s t a l l e d Co u n t y L o c a t i o n s AD C 7X 2 3 S p l i t t e r S h e l f $ 29 8 . 1 4 Ap r i l 20 0 9 Cu s t e r : f o r t h e C h a l l s WO # 2 0 0 9 - 1 5 LX 3 2 S p l i t t e r M o d u l e $ 1, 5 4 7 . 6 5 Ex c h a n g e Ca l i x Co m b o A D S L / 2 + 2 4 P o r t s $ 8, 8 0 4 . 2 5 Ma r c h 20 0 9 Cu s t e r : f o r t h e C h a l l s GP O N 4 - P o r t $ 3, 9 1 4 . 6 3 Ex c h a n g e GP O N O I M 2 . 4 / 1 . 2 F i b e r $ 3, 0 3 2 . 7 4 WO # 2 0 0 9 - 1 6 Tr a n s r e c e i v e r Te l l a b s AD S L 2 + 6 + 6 C a r d s $ 3, 9 7 5 . 0 0 Ma r c h 2 0 0 9 Cu s t e r : f o r t h e C h a l l s WO # 2 0 0 9 - 1 9 Ex c h a n g e Ca l i x 71 0 0 N T ' s $ 63 3 . 8 8 Ma r c h 20 0 9 Cu s t e r : f o r t h e M a y WO # 2 0 0 8 - 2 1 Ex c h a n g e AD V A 10 G I G O C - 1 9 2 L a m b d a $ 29 , 4 4 0 . 3 5 Au g u s t 2 0 0 9 Cu s t e r : f o r t h e C h a l l i s WO # 2 0 0 9 - 2 9 Fo r D W D M E q u i p m e n t Ex c h a n g e Ca l i x 71 0 0 N T ' s $ 1, 5 8 5 . 6 1 Ma y 20 0 9 Le m h i : f o r t h e M a y WO # 2 0 0 9 - 4 0 Ex c h a n g e Co r n i n g / S u p e r i o r E s s e x Fi b e r O p t i c C a b l e $ 64 4 . 3 0 Au g u s t 20 0 9 Cu s t e r : f o r t h e C h a l l s Ca l i x 71 0 O N T ' s $ 2, 3 4 6 . 2 1 Ex c h a n g e WO # 2 0 0 9 - 4 1 Ca l i x 71 0 O N T ' s $ 1, 5 5 9 . 6 3 Ma y 20 0 9 Cu s t e r : f o r t h e C h a l l s WO # 2 0 0 9 - 5 1 Ex c h a n g e AD V A SI M M o d u l e t o t h e 2 . 5 G $ 6, 8 8 2 . 7 2 Au g u s t 20 0 9 Cu s t e r : f o r t h e C l a y t o n WO # 2 0 0 9 - 5 5 La m b d a Ex c h a n g e Te l l a b s AD S L 2 + 6 + 6 C a r d s $ 7, 4 3 9 . 4 9 Ju n e 2 0 0 9 Cu s t e r : f o r t h e C h a l l s WO # 2 0 0 9 - 5 6 Ex c h a n g e Su b T o t a l $ 72 , 1 0 4 . 6 0 Ma n u f a c t u r e r l P r o v i d e r Mo d e l o r I D N o . Co s t Da t e s I n s t a l l e d Co u n t y L o c a t i o n s Co m i n g / S u p e r i o r E s s e x Fi b e r O p t i c C a b l e $ 55 9 . 3 5 Au g u s t 2 0 0 9 Le m h i : f o r t h e M a y Ca l i x 71 0 O N T ' s $ 2, 0 8 8 . 9 4 Ex c h a n g e WO # 2 0 0 9 - 6 2 Ca l i x E5 - 3 1 2 E t h e r n e t S e r v i c e $ 17 , 3 9 6 . 5 0 Oc t o b e r 2 0 0 9 Le m h i : f o r t h e E l k B e n d WO # 2 0 0 9 - 6 4 Ex c h a n g e Ca l i x 71 0 0 N T ' s $ 2, 8 8 1 . 3 2 Au g u s t 2 0 0 9 Cu s t e r : f o r t h e M a y WO # 2 0 0 9 - 6 7 Ex c h a n g e Ca l i x 71 0 0 N T ' s $ 68 7 . 5 1 No v e m b e r 2 0 0 9 Cu s t e r : f o r t h e C l a y t o n WO # 2 0 0 9 - 8 3 Ex c h a n g e Ca l i x 71 0 O N T ' s $ 2, 1 5 3 . 6 9 No v e m b e r 2 0 0 9 Cu s t e r : f o r t h e M a y WO # 2 0 0 9 - 8 6 Ex c h a n g e Ca l i x AD S L 2 + $ 8, 1 8 6 . 0 0 De c e m b e r 2 0 0 9 Cu s t e r : f o r t h e C h a l l s WO # 2 0 0 9 - 9 4 Po t s 2 4 P o r t s Ex c h a n g e Ca l i x 71 4 0 N T ' s $ 75 7 . 6 8 De c e m b e r 2 0 0 9 Cu s t e r : f o r t h e C l a y t o n WO # 2 0 0 9 - 1 0 0 Ex c h a n g e Su b T o t a l $ 34 , 7 1 0 . 9 9 Gr a n d T o t a l $ 1 , 0 6 1 , 7 8 5 . 6 8 Work order cost summary Work order description Work order number New duct and fiber to Bil McKee up Daughtry Gulch12008-54 I Total overhead Total cost 17,117.51 I 18,800.121 Unit material costIndividual assets/items: CABLE BFO 12 SINGLE MODE 2,846.00 CABLE BFO 24 SINGLE MODE 1,542.00 710 ONT 2-POTS 1-ENTERNET 1.00 0.25 0.35 416.09 yes ok 723.74 542.78 416.09 yes Labor and overhead allocated 7,362.71 5,521.84 4,232.96 Total unit cost 2.84 3.93 4,649.05 8,086.45 6,064.62 4,649.05 416.70 1,682.61 17,117.51 4,655.82 18,800.12 Labor and Overhead Summary Labor Employee Name Date 9/2,3,5/08 9/2&3/08 9/5/2008 12/23/2008 12/3/2008 12/19/2008 12/19/2008 1/13&22/09 3/3/2009 3/3/2009 3/4/2009 Payroll Hours 21.00 12.00 6.00 24.00 4.00 1.00 17.00 7.00 5.00 4.00 5.00 Cost 888.35 37730 128.55 834.26 174.25 33.69 381.15 283.14 209.95 106.79 209.95 # 104 136 139 104 118 136 139 127 118 139 118 Total labor 106.00 3,627.38 Special Invoices Vendor CostNameDateCheck Midstate Consultants 10/20/2008 23941 297.00 Rivers West Contractors, Inc 1/3/2009 24224 3,291.00 CTCI OH Materials 12/12/2008 4,652.34 CTCI OH Materials 1/21/2009 251.69 Salmon River Electric 2/4/2009 24362 106.90 CTCI OH Materials 2/23/2009 448.11 Custer County / Pett Cash 3/18/2009 24523 12.00 CTCI OH Materials 3/5/2009 297.67 Border States 4/13/2009 24630 103.68 Border States 4/17/2009 24666 54.29 Total Special Invoices 9,514.68 Sales tax 75.99+24.97 100.96 Use Tax 6.22+3.26 9.48 Veh. Exp. 109.96+191.34+3.88+35.13 340.31 Plow Exp. 70.37+51.76+.81 122.94 POAD 1172.3+1280.13+348.13+296.06 3,096.62 PROV 62.18+222.40+13.37+7.19 305.14 Freight Misc. Total labor and overhead 17,117.51 Work order cost summary Work order description Work order number New cable and duct and drop fiber to Glen Elzinga off of Dowlon Lane12008-58 I Total overhead 37,054.321 yes ok 39,537.621 yes Unit material cost Total material Labor and cost overhead allocated 0.25 972.95 14,517.78 4.05 15,490.73 0.35 1,032.06 15,399.78 5.60 16,431.84 0.20 67.97 1,014.21 3.19 1,082.18 410.32 410.32 6,122.55 6,532.87 6,532.87 Total cost Individual assets/items: Cable BFO 12 Single Mode Cable BFO 24 Single Mode Cable BFO 4PR S/M FIBER D 710 ONT 2-POTS 1-ENTERNET 3,826.00 2,932.00 339.00 1.00 411.13 2,483.30 37,054.32 6,545.72 39,537.62 Labor and Overhead Summary Labor Employee Payroll Cost#Name Date Hours 104 9/12/2008 3.00 123.98 104 9/24/2008 1.00 41.32 139 9/12/2008 4.00 85.69 113 11/17/2008 1.00 60.73 104 11/19/2008 2.00 95.89 113 11/3/2008 2.00 121.47 104 12/22/2008 8.50 289.40 104 1/5/2009 2.00 76.82 104 3/31/2009 3.00 118.24 104 6/15/2009 8.00 317.09 118 6/15-18/09 19.00 800.32 139 6/15-16/09 14.00 379.14 Total labor 67.50 2,510.09 Special Invoices Vendor CostNameDateCheck Custer County Road & Bridge 9/18/2008 23832 25.00 Midstate Consultants 10/20/2008 23941 247.50 CTCI OH Materials 11/21/2008 823.08 CTCI OH Materials 11/26/2008 5,194.98 Rivers West Contractors, Inc 1/3/2009 24224 21,877.00 Custer County-Easement 12/30/2008 24199 9.00 CTCI OH Materials 12/31/2008 2,572.13 CTCI OH Materials 1/19/2009 65.49 CTCI OH Materials 4/6/2009 63.74 CTCI OH Materials 6/30/2009 832.86 Salmon River Electric 6/15/2009 11166 106.90 Rising River Inc.8/6/2009 25058 630.00 Total Special Invoices 32,447.68 Sales tax 120.3+28.70 149.00Uæ Tax ~2~ ~2~ Veh. Exp. 22.56+2.78+11.10+35.35+1.09+7.52+37.43 117.83 Plow Exp. 14.43+.19+9.56+.23+~.11 58.52 POAD 142.08+42.17+168.73+375.21+99.46+88.81+421 1,337.98 Freight PROV 12.75+2.16+8.64+45.01 +3.83+5.42+43.07 120.88 Total labor and overhad 37,054.32 Work order cost summary Work order description Work order number New duct, fiber, and drop to May and Sydney's restaurant12008-64 I Total overhead 4,401.551 4,988.871 yes ok Total cost yes Individual assetslitems:Labor and overhead allocated Total unit costUnit material cost CABLE BFO 4PR SIM FIBER D 854.00 710 ONT 2-POTS 1-ENTERNET 1.00 171.23 416.09 1,283.25 3,118.30 1.70 3,534.39 1,454.48 3,534.39 587.32 4,401.55 3,536.09 4,988.87 Labor and Overhead Summary Labor # 104 139 104 139 104 127 139 Employee Name Payroll Date Hours 9/26/2008 6.00 9/26/2008 6.0010/212008 6.00 10/2/2008 6.00 3/16/2009 3.00 3/16&17/09 5.00 3/16/2009 2.00 Cost 247.93 128.55 262.78 137.39 118.24 214.27 53.41 Total labor 34.00 1,162.57 Special Invoices Vendor CostNameDateCheck CTCI OH Material 10/30/2008 1,920.79 Salmon River Electric 3/27/2009 24552 106.90 CTCI OH Material 3/18/2009 255.86 Total Special Invoices 2,283.55 Sales tax 35.24 35.24 Use Tax Veh. Exp.33.82+42.85+25.12 101.79 Plow Exp.21.66+11.67 33.33 POAD 213.18+275.05+236.84 725.07 Freight Prov 19.11+22.93+17.96 60.00 Total labor and overhead 4,401.55 Work order cost summary Work order description Work order number Hurless, Curt new drop at Squaw Creek12008-72 I Total overhead Total cost 11,345.631 12,295.241 Individual assets/items:Unit material cost Cable BFO 12 Single Mode 710 ONT 2-POTS 1-ENTERNET 533.52 416.09 2,098.00 1.00 yes ok yes Labor and Total unit costoverhead allocated 6,374.32 3.29 6,907.84 4,971.31 5,387.40 5,387.40 949.61 11,345.63 5,390.69 12,295.24 Labor and Overhead Summary Labor # 104 139 104 104 118 139 118 139 Employee Name Payroll Date Hours 11/13-11/19 31.00 11/3-11/8 27.00 12/23/2009 3.00 1/8/2009 2.00 2/27/2009 5.00 2/27/2009 5.00 3/6/2009 6.00 3/6/2009 6.00 Cost 1,486.27 673.03 102.14 76.82 239.25 134.67 251.94 160.21 Total labor 85.00 3,124.33 Special Invoices Vendor CostNameDateCheck Rivers West Contractors Inc 1/3/2009 24224 1,573.50 Petty cash/Courthouse/Easement 12130/2008 24199 18.00 Mid-State Consultants 12/1212008 24139 54.50 CTCI OH Materials 12/31/2008 2,599.03 CTCI OH Materials 1/19/2009 43.38 Berry Electric Inc.3/9/2009 24494 463.38 CTCI OH Materials 3/31/2009 526.29 Total Special Invoices 5,768.08 Sales tax 32.01+24.97 56.98 Use Tax Veh. Exp. 161+12.49+1.12+11.81+30.13 216.55 Plow Exp. 10.94+3.38+.24 14.56 POAD 1307.68+132.42+99.50+283.82+17762 2,001.04 Freight Provo 125.31 +15.88+3.80+8.34+1 0.76 164.09 Total labor and overhead 11,345.63 Work order cost summary Work order description Work order number ADC 1x32 PON Splitter Module for May CO12008-73 . I Total overhead 267.80 I 1,727.851 yes ok Total cost yes Individual assets/items:Labor and overhead allocated Total unit costUnit material eost Splitter Mod 1x32 SC/APC 1,460.05 267.80 1,727.85 1,727.851.00 1,460.05 267.80 1,727.85 1,727.85 ACT. 2232 Labor and Overhead Summary Labor # Employee Name Date Payroll Hours Cost Total labor Special Invoices Vendor Name Date Check Cost Total Special Invoices Sales tax Use Tax 97.ßO 97.80 Veh. Exp. Plow Exp. POAD Freight 170.00 170.00 Misc. Total labor and overhead 267.80 Work order cost summary Wor order description ADVA 10 GIG NETWORK UPGRADE . Work order number 12008-80 I Total overhead 6,191.391 yes ok Total cost 77,781.791 yes Individual assetslitems:Part Number Unit material cost Act Challs Optical Line Driver (OLD) Modules OLD,ULR, VGA3520 EDFA VOA, MSA 150.1083.01 2.00 11,186.00 22.372.00 1,934.81 12.153.40 24.306.81 1406.6 OLD wi Raman Amp, 1510 nm OSC 150.1081.01 1.00 10,626.70 10,626.70 919.03 11.545.73 11,545.73 1406.6 SPARE, OLD.ULR, VGA3520 EDFA VOA, MSA 150.1083-01 1.00 11,186.00 11,186.00 967.40 12,153.40 12,153.40 1406.6 SPARE, OLD wI Raman Amp, 1510 nm OSC 150.1081-01 1.00 10,626.70 10,626.70 919.03 11,545.73 11,545.73 1406. DCMs For Variable-ain Amplifiers DCM With ID. SMF. 100km, 1RU SheW Assy, LC UPC 100.1170.10 2.00 8.389.50 16.779.00 1,451.11 9,115.05 18.230.11 1406.6 52,014.90 71,590.40 6,191.39 56,513.33 77,781.79 Labor and Overhead Summary Labor # 105 115 Employee Name Date 3/6-3/9/09 3/7-3/8/09 Payroll Hours 12.00 4.00 Cost 751.94 255.06 Total labor 16.00 1,007.00 Special Invoices Vendor CostNameDateCheck ADVA 2/25/2009 24434 .23,714.32 ADVA 2/25/2009 24434 ~177.87 ADVA 2/25/2009 24434 ~52,171.50 76,063.69 (71,590.40) equipment 4,473.29 4 4,473.29 UPS 3/18/2009 24520 5.08 ADVA 3/27/2009 24531 163.46 Total Special Invoices 4,641.83 Sales tax Use Tax Veh. Exp.40.17 40.17 Plow Exp. POAD 473.64 473.64 PROV 28.75 28.75 Misc. Total labor and overhead 6,191.39 Work order cost summary Work order description FTIH build for Elk Bend Units 3 & 4 Work order number 12009-1 I Total overhead 569,064.78 1 yes ok Total cost 666,152.791 yes Individual assetslitems:Unit material cost Labor and overhead allocated 710 ONT 2-POTS 1-ENTERNEl 48.00 410.32 19,695.27 125,692.07 3,028.90 145,387.34 2232 710 ONT 2-POTS 1-ENTERNEl 1.00 411.55 411.55 2.626.45 3,038.00 3,038.00 2232 BF0121 12,400.00 0.85 10,540.00 67,264.60 6.27 77,804.60 2423.1 BF0121W 2,634.00 0.94 2,475.96 15,801.18 6.94 18,27714 2423.1 BF0241 10.856.00 0.96 10,421.76 66,510.01 7.09 76,931.77 2423.1 BF0361 3,774.00 1.00 3,774.00 24,085.07 7.38 27,859.07 2423.1 BF0481 1.314.00 1.10 1,445.40 9,224.31 8.12 10.669.71 2423.1 BF0601 1,764.00 1.15 2,028.60 12,946.20 8.49 14,974.80 2423.1 BF0841 4,020.00 1.39 5,587.80 35,660.45 '. 10.26 41,248.25 2423.1 BF01441 7,340.00 1.87 13.725.80 87,595.87 13.80 101,321.67 2423.1 BF02881 442.00 2.92 1,290.64 8,236.66 21.55 9,527.30 2423.1 BF02881W 1,474.00 3.01 4,436.74 28,314.57 22.22 32,751.31 2423.1 SEB4F LABOR ONLY 136.00 0.40 54.40 347.17 2.95 401.57 2423.1 SEB12 FIBER I 11,434.00 0.79 9,032.86 57,646.27 5.83 66,679.13 2423.1 SEB12 FIBER IW 4,380.00 0.97 4,248.60 27,113.89 7.16 31.362.50 2423.1 513,143.82 sub total 89,169.38 3 1 x32 splitter pack AFUDC for project 1.00 1.00 4,583.63 3,335.00 4,583.63 3,335.00 4,583.63 3,335.00 4,583.63 3,335.00 2232 163.008.97 2423.1 8.757.85 97,088.01 569,064.78 14,113.60 666,152.79 Labor and Overhead Summry labor Employee Payrn Co#Name Date f-.. 113 01/13-19/09 7.00 667.13 104 31312009 2.00 78.83 113 3/2-31/2009 8,00 557.91 118 3130/2009 5.00 209.95 127 31302009 5.00 214.25 103 4/27/2009 3.00 283.05 104 4127/2009 3.00 115.55 113 4/14-3009 7.00 463.76 Se attach detaß she 5/31/20 91.00 3,851.72 113 611-309 26.00 1.453.98 134 619/20 1.50 57.12 136 615-23109 22.00 724.93 See attache detaU she 7/311200 29.50 1,739.40 See attche detail she 8131/200 190.00 7,29.44 See attche detaU she 9/30200 201.00 8,235.2 See attche detH she 10/31/200 85.00 3,69.67 See attche detH sheet 11/30200 36.50 1,766.45 See attche detU she 121311200 183.00 7,556.58 Totl labor 905.50 38,96.14 $peiallnvol Vemor CotNameDateChekMidStte Cort 1/31200 2423 1,221.00MidStte Cort 1/231200 24319 913.00MidSte Ccnts 2/12/2009 24395 1,09.50MidStte Corn 3/9/200 244 840.14 MidSte Consri 319/200 2442 44.26 CTC! Materls 5/26120 40.55 MidSte ConsiJrts 3/712 24534 261.00 MidSte ConsiArt 4/17/20 246 1,637.00 MidStte Consulnt 411712 246 730.45 MidState Consultnt 5/3/200 24727 513.00 TrØCk.~.,jnc 5/112 2477 60,992.83 MidStte Couhart 51211200 24Tl8 1,154.10 MidStte Consulnt 5129/200 24796 2,318.08 Track UUitie, Inc 61191200 24879 6,921.68MidStte Coulnt 61191200 248 6,93.28 Ben Electri Inc 615100 248 1,126.90 Be Elri Inc 611912009 248 2.200.27 MidSte ConsiJrt 6/51200 24910 6,311.15 Bery Eleri Inc 6112 24914 4,40.84 t",cIjJii.lno .7/1712 249 116,502,,5 .MidStte Cort 7/7/20 2499 10,05.81 Be Elri Inc 8/61 25078 2,68.02 MidSte Consullnt 8/6/00 2508 14,403.82 MidSte Consnt 81111200 25087 6,807.70 Be Beri Inc 81181200 25107 2,329.93 CTCI OH Materils 8/28/200 8.99 Be Elri Inc 81181200 25116 1,686.79 MidStte Consnts 8/311200 25143 10,400.76 Roin VaIlS",p~9/41200 25165 4.51 MidStte Consulrt 9/419 25162 2.63.60 Allie Builder SlKply 9/41 25159 33.18 MidSte Consulit 9/1712 2521 1.076.75 CTa OHMàterls 9/241 13.701.05 Berr EJri Inc 9/11/20 25217 503.83 TiackUllle;'tnc:;101112 2525 '95,73.46 MidSte Coulnt 10/81200 2529 88.50AfBUId,,Supl 10/81200 25293 13.19 KGP 10/81200 2529 1,881.28 Ro Valle Sup~10/8/200 2529 217.50 Boer Sttes 10/8/2009 2530 1.079.60 MidStte Consulnt 10/2319 25346 1.001.29 CTa OHMaterls 1112120 8.258.06 Be Eleric Inc 10116120 25337 3,195.73 Be Elric Inc 101231 25363 612.05 KGPLoistic 10/0/20 25372 3,291.14 Be 8eri Inc 1115/20 25401 610.11KGPloistic11/13/20 25418 1,927.00 MidSt Coant 11/13/200 2543 2.682.05 . TrâCkUilietiil 11/231 254 15.29.88. erCl OH Materls 11/61200 154.71Midte Consnt 11/30200 25478 2,163.00 KGP Logisics 11/30/200 25475 60.18 KGP Logisic 12/31200 25499 3,429.79 CTCI OH Materb 12/81 1,00.77 KGP LOQisic 1211112 25537 84.84MidSte Consnt 12111/20 255 2.96.00 Be 8eri Inc 12/28/10 25590 238.60MidSte Cont 12/28100 25586 7.84 Be 8eric Inc 12/30 25601 649,90 KGP loistics 1/22110 2562 20,730.51 (4.58.63) equime 16.146.88 .16,146.88 Saleta 1181,73+24.69 1,206.42 Use Tax 20.48+112.88+64.79+197.47+99.34+16.28+8.59+2' 2,019.64 Yah. Exp, 3.87+50.24+15.08+305.20+4S.18+35.24+216.78+3! 1,722.28 PtoExp. POAD 34.15+592.07+60.88+1376.37+772.79+40.07+2 18,339.93 Freigh PROY 13.37+26.96+23.12+202.17+96.95+39.55135.20+' 1,324.41 T otallabo and overhd 56.06.78 . ' Idaho 503H - Custer Telephone Cooperative, Inc. CPR Tabulation Sheet Work Order 980-2009-1 Elk Bend Units 3 & 4 Exchange CONTRACT UNIT DESCRIPTION QUANTITY LABOR MATERIAL L&B TOTAL COST BA22 118 32.00 38.93 $70.93 $8,369.74 BD3A 118 55.00 136.82 $191.82 $22,634.76 BF0121 12400 0.48 0.37 $0.85 $10,540.00 BF0121W 2634 0.60 0.34 $0.94 $2,475.96 BF0241 10856 0.48 0.48 $0.96 $10,421.76 BF0361 3774 0.48 0.52 $1.00 $3,774.00 BF0481 1314 0.48 0.62 $1.10 $1,445.40 BF0601 1764 0.48 0.67 $1.15 $2,028.60 BF0841 4020 0.48 0.91 $1.39 $5,587.80 BF01441 7340 0.48 1.39 $1.87 $13,725.80 BF02881 442 0.48 2.44 $2.92 $1,290.64 BF02881W 1474 0.60 2.41 $3.01 $4,436.74 BM2(5/8)(8)164 25.00 31.00 $56.00 $9,184.00 BM2AC 21 15.00 19.00 $34.00 $714.00 BM53F 29 25.00 19.15 $44.15 $1,280.35 BM60(4")P 370 30.80 3.59 $34.39 $12,724.30 BM60(4")DP 44 30.80 3.59 $34.39 $1,513.16 BM60(4")PT 215 30.80 3.59 $34.39 $7,393.85 BM61(4")P 96 30.80 3.59 $34.39 $3,301.44 BM61 (4")T 88 19.80 0.00 $19.80 $1,742.40 BM65(4")236 30.00 40.15 $70.15 $16,555.40 BM71 118 11.00 0.00 $11.00 $1,298.00 BM83 69 12.50 6.33 $18.83 $1,299.27 SEB4F LABOR ONL Y 136 0.40 0.00 $0.40 $54.40 SEB12 FIBER I 11434 0.40 0.39 $0.79 $9,032.86 SEB12 FIBER IW 4380 0.60 0.37 $0.97 $4,248.60 UD(1X1-1.25")738 1.80 0.46 $2.26 $1,667.88 UD(1X2-1.25")23268 1.86 0.90 $2.76 $64,219.68 UD(1X1-0.75")8516 2.85 0.28 $3.13 $26,655.08 UD(1X3-1.25")4408 2.00 1.34 $3.34 $14,722.72 UHF(24"X36"X36")T 31 275.00 413.40 $688.40 $21,340.40 UHF(36"X60"X36")T 87 400.00 841.23 $1,241.23 $107,987.01 WUHF 7 250.00 10.00 $260.00 $1,820.00 $395,486.00 Idaho 503H . Custer Telephone Cooperative, Inc. CPR Tabulation Sheet Work Order 980.2009.1 Elk Bend Units 3 & 4 Exchange I Total unit I ICONTRACT UNIT DESCRIPTION TAX DISTRICT QUANTITY LABOR MATERIAL L&B TOTAL COST cost Total CPR value BA22 29 118 32.00 38.93 $70.93 $8,369.74 l I I BD3A 29 118 55.00 136.2 $191.82 $22,634.76 BF012l 29 12400 0.48 0.37 $0.85 $10,54.00 6.27 77,804.60 BF0121W 29 2634 0.60 0.34 $0.94 $2,475.96 6.94 18,27714 BF0241 29 10856 0.48 0.48 $0.96 $10,421.76 7.09 76,931.77 BF0361 29 3774 0.48 0.52 $1.00 $3,774.00 7.38 27,859.07 BF0481 29 1314 0.48 0.62 $1.10 $1,445.40 8.12 10,669.71 BF0601 ....29 1764 0.48 0.67 $1.5 $2,028.60 8.49 14,974.80 BF0841 29 4020 0.48 0.91 $1.39 $5,587,80 10.26 41,248.25 BF01441 29 7340 0.48 1.39 $1.87 $13.725.80 13.80 101,321.67 BF02881 29 442 0.48 2,44 $2.92 $1,290:64 21.55 9,527.30 BF02881W -..29 1474 0.60 2,41 $3.01 $4,436.74 22.22 32,751.31 BM2(5/8)(8)29 164 25.00 31.00 $56.00 $9,184.00 BM2AC 29 21 15.00 19.00 $34.00 $714.00 BM53F 29 29 25.00 19.15 $44.15 $1,280.35 BM60 4" P 29 370 30.80 3.59 $34.39 $12.724.30 BM60 4" DP 29 44 30.80 3.59 $34.39 $1,513.16 BM60 4" PT 29 215 30.80 3.59 $34.39 $7,393.85 BM61 4" P 29 96 30.80 3.59 $34.39 $3,301.44 BM61 4"T 29 88 19.80 0.00 $19.80 $1,742.40 BM65 4"29 236 30.00 40.15 $70.15 $16,555.40 BM71 29 118 11.00 0.00 $11.00 $1,298.00 BM83 29 69 12.50 6.33 $18.83 $1,299.27 SEB4F LABOR ONLY .'. 0 29 136 0.40 .0.00 $0.40 $54.40 2.95 401.57 SEB12FIBERI ....29 11434 0.40 0.39 $0.79 $9,032.86 5.83 66,679.13 SEB12 FIBERIW .0 29 4380 0.60 0.37 $0.97 $4,248.60 7.16 31,362.49 UC 1X1-1.25"29 738 1.80 0.46 $2.26 $1,667.88 UC 1X2-1.25"29 23268 1.86 0.90 $2.76 $64,219.68 UD 1X1-0.75"29 8516 2.85 0.28 $3.13 $26,655.08 UD 1X3-1.25"29 4408 2.00 1.34 $3.34 $14,722.72 UHF(24"X36"X36")T 29 31 275.00 413.40 $688.40 $21,340.40 UHF(36"X60"X36")T 29 87 400.00 841.23 $1.241.23 $107,987.01 WUHF 29 7 250.00 10.00 $260.00 $1,820.00 $395,486.00 509,808.81 Total fiber material and labor cost $69,062:56 Work order cost summary Work order description Work order number New ONT to Viola Oniel, Gary Madsen, South Butte, Squaw Creek Sub, Kerndon,12009-4 I Total overhead 2,711.241 yes ok 4,030.71 I yes Unit material cost Labor and Total unit costoverhead allocated 487.29 487.29 1,001.28 1,488.57 1,488.57 416.09 832.18 1,709.96 1,271.07 2,542.14 Total cost Individual assets/items: 714 ONT 4 POTS 2-ETHERNET 1.00 710 ONT 2-POTS 1-ENTERNET 2.00 903.38 1,319.47 2,711.24 2,759.64 4,030.71 Labor and Overhead Summary Labor # 127 Employee Name Date 1/5-15/09 Payroll Hours 24.00 Cost 970.80 Total labor 24.00 970.80 Special Invoices Vendor CostNameDateCheck CTCI OH Materials 1/19/2009 408.51 Total Special Invoices 408.51 Sales tax 79.18 79.18 Use Tax Veh. Exp.13.33 13.33 Plow Exp. POAD 1193.62 1,193.62 Freight PROV 45.80 45.80 Total labor and overhad 2,711.24 Work order cost summary Work order description Work order number Install ONT in T-Creek Mine Admin over their fiber in their server room12009-10 I Total cost 837.101 yes ok 1,253.191 yes Unit material cost Labor and Total unit costoverhead allocated 416.09 416.09 837.10 1,253.19 1,253.19 Total overhead Individual assets/items: 710 ONT 2-POTS 1-ENTERNET 1.00 416.09 416.09 837.10 1,253.19 1,253.19 Labor and Overhead Summary Labor # 118 127 Employee Name Payroll Date Hours 2/5/2009 2.50 2/3-4/09 4.00 Cost 119.63 170.58 Total labor 6.50 290.21 Special Invoices Vendor CostNameDateCheck CTCI OH Material 2/10/2009 178.14 Total Special Invoices 178.14 Sales tax 24.97 24.97 Use Tax Veh. Exp.7.67 7.67 Plow Exp. POAD 326.12 326.12 Freight PROV 9.99 9.99 Total labor and overhead 837.10 Work order cost summary Work order description Work order number Total overhead Total cost Individual assets/items: Cisco Catalyst 375012 SFP DC Power Ethernet Switch 1000 Base- T SFP GE SFP. LC connector Cisco ASR1006 DC Powered Router Cisco 8-port GigabitEthemet card 1000 Base- T SFP 19" 8ft. Unequal flanged Relay Rack 3750 Cisco Catalyst 12 Port SPF Switch, Cisco ASR1006 DC Powered Router,12009-11 I 23,780.631 128,401.91 1 Unit matenal cost 5,307.05 699.15 1,761.15 66,080.00 29,500.00 699.15 yes ok yes Labor and overhead allocated 1,206.30 158.92 400.31 15,020.12 6,705.41 158.92 574.78 130.65 ACT. 6.513.35 6,513.35 1406 286.02 858.07 1406 720.49 2,161.46 1406 81,100.12 81,100.12 1406 18,102.71 36,205.41 1406 286.02 858.07 1406 705.42 705.42 1406 1.00 3.00 3.00 5,307.05 233.05 587.05 104,621.28 23.780.63 107.714.14 128,401.91 1.00 2.00 3.00 66,080.00 14,750.00 233.05 1.00 574.78 87,764.98 Labor and Overhead Summary Labor 131 Payroll CostDateHours 3/6-18/09 19.00 641.07 2/23/2009 2.00 86.39 2125/2009 5.00 175.92 2/25/2009 5.00 134.67 3/5-13/09 23.00 1,083.67 3/6-13/09 14.50 518.58 Employee# Name 105 136 139 105 136 Total labor 68.50 2,640.30 Special Invoices Vendor CostNameDateCheck INX 3/9/2009 24454 .$8,260.96 $(7,767.35) equipment 493.61 4 $493.61 INX 3/27/2009 24542 604.80 INX 3/9/2009 24454 $101,391.95 $ (95.580.00) equipment 5.811.95 4 $5.811.95 INX 3/27/2009 24542 .$776.16 $(699.15) equipment 77.01 4 $77.01 INX 3/27/2009 24542 9.864.00 Jenson Oil 413/2009 24566 26.36 Kimble Oil 4/3/2009 24576 2.89 Wells Fargo cardffe Bejamin Inn 4/13/2009 24625 162.00 Embarq 3/9/2009 24453 .$1,703.63 $(574.78) equipment 1,128.85 .$1,128.85 Embarq 3/9/2009 24453 143.64 CTCI OH Material 3/15/2009 3.21 Embarq 3/27/2009 24540 64.66 Embarq 3/27/2009 24540 227.82 Embarq 4/13/2009 24620 51.86 Chucks Welding & Sales 4/13/2009 24622 32.65 Total Special Invoices 18,695.31 Sales ta Use Tax 102.22+8.62+3.88+13.66+3.11 131.49 Veh. Exp.47.71 47.71 14.17+94.23 108.40 Plow Exp. POAD 562.45 562.45 397.37+1110.13 1,507.50 Freight PROV 20.01 +67.46 87.47 Sub Total 2,445.02 Total labor and overhead 23.780.63 Work order cost summary Work order description Work order number Splitter Shelf and 1x32 Splitter Module for Challs CO12009-15 I Total overhead 104.481 1,845.791 yes ok Total cost yes Unit material costIndividual assetsltems:Labor and overhead allocated Total unit cost Act. 7 X 23 inch splitter shelf 1 X 32 splitter Module 1.00 1.00 281.26 1,460.05 281.26 1,460.05 16.88 87.60 298.14 1,547.65 298.14 1,547.65 2232 2232 1,741.31 1,741.31 104.48 1,845.79 1,845.79 Labor Labor and Overhead Summary # Employee Name Date Payroll Hours Cost Total labor Special Invoices Vendor Name Embarq Embarq Date 3/9/2009 3/18/2009 Check 24453 24521 Cost Total Special Invoices Sales tax Use Tax Yeh. Exp. Plow Exp. POAD Freight PROY 16.88+87.60 104.48 104.48Total labor and overhead . 281.26 equipment . 1,460.05 equipment Work order cost summary Work order description Work order number Calix 3/ea Combo cards and 1/ea GPON card for Challis Exchange PO #243112009-16 I T olal overhead 1.123.37 ( yes ok 15.751.62 ( ye Unit material cost Act 2.725.45 8,176.35 627.90 2,934.75 8,804.25 2232.1 3.635.45 3,635.45 279.18 3.914.63 3.914.63 2232 2.816.45 2,816.45 216.29 3.032.74 3.032.74 2232 Tolal cost Individual assetsrrtems: Calix Combo ADSL2I2+ 24 Ports 100-00574 3.00 Optical Line Termination, GPON 4-prt 100-00658 1.00 GPON OIM 2.4/1.2 single fiber transceiver 100-01336 1.00 9,177.35 14,628.25 1,123.37 9,882.12 15.751.62 Labor and Overhead Summary Labor # Employee Name Payroll Hours CostDate Total labor Special Invoices Vendor Name Date 3/9/2009 Check 24450Calix Cost 231.77 .. Total Special Invoices 231.77 Sales tax 891.60Use Tax Veh. Exp. Plow Exp. POAD Freight PROV 891.60 Total labor and overhead 1,123.37 . 14,860.02 -14628.25 231.77 Work order cost summary Work order description Work order number Total overhead Total cost Individual assets/items: 0130-0097 ADSL 6+6 with ADSL 2+ Tellabs ADSL2+ 6+6 Cards Purchased 5/ea12009-19 1 225.00 I 3.975.00 I yes ok yes Unit material cost Labor and overhead allocated 5.00 750.00 3.750.00 225.00 795.00 3.975.00 750.00 3.750.00 225.00 795.00 3.975.00 Act 2232.1 Labor and Overhead Summary Labor # Employee Name Date Payroll Hours Cost Total labor Special Invoices Vendor Name Date 3/9/2009 Check 24453Emb,arq Cost Total Special Invoices Sales tax Use Tax 225,00 Veh. Exp. Plow Exp. POAD Freight PROV 225.00 Total labor and overhad 225,00 .3,750.00 material Work order cost summary Work order description Work order number New ONT to Jentre at old Zollnger cinder block house12009-21 I Total overhead 217.791 633.881 yes ok Total cost yes Unit material costIndividual assets/items:Labor and overhead allocated Total unit cost 710 ONT 2-POTS 1-ENTERNET 1.00 416.09 416.09 217.79 633.88 633.88 416.09 416.09 217.79 633.88 633.88 Labor and Overhead Summary Labor # 127 Employee Name Payroll Date Hours 2/23/2009 1.00 Cost 42.64 Total labor 1.00 42.64 Special Invoices Vendor CostNameDateCheck CTCI OH Material 2/26/2009 90.57 Total Special Invoices 90.57 Sales tax 24.97 24.97 Use Tax Veh. Exp.1.18 1.18 Plow Exp. POAD 56.77 56.77 Freight PROV 1.66 1.66 Total labor and overhead 217.79 Work order cost summary Work order description Work order number New ADVA 10G/OC-192 lambda for the DWDM equipment12009-29 I Total overhead 2.129.851 29,440.351 yes ok Total cost yes Unit material costIndividual assetslitems: XPDR MTHBD, 10G LANIWAN/OUT-2 Tunable 150-1180-00-01 XCVR, XFP, MR, SM, 11.1 Gb/s 1310nm 165-2288-01-01 12,495.00 1,160.25 24,990.00 2,320.50 1.948.88 180.97 13,469.44 26,938.88 1,250.73 2.501.47 2.00 2.00 13,655.25 27,310.50 2,129.85 14,720.18 29,440.35 Act. 1406. 1406.6 Labor and Overhead Summary Labor # 105 Employee Name Date 7/07-08/09 Payroll Hours 2.50 Cost 157.81 Total labor 2.50 157.81 Special Invoices Vendor Name ADVA Optical Networking Check 24989 CostDate 7/17/2009 1,931.64 .. Total Special Invoices 1,931.64 Sales tax Use Tax Veh. Exp.2.99 2.99 Plow Exp. POAD 34.08 34.08 Freight PROV 3.33 3.33 Total labor and overhead 2,129.85 ~ 29,242.14 -27310.50 1,931.64 Work order cost summary Work order description Work order number New ONT to Robert Nau at Ellis 12009-40 Total overhead Total cost 1,169.521 1,585.61 1 Individual assets/items:Unit material cost 710 ONT 2-POTS 1-ENTERNET 416.091.00 416.09 yes ok yes Labor and Total unit costoverhead allocated 1,169.52 1,585.61 1,585.61 416.09 416.09 1,169.52 1,585.61 1,585.61 Labor and Overhead Summary Labor # 118 Employee Name Date 4/23-24/09 Payroll Hours 11.00 Cost 491.75 Total labor 11.00 491.75 Special Invoices Vendor CostNameDateCheck CTC) OH Material 4/30/2009 128.26 Total Special Invoices 128.26 Sales tax 24.97 24.97 Use Tax Veh. Exp.12.76 12.76 Plow Exp. POAD 511.78 511.78 Freight Misc. Total labor and overhead 1,169.52 Work order cost summary Work order description Work order number Chuck Babb new Stephens Gulch Sub. New fiber drop.12009-41 I Total overhead 2,467.51 I 2,990.51 I yes ok Total cost yes Unit material costIndividual assets/items:Labor and overhead allocated Total unit cost CABLE BFO 4PR S/M FIBER 562.00 710 ONT 2-POTS 1.ENTERNET 1.00 0.20 410.32 112.68 410.32 531.62 1,935.89 1.15 2,346.21 644.30 2,346.21 410.52 523.00 2,467.51 2,347.35 2,990.51 Labor and Overhead Summary Labor # 104 139 104 118 139 Employee Name Payroll Date Hours 5/1/2009 5/1/2009 7/9-7/13/09 7/13/2009 7/9-713/09 1.00 1.00 11.50 6.00 9.00 Cost 40.57 26.87 509.71 258.61 233.02 Total labor 28.50 1,068.78 Special Invoices Vendor CostNameDateCheck CTCI OH Material 5/27/2009 111.33 Salmon River Electric 7/6/2009 24994 318.75 CTCI OH Material 8/3/2009 524.56 Salmon River Electric 8/18/2009 25106 75.00 Total Special Invoices 1,029.64 Sales tax 31.38 31.38 Use Tax Veh. Exp.6.7+31.66 38.36 Plow Exp.0.28+11.43 11.71 POAD 16.99+238.52 255.51 Freight Prov 4.65+27.48 32.13 Total labor and overhead 2,467.51 Work order cost summary Work order description Work order number New ONT and fiber spliceing to Paula Bunzt up Morgan Creek just past Trent Roman12009-51 I Total overhead 1,150.281 1,559.631 yes ok Total cost yes Unit material costIndividual assets/items:Labor and overhead allocated 710 ONT 2-POTS 1-ENTERNET 1.00 409.35 409.35 1,150.28 1,559.63 1,559.63 409.35 409.35 1,150.28 1,559.63 1,559.63 Làbor and Overhead Summary Labor # 118 Employee Name Date 5/27-29/09 Payroll Hours 11.00 Cost 496.16 Total labor 11.00 496.16 Special Invoices Vendor CostNameDateCheck CTCI OH Materials 5/29/2009 405.64 Total Special Invoices 405.64 Sales tax 24.56 24.56 Use Tax Veh. Exp.36.99 -36.99 Plow Exp. POAD 186.93 186.93 Freight Prov Total labor and overhead 1,150.28 Work order cost summary Work order description Work order number Total overhead Total cost individual assetslrtems: SIM MTHBD. DATA MUX. 2 Port XCVR. SFP. MR SM 1310nm New ADVA SIM modules for the 2.5G Lambda so that ATC could get access to internet and video12009-55 I 397.221 6.882.721 Unit materil cost 5,950.00 535.50 yes ok 150-1165-01-01 165-2267-01-01 2.00 3.00 2.975.00 178.50 yes Act.Labor and overhead allocated 364.42 32.80 3.157.21 6.314.42 189.43 568.30 1406.6 1406.6 3.153.50 6,485.50 397.22 3.346.64 6.882.72 Labor and Overhead Summary Labor # Employee Name Payroll Hours CostDate Total labor Special Invoices Vendor Name ADVA Optical Networking Date 7/8/2009 Check 24941 Cost 397.22 II Total Special Invoices 397.22 Sales tax Use Tax Veh. Exp. Plow Exp. POAD Freight Misc. Total labor and overhead 397.22 . 6,882.72 -6485.50 397.22 Work order cost summary Work order description Work order number 10 New ADSL 6+6 cards 12009-56 Total overhead 439.491 7,439.491 yes ok Total cost yes Individual assets/items:Labor and overhead allocated Total unit costUnit material cost ADSL 6+6 With ADSL 2+7.000.00 439.49 743.95 7.439.4910.00 700.00 700.00 7.000.00 439.49 743.95 7,439.49 Act. 2232.1 Labor and Overhead Summary Labor # Employee Name Payroll Hours CostDate Total labor Special Invoices Vendor Name KGP Logistics, Inc Date 6/25/2009 Check 24903 Cost 18.39 41 Total Special Invoices 18.39 Sales tax 421.10Use Tax Veh. Exp. Plow Exp. POAD Freight Misc. 421.10 Total labor and overhead 439.49 ~ $ 7,018.39 $ (7,000.00) equipment $ 18.39 Work order cost summary Work order description Work order number New duct and fiber drop to Gorgi in May (old Ford Ziegler place)12009-62 I Total overhead 2,128.10 1 yes ok 2,648.291 yes Unit material cost Labor and Total unit costoverhead allocated 0.20 109.87 449.48 1.02 559.35 410.32 410.32 1,678.62 2,088.94 2,088.94 Total cost Individual assets/items: CABLE BFa 4PR 8/M FIBER 548.00 710 aNT 2-POT8 1-ENTERNET 1.00 410.52 520.19 2,128.10 2,089.96 2,648.29 Labor and Overhead Summary Labor # 118 139 Employee Name Payroll Date Hours 7/27-30/09 17.00 7/27-29/09 16.00 Cost 732.67 414.22 Total labor 33.00 1,146.89 Special Invoices Vendor CostNameDateCheck CTCI OH Materials 8/3/2009 643.18 Total Special Invoices 643.18 Sales tax 31.21 31.21 Use Tax Veh. Exp.39.42 39.42 Plow Exp.14.24 14.24 POAD 231.71 231.71 Freight PROV 21.45 21.45 Total labor and overhead 2,128.10 Work order cost summary Work order description New E5-312 for ethernet service to Salmon Work order number 12009-64 I Total overhead 4.604.221 yes ok Total cost 17,396.501 yes Individual assets/items:Unit material cost Labor and Act.overhead allocated 710 ONT 2-POTS 1-ENTERNET 1.00 410.32 410.32 147.68 558.00 558.00 2232 710 ONT 2-POTS 1-ENTERNET 2.00 410.32 820.64 295.37 558.00 1,116.01 2232 710 ONT 2-POTS 1-ENTERNET 1.00 410.32 410.32 147.68 558.00 558.00 2232 Elk Bend E5-312 1.00 4,495.50 4,495.50 1.618.03 6,113.53 6,113.53 2232 GigE SFP Transceiver Mod. Single Moe 60Km 3.00 382.50 1,147.50 413.01 520.17 1,560.51 2232 GigE SFP Transceiver Mod. RJ45 100M 2.00 157.50 315.00 113.38 214.19 428.38 2232 GigE SFP Transceiver Mod. RJ45 100M 1.00 157.50 157.50 56.69 214.19 214.19 2232 Spare E5-312 1.00 4,495.50 4,495.50 1.618.03 6,113.53 6.113.53 2232 GigE SFP Transceiver Mod. Single Mode 60Km 1.00 382.50 382.50 137.67 520.17 520.17 2232 GigE SFP Transceiver Mod. RJ45 100M 1.00 157.50 157.50 56.69 214.19 214.19 2232 11,459.46 12.792.28 4,604.22 15.583.97 17,396.50 Labor and Overhead Summary Labor Employee Name Date 8/19-25/09 8/19-26/09 8/21-27/09 Payroll Hours 15.00 20.50 14.50 Cost# 105 115 131 685.26 934.01 546.89 Total labor 50.00 2,166.16 Special Invoices Vendor CostNameDateCheck CTCIOH Material 8/31/2009 113.16 Calix 8/31/2009 25139 10,588.28 (10,521.00) equipment 67.28 4 67.28 overhead Calix 9/11/2009 25186 489.06 (472.50) equipment 16.56 16.56 overhead Calix 9/11/2009 25186 196.64 (157.50) equipment 39.14 39.14 overhead Stagecoach Inn!Wells Fargo JB 101212009 25255 162.00 CTCI OH Materials 8/31/2009 350.93 CTCIOH Materials 9/25/2009 147.84 Total Special Invoices 896.91 Sales tax 24.62 24.62 Use Tax 635.3+29.34+11.80 676.44 Veh. Exp.57.05 57.05 Plow Exp. POAD 738.18 738.18 Freight Prov 44.86 44.86 Total labor and overhead 4,604.22 Work order cost summary Work order description Work order number New fiber and duct to Ted Oniel on Fury Lane12009-67 I Total overhead 2,471.00 1 2,881.321 yes -I ok yesTotal cost Unit material costIndividual assets/items: Labor and overhead allocated Total unit cost 710 ONT 2-POTS 1-ENTERNET 1.00 410.32 410.32 2,471.00 2,881.32 2,881.32 410.32 410.32 2,471.00 2,881.32 2,881.32 Labor and Overhead Summary Labor # 104 118 139 Employee Name Date 8/20-27/09 8/26&27/09 8/20-27/09 Payroll Hours 11.00 9.00 12.00 Cost 417.52 339.40 302.88 Total labor 32.00 1,059.80 Special Invoices Vendor CostNameDateCheck CTCI OH Material 8/31/2009 450.81 Berry Electric 9/4/2009 25174 569.29 Total Special Invoices 1,020.10 Sales tax 24.62 24.62 Use Tax Veh. Exp.36.51 36.51 Plow Exp.5.64 5.64 POAD 295.28 295.28 Freight Prov 29.05 29.05 Total labor and overhead 2,471.00 Work order cost summary Work order description Work order number New ONT at Water treatment plant at Thompson Creek12009-83 I Total overhead 275.961 687.51 I yes ok yesTotal cost Individual assets/items:Unit matenal cost Total material cost Labor and overhead allocated Total unit cost 710 ONT 2-POTS 1-ENTERNET 1.00 411.55 411.55 275.96 687.51 687.51 411.55 411.55 275.96 687.51 687.51 Labor and Overhead Summary Labor # 118 Employee Name Payroll Date Hours 10/8/2009 1.50 Cost 65.36 Total labor 1.50 65.36 Special Invoices Vendor CostNameDateCheck CTC) OH Materials 11/2/2009 149.59 Total Special Invoices 149.59 Sales tax 24.69 24.69 Use Tax Veh. Exp.2.28 2.28 Plow Ex. POAD 34.04 34.04 Freight Misc. Total labor and overhead 275.96 Work order cost summary Work order description Work order number New ONT for Bauchman trailor up Pahsomeroi and ONT at old Cunningham Log House12009-86 I Total overhead 1,330.591 yes ok 2,153.691 yes Unit material cost Labor and Total unit costoverhead allocated 411.55 823.10 1,330.59 1,076.85 2,153.69 Total cost Individual assetslitems: 710 ONT 2-POTS 1-ENTERNET 2.00 411.55 823.10 1,330.59 1,076.85 2,153.69 Labor and Overhead Summary Labor # 118 127 Employee Name Payroll Date Hours 10/26/2009 3.00 10/30/2009 3.00 Cost 130.71 129.05 Total labor 6.00 259.76 Special Invoices Vendor CotNameDateCheck CTCI OH Materials 11/2/2009 187.26 Berry Electric Inc 11/16/2009 25449 682.95 Total Special Invoices 870.21 Sales tax 49.38 49.38 Use Tax Veh. Exp.9.10 9.10 Plow Exp. POAD 136.08 136.08 Freight Prov 6.06 6.06 Total labor and overhead 1,330.59 Work order cost summary Work order description Work order number Total overhead Total cost Individual assets/items; Combo ADSL2 2+ and POTS 24 Por 3 new Calix ADSL 2+ with bonding card12009-94 1 9.651 8.186.00 I yes ok yes Unit material cost 100.01630 3.00 2,725.45 8.176.35 9.65 2.728.67 8,186.00 2,725.45 8,176.35 9.65 2,728.67 8,186.00 Act. 2232.1 Labor and Overhead Summary Labor # Employee Name Date Payroll Hours Cost Total labor Special Invoices Vendor Name Calix Date 12/28/2009 Check 25580 Cost ~8,186.00 equipment -8176.35 9.659.65 II Total Special Invoices 9.65 Sales tax Use Tax Veh. Exp. Plow Exp. POAD Freight Misc. Total labor and overhead 9.65 Work order cost summary Work order description Work order number Total overhead Total cost Individual assetsñtems: Change out of ONT at McKee 714 ONT 4 POTS 2-ETHERNET WO#2008-54 (-1)710 ONT 2-POTS 1-ENTERNET W0#2009-60 (1)710 ONT 2-POTS 1-ENTERNET ONT's for ThompSon Creek water treatment, Mckee ONT Change out Misc matenal12009-100 I yes ok273,381 757.681 yes 41.07 113.82 113.82 232.31 643.86 643.86 Unit matenal cost Labor and overhad allocated 1.00 484.30 411.55 72.75 72.75 1.00 411.55 411.55 1,380.15 484.30 273.38 757.68 757.68 Act. 2232 2232 Labor and Overhead Summary Labor # Employee Name Date Payroll Hours Cost Total labor Special Invoices Vendor Name CTCI OH Material WO#2008-54 CTCI OH Material WO#2009-41 CTCI OH Material WO#2009-60 CTCI OH Material WO#2009-61 Date Check 12/10/2009 12/10/2009 12/10/2009 12/15/2009 Cost 58.09 58.09 125.03 3.11 Total Special Invoices 244.32 29.06Sales tax 4.37+24.69 Use Tax Veh. Exp. Plow Exp. POAD Freight Misc. Total labor and overhead 273.38 ., ' . LI N K FR O M MA C K A Y EX I S T i N G CE N T R A L O F F I C E Fu j i t s u Fla s h w a v e 4 3 0 0 SO N E T E q u i p m e n t Ex i s t i n g FL M 5 0 / 1 5 0 MU X LI N K F R O M MA C K A Y BF 0 9 6 NE W FU J I T S U FW 4 0 1 0 Ex i s t i n g MA R C O N I TN X . 1 1 0 0 AT M SW I T C H CI S C O 72 0 6 10 / 1 0 0 / 1 0 0 0 Eth e S w i t c h MA Y E X C H A I I G E TU R I N I W H I T E R O C K VL X 2 0 2 0 CA U X C7 co CA U X C7 Bl C CH A L L I S B R O A D B A N D E Q U I P M E N T 2 0 0 9 CH A L L I S T O C L A Y T O N L I N K FIB E R O C - 3 ( P A T H 1 ) ~- FI B E R O C - 3 ( P A T H 2 ) FI B E R O G - 3 ( P A T H 3 ) LI N K T O S T A N L E Y Fu j i t s u Fl a s h w a v e 4 3 0 0 SO N E T E q u i p m e n t CH A L L I S E X C H A G E CL A Y T O N E X C H A N G E ~-o r:L. (J A U X C7CO - CA L I X C7 BL C -- AF C lE T 3~\ Cl a y n C . O . RS T 1 , R S T 2 , R S T 3 , R S T 4 , R S T 5 . R S T 6 , R S T 7 , R S T B RS T 9 , R S T 1 0 , R S T 1 1 , R S T 1 2 DS L A G R E G A T I O N F O R CL A Y T O N TE L L A B S LE T 1 TE L L A B S LE T 2 NE T T O N E T lP D 4 0 0 0 TO C U S T O M E R S WIT H I N 1 2 K F E E T IIIiIIIIIII - - - - - , - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ~ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - i E L K B E N D E X C H A G E i I I I I I I I I I I CA L I X C7 CO RS T 2Au TO C U S T O M E R S WI T H I N 1 2 K F E E T 2R S T 1 , 2 R S T 2 , 2 R S T 3 , 2 R S T 4 , 2 R S T 5 , 2 R S T 6 , 2 R S T 7 (J C A U X C7 CO LJ U X C7Bl C . 23 7 , 9 9 8 . 1 TE L L A S C i s S 1 1 , 4 1 4 . 4 9 S FI B E R O P T I C C A B L E 12 8 . 4 0 1 . 1 S 5 6 9 , 8 6 5 . 6 1 $ 1 , 0 6 1 , 7 8 5 . 6 6 i; ~ c: CA L I X C7 BL C A! V A I a z S 1 1 4 . 1 0 4 . 8 6 Bro d b a n d O v e r i e w