{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Preventive Maintenance ","Additional Information","Sheet1"],"not_rendered":{"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Preventive Maintenance ","index":0,"n_rows":36,"n_cols":9,"rows_kept":36,"merged":[[1,1,1,2],[1,3,1,8],[3,2,3,10],[21,1,21,11],[28,7,28,8],[30,2,30,11],[31,2,31,11],[32,2,32,11],[33,2,33,11],[34,2,34,11],[35,2,36,11]]}
[]
[null,"Name of proposing firm:"]
[null,null,"ITB Number: "]
[null,null,"5 - Year Preventive Maintenance and Operational Fees"]
[null,1,"Schedule of Possible Throughput Levels of CNG Dispensed Monthly","Therms per month",{"$f":"600000/12","v":{"v":50000,"d":"50,000"}},{"$f":"700000/12","v":{"v":58333.333333333336,"d":"58,333"}},{"$f":"800000/12","v":{"v":66666.66666666667,"d":"66,667"}},{"$f":"900000/12","v":{"v":75000,"d":"75,000"}},{"$f":"1000000/12","v":{"v":83333.33333333333,"d":"83,333"}}]
[null,2,"Weight factor for likelihood of encountering the respective throughput levels",{"$f":"SUM(E6:I6)","v":{"v":1.05,"d":"105%"}},{"v":0.1,"d":"10%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.2,"d":"20%"}]
[]
[null,3,"Pricing for Preventive Maintenance of CNG system","$/Therm"]
[]
[null,4,"Extended cost at each monthly throughput level (Contractor's (comprehensive costs for CNG O&M services)","$/month",{"$f":"E5*E8","v":0},{"$f":"F5*F8","v":0},0,0,0]
[]
[null,"5A","Weighted average cost for O&M services across all throughput levels (unweighted)","$/Therm",{"$f":"(SUM(E10:I10)/(SUM(E5:I5)))","v":{"v":0,"d":"0.000"}}]
[null,"5B","Weighted average cost for O&M services across all throughput levels (weighted to most likely throughput levels)","$/Therm",{"$f":"((E10*E6)+(F10*F6)+(G10*G6)+(H10*H6)+(I10*I6))/((E5*E6)+(F5*F6)+(G5*G6)+(H5*H6)+(I5*I6))","v":{"v":0,"d":"0.000"}}]
[]
[null,6,"Monthly cost for O&M services (weighted to most likely throughput levels)","$/month",{"$f":"((((E5*E6)+(F5*F6)+(G5*G6)+(H5*H6)+(I5*I6))/D6*E13))","v":0}]
[]
[null,7,"Annual cost for O&M services (weighted to most likely throughput levels)","$/year",{"$f":"((((E5*E6)+(F5*F6)+(G5*G6)+(H5*H6)+(I5*I6))/D6*E13))*12","v":0}]
[]
[null,8,"Cost of CNG O&M services at Facility for 5-year contract term","$/contract",{"$f":"E17*5","v":{"v":0,"d":"$0"}}]
[]
[]
[null,"5 - Year Repair Services"]
[null,null,"Line Item","Labor","Estimated Hours","Unit","Hourly Rate","Total"]
[null,null,1,"Project Manager",64,"HRS",null,{"$f":"E24*G24","v":0}]
[null,null,2,"Lead Technician",128,"HRS",null,{"$f":"E25*G25","v":0}]
[null,null,3,"Technician Helper",{"$f":"256/2","v":128},"HRS",null,0]
[null,null,"TOTAL ","5 Year Period",{"$nulls":3},{"$f":"SUM(H24:H26)","v":0}]
[]
[null,null,"Preventive Maintenance & Repair Services - Grand Total",{"$nulls":4},{"$f":"SUM(E19+H27)","v":0}]
[]
[null,null,"NOTES:"]
[null,null,"NOTE: Contractor must fill in cells highlighted yellow."]
[null,null,"THE UNIT QUANTITIES ABOVE ARE ESTIMATED VALUES: This is a Fixed Unit-Price, Indefinite Quantity contract and the quantities above are estimates only. The quantities may exceed or be less than the estimated amounts. "]
[null,null,"NOTE: All site visit unit prices contained within the Base Services portion of this contract shall be inclusive of travel and lodging expenses.  "]
[null,null,"NOTE: Project personnel must be qualified in the labor categories proposed."]
[null,null,"NOTE:  The fully burdened hourly rates contained above shall be inclusive of all labor, overhead, and profit necessary to perform the Supplemental Services requirements.  Materials and replacement parts for Supplemental services shall be reimbursed in accordance with the Statement of Work.  Payments for supplemental services shall be made for actual services performed.  "]

{"sheet":"Additional Information","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"merged":[[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,1,8,7]]}
[null,"Definitions and Comments"]
[1,"Range of possible monthly throughput levels of CNG fuel in Therms dispensed to NGVs that may occur at the Arlington Transit (ART) CNG-fueling facility in any month of the contract term.  Number in each column is the minimum for that range, i.e. the first column in Line 28 represents the usage range from 20,000-29,999 Therms per month, and the second column in Line 28 represents the range from 30,000-39,999 Therms per month."]
[2,"Weighting of likelihood that a given throughput level will be encountered, as determined by ART."]
[3,"Contractor's charge a fixed monthly rate for operations & maintenance services for the CNG facility, including all materials, labor, profit and overheads.  Includes consumables, scheduled and unscheduled repairs, taxes, insurances, management, telecommunication, and related expenses, but excludes all costs for gas and electrical power.  Values shall be adjusted annually and cumulatively by the Producer Price Index as published by the U.S. Dept. of Labor for Washington DC/Baltimore, not to exceed 3% annually.  Contractor's billing to ART shall be fixed monthly."]
[4,"Extended monthly cost for O&M services, based on the throughput and unit pricing from each column.  Calculation: [value from Line 1 x value from Line 2]."]
["5A","Average cost per Therm of CNG for O&M services, unweighted.  Calculation: =(SUM(D9:H9)/(SUM(D4:H4)))"]
["5B","Average cost per Therm of CNG for O&M services, weighted to most likely throughput levels as determined by ART.   Description: (sum of extended monthly cost @ throughput level x weight factor) ÷ (sum of monthly throughput level x weight factor).   Calculation: =[((D9*D5)+(E9*E5)+(F9*F5)+(G9*G5)+(H9*H5))] / [((D4*D5)+(E4*E5)+(F4*F5)+(G4*G5)+(H4*H5))]."]
[6,"Annualized cost for O&M services, including weighting towards most likely throughput levels Therms per month.  Description: (sum of monthly throughputs x weight factors) ÷ (product of sum of weight factors x unweighted price per Therm) x 12 months.   Calculation: =((((D4*D5)+(E4*E5)+(F4*F5)+(G4*G5)+(H4*H5))/C5*D12))*12."]
[7,"Simple value of years 1-5 of estimated Owner costs for O&M service.  Description: summary annual cost for year 1 x 5 (NPV not calculated). This does not represent that actual award amount but is used to compare bid costs.  "]

{"sheet":"Sheet1","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"hidden":true,"merged":[[1,2,1,3],[2,2,2,6]]}
[]
[null,null,"3-yr O&M"]
[null,null,"10-yr O&M"]
[null,"Year ending",2013,2016,2017,2017,2018]
[null,"Buses",24,54,78,91,122]
[null,"x DGE's / day",35,40,40,40,40]
[null,"x service days / week",5,6,6,6,6]
[null,"x weeks / month",4.28,4.28,4.28,4.28,4.28,{"$f":"52/12","v":4.333333333333333}]
[null,"= DGEs / fleet / month",{"$f":"C5*C6*C7*C8","v":{"v":17976,"d":"17,976"}},{"$f":"D5*D6*D7*D8","v":{"v":55468.8,"d":"55,469"}},{"$f":"E5*E6*E7*E8","v":{"v":80121.6,"d":"80,122"}},{"$f":"F5*F6*F7*F8","v":{"v":93475.20000000001,"d":"93,475"}},{"$f":"G5*G6*G7*G8","v":{"v":125318.40000000001,"d":"125,318"}}]
[null,"x SCF / DGE",137,137,137,137,137]
[null,"= SCF / fleet / month",{"$f":"C9*C10","v":{"v":2462712,"d":"2,462,712"}},{"$f":"D9*D10","v":{"v":7599225.600000001,"d":"7,599,226"}},{"$f":"E9*E10","v":{"v":10976659.200000001,"d":"10,976,659"}},{"$f":"F9*F10","v":{"v":12806102.400000002,"d":"12,806,102"}},{"$f":"G9*G10","v":{"v":17168620.8,"d":"17,168,621"}}]
[null,"/ SCF / Therm",98,98,98,98,98]
[null,"= Therm / month",{"$f":"C11/C12","v":{"v":25129.714285714286,"d":"25,130"}},{"$f":"D11/D12","v":{"v":77543.11836734695,"d":"77,543"}},{"$f":"E11/E12","v":{"v":112006.72653061226,"d":"112,007"}},{"$f":"F11/F12","v":{"v":130674.51428571431,"d":"130,675"}},{"$f":"G11/G12","v":{"v":175190.0081632653,"d":"175,190"}}]