{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Price schedule","schedule a_fixed cost_fleet inf","schedule b_variable cost","schedule c_driver cost","schedule d_admins cost","schedule e_other ohead cost"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Price schedule","index":0,"n_rows":14,"n_cols":9,"rows_kept":14,"merged":[[4,1,4,4],[5,1,5,4],[6,1,6,4]]}
["Project Price schedule summary"]
[]
[null,"days","trips","km/trip","teams","year 1"]
["utilisation",245,3,80,5,{"$f":"B4*C4*D4*E4","v":{"v":294000,"d":"294,000"}}]
["fixed cost - schedule A",{"$nulls":4},{"$f":"'schedule a_fixed cost_fleet inf'!L2","v":0}]
["variable cost - schedule b",{"$nulls":4},{"$f":"'schedule b_variable cost'!M2","v":0}]
["total cost",{"$nulls":4},{"$f":"F5+F6","v":0}]
[{"$nulls":8},{"$f":"I3*$B$4*$B$5*$B$7*$B$6*1.15","v":0}]
["profit - bidder to indicated and add % profit to the project",{"$nulls":3},"%",{"$f":"F7*D9","v":0}]
["total project cost per year",{"$nulls":4},{"$f":"F5+F6+F9","v":0}]
["Total project inclusive of vat"]
[]
[]
[{"$nulls":5},{"$f":"F10/F4","v":0}]

{"sheet":"schedule a_fixed cost_fleet inf","index":1,"n_rows":32,"n_cols":12,"rows_kept":32}
["Schedule A"]
["Fixed cost"]
[{"$nulls":11},"(A)"]
["Fleet information and finance details"]
["No","registration number","new or used","make","model","how many passengers","date of 1st registration","date of rebuilt / refurbish","odometer reading at rebuilt / refurbish","current odometer reading","monthly instalment  / lease","depreciation"]
[1]
[2]
[3]
[4]
[5]
["Spare vehicles if available "]
[1]
[2]
[3]
[]
["Fixed costs ",null,null,"Vehicle 1","Vehicle 2","Vehicle 3","Vehicle 4","Vehicle 5",null,null,"monthly cost","Total fixed cost per year"]
["instalments: used vehicles"]
["instalments: new vehicles"]
["insurance: vehicles"]
["insurance: other"]
["passenger liability cover"]
["operating licences and permits"]
["vehicle licences "]
["driver costs"]
["admin cost"]
["other overheads"]
["Total per year"]
[{"$nulls":11},"(A)"]
["Remarks"]
["driver costs",null,null,"complete schedule c - driver cost, indicating all the costs pertaining to driver cost"]
["admin costs",null,null,"complete schedule d - admin cost,  indicating all the costs pertaining to admin cost"]
["other overheads",null,null,"complete schedule e - other overheads,  indicating all the costs pertaining to other overheads"]

{"sheet":"schedule b_variable cost","index":2,"n_rows":34,"n_cols":13,"rows_kept":34}
["Schedule B"]
["Total Variable cost: tyres + repair and maintenance + fuel"]
[{"$nulls":12},"(A + B +C)"]
["A)  Variable cost: tyres "]
["No","registration number","distance per year","kilometres per tyre set per year","number of tyre sets per year (b / c)","tyre cost per set of 4 tyres","total tyre costs per year (d x e)","other tyre costs per year",{"$nulls":4},"Total tyre cost per year (f + g)"]
[null,"a","b","c","d","e","f","g","h","i","j","k","l"]
[1]
[2]
[3]
[4]
[5]
["Total per year"]
[{"$nulls":12},"(A)"]
["B)  Variable cost: repair and maintenance"]
["No","registration number","distance per year","service intervals in kilometres","count of minor services","cost per minor service","total cost of minor services per year (d x e)","count of major services","cost per major service ","total cost of major services per year (g x h)","oil cost per year for top up","other repair and maintenance cost per year","Total repair and maintenance cost (f + i + j + k)"]
[null,"a","b","c","d","e","f","g","h","i","j","k","l"]
[1]
[2]
[3]
[4]
[5]
["Total per year"]
[{"$nulls":12},"(B)"]
[]
["C)  Variable cost: fuel"]
["No","registration number","distance per year","petrol or diesel","fuel price","fuel consumption - km/l","total fuel litre usage per year (b /e)",{"$nulls":5},"Total fuel cost per year (d x f)"]
[null,"a","b","c","d","e","f","g","h","i","j","k","l"]
[1]
[2]
[3]
[4]
[5]
["Total per year"]
[{"$nulls":12},"(C)"]

{"sheet":"schedule c_driver cost","index":3,"n_rows":29,"n_cols":8,"rows_kept":29}
["Schedule C"]
["Fixed costs - driver cost"]
[]
["driver cost - record all costs pertaining to drivers assigned to the project","driver 1","driver 2","driver 3","driver 4","driver 5","monthly cost","Total cost per year"]
{"$rows_empty":21}
["Total "]
[]
["remarks"]
["record all costs pertaining to drivers for the project"]

{"sheet":"schedule d_admins cost","index":4,"n_rows":29,"n_cols":8,"rows_kept":29}
["Schedule D"]
["Fixed costs - admin cost"]
[]
["admin cost -  Where the bidder has other projects utilising some of the same overheads, only a % must be assigend to this project",{"$nulls":5},"monthly cost","Total cost per year"]
{"$rows_empty":21}
["Total "]
[]
["remarks"]
["record all costs pertaining to admin for the project"]

{"sheet":"schedule e_other ohead cost","index":5,"n_rows":29,"n_cols":8,"rows_kept":29}
["Schedule E"]
["Fixed costs - other overhead cost"]
[]
["other overhead cost - record all other overhead costs pertaining to the project.  Where the bidder has other projects utilising some of the same overheads, only a % must be assigend to this project",{"$nulls":5},"monthly cost","Total cost per year"]
{"$rows_empty":21}
["Total "]
[]
["remarks"]
["record all costs pertaining to other overhead costs for the project"]