{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Input","Capex_Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":69,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Input","index":0,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,"Model Input",null,null,"Section Check:","Ok",null,null,null,null,"Legend:","Assumptions","Input","Formula"]
[]
[]
[]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Fleet Data"]
[]
[null,null,null,null,null,"Data As At (Date)"]
[null,null,null,null,"JGN","2024-01-01"]
[]
[]
[null,"Fleet Replacement Criteria"]
[]
[null,null,"JGN"]
[]
[null,null,null,null,"Vehicle Type","Replacement Criteria Selection",null,"Replacement Age (years)","Replacement Kilometer (km)","Average Annual Kilometer (km)","Replacement Cost \n($Real 2023)"]
[]
[null,null,null,null,"Material Handling","Replacement Age (years)",null,10,150000,0,70000]
[null,null,null,null,"Heavy Commercial - Large","Replacement Kilometer (km)",null,10,150000,13000,270000]
[null,null,null,null,"Heavy Commercial - Small","Replacement Kilometer (km)",null,10,150000,20000,150000]
[null,null,null,null,"Light Commercial 4x2 ute","Replacement Age (years)",null,5,150000,28503.000000000015,0]
[null,null,null,null,"Light Commercial 4x4 ute","Replacement Age (years)",null,5,150000,30000,99000]
[null,null,null,null,"Light Commercial Van Large","Replacement Age (years)",null,4,150000,30000,118000]
[null,null,null,null,"Light Commercial Van Small","Replacement Age (years)",null,5,150000,30000,80000]
[null,null,null,null,"Rebuild","Replacement Age (years)",null,5,null,null,80000]
[null,null,null,null,"Passenger Hybrid","Replacement Age (years)",null,5,150000,30000,0]
[null,null,null,null,"Plant","Replacement Age (years)",null,10,null,0,60000]
[null,null,null,null,"Trailer  ","Replacement Age (years)",null,10,null,0,25000]
[null,null,null,null,"Excavation","Replacement Age (years)",null,7,null,0,80000]
[null,null,null,null,"Other","Replacement Kilometer (km)",null,null,null,0,0]
[null,null,null,null,"Other","Replacement Age (years)",null,null,0,0,0]
[]
[null,"End"]

{"sheet":"Capex_Summary","index":1,"n_rows":117,"n_cols":18,"rows_kept":117,"cut":false,"hidden":false,"merged":[[9,3,9,4]]}
[null,null,"Capex Summary",null,null,"Section Check:",null,null,"Ok",null,null,"Legend:","Assumptions","Input","Formula"]
[]
[]
[]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,null,null,null,"Navigation"]
[]
[null,null,null,"JGN Fleet Capex Forecast"]
[]
[null,"JGN Fleet Capex Forecast",null,null,null,"[TOP]"]
[]
[null,null,null,"Replacement Vehicle Volumes (#)"]
[null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,"Replacement Vehicle Volumes (#)","Total",null,null,"2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31","2029-12-31","2030-12-31","TOTAL (CY19-CY23)","TOTAL (RY26-RY30)","TOTAL"]
[null,null,null,1,"Material Handling",9,null,null,1,3,0,2,2,1,0,8,8,9]
[null,null,null,2,"Heavy Commercial - Large",0,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,3,"Heavy Commercial - Small",11,null,null,2,1,5,0,1,1,1,9,9,11]
[null,null,null,4,"Light Commercial 4x2 ute",57,null,null,4,0,1,3,0,42,7,8,53,57]
[null,null,null,5,"Light Commercial 4x4 ute",49,null,null,1,1,0,18,0,24,5,20,48,49]
[null,null,null,6,"Light Commercial Van Large",105,null,null,4,12,0,8,43,3,35,67,101,105]
[null,null,null,7,"Light Commercial Van Small",3,null,null,0,0,0,0,0,1,2,0,3,3]
[null,null,null,8,"Rebuild",3,null,null,1,0,0,0,0,2,0,1,2,3]
[null,null,null,9,"Passenger Hybrid",17,null,null,5,0,5,1,1,3,2,12,12,17]
[null,null,null,10,"Plant",5,null,null,5,0,0,0,0,0,0,5,0,5]
[null,null,null,11,"Trailer  ",24,null,null,6,14,0,1,2,1,0,23,18,24]
[null,null,null,12,"Excavation",1,null,null,1,0,0,0,0,0,0,1,0,1]
[null,null,null,13,"Other",0,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,14,"Other",0,null,null,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Total Replacement Vehicle Volumes (#)",284,null,null,30,31,11,33,49,78,52,154,254,284]
[]
[null,null,null,"Smoothed Volumes",null,null,null,null,"Smoothing over entire duration evenly"]
[]
[null,null,null,null,"Smoothed Volumes","Total",null,null,"2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31","2029-12-31","2030-12-31",null,"TOTAL (RY26-RY30)","TOTAL"]
[null,null,null,1,"Material Handling",9,null,null,1.2857142857142858,1.2857142857142858,1.2857142857142858,1.2857142857142858,1.2857142857142858,1.2857142857142858,1.2857142857142858,null,7.7142857142857144,9]
[null,null,null,2,"Heavy Commercial - Large",0,null,null,0,0,0,0,0,0,0,null,0,0]
[null,null,null,3,"Heavy Commercial - Small",11,null,null,1.5714285714285714,1.5714285714285714,1.5714285714285714,1.5714285714285714,1.5714285714285714,1.5714285714285714,1.5714285714285714,null,9.4285714285714288,11]
[null,null,null,4,"Light Commercial 4x2 ute",56.999999999999986,null,null,8.1428571428571423,8.1428571428571423,8.1428571428571423,8.1428571428571423,8.1428571428571423,8.1428571428571423,8.1428571428571423,null,48.857142857142847,56.999999999999986]
[null,null,null,5,"Light Commercial 4x4 ute",49,null,null,7,7,7,7,7,7,7,null,42,49]
[null,null,null,6,"Light Commercial Van Large",105,null,null,15,15,15,15,15,15,15,null,90,105]
[null,null,null,7,"Light Commercial Van Small",2.9999999999999996,null,null,0.42857142857142855,0.42857142857142855,0.42857142857142855,0.42857142857142855,0.42857142857142855,0.42857142857142855,0.42857142857142855,null,2.5714285714285712,2.9999999999999996]
[null,null,null,8,"Rebuild",2.9999999999999996,null,null,0.42857142857142855,0.42857142857142855,0.42857142857142855,0.42857142857142855,0.42857142857142855,0.42857142857142855,0.42857142857142855,null,2.5714285714285712,2.9999999999999996]
[null,null,null,9,"Passenger Hybrid",17,null,null,2.4285714285714284,2.4285714285714284,2.4285714285714284,2.4285714285714284,2.4285714285714284,2.4285714285714284,2.4285714285714284,null,14.571428571428571,17]
[null,null,null,10,"Plant",5,null,null,0.7142857142857143,0.7142857142857143,0.7142857142857143,0.7142857142857143,0.7142857142857143,0.7142857142857143,0.7142857142857143,null,4.2857142857142856,5]
[null,null,null,11,"Trailer  ",23.999999999999996,null,null,3.4285714285714284,3.4285714285714284,3.4285714285714284,3.4285714285714284,3.4285714285714284,3.4285714285714284,3.4285714285714284,null,20.571428571428569,23.999999999999996]
[null,null,null,12,"Excavation",0.99999999999999978,null,null,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,null,0.85714285714285698,0.99999999999999978]
[null,null,null,13,"Other",0,null,null,0,0,0,0,0,0,0,null,0,0]
[null,null,null,14,"Other",0,null,null,0,0,0,0,0,0,0,null,0,0]
[null,null,null,0,0,0,null,null,0,0,0,0,0,0,0,null,0,0]
[null,null,null,null,"Total Smoothed Volumes",284,null,null,40.571428571428584,40.571428571428584,40.571428571428584,40.571428571428584,40.571428571428584,40.571428571428584,40.571428571428584,null,243.42857142857147,284]
[]
[null,null,null,"% Allocation Overwrite",null,null,null,null,"Allocate % of Replacement (allowing for uneven distribution)"]
[]
[null,null,null,null,"% Allocation Overwrite","Total","Overwrite?",null,"2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31","2029-12-31","2030-12-31"]
[null,null,null,1,"Material Handling",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,2,"Heavy Commercial - Large",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,3,"Heavy Commercial - Small",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,4,"Light Commercial 4x2 ute",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,5,"Light Commercial 4x4 ute",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,6,"Light Commercial Van Large",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,7,"Light Commercial Van Small",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,8,"Rebuild",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,9,"Passenger Hybrid",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,10,"Plant",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,11,"Trailer  ",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,12,"Excavation",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,13,"Other",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,14,"Other",1,"No",null,0,0,0,0,0,0,1]
[null,null,null,0,0,1,"No",null,0,0,0,0,0,0,1]
[]
[null,null,null,"Replacement Capex Forecast Expenditure ($)"]
[]
[null,null,null,null,null,null,null,null,"Forecast","Forecast","Reg1","Reg2","Reg3","Reg4","Reg5"]
[null,null,null,null,"Replacement Capex Forecast Expenditure ($)","Replacement Cost \n($Real 2023)",null,null,"2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31","2029-12-31","2030-12-31","TOTAL (CY19-CY23)","TOTAL (RY26-RY30)","TOTAL"]
[null,null,null,1,"Material Handling",70000,null,null,70000,210000,0,140000,140000,70000,0,560000,455000,630000]
[null,null,null,2,"Heavy Commercial - Large",270000,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,3,"Heavy Commercial - Small",150000,null,null,300000,150000,750000,0,150000,150000,150000,1350000,1200000,1650000]
[null,null,null,4,"Light Commercial 4x2 ute",0,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,5,"Light Commercial 4x4 ute",99000,null,null,99000,99000,0,1782000,0,2475000,594000,1980000,4603500,5049000]
[null,null,null,6,"Light Commercial Van Large",118000,null,null,472000,1416000,0,944000,5546000,1770000,4130000,8378000,11033000,14278000]
[null,null,null,7,"Light Commercial Van Small",80000,null,null,0,0,0,0,0,80000,160000,0,160000,240000]
[null,null,null,8,"Rebuild",80000,null,null,80000,0,0,0,0,240000,0,80000,240000,320000]
[null,null,null,9,"Passenger Hybrid",0,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,10,"Plant",60000,null,null,300000,0,0,0,0,0,0,300000,0,300000]
[null,null,null,11,"Trailer  ",25000,null,null,150000,350000,0,25000,50000,25000,0,575000,275000,600000]
[null,null,null,12,"Excavation",80000,null,null,80000,0,0,0,0,0,0,80000,0,80000]
[null,null,null,13,"Other",0,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,14,"Other",0,null,null,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Total Replacement Capex Forecast Expenditure ($)",null,null,null,1551000,2225000,750000,2891000,5886000,4810000,5034000,13303000,17966500,23147000]
[]
[null,null,null,"Smoothed Expenditure"]
[]
[null,null,null,null,"Smoothed Expenditure","Replacement Cost \n($Real 2023)",null,null,"2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31","2029-12-31","2030-12-31",null,"TOTAL (RY26-RY30)","TOTAL"]
[null,null,null,1,"Material Handling",70000,null,null,90000,90000,90000,90000,90000,90000,90000,null,540000,630000]
[null,null,null,2,"Heavy Commercial - Large",270000,null,null,0,0,0,0,0,0,0,null,0,0]
[null,null,null,3,"Heavy Commercial - Small",150000,null,null,235714.28571428571,235714.28571428571,235714.28571428571,235714.28571428571,235714.28571428571,235714.28571428571,235714.28571428571,null,1414285.7142857143,1650000]
[null,null,null,4,"Light Commercial 4x2 ute",0,null,null,0,0,0,0,0,0,0,null,0,0]
[null,null,null,5,"Light Commercial 4x4 ute",99000,null,null,721285.71428571432,721285.71428571432,721285.71428571432,721285.71428571432,721285.71428571432,721285.71428571432,721285.71428571432,null,4327714.2857142864,5049000.0000000009]
[null,null,null,6,"Light Commercial Van Large",118000,null,null,2039714.2857142857,2039714.2857142857,2039714.2857142857,2039714.2857142857,2039714.2857142857,2039714.2857142857,2039714.2857142857,null,12238285.714285715,14278000]
[null,null,null,7,"Light Commercial Van Small",80000,null,null,34285.714285714283,34285.714285714283,34285.714285714283,34285.714285714283,34285.714285714283,34285.714285714283,34285.714285714283,null,205714.28571428571,240000]
[null,null,null,8,"Rebuild",80000,null,null,45714.285714285717,45714.285714285717,45714.285714285717,45714.285714285717,45714.285714285717,45714.285714285717,45714.285714285717,null,274285.71428571432,320000.00000000006]
[null,null,null,9,"Passenger Hybrid",0,null,null,0,0,0,0,0,0,0,null,0,0]
[null,null,null,10,"Plant",60000,null,null,42857.142857142855,42857.142857142855,42857.142857142855,42857.142857142855,42857.142857142855,42857.142857142855,42857.142857142855,null,257142.8571428571,299999.99999999994]
[null,null,null,11,"Trailer  ",25000,null,null,85714.28571428571,85714.28571428571,85714.28571428571,85714.28571428571,85714.28571428571,85714.28571428571,85714.28571428571,null,514285.7142857142,599999.99999999988]
[null,null,null,12,"Excavation",80000,null,null,11428.571428571429,11428.571428571429,11428.571428571429,11428.571428571429,11428.571428571429,11428.571428571429,11428.571428571429,null,68571.42857142858,80000.000000000015]
[null,null,null,13,"Other",0,null,null,0,0,0,0,0,0,0,null,0,0]
[null,null,null,14,"Other",0,null,null,0,0,0,0,0,0,0,null,0,0]
[null,null,null,15,0,0,null,null,0,0,0,0,0,0,0,null,0,0]
[null,null,null,null,"Total Smoothed Expenditure",null,null,null,3306714.2857142854,3306714.2857142854,3306714.2857142854,3306714.2857142854,3306714.2857142854,3306714.2857142854,3306714.2857142854,null,19840285.714285716,23147000]
[]
[]
[]
[]
[null,"End"]