{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Preliminary Economic Model"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Preliminary Economic Model","index":0,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,6,7,6],[3,7,7,9]]}
[]
[null,"PRELIMINARY ECONOMIC MODEL"]
[]
[null,"Input Parameters","Units","Value","Comment",null,"INSTRUCTIONS:","This worksheet is intended to provide guidance on the per mile cost metric.  The input values are for example only.  Green cells inputs made by Applicants."]
[null,"Installed Distance","miles"]
[null,"Installed Distance","km"]
[null,"Project Duration","months"]
[]
[null,"1.  Consultant & Contractor Costs","Units","Value","Comment"]
[null,"Project Management","($)",null,null,null,"Results Summary","Units","Value"]
[null,"Site preparation (vegetation control)","($)",null,null,null,"Total Project Cost","($)",{"$f":"+D27+D32+D46+D58+D64","v":0}]
[null,"Excavation","($)",null,null,null,"Total cost ","($/mile)",{"$f":"+I11/D5","v":{"$error":"#DIV/0!"}}]
[null,"Utility day-lighting (pot holing, underground survey/mapping)","($)",null,null,null,"Total cost ","($/km)",{"$f":"I12*0.621","v":{"$error":"#DIV/0!"}}]
[null,"Backfilling","($)"]
[null,"Repaving","($)"]
[null,"Restoring landscapes (vegetation)","($)"]
[null,"Install conduits","($)"]
[null,"Install duct banks (if needed)","($)"]
[null,"Install access shafts","($)"]
[null,"Install junction boxes","($)"]
[null,"Install vaults","($)"]
[null,"Install pads for pad-mount equipment","($)"]
[null,"Install cables","($)"]
[null,"Install joints (splice, termination, elbow)","($)"]
[null,"Transportation","($)"]
[null,"Damages and repairs","($)"]
[null,"Total Consultant & Contractor Cost","($)",{"$f":"SUM(D10:D26)","v":0}]
[]
[null,"2.  Utility Labor Costs","Units","Value","Comment"]
[null,"Project Management","($)"]
[null,"Utility installations","($)"]
[null,"Total Consultant & Contractor Cost","($/km)",{"$f":"SUM(D30:D31)","v":0}]
[]
[null,"3.  Material & Material Transport Costs","Units","Value","Comment"]
[null,"Cable","($/km)"]
[null,"Conduit","($/km)"]
[null,"Duct Banks (if needed)","($/km)"]
[null,"Access shafts","($/km)"]
[null,"Junction boxes","($/km)"]
[null,"Vaults","($/km)"]
[null,"Equipment mounting pads","($/km)"]
[null,"Terminations","($/km)"]
[null,"Instrumentation","($/km)"]
[null,"Materials Transport & Handling","($/km)"]
[null,"Consumables","($/km)"]
[null,"Total Material Cost","($/km)",{"$f":"SUM(D35:D45)","v":0}]
[]
[null,"4.  Capital Equipment Costs"," "]
[null,null,"Units","Capital Equipment #1:  Mapping & Survey","Capital Equipment #2:  Drilling","Capital Equipment  #3: Restoration Service","Capital Equipment  #4: (As needed)","Cost Modeling Tool can be expanded for additional capital equipment items"]
[null,"CAPEX ","($)"]
[null,"Annual return on CAPEX ","(%)"]
[null,"Useful life ","(yrs)"]
[null,"Annual amortized cost recovery for tool CAPEX, including Annual return on CAPEX","($)",{"$f":"-PMT(D51,D52,D50)","v":{"$error":"#NUM!"}},{"$f":"-PMT(E51,E52,E50)","v":{"$error":"#NUM!"}},{"$f":"-PMT(F51,F52,F50)","v":{"$error":"#NUM!"}},{"$f":"-PMT(G51,G52,G50)","v":{"$error":"#NUM!"}}]
[null,"Capital Equipment Maintenance","% of CAPEX"]
[null,"Annual Capital Equipment Maintenance Cost","($)",{"$f":"+D54*D50","v":0},{"$f":"+E54*E50","v":0},{"$f":"+F54*F50","v":0},{"$f":"+G54*G50","v":0}]
[null,"Monthly Capital Equipment Maintenance Cost","($)",{"$f":"+D55/12","v":0},{"$f":"+E55/12","v":0},0,0]
[null,"Project CAPEX (amortized cost recovery + capital equipment maintenance)","($)",{"$f":"+D56*$D7","v":0},{"$f":"+E56*$D7","v":0},{"$f":"+F56*$D7","v":0},{"$f":"+G56*$D7","v":0}]
[null,"Total CAPEX (Categories # 1 - 4)","($)",{"$f":"SUM(D57:G57)","v":0}]
[]
[null,"5.  Other Costs"," "]
[null,"AFUDC & Interest","($)"]
[null,"Equipment rental","($)"]
[null,"Insurance","($)"]
[null,"Total Consultant & Contractor Cost","($/km)",{"$f":"SUM(D61:D63)","v":0}]