{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Pricing with Roadside Ass","Price Schedule","Maintenance","Chevrolet"],"not_rendered":{"images":1,"external_links":2,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Pricing with Roadside Ass","index":0,"n_rows":35,"n_cols":19,"rows_kept":35,"hidden":true,"merged":[[12,3,12,8],[12,12,12,17]],"flags":["formulas_cached_only"]}
[]
["Fixed Costs Given for 17000 vehicles",null,null,17000]
[null,null,"Per Vehicle","Over 48 Months"]
[{"$nulls":3},0]
["F&R Costs/Fleetmax",null,{"v":35,"d":"35.00"},{"v":28560000,"d":"28,560,000.00"}]
["Card Fee",null,{"v":62,"d":"62.00"}]
["Viamax Fleet",null,{"v":17.5,"d":"17.50"},{"v":14280000,"d":"14,280,000.00"}]
["Subtotal",null,{"v":114.5,"d":"114.50"},{"v":42840000,"d":"42,840,000.00"}]
["Inflation Adjustment @5% pa Compounded Annually",null,{"v":1.1576,"d":"1.16"}]
["Total",null,{"v":132.5452,"d":"132.55"},{"v":108156883.19999999,"d":"108,156,883.20"}]
["Kgwerano Margin"]
["Total Price",null,{"v":132.5452,"d":"132.55"},{"v":108156883.19999999,"d":"108,156,883.20"}]
[{"$nulls":3},"Normal Pricing",{"$nulls":8},"70/30 Profit Share"]
[]
["LDV's",null,"Pricing with Service Plan",{"$nulls":3},"Pricing with no Service Plan",{"$nulls":4},"Pricing with Service Plan",{"$nulls":3},"Pricing with no Service Plan"]
["Estimated CPK",null,"48 Months - 160 000km","42 Months - 160 000km","36 Months - 160 000km","32 Months - 160 000km","48 Months - 160 000km","42 Months - 160 000km","36 Months - 160 000km","32 Months - 160 000km",null,"48 Months - 160 000km","42 Months - 160 000km","36 Months - 160 000km","32 Months - 160 000km","48 Months - 160 000km","42 Months - 160 000km","36 Months - 160 000km","32 Months - 160 000km"]
["< 1250 cc",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["1251-1550 cc",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["1551-1750 cc",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["1751-1950 cc",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["1951-2150 cc",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2151-2500 cc",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2501-3500 cc",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Above 3500 cc",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["LDV - 4X4",null,"Pricing with Service Plan",{"$nulls":3},"Pricing with no Service Plan",{"$nulls":4},"Pricing with Service Plan",{"$nulls":3},"Pricing with no Service Plan"]
["Estimated CPK",null,"48 Months - 160 000km","42 Months - 160 000km","36 Months - 160 000km","32 Months - 160 000km","48 Months - 160 000km","42 Months - 160 000km","36 Months - 160 000km","32 Months - 160 000km",null,"48 Months - 160 000km","42 Months - 160 000km","36 Months - 160 000km","32 Months - 160 000km","48 Months - 160 000km","42 Months - 160 000km","36 Months - 160 000km","32 Months - 160 000km"]
["< 1250 cc"]
["1251-1550 cc"]
["1551-1750 cc"]
["1751-1950 cc"]
["1951-2150 cc",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2151-2500 cc",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2501-3500 cc",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Above 3500 cc",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Price Schedule","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"merged":[[2,0,3,3],[6,1,6,2]],"flags":["formulas_cached_only"]}
["Annexure B: Pricing Schedule - Provision of Short Term Vehicle Rentals, Chauffeur Drive, and Bus Services for Official Funerals and State Events"]
[]
["Note: \n* All prices must include VAT and a price must be provided for the full period of the contract.\n* The Annexure B: Pricing Schedule must be submitted in a separate envelope / memory stick than the tehcnical response."]
[]
[]
[]
["Bidder Name"]
[]
[]
["Item Number","Item Description","Total Estimated Amount for events over the contract period","% Administration fee","TOTAL INTEREST PAYABLE"]
[null,"The percentage administration fee to be charged by the Contractor shall be calculated on the total amounts charged by its suppliers for services rendered in terms of this contract.",{"v":100000000,"d":"R 100,000,000.00"},null,{"v":0,"d":"R0.00"}]

{"sheet":"Maintenance","index":2,"n_rows":22,"n_cols":13,"rows_kept":22,"hidden":true,"flags":["formulas_cached_only"]}
[null,"MAINTENANCE / SERVICE PLANS EXCLUDED"]
[null,"Category B",null,"Pricing with Service Plan",{"$nulls":3},"Pricing with no Service Plan"]
[null,"Estimated CPK","Maintenance CPK","48 Months - 160 000km","42 Months - 160 000km","36 Months - 160 000km","32 Months - 160 000km","48 Months - 160 000km","42 Months - 160 000km","36 Months - 160 000km","32 Months - 160 000km"]
[1,"< 1250 cc",0.065,{"v":216.66666666666666,"d":"216.67"},{"v":247.61904761904762,"d":"247.62"},{"v":288.8888888888889,"d":"288.89"},{"v":325,"d":"325.00"},331.25,{"v":378.57142857142856,"d":"378.57"},{"v":441.6666666666667,"d":"441.67"},{"v":496.875,"d":"496.88"},null,0.02]
[2,"1251-1550 cc",{"v":0.07436000000000001,"d":"0.074"},{"v":247.8666666666667,"d":"247.87"},{"v":283.27619047619055,"d":"283.28"},{"v":330.48888888888894,"d":"330.49"},{"v":371.80000000000007,"d":"371.80"},{"v":362.45000000000005,"d":"362.45"},{"v":414.2285714285715,"d":"414.23"},{"v":483.2666666666667,"d":"483.27"},{"v":543.6750000000001,"d":"543.68"},null,0.02]
[3,"1551-1750 cc",{"v":0.08866,"d":"0.089"},{"v":295.53333333333336,"d":"295.53"},{"v":337.752380952381,"d":"337.75"},{"v":394.0444444444445,"d":"394.04"},{"v":443.3,"d":"443.30"},{"v":410.1166666666667,"d":"410.12"},{"v":468.70476190476194,"d":"468.70"},{"v":546.8222222222223,"d":"546.82"},{"v":615.175,"d":"615.18"},null,0.02]
[4,"1751-1950 cc",{"v":0.09815,"d":"0.098"},{"v":327.1666666666667,"d":"327.17"},{"v":373.9047619047619,"d":"373.90"},{"v":436.22222222222223,"d":"436.22"},490.75,{"v":462.58333333333337,"d":"462.58"},{"v":528.6666666666667,"d":"528.67"},{"v":616.7777777777778,"d":"616.78"},{"v":693.875,"d":"693.88"},null,0.02]
[5,"1951-2150 cc",{"v":0.14339,"d":"0.143"},{"v":477.96666666666664,"d":"477.97"},{"v":546.247619047619,"d":"546.25"},{"v":637.2888888888888,"d":"637.29"},{"v":716.9499999999999,"d":"716.95"},{"v":613.3833333333333,"d":"613.38"},{"v":701.0095238095237,"d":"701.01"},{"v":817.8444444444443,"d":"817.84"},{"v":920.0749999999999,"d":"920.08"},null,0.035]
[6,"2151-2500 cc",0.156,{"v":520,"d":"520.00"},{"v":594.2857142857143,"d":"594.29"},{"v":693.3333333333334,"d":"693.33"},{"v":780,"d":"780.00"},676.25,{"v":772.8571428571429,"d":"772.86"},{"v":901.6666666666667,"d":"901.67"},{"v":1014.375,"d":"1014.38"},null,0.035]
[7,"2501-3500 cc",0.156,{"v":520,"d":"520.00"},{"v":594.2857142857143,"d":"594.29"},{"v":693.3333333333334,"d":"693.33"},{"v":780,"d":"780.00"},{"v":697.0833333333334,"d":"697.08"},{"v":796.6666666666667,"d":"796.67"},{"v":929.4444444444445,"d":"929.44"},{"v":1045.625,"d":"1045.63"},null,0.035]
[8,"Above 3500 cc",0.156,{"v":520,"d":"520.00"},{"v":594.2857142857143,"d":"594.29"},{"v":693.3333333333334,"d":"693.33"},{"v":780,"d":"780.00"},{"v":697.0833333333334,"d":"697.08"},{"v":796.6666666666667,"d":"796.67"},{"v":929.4444444444445,"d":"929.44"},{"v":1045.625,"d":"1045.63"},null,0.035]
[]
[null,"Category C",null,"Pricing with Service Plan",{"$nulls":3},"Pricing with no Service Plan"]
[null,"Estimated CPK",null,"48 Months - 160 000km","42 Months - 160 000km","36 Months - 160 000km","32 Months - 160 000km","48 Months - 160 000km","42 Months - 160 000km","36 Months - 160 000km","32 Months - 160 000km"]
[1,"< 1250 cc",{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[2,"1251-1550 cc",{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[3,"1551-1750 cc",{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[4,"1751-1950 cc",{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[5,"1951-2150 cc",{"v":0.13739700000000002,"d":"0.137"},{"v":457.99000000000007,"d":"457.99"},{"v":523.417142857143,"d":"523.42"},{"v":610.6533333333334,"d":"610.65"},{"v":686.9850000000001,"d":"686.99"},{"v":593.4066666666668,"d":"593.41"},{"v":678.1790476190477,"d":"678.18"},{"v":791.208888888889,"d":"791.21"},{"v":890.1100000000001,"d":"890.11"},null,0.035]
[6,"2151-2500 cc",{"v":0.169169,"d":"0.169"},{"v":563.8966666666666,"d":"563.90"},{"v":644.4533333333334,"d":"644.45"},{"v":751.8622222222223,"d":"751.86"},{"v":845.845,"d":"845.85"},{"v":720.1466666666666,"d":"720.15"},{"v":823.0247619047619,"d":"823.02"},{"v":960.1955555555556,"d":"960.20"},1080.22]
[7,"2501-3500 cc",{"v":0.18159,"d":"0.182"},{"v":605.3000000000001,"d":"605.30"},{"v":691.7714285714286,"d":"691.77"},{"v":807.0666666666667,"d":"807.07"},907.95,{"v":782.3833333333334,"d":"782.38"},{"v":894.152380952381,"d":"894.15"},{"v":1043.177777777778,"d":"1043.18"},{"v":1173.575,"d":"1173.58"}]
[8,"Above 3500 cc",{"v":0.18159,"d":"0.182"},{"v":605.3000000000001,"d":"605.30"},{"v":691.7714285714286,"d":"691.77"},{"v":807.0666666666667,"d":"807.07"},907.95,{"v":782.3833333333334,"d":"782.38"},{"v":894.152380952381,"d":"894.15"},{"v":1043.177777777778,"d":"1043.18"},{"v":1173.575,"d":"1173.58"}]

{"sheet":"Chevrolet","index":3,"n_rows":18,"n_cols":7,"rows_kept":18,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"Service","Service costs","Allowance","Category"]
["Model","Engine","Price ®","intervals","Total","per service"]
[]
["Spark",796,{"v":64700,"d":"64,700"}]
["Spark LS AC",796,{"v":78800,"d":"78,800"}]
["Aveo 5 dr PS",{"v":1498,"d":"1,498"},{"v":94875,"d":"94,875"}]
["Aveo LS 5 dr AC PS",{"v":1498,"d":"1,498"},{"v":110240,"d":"110,240"}]
["Aveo LT 5 dr AC PS",{"v":1498,"d":"1,498"},{"v":125000,"d":"125,000"}]
["Aveo LS 4 dr AC PS",{"v":1498,"d":"1,498"},{"v":110240,"d":"110,240"}]
["Aveo LT 4 dr AC PS",{"v":1498,"d":"1,498"},{"v":125000,"d":"125,000"}]
["Optra 1.6 AC PS",{"v":1598,"d":"1,598"},{"v":141700,"d":"141,700"}]
["Optra 1.6 LS AC PS",{"v":1598,"d":"1,598"},{"v":156700,"d":"156,700"}]