{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":74,"n_cols":10,"rows_kept":74,"merged":[[13,9,14,9],[16,9,17,9],[19,9,20,9],[23,9,24,9],[27,9,28,9],[31,9,32,9],[40,9,42,9],[45,9,47,9],[67,4,67,5],[67,6,67,7]]}
[]
["Last Update: 26 May 2022"]
["Time settings",null,null,"Fee settings"]
[]
["Months/year",12,null,"Recovery of fixed costs",{"$nulls":5},{"v":1,"d":"100%"}]
["Average working days/month",22,null,"Management fee",{"$nulls":5},{"v":0.05,"d":"5%"}]
["Average working hours/day",8,null,"Green fee",{"$nulls":5},{"v":0,"d":"0%"}]
[]
["Participating organization",null,null,"(Agency 1)","(Agency 2)","(Agency 3)","(Agency 5)","(Agency 5)","(Agency 6)","Average to recover"]
[]
["A) Fixed costs to be recovered by trip duration (USD/H)*"]
[]
["A1. Vehicle rent or depreciation"]
["Category 1 vehicles (average annual cost): Light vehicles",null,null,{"v":4860,"d":"4,860.00"},{"v":5100,"d":"5,100.00"},{"v":4600,"d":"4,600.00"},{"$nulls":3},{"$f":" SUMPRODUCT(D14:H14, D15:H15) / SUM(D15:H15) / (B5 * B6 * B7) * J5","v":{"v":2.3141835016835017,"d":"2.31"}}]
["Category 1 vehicles (number of vehicles)",null,null,19,16,10]
[]
["Category 2 vehicles (average annual cost): Placeholder"]
["Category 2 vehicles (number of vehicles)",null,null,41]
[]
["Category 3 vehicles (average annual cost): Placeholder"]
["Category 3 vehicles (number of vehicles)"]
[]
["A2. Insurance"]
["Annual insurance cost per vehicle",{"$nulls":8},{"$f":" SUMPRODUCT(D24:H24, D25:H25) / SUM(D25:H25) / (B5 * B6 * B7) * J5","v":0}]
["Number of light vehicles",null,null,50,30,35]
[]
["A3. Tracking and e-booking"]
["Annual tracking and e-booking cost per vehicle",{"$nulls":8},{"$f":" SUMPRODUCT(D28:H28, D29:H29) / SUM(D29:H29) / (B5 * B6 * B7) * J5","v":0}]
["Number of light vehicles",null,null,50,30,35]
[]
["A4. Driver"]
["Average annual cost drivers",null,null,{"v":11880,"d":"11,880.00"},{"v":14400,"d":"14,400.00"},{"$nulls":4},{"$f":" SUMPRODUCT(D32:H32, D33:H33) / SUM(D33:H33) / (B5 * B6 * B7) * J5","v":{"v":3.74769656019656,"d":"3.75"}}]
["Number of drivers",null,null,19,25,30]
[]
["Total"]
["Total fixed costs (USD/H)",{"$nulls":8},{"$f":" J14 + J24 + J28 + J32","v":{"v":6.061880061880062,"d":"6.06"}}]
[]
["B) Variable costs to be recovered by trip mileage (USD/Km)*"]
[]
["B1. Maintenance and repair"]
["Average annual maintenance and repair cost per km",{"$nulls":8},{"$f":" SUMPRODUCT(D41:H41, D42:H42, D43:H43) / SUMPRODUCT(D42:H42, D43:H43)","v":0}]
["Average annual mileage per vehicle",null,null,{"v":15000,"d":"15,000.00"},{"v":10000,"d":"10,000.00"},{"v":14000,"d":"14,000.00"}]
["Number of vehicles",null,null,19,16,10]
[]
["B2. Fuel"]
["Average annual fuel cost per km",null,null,{"v":0.8,"d":"0.80"},null,0.17,{"$nulls":3},{"$f":" SUMPRODUCT(D46:H46, D47:H47, D48:H48) / SUMPRODUCT(D47:H47, D48:H48)","v":{"v":0.2925824175824176,"d":"0.29"}}]
["Average annual mileage per vehicle",null,null,{"v":6000,"d":"6,000.00"},{"v":10000,"d":"10,000.00"},{"v":9000,"d":"9,000.00"}]
["Number of vehicles",null,null,19,16,10]
[]
["Total"]
["Total variable costs (USD/KM)",{"$nulls":8},{"$f":" J41 + J46","v":{"v":0.2925824175824176,"d":"0.29"}}]
[]
["C) Fees to be recovered"]
[]
["C1. Management fee"]
["Management fee on fixed costs (USD/H)",{"$nulls":8},{"$f":" J36 * J6","v":{"v":0.30309400309400314,"d":"0.30"}}]
["Management fee on variable costs (USD/Km)",{"$nulls":8},{"$f":" J51 * J6","v":{"v":0.014629120879120881,"d":"0.01"}}]
[]
["C2. Green fee"]
["Green fee on fixed costs (USD/H)",{"$nulls":8},{"$f":" J36 * J7","v":0}]
["Green fee on variable costs (USD/Km)",{"$nulls":8},{"$f":" J57 * J7","v":0}]
[]
["C3. Tehnology supplier fee"]
["Transactional fixed fee per trip"]
["*all numbers reflect year end values as of 2019"]
[]
["E) Price examples","Duration (h)",null,"Mileage (km)","Fixed costs","Variable costs","Mgmt fee","Green fee","Technology supplier fee","Total price"]
["Payment recipient",{"$nulls":3},"Vehicle owning organization",null,"Service Support Coordinator",null,"Technology Supplier"]
["Example 1: Short trip (30 min, 6Km)",{"v":1,"d":"1.00"},null,{"v":66,"d":"66.00"},{"$f":" $J$36 * B69","v":{"v":6.061880061880062,"d":"6.06"}},{"$f":" $J$51 * D69","v":{"v":19.310439560439562,"d":"19.31"}},{"$f":" $J$56 * B69 + $J$57 * D69","v":{"v":1.2686159811159814,"d":"1.27"}},{"$f":" $J$60 * B69 + $J$61 * D69","v":0},{"$f":"J64","v":0},{"$f":"SUM(E69:I69)","v":{"v":26.640935603435604,"d":"26.64"}}]
["Example 2: Long trip (5h 20min, 159Km)",{"v":5.3,"d":"5.30"},null,{"v":200,"d":"200.00"},{"$f":" $J$36 * B70","v":{"v":32.12796432796433,"d":"32.13"}},{"$f":" $J$51 * D70","v":{"v":58.51648351648352,"d":"58.52"}},{"$f":" $J$56 * B70 + $J$57 * D70","v":{"v":4.532222392222392,"d":"4.53"}},{"$f":" $J$60 * B70 + $J$61 * D70","v":0},{"$f":"J64","v":0},{"$f":"SUM(E70:I70)","v":{"v":95.17667023667025,"d":"95.18"}}]
[]
["F) Ride-sharing"]
["Trips which are shared between Participating Organizations shall be priced based on the methodology in this annex. The invoice amount shall then be divided by the number"]
["of Participating Organizations which share the trip"]