{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["BUDGET 2023-24","BUDGET 2023-24 6MONTHS"],"read":"whole","date_system":"1900"}

{"sheet":"BUDGET 2023-24","index":0,"n_rows":18,"n_cols":7,"rows_kept":18,"merged":[[1,0,1,6],[3,0,4,6],[17,5,19,6]]}
[]
["DCOG CWP Tender T01/2021 Annexure C - Bid Costing Sheet"]
[]
["Bidder to complete yellow cells only using MS Excel or similar software.  Any other change to the spread sheet will invalidate the bid"]
[]
[]
["Provisional Budget Per Province / year","Target Participants","A: Participant wages (Excl. COID / UIF)","B: Goods / Services / Equipment","TOTAL","IA % Project Management fee","Bidder Quoted PM Fee (Incl. 15% VAT)"]
["Eastern Cape",{"v":47000,"d":"47,000"},{"v":591155025,"d":"591,155,025"},{"v":72231000,"d":"72,231,000"},{"$f":"C8+D8","v":{"v":663386025,"d":"663,386,025"}},{"v":0.05,"d":"5.0%"},{"$f":"ROUND(E8*F8,0)","v":{"v":33169301,"d":"33,169,301"}}]
["Free State",{"v":24800,"d":"24,800"},{"v":311103288,"d":"311,103,288"},{"v":38008500,"d":"38,008,500"},{"$f":"C9+D9","v":{"v":349111788,"d":"349,111,788"}},{"v":0,"d":"0.0%"},{"$f":"ROUND(E9*F9,0)","v":0}]
["Gauteng",{"v":22600,"d":"22,600"},{"v":287723738,"d":"287,723,738"},{"v":35158500,"d":"35,158,500"},{"v":322882238,"d":"322,882,238"},{"v":0,"d":"0.0%"},0]
["KwaZulu-Natal",{"v":45000,"d":"45,000"},{"v":601972025,"d":"601,972,025"},{"v":73527000,"d":"73,527,000"},{"v":675499025,"d":"675,499,025"},{"v":0,"d":"0.0%"},0]
["Limpopo",{"v":29000,"d":"29,000"},{"v":379024563,"d":"379,024,563"},{"v":46309500,"d":"46,309,500"},{"v":425334063,"d":"425,334,063"},{"v":0,"d":"0.0%"},0]
["Mpumalanga",{"v":26900,"d":"26,900"},{"v":349869375,"d":"349,869,375"},{"v":42753000,"d":"42,753,000"},{"v":392622375,"d":"392,622,375"},{"v":0,"d":"0.0%"},0]
["North West ",{"v":21200,"d":"21,200"},{"v":273947913,"d":"273,947,913"},{"v":33463500,"d":"33,463,500"},{"v":307411413,"d":"307,411,413"},{"v":0,"d":"0.0%"},0]
["Northern Cape",{"v":21000,"d":"21,000"},{"v":239876938,"d":"239,876,938"},{"v":29278500,"d":"29,278,500"},{"v":269155438,"d":"269,155,438"},{"v":0,"d":"0.0%"},0]
["Western Cape",{"v":17500,"d":"17,500"},{"v":204642450,"d":"204,642,450"},{"v":24966000,"d":"24,966,000"},{"v":229608450,"d":"229,608,450"},{"v":0,"d":"0.0%"},0]
["TOTAL",{"$f":"SUM(B8:B16)","v":{"v":255000,"d":"255,000"}},{"$f":"SUM(C8:C16)","v":{"v":3239315315,"d":"3,239,315,315"}},{"$f":"SUM(D8:D16)","v":{"v":395695500,"d":"395,695,500"}},{"$f":"SUM(E8:E16)","v":{"v":3635010815,"d":"3,635,010,815"}},null,{"$f":"SUM(G8:G16)","v":{"v":33169301,"d":"33,169,301"}}]
[{"$nulls":5},"Supplier bid amount for 12 months (SBD 3.3 / PPPFA Price) per province"]

{"sheet":"BUDGET 2023-24 6MONTHS","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"merged":[[1,0,1,6],[3,0,4,6],[17,5,19,6]]}
[]
["DCOG CWP Tender T23/2023 Annexure C - Bid Costing Sheet"]
[]
["Bidder to complete yellow cells only using MS Excel or similar software.  Any other change to the spread sheet will invalidate the bid"]
[]
[]
["Provisional Budget Per Province / year","Target Participants","A: Participant wages (Excl. COID / UIF)","B: Goods / Services / Equipment","TOTAL","IA % Project Management fee","Bidder Quoted PM Fee (Incl. 15% VAT)"]
["Eastern Cape",{"v":47000,"d":"47,000"},{"$f":"591155025/2","v":{"v":295577512.5,"d":"295,577,513"}},{"$f":"72231000/2","v":{"v":36115500,"d":"36,115,500"}},{"$f":"C8+D8","v":{"v":331693012.5,"d":"331,693,013"}},{"v":0,"d":"0.0%"},{"$f":"ROUND(E8*F8,0)","v":0}]
["Free State",{"v":24800,"d":"24,800"},{"$f":"311103288/2","v":{"v":155551644,"d":"155,551,644"}},{"$f":"38008500/2","v":{"v":19004250,"d":"19,004,250"}},{"$f":"C9+D9","v":{"v":174555894,"d":"174,555,894"}},{"v":0,"d":"0.0%"},{"$f":"ROUND(E9*F9,0)","v":0}]
["Gauteng",{"v":22600,"d":"22,600"},{"$f":"287723738/2","v":{"v":143861869,"d":"143,861,869"}},{"$f":"35158500/2","v":{"v":17579250,"d":"17,579,250"}},{"v":161441119,"d":"161,441,119"},{"v":0,"d":"0.0%"},0]
["KwaZulu-Natal",{"v":45000,"d":"45,000"},{"$f":"601972025/2","v":{"v":300986012.5,"d":"300,986,013"}},{"$f":"73527000/2","v":{"v":36763500,"d":"36,763,500"}},{"v":337749512.5,"d":"337,749,513"},{"v":0,"d":"0.0%"},0]
["Limpopo",{"v":29000,"d":"29,000"},{"$f":"379024563/2","v":{"v":189512281.5,"d":"189,512,282"}},{"$f":"46309500/2","v":{"v":23154750,"d":"23,154,750"}},{"v":212667031.5,"d":"212,667,032"},{"v":0,"d":"0.0%"},0]
["Mpumalanga",{"v":26900,"d":"26,900"},{"$f":"349869375/2","v":{"v":174934687.5,"d":"174,934,688"}},{"$f":"42753000/2","v":{"v":21376500,"d":"21,376,500"}},{"v":196311187.5,"d":"196,311,188"},{"v":0,"d":"0.0%"},0]
["North West ",{"v":21200,"d":"21,200"},{"$f":"273947913/2","v":{"v":136973956.5,"d":"136,973,957"}},{"$f":"33463500/2","v":{"v":16731750,"d":"16,731,750"}},{"v":153705706.5,"d":"153,705,707"},{"v":0,"d":"0.0%"},0]
["Northern Cape",{"v":21000,"d":"21,000"},{"$f":"239876938/2","v":{"v":119938469,"d":"119,938,469"}},{"$f":"29278500/2","v":{"v":14639250,"d":"14,639,250"}},{"v":134577719,"d":"134,577,719"},{"v":0,"d":"0.0%"},0]
["Western Cape",{"v":17500,"d":"17,500"},{"$f":"204642450/2","v":{"v":102321225,"d":"102,321,225"}},{"$f":"24966000/2","v":{"v":12483000,"d":"12,483,000"}},{"v":114804225,"d":"114,804,225"},{"v":0,"d":"0.0%"},0]
["TOTAL",{"$f":"SUM(B8:B16)","v":{"v":255000,"d":"255,000"}},{"$f":"SUM(C8:C16)","v":{"v":1619657657.5,"d":"1,619,657,658"}},{"$f":"SUM(D8:D16)","v":{"v":197847750,"d":"197,847,750"}},{"$f":"SUM(E8:E16)","v":{"v":1817505407.5,"d":"1,817,505,408"}},null,{"$f":"SUM(G8:G16)","v":0}]
[{"$nulls":5},"Supplier bid amount for 06 months (SBD 3.3 / PPPFA Price) per province"]