{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Pricing Schedule Year1-5"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Pricing Schedule Year1-5","index":0,"n_rows":93,"n_cols":9,"rows_kept":93}
[null,null,"    Autopax Cash Handling Tender Pricing Schedule",{"$nulls":5},"Annexure B"]
[]
[{"$nulls":3},"Year1",null,"Year1","Year1","Year1","Year1"]
[null,"No. Sites/Avg. Monthly Cash Volumes","Cost Category","Unit Cost per month (VAT inclusive)",null,"Deposit & Risk Fee (VAT inclusive)","Device Cost per month (VAT inclusive)","CIT Cost per month (VAT Inclusive)","TOTAL Annual Cost (VAT inclusive)"]
[]
[null,23,"Devices with Note capacity of 3000",{"$nulls":3},{"$f":"(B6*D6)","v":0},null,{"$f":"G6*12","v":0}]
[]
[null,9,"CIT 3 x weekly",{"$nulls":4},{"$f":"(B8*D8)","v":0},{"$f":"H8*12","v":0}]
[null,5,"CIT 5 x weekly",{"$nulls":4},{"$f":"(B9*D9)","v":0},{"$f":"H9*12","v":0}]
[null,9,"CIT 6 x weekly",{"$nulls":4},{"$f":"(B10*D10)","v":0},0]
[]
[null,{"v":12000000,"d":"R12,000,000.00"},"Cash Deposit Fee per R100 (VAT incl.)",null,null,{"$f":"(B12*D12)/100","v":0},null,null,{"$f":"F12*12","v":0}]
[]
[null,{"$f":"+B12","v":{"v":12000000,"d":"R12,000,000.00"}},"Insurance/Risk Cover Fee per R100 (VAT Incl.)",null,null,{"$f":"(B14*D14)/100","v":0},null,null,{"$f":"F14*12","v":0}]
[]
[null,null,"TOTAL Annual Cost Year 1 (VAT inclusive)",{"$nulls":5},{"$f":"SUM(I6:I15)","v":0}]
[]
[{"$nulls":3},"Year2",null,"Year2","Year2","Year2","Year2"]
[null,"No. Sites/Avg. Monthly Cash Volumes","Cost Category","Unit Cost per month (VAT inclusive)",null,"Deposit & Risk Fee (VAT inclusive)","Device Cost per month (VAT inclusive)","CIT Cost per month (VAT Inclusive)","TOTAL Annual Cost (VAT inclusive)"]
[]
[null,23,"Devices with Note capacity of 3000",{"$nulls":3},{"$f":"(B21*D21)","v":0},null,{"$f":"G21*12","v":0}]
[]
[null,9,"CIT 3 x weekly",{"$nulls":4},{"$f":"(B23*D23)","v":0},{"$f":"H23*12","v":0}]
[null,5,"CIT 5 x weekly",{"$nulls":4},{"$f":"(B24*D24)","v":0},{"$f":"H24*12","v":0}]
[null,9,"CIT 6 x weekly",{"$nulls":4},{"$f":"(B25*D25)","v":0},0]
[]
[null,{"v":12500000,"d":"R12,500,000.00"},"Cash Deposit Fee per R100 (VAT incl.)",null,null,{"$f":"(B27*D27)/100","v":0},null,null,{"$f":"F27*12","v":0}]
[]
[null,{"$f":"+B27","v":{"v":12500000,"d":"R12,500,000.00"}},"Insurance/Risk Cover Fee per R100 (VAT Incl.)",null,null,{"$f":"(B29*D29)/100","v":0},null,null,{"$f":"F29*12","v":0}]
[]
[null,null,"TOTAL Annual Cost Year 2 (VAT inclusive)",{"$nulls":5},{"$f":"SUM(I21:I30)","v":0}]
[]
[{"$nulls":3},"Year3",null,"Year3","Year3","Year3","Year3"]
[null,"No. Sites/Avg. Monthly Cash Volumes","Cost Category","Unit Cost per month (VAT inclusive)",null,"Deposit & Risk Fee (VAT inclusive)","Device Cost per month (VAT inclusive)","CIT Cost per month (VAT Inclusive)","TOTAL Annual Cost (VAT inclusive)"]
[]
[null,23,"Devices with Note capacity of 3000",{"$nulls":3},{"$f":"(B36*D36)","v":0},null,{"$f":"G36*12","v":0}]
[]
[null,9,"CIT 3 x weekly",{"$nulls":4},{"$f":"(B38*D38)","v":0},{"$f":"H38*12","v":0}]
[null,5,"CIT 5 x weekly",{"$nulls":4},{"$f":"(B39*D39)","v":0},{"$f":"H39*12","v":0}]
[null,9,"CIT 6 x weekly",{"$nulls":4},{"$f":"(B40*D40)","v":0},0]
[]
[null,{"v":13250000,"d":"R13,250,000.00"},"Cash Deposit Fee per R100 (VAT incl.)",null,null,{"$f":"(B42*D42)/100","v":0},null,null,{"$f":"F42*12","v":0}]
[]
[null,{"$f":"+B42","v":{"v":13250000,"d":"R13,250,000.00"}},"Insurance/Risk Cover Fee per R100 (VAT Incl.)",null,null,{"$f":"(B44*D44)/100","v":0},null,null,{"$f":"F44*12","v":0}]
[]
[null,null,"TOTAL Annual Cost Year 3 (VAT inclusive)",{"$nulls":5},{"$f":"SUM(I36:I45)","v":0}]
[]
[{"$nulls":3},"Year4",null,"Year4","Year4","Year4","Year4"]
[null,"No. Sites/Avg. Monthly Cash Volumes","Cost Category","Unit Cost per month (VAT inclusive)",null,"Deposit & Risk Fee (VAT inclusive)","Device Cost per month (VAT inclusive)","CIT Cost per month (VAT Inclusive)","TOTAL Annual Cost (VAT inclusive)"]
[]
[null,23,"Devices with Note capacity of 3000",{"$nulls":3},{"$f":"(B51*D51)","v":0},null,{"$f":"G51*12","v":0}]
[]
[null,9,"CIT 3 x weekly",{"$nulls":4},{"$f":"(B53*D53)","v":0},{"$f":"H53*12","v":0}]
[null,5,"CIT 5 x weekly",{"$nulls":4},{"$f":"(B54*D54)","v":0},{"$f":"H54*12","v":0}]
[null,9,"CIT 6 x weekly",{"$nulls":4},{"$f":"(B55*D55)","v":0},0]
[]
[null,{"v":14000000,"d":"R14,000,000.00"},"Cash Deposit Fee per R100 (VAT incl.)",null,null,{"$f":"(B57*D57)/100","v":0},null,null,{"$f":"F57*12","v":0}]
[]
[null,{"$f":"+B57","v":{"v":14000000,"d":"R14,000,000.00"}},"Insurance/Risk Cover Fee per R100 (VAT Incl.)",null,null,{"$f":"(B59*D59)/100","v":0},null,null,{"$f":"F59*12","v":0}]
[]
[null,null,"TOTAL Annual Cost Year 4 (VAT inclusive)",{"$nulls":5},{"$f":"SUM(I51:I60)","v":0}]
[]
[{"$nulls":3},"Year5",null,"Year5","Year5","Year5","Year5"]
[null,"No. Sites/Avg. Monthly Cash Volumes","Cost Category","Unit Cost per month (VAT inclusive)",null,"Deposit & Risk Fee (VAT inclusive)","Device Cost per month (VAT inclusive)","CIT Cost per month (VAT Inclusive)","TOTAL Annual Cost (VAT inclusive)"]
[]
[null,23,"Devices with Note capacity of 3000",{"$nulls":3},{"$f":"(B66*D66)","v":0},null,{"$f":"G66*12","v":0}]
[]
[null,9,"CIT 3 x weekly",{"$nulls":4},{"$f":"(B68*D68)","v":0},{"$f":"H68*12","v":0}]
[null,5,"CIT 5 x weekly",{"$nulls":4},{"$f":"(B69*D69)","v":0},{"$f":"H69*12","v":0}]
[null,9,"CIT 6 x weekly",{"$nulls":4},{"$f":"(B70*D70)","v":0},0]
[]
[null,{"v":15000000,"d":"R15,000,000.00"},"Cash Deposit Fee per R100 (VAT incl.)",null,null,{"$f":"(B72*D72)/100","v":0},null,null,{"$f":"F72*12","v":0}]
[]
[null,{"v":15000000,"d":"R15,000,000.00"},"Insurance/Risk Cover Fee per R100 (VAT Incl.)",null,null,{"$f":"(B74*D74)/100","v":0},null,null,{"$f":"F74*12","v":0}]
[]
[null,null,"TOTAL Annual Cost Year 5 (VAT inclusive)",{"$nulls":5},{"$f":"SUM(I66:I75)","v":0}]
[]
[{"$nulls":3},"Total Tender Cost Calculation Summary",{"$nulls":4},"TOTAL Cost (VAT inclusive)"]
[]
[null,null,"Once Off Delivery & Installation Costs per Device",null,null,23," x Devices",null,{"$f":"D80*F80","v":0}]
[null,null,"(if applicable)"]
[]
[null,null,"Once Off Cost of Plinths if not included",null,null,23," x Devices",null,{"$f":"D83*F83","v":0}]
[null,null,"(if applicable)"]
[]
[null,null,"TOTAL Annual Cost Year 1",{"$nulls":5},{"$f":"+I16","v":0}]
[null,null,"TOTAL Annual Cost Year 2",{"$nulls":5},{"$f":"+I31","v":0}]
[null,null,"TOTAL Annual Cost Year 3",{"$nulls":5},{"$f":"+I46","v":0}]
[null,null,"TOTAL Annual Cost Year 4",{"$nulls":5},{"$f":"+I61","v":0}]
[null,null,"TOTAL Annual Cost Year 5",{"$nulls":5},{"$f":"+I76","v":0}]
[]
[null,null,"TOTAL Cost Year1 - Year5 (VAT inclusive)",{"$nulls":5},{"$f":"SUM(I80:I90)","v":0}]
[null,null,"     (Note: Bidders to complete only yellow highlighted values in Column D - Spreadsheet will update total costs automatically)"]