{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["ANNEXURE B - CAPRICORN"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"ANNEXURE B - CAPRICORN","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[6,0,8,8],[9,0,10,0],[9,1,9,6],[9,7,9,8],[15,0,15,7],[16,0,16,7],[17,0,17,7],[18,0,18,7],[20,0,20,8],[21,0,21,4],[21,5,21,8],[24,0,24,1],[24,4,24,7],[28,0,28,1],[28,4,28,7]]}
[]
[]
[]
[]
[]
[]
["ANNEXURE B: PRICING SCHEDULE FOR CAPRICORN DISTRICT"]
[]
[]
[null,"Monthly Cost per Guard (please capture monthly rates only)",{"$nulls":5},"Cost per Year (please note that calculations will be performed automatically)"]
[null,"Salary per Guard","Overheads per Guard","Profit per Guard","Total Cost per Guard","Number of Guards","Total Cost for Guards","Total Cost per Guard","Total Cost for Guards"]
["Armed Guards (Day Shift)",{"$nulls":3},{"$f":"B12+C12+D12","v":{"v":0,"d":"R0.00"}},12,{"$f":"E12*F12","v":{"v":0,"d":"R0.00"}},{"$f":"E12*12","v":{"v":0,"d":"R0.00"}},{"$f":"G12*12","v":{"v":0,"d":"R0.00"}}]
["Unarmed Guards (Day Shift)",{"$nulls":3},{"$f":"B13+C13+D13","v":{"v":0,"d":"R0.00"}},20,{"$f":"E13*F13","v":{"v":0,"d":"R0.00"}},{"$f":"E13*12","v":{"v":0,"d":"R0.00"}},{"$f":"G13*12","v":{"v":0,"d":"R0.00"}}]
["Armed Guards (Night Shift)",{"$nulls":3},{"$f":"B14+C14+D14","v":{"v":0,"d":"R0.00"}},10,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Unarmed Guards (Night Shift)",{"$nulls":3},{"$f":"B15+C15+D15","v":{"v":0,"d":"R0.00"}},13,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Total Cost per Month (excl vat)",{"$nulls":7},{"$f":"SUM(G12:G15)","v":{"v":0,"d":"R0.00"}}]
["VAT",{"$nulls":7},{"$f":"I16*0.15","v":{"v":0,"d":"R0.00"}}]
["Total Cost per Month (incl vat)",{"$nulls":7},{"$f":"SUM(I16:I17)","v":{"v":0,"d":"R0.00"}}]
["Total Bidding Price for Year 1 (incl vat)",{"$nulls":7},{"$f":"I18*12","v":{"v":0,"d":"R0.00"}}]
[]
["NB:  The automatic calculations are as follows:"]
["1. Total Cost per Guard per Month = Salary per Guard + Overhead per Guard + Profit per Guard\n2. Total Cost of Guards per Month = Total Cost per Guard per Month × Number of Guards\n \n\n",{"$nulls":4},"3. Total Cost per Guard per Year = Total Cost per Guard per Month × 12 Months \n4. Total Cost of Guards per Year =  Total Cost per Guard per Year × Number of Guards"]
[]
[]
["Signature",{"$nulls":3},"Date"]
[]
[]
[]
["Name of Bidder",{"$nulls":3},"Position"]