{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["HowTo","Example","Summary","OR Tambo","Bram Fischer","George","References","Documentation"],"not_rendered":{"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"HowTo","index":0,"n_rows":68,"n_cols":2,"rows_kept":68,"merged":[[0,0,0,8],[1,0,2,8],[3,0,3,8],[4,0,4,8],[5,1,5,8],[6,1,6,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[10,1,10,8],[11,1,11,8],[12,0,12,8],[13,1,13,8],[14,1,14,8],[15,0,15,8],[16,0,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,0,20,8],[21,0,21,8],[22,1,22,8],[23,1,23,8],[24,1,24,8],[25,1,25,8],[26,0,26,8],[27,0,27,8],[28,1,28,8],[29,1,29,8],[30,1,30,8],[31,1,31,8],[32,0,32,8],[33,0,33,8],[34,1,34,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,0,38,8],[39,0,39,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[43,1,43,8],[44,1,44,8],[45,1,45,8],[46,1,46,8],[47,1,47,8],[48,1,48,8],[49,1,49,8],[50,1,50,8],[51,1,51,8],[52,1,52,8],[53,0,53,8],[54,0,54,8],[55,0,55,8],[56,1,56,8],[57,1,57,8],[58,1,58,8],[59,1,59,8],[60,1,60,8],[61,1,61,8],[62,1,62,8],[63,1,63,8],[64,0,64,8],[65,0,65,8],[66,0,66,8],[67,1,67,8]]}
[]
["The Example page is a consolidated example to assist. \nThe information is for representative purposes only."]
[]
[]
["Instructions on how to complete the Summary page."]
["Step 1","Type your company name in Name of Bidder,  contact information in the space provided."]
["Step 2","No action is required for the responses to each bid; when you complete the separate bid submissions the information is brought forward."]
[]
["Instructions on how to complete the various portions of pages \nOR Tambo, Bram Fischer and George."]
["Key Financial Information and Indicators"]
["Step 1","Select Y is the Bidder's proposal includes this site. Otherwise ensure N is set."]
["Step 2","Complete the financial information and indicators."]
["Estimate Time Line for the FIPDM Project Stages"]
["Step 1","Type the start and end date for each stage. Do this for each stage."]
["Step 2","The number of working days is calculated for each pair of start and end dates that you typed. No further action is required for this section of the document."]
[]
["Land Lease Projection"]
["Step 1","Type the monthly land lease amount that you expect to pay for Year 1 in cell G24."]
["Step 2","The annual escalation percentage that ACSA applies is set in column E. If you want to change the percentages, type the percentage applicable to the year or years you want to change."]
["Step 3","No action is required for the responses to each bid; when you complete the separate bid submissions the information is brought forward."]
[]
["Projected Fuel Sales"]
["Step 1","Change the percentage of profit due to ACSA if different from the minimum percentage."]
["Step 2","Type the total projected monthly fuel sales for each year in column titled Monthly Sales."]
["Step 3","The annual fuel sales based on the monthly amount you typed in is calculated. No further action is required in this column."]
["Step 4","The annual profit is calculated based on the annual profit calculated in the previous column. No further action is required in this column."]
[]
["Projected Convenience Store Sales"]
["Step 1","Change the percentage of profit due to ACSA if different from the minimum percentage."]
["Step 2","Type the total projected monthly convenience store sales for each year in column titled Monthly Sales."]
["Step 3","The annual convenience store sales based on the monthly amount you typed in is calculated. No further action is required in this column."]
["Step 4","The annual profit is calculated based on the annual profit calculated in the previous column. No further action is required in this column."]
[]
["Projected Sales of Other Activities"]
["Step 1","Change the percentage of profit due to ACSA if different from the minimum percentage."]
["Step 2","Type the total projected monthly sales from any other activities for each year in column titled Monthly Sales."]
["Step 3","The annual sales from any other activities based on the monthly amount you typed in is calculated. No further action is required in this column."]
["Step 4","The annual profit is calculated based on the annual profit calculated in the previous column. No further action is required in this column."]
[]
["Projected Profit and Loss Statement for three years"]
["Step 1","Update the description from Product / Service 1 to a summarised description of the main product or service included in the Profit and Loss Statements of the company. Repeat this for the remaining descriptions to a maximum of six (6) line items."]
["Step 2","Type the projected annual total for the sales category described. Do this for each of the categories you specified."]
["Step 3","Repeat steps 1 and 2 for the next 2 years of data."]
["Step 4","The subtotal of the sales is calculated automatically. No action is required for the aggregation."]
["Step 5","The cost of sales Product / Service details will change to the categories you specified in step 1 above. No further action is required for the Cost of Sales descriptions."]
["Step 6","Type the projected annual total for the sales category described. Do this for each of the categories you specified."]
["Step 7","The gross profit for each year will be calculated : Sales less Cost of Sales. No further action is required to calculate the Gross Profit."]
["Step 8","Replace \"Summary Expense\" with the expenses applicable to your company. Summarise as required. Use a line for kind of expense. The expenses will be aggregated for each year automatically."]
["Step 9","Income for Operations is calculated. No further action is required."]
["Step 10","Type in the estimated income tax for each year."]
["Step 11","Net profit is calculated. No further action is required."]
["Step 12","Type the percentage of the net profit for Airports Company for each year."]
["Step 13","The Estimated Rand Value is calculated. No further action is required."]
[]
["Instruction on completing the References"]
[]
["Step 1","Select from the drop down list the nature of the Bidders responsibilities."]
["Step 2","Type the Client and or Company Name."]
["Step 3","Describe the services and or responsibilities the Bidder had for this reference site."]
["Step 4","The date of practical completion. If the date is in the future, specify it as \"eta 2024/06/12\" for the 12th of June 2024. Otherwise type the date in the format YYYY/MM/DD and the spreadsheet will update the format to be like 12-Jun-2024."]
["Step 5","The date the team started on site with site establishment or similar."]
["Step 6","The date the team departed from site and the facilities were ready to be operated."]
["Step 7","The details of the person ACSA can reach out to as a reference for the work performed. Ideally we require the Title, Name or Initials, Surname, Telephone or Cellphone number, Email address."]
["Step 8","Please use this column to add any information that will be of value to the bid evaluation team."]
[]
["The Documentation Sheet"]
[]
[null,"This sheet provides the list of documentation that may be applicable to this project for each stage of the engagement. Not all the items may apply for example Solar data. Some additional document requirements may be added once agreed between the parties concerned."]

{"sheet":"Example","index":1,"n_rows":172,"n_cols":10,"rows_kept":172,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,7],[3,0,3,1],[3,2,3,8],[4,0,4,8],[5,0,5,6],[5,7,5,8],[5,9,13,9],[6,0,6,6],[6,7,6,8],[7,0,7,6],[7,7,7,8],[8,0,8,6],[8,7,8,8],[9,0,9,6],[9,7,9,8],[10,0,10,6],[10,7,10,8],[11,0,11,6],[11,7,11,8],[12,0,12,6],[12,7,12,8],[13,0,13,6],[13,7,13,8],[14,0,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,5],[18,0,18,5],[18,9,24,9],[19,0,19,5],[20,0,20,5],[21,0,21,5],[22,0,22,5],[23,0,23,5],[24,0,24,5],[25,0,25,8],[26,0,26,5],[26,9,27,9],[27,0,27,8],[28,0,28,8],[29,0,29,8],[30,0,30,3],[30,5,30,6],[30,7,30,8],[31,0,31,3],[31,5,31,6],[31,7,31,8],[31,9,50,9],[32,0,32,3],[32,5,32,6],[32,7,32,8],[33,0,33,3],[33,5,33,6],[33,7,33,8],[34,0,34,3],[34,5,34,6],[34,7,34,8],[35,0,35,3],[35,5,35,6],[35,7,35,8],[36,0,36,3],[36,5,36,6],[36,7,36,8],[37,0,37,3],[37,5,37,6],[37,7,37,8],[38,0,38,3],[38,5,38,6],[38,7,38,8],[39,0,39,3],[39,5,39,6],[39,7,39,8],[40,0,40,3],[40,5,40,6],[40,7,40,8],[41,0,41,3],[41,5,41,6],[41,7,41,8],[42,0,42,3],[42,5,42,6],[42,7,42,8],[43,0,43,3],[43,5,43,6],[43,7,43,8],[44,0,44,3],[44,5,44,6],[44,7,44,8],[45,0,45,3],[45,5,45,6],[45,7,45,8],[46,0,46,3],[46,5,46,6],[46,7,46,8],[47,0,47,3],[47,5,47,6],[47,7,47,8],[48,0,48,3],[48,5,48,6],[48,7,48,8],[49,0,49,3],[49,5,49,6],[49,7,49,8],[50,0,50,3],[50,5,50,6],[50,7,50,8],[51,0,51,6],[51,7,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,8],[55,0,55,1],[55,3,55,4],[55,5,55,6],[55,7,55,8],[56,0,56,1],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,75,9],[57,0,57,1],[57,3,57,4],[57,5,57,6],[57,7,57,8],[58,0,58,1],[58,3,58,4],[58,5,58,6],[58,7,58,8],[59,0,59,1],[59,3,59,4],[59,5,59,6],[59,7,59,8],[60,0,60,1],[60,3,60,4],[60,5,60,6],[60,7,60,8],[61,0,61,1],[61,3,61,4],[61,5,61,6],[61,7,61,8],[62,0,62,1],[62,3,62,4],[62,5,62,6],[62,7,62,8],[63,0,63,1],[63,3,63,4],[63,5,63,6],[63,7,63,8],[64,0,64,1],[64,3,64,4],[64,5,64,6],[64,7,64,8],[65,0,65,1],[65,3,65,4],[65,5,65,6],[65,7,65,8],[66,0,66,1],[66,3,66,4],[66,5,66,6],[66,7,66,8],[67,0,67,1],[67,3,67,4],[67,5,67,6],[67,7,67,8],[68,0,68,1],[68,3,68,4],[68,5,68,6],[68,7,68,8],[69,0,69,1],[69,3,69,4],[69,5,69,6],[69,7,69,8],[70,0,70,1],[70,3,70,4],[70,5,70,6],[70,7,70,8],[71,0,71,1],[71,3,71,4],[71,5,71,6],[71,7,71,8],[72,0,72,1],[72,3,72,4],[72,5,72,6],[72,7,72,8],[73,0,73,1],[73,3,73,4],[73,5,73,6],[73,7,73,8],[74,0,74,1],[74,3,74,4],[74,5,74,6],[74,7,74,8],[75,0,75,1],[75,3,75,4],[75,5,75,6],[75,7,75,8],[76,0,76,4],[76,5,76,6],[76,7,76,8],[77,0,77,8],[78,0,78,8],[79,0,79,8],[80,0,80,1],[80,3,80,4],[80,5,80,6],[80,7,80,8],[81,0,81,1],[81,3,81,4],[81,5,81,6],[81,7,81,8],[81,9,100,9],[82,0,82,1],[82,3,82,4],[82,5,82,6],[82,7,82,8],[83,0,83,1],[83,3,83,4],[83,5,83,6],[83,7,83,8],[84,0,84,1],[84,3,84,4],[84,5,84,6],[84,7,84,8],[85,0,85,1],[85,3,85,4],[85,5,85,6],[85,7,85,8],[86,0,86,1],[86,3,86,4],[86,5,86,6],[86,7,86,8],[87,0,87,1],[87,3,87,4],[87,5,87,6],[87,7,87,8],[88,0,88,1],[88,3,88,4],[88,5,88,6],[88,7,88,8],[89,0,89,1],[89,3,89,4],[89,5,89,6],[89,7,89,8],[90,0,90,1],[90,3,90,4],[90,5,90,6],[90,7,90,8],[91,0,91,1],[91,3,91,4],[91,5,91,6],[91,7,91,8],[92,0,92,1],[92,3,92,4],[92,5,92,6],[92,7,92,8],[93,0,93,1],[93,3,93,4],[93,5,93,6],[93,7,93,8],[94,0,94,1],[94,3,94,4],[94,5,94,6],[94,7,94,8],[95,0,95,1],[95,3,95,4],[95,5,95,6],[95,7,95,8],[96,0,96,1],[96,3,96,4],[96,5,96,6],[96,7,96,8],[97,0,97,1],[97,3,97,4],[97,5,97,6],[97,7,97,8],[98,0,98,1],[98,3,98,4],[98,5,98,6],[98,7,98,8],[99,0,99,1],[99,3,99,4],[99,5,99,6],[99,7,99,8],[100,0,100,1],[100,3,100,4],[100,5,100,6],[100,7,100,8],[101,0,101,4],[101,5,101,6],[101,7,101,8],[102,0,102,8],[103,0,103,8],[104,0,104,8],[105,0,105,1],[105,3,105,4],[105,5,105,6],[106,0,106,1],[106,3,106,4],[106,5,106,6],[106,7,106,8],[106,9,125,9],[107,0,107,1],[107,3,107,4],[107,5,107,6],[107,7,107,8],[108,0,108,1],[108,3,108,4],[108,5,108,6],[108,7,108,8],[109,0,109,1],[109,3,109,4],[109,5,109,6],[109,7,109,8],[110,0,110,1],[110,3,110,4],[110,5,110,6],[110,7,110,8],[111,0,111,1],[111,3,111,4],[111,5,111,6],[111,7,111,8],[112,0,112,1],[112,3,112,4],[112,5,112,6],[112,7,112,8],[113,0,113,1],[113,3,113,4],[113,5,113,6],[113,7,113,8],[114,0,114,1],[114,3,114,4],[114,5,114,6],[114,7,114,8],[115,0,115,1],[115,3,115,4],[115,5,115,6],[115,7,115,8],[116,0,116,1],[116,3,116,4],[116,5,116,6],[116,7,116,8],[117,0,117,1],[117,3,117,4],[117,5,117,6],[117,7,117,8],[118,0,118,1],[118,3,118,4],[118,5,118,6],[118,7,118,8],[119,0,119,1],[119,3,119,4],[119,5,119,6],[119,7,119,8],[120,0,120,1],[120,3,120,4],[120,5,120,6],[120,7,120,8],[121,0,121,1],[121,3,121,4],[121,5,121,6],[121,7,121,8],[122,0,122,1],[122,3,122,4],[122,5,122,6],[122,7,122,8],[123,0,123,1],[123,3,123,4],[123,5,123,6],[123,7,123,8],[124,0,124,1],[124,3,124,4],[124,5,124,6],[124,7,124,8],[125,0,125,1],[125,3,125,4],[125,5,125,6],[125,7,125,8],[126,0,126,4],[126,5,126,6],[126,7,126,8],[127,0,127,8],[128,0,128,8],[129,0,129,8],[130,0,130,2],[130,3,130,4],[130,5,130,6],[130,7,130,8],[131,0,131,2],[131,3,131,4],[131,5,131,6],[131,7,131,8],[131,9,136,9],[132,0,132,2],[132,3,132,4],[132,5,132,6],[132,7,132,8],[133,0,133,2],[133,3,133,4],[133,5,133,6],[133,7,133,8],[134,0,134,2],[134,3,134,4],[134,5,134,6],[134,7,134,8],[135,0,135,2],[135,3,135,4],[135,5,135,6],[135,7,135,8],[136,0,136,2],[136,3,136,4],[136,5,136,6],[136,7,136,8],[137,0,137,2],[137,3,137,4],[137,5,137,6],[137,7,137,8],[138,0,138,8],[139,0,139,2],[139,3,139,4],[139,5,139,6],[139,7,139,8],[140,0,140,2],[140,3,140,4],[140,5,140,6],[140,7,140,8],[140,9,145,9],[141,0,141,2],[141,3,141,4],[141,5,141,6],[141,7,141,8],[142,0,142,2],[142,3,142,4],[142,5,142,6],[142,7,142,8],[143,0,143,2],[143,3,143,4],[143,5,143,6],[143,7,143,8],[144,0,144,2],[144,3,144,4],[144,5,144,6],[144,7,144,8],[145,0,145,2],[145,3,145,4],[145,5,145,6],[145,7,145,8],[146,0,146,2],[146,3,146,4],[146,5,146,6],[146,7,146,8],[147,0,147,8],[148,0,148,2],[148,3,148,4],[148,5,148,6],[148,7,148,8],[149,0,149,8],[150,0,150,2],[150,3,150,4],[150,5,150,6],[150,7,150,8],[151,0,151,2],[151,3,151,4],[151,5,151,6],[151,7,151,8],[151,9,162,9],[152,0,152,2],[152,3,152,4],[152,5,152,6],[152,7,152,8],[153,0,153,2],[153,3,153,4],[153,5,153,6],[153,7,153,8],[154,0,154,2],[154,3,154,4],[154,5,154,6],[154,7,154,8],[155,0,155,2],[155,3,155,4],[155,5,155,6],[155,7,155,8],[156,0,156,2],[156,3,156,4],[156,5,156,6],[156,7,156,8],[157,0,157,2],[157,3,157,4],[157,5,157,6],[157,7,157,8],[158,0,158,2],[158,3,158,4],[158,5,158,6],[158,7,158,8],[159,0,159,2],[159,3,159,4],[159,5,159,6],[159,7,159,8],[160,0,160,2],[160,3,160,4],[160,5,160,6],[160,7,160,8],[161,0,161,2],[161,3,161,4],[161,5,161,6],[161,7,161,8],[162,0,162,2],[162,3,162,4],[162,5,162,6],[162,7,162,8],[163,0,163,2],[163,3,163,4],[163,5,163,6],[163,7,163,8],[164,0,164,8],[165,0,165,2],[165,3,165,4],[165,5,165,6],[165,7,165,8],[166,0,166,8],[167,0,167,2],[167,3,167,4],[167,5,167,6],[167,7,167,8],[168,0,168,8],[169,0,169,2],[169,3,169,4],[169,5,169,6],[169,7,169,8],[170,0,170,2],[170,3,170,4],[170,5,170,6],[170,7,170,8],[171,0,171,2],[171,3,171,4],[171,5,171,6],[171,7,171,8]]}
[{"$nulls":9},"The information you need to type onto this document."]
[{"$f":"\"The information for submitting a bid for \nSome Airport Service Station with Convenient Store Operations for \nExample Bidder \"&CHAR(10)","v":"The information for submitting a bid for \nSome Airport Service Station with Convenient Store Operations for \nExample Bidder \n"},{"$nulls":8},"The heading includes the company name you typed on the summary page. No action is required from the Bidder."]
["Proposal for Some Airport (Y/N)",{"$nulls":7},"Y","Select or type Y if you are submitting a proposal for this site."]
["Name of Bidder",null,{"$f":"Summary!E2","v":0},{"$nulls":6},"No action required from the Bidder."]
[]
["Estimate of Capital Investment",{"$nulls":6},{"v":20000000,"d":"R20,000,000.00"},null,"Type the information applicable for this site."]
["The expected business growth over the duration of the concession (%)",{"$nulls":6},{"v":0.03,"d":"3.0%"}]
["Working capital required to start the business (year 1)",{"$nulls":6},{"v":1500000,"d":"R1,500,000.00"}]
["Total square meters of the Development",{"$nulls":6},{"v":4000,"d":"4,000.00"}]
["Hurdle Rate",{"$nulls":6},{"v":0.12,"d":"12.0%"}]
["Net Present Value (NPV) using 20 year period DCF",{"$nulls":6},{"v":10,"d":"10.00"}]
["Return on Investment (ROI) year 1",{"$nulls":6},"1.65%"]
["Average year-on-year over the 20-year lease duration",{"$nulls":6},{"v":0,"d":"0.00"}]
["Internal Rate of Return (IRR)",{"$nulls":6},{"v":0.16,"d":"16.0%"}]
[]
[]
["Estimate Time Line for the Framework for Infrastructure Delivery and Procurement Management (FIPDM) Project Stages"]
["Stage",{"$nulls":5},"Start","End","Working Days"]
["1. Initiation",{"$nulls":5},"2023-07-01","2023-08-01",{"$f":"NETWORKDAYS(G19,H19)","v":22},"Type in the estimated start and end dates using the format yyyy/mm/dd e.g. 2023/09/01\n\nThe working days will be calculated for you.\nFormula: Networkdays(Start Date, End Date)."]
["2. Concept",{"$nulls":5},"2023-08-01","2023-08-31",{"$f":"NETWORKDAYS(G20,H20)","v":23}]
["3. Design Development",{"$nulls":5},"2023-08-31","2023-09-30",22]
["4. Design Documentation",{"$nulls":5},"2023-09-30","2023-12-01",45]
["5. Works",{"$nulls":5},"2023-12-01","2024-12-01",261]
["6. Handover",{"$nulls":5},"2024-12-01","2025-01-15",33]
["7. Close out",{"$nulls":5},"2025-01-15","2025-01-18",3]
[]
["Construction estimated from start and end ",{"$nulls":5},{"$f":"MIN(G19:G25)","v":"2023-07-01"},{"$f":"MAX(H19:H25)","v":"2025-01-18"},405,"The earliest start date, latest end date and working days are calcuated. Holidays are no applicable for this exercise. \nNo action is required from the Bidder."]
[]
[]
["Land Lease Projection"]
["Year",{"$nulls":3},"Escalation %","Monthly Land Lease",null,"Annual Land Lease"]
["Year 1 ",{"$nulls":3},"-",{"v":150000,"d":"R150,000.00"},null,{"$f":"F32*12","v":{"v":1800000,"d":"R1,800,000.00"}},null,"Type in the monthly lease you propose for the first year.\n\nNo other months are required because the percentage escalation is applied.\n\nThe ACSA minimum percentage increase is 8%. \nYou can change the percentage if required. The percentage will be revisited at the mid point of the contract i.e. year 10.\nThe percentage escalation applies from the second year onwards.\n\nFormulae: \nMonthly Land Lease = Monthly Land Lease from previous year + Escalation percentage of Monthly Land Lease from previous year\nAnnual Land Lease = Monthly Land Lease X 12"]
["Year 2",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"$f":"(F32*(1+E33))","v":{"v":162000,"d":"R162,000.00"}},null,{"v":1944000,"d":"R1,944,000.00"}]
["Year 3",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":174960,"d":"R174,960.00"},null,{"v":2099520,"d":"R2,099,520.00"}]
["Year 4",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":188956.80000000002,"d":"R188,956.80"},null,{"v":2267481.6,"d":"R2,267,481.60"}]
["Year 5",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":204073.34400000004,"d":"R204,073.34"},null,{"v":2448880.1280000005,"d":"R2,448,880.13"}]
["Year 6",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":220399.21152000007,"d":"R220,399.21"},null,{"v":2644790.5382400006,"d":"R2,644,790.54"}]
["Year 7",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":238031.1484416001,"d":"R238,031.15"},null,{"v":2856373.781299201,"d":"R2,856,373.78"}]
["Year 8",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":257073.64031692813,"d":"R257,073.64"},null,{"v":3084883.6838031374,"d":"R3,084,883.68"}]
["Year 9",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":277639.5315422824,"d":"R277,639.53"},null,{"v":3331674.3785073888,"d":"R3,331,674.38"}]
["Year 10",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":299850.694065665,"d":"R299,850.69"},null,{"v":3598208.32878798,"d":"R3,598,208.33"}]
["Year 11",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":323838.74959091825,"d":"R323,838.75"},null,{"v":3886064.995091019,"d":"R3,886,065.00"}]
["Year 12",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":349745.8495581917,"d":"R349,745.85"},null,{"v":4196950.1946983,"d":"R4,196,950.19"}]
["Year 13",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":377725.5175228471,"d":"R377,725.52"},null,{"v":4532706.2102741655,"d":"R4,532,706.21"}]
["Year 14",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":407943.55892467493,"d":"R407,943.56"},null,{"$f":"F45*12","v":{"v":4895322.707096099,"d":"R4,895,322.71"}}]
["Year 15",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":440579.04363864893,"d":"R440,579.04"},null,{"$f":"F46*12","v":{"v":5286948.523663787,"d":"R5,286,948.52"}}]
["Year 16",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":475825.3671297409,"d":"R475,825.37"},null,{"$f":"F47*12","v":{"v":5709904.405556891,"d":"R5,709,904.41"}}]
["Year 17",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":513891.3965001202,"d":"R513,891.40"},null,{"$f":"F48*12","v":{"v":6166696.758001442,"d":"R6,166,696.76"}}]
["Year 18",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":555002.7082201298,"d":"R555,002.71"},null,{"$f":"F49*12","v":{"v":6660032.498641558,"d":"R6,660,032.50"}}]
["Year 19",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":599402.9248777402,"d":"R599,402.92"},null,{"v":7192835.0985328825,"d":"R7,192,835.10"}]
["Year 20",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":647355.1588679595,"d":"R647,355.16"},null,{"v":7768261.906415515,"d":"R7,768,261.91"}]
["Total",{"$nulls":6},{"$f":"SUM(H32:I51)","v":{"v":82371535.73660937,"d":"R82,371,535.74"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Fuel Sales"]
["Year",null,"Profit %","Monthly Sales",null,"Annual Sales",null,"Annual Profit"]
["Year 1",null,{"v":0.02,"d":"2%"},{"v":200000,"d":"R200,000.00"},null,{"$f":"D57*12","v":{"v":2400000,"d":"R2,400,000.00"}},null,{"$f":"(D57*C57)*12","v":{"v":48000,"d":"R48,000.00"}},null,"Type in the estimated monthly sales for each year. Suggest average is used.\n\nThe proposed ACSA profit percentage is 10%. \nYou can change the percentage if required. \n\nFormulae: \nAnnual Sales = Monthly Sales X 12\nAnnual Profit = Profit percentage of Annual Sales"]
["Year 2",null,{"v":0.02,"d":"2%"},{"v":220000,"d":"R220,000.00"},null,{"$f":"D58*12","v":{"v":2640000,"d":"R2,640,000.00"}},null,{"v":52800,"d":"R52,800.00"}]
["Year 3",null,{"v":0.02,"d":"2%"},{"v":240000,"d":"R240,000.00"},null,{"v":2880000,"d":"R2,880,000.00"},null,{"v":57600,"d":"R57,600.00"}]
["Year 4",null,{"v":0.02,"d":"2%"},{"v":260000,"d":"R260,000.00"},null,{"v":3120000,"d":"R3,120,000.00"},null,{"v":62400,"d":"R62,400.00"}]
["Year 5",null,{"v":0.02,"d":"2%"},{"v":280000,"d":"R280,000.00"},null,{"v":3360000,"d":"R3,360,000.00"},null,{"v":67200,"d":"R67,200.00"}]
["Year 6",null,{"v":0.02,"d":"2%"},{"v":300000,"d":"R300,000.00"},null,{"v":3600000,"d":"R3,600,000.00"},null,{"v":72000,"d":"R72,000.00"}]
["Year 7",null,{"v":0.02,"d":"2%"},{"v":320000,"d":"R320,000.00"},null,{"v":3840000,"d":"R3,840,000.00"},null,{"v":76800,"d":"R76,800.00"}]
["Year 8",null,{"v":0.02,"d":"2%"},{"v":340000,"d":"R340,000.00"},null,{"v":4080000,"d":"R4,080,000.00"},null,{"v":81600,"d":"R81,600.00"}]
["Year 9",null,{"v":0.02,"d":"2%"},{"v":360000,"d":"R360,000.00"},null,{"v":4320000,"d":"R4,320,000.00"},null,{"v":86400,"d":"R86,400.00"}]
["Year 10",null,{"v":0.02,"d":"2%"},{"v":380000,"d":"R380,000.00"},null,{"v":4560000,"d":"R4,560,000.00"},null,{"v":91200,"d":"R91,200.00"}]
["Year 11",null,{"v":0.02,"d":"2%"},{"v":400000,"d":"R400,000.00"},null,{"v":4800000,"d":"R4,800,000.00"},null,{"v":96000,"d":"R96,000.00"}]
["Year 12",null,{"v":0.02,"d":"2%"},{"v":420000,"d":"R420,000.00"},null,{"v":5040000,"d":"R5,040,000.00"},null,{"v":100800,"d":"R100,800.00"}]
["Year 13",null,{"v":0.02,"d":"2%"},{"v":440000,"d":"R440,000.00"},null,{"v":5280000,"d":"R5,280,000.00"},null,{"v":105600,"d":"R105,600.00"}]
["Year 14",null,{"v":0.02,"d":"2%"},{"v":460000,"d":"R460,000.00"},null,{"v":5520000,"d":"R5,520,000.00"},null,{"v":110400,"d":"R110,400.00"}]
["Year 15",null,{"v":0.02,"d":"2%"},{"v":480000,"d":"R480,000.00"},null,{"v":5760000,"d":"R5,760,000.00"},null,{"v":115200,"d":"R115,200.00"}]
["Year 16",null,{"v":0.02,"d":"2%"},{"v":500000,"d":"R500,000.00"},null,{"v":6000000,"d":"R6,000,000.00"},null,{"v":120000,"d":"R120,000.00"}]
["Year 17",null,{"v":0.02,"d":"2%"},{"v":520000,"d":"R520,000.00"},null,{"v":6240000,"d":"R6,240,000.00"},null,{"v":124800,"d":"R124,800.00"}]
["Year 18",null,{"v":0.02,"d":"2%"},{"v":540000,"d":"R540,000.00"},null,{"v":6480000,"d":"R6,480,000.00"},null,{"v":129600,"d":"R129,600.00"}]
["Year 19",null,{"v":0.02,"d":"2%"},{"v":560000,"d":"R560,000.00"},null,{"v":6720000,"d":"R6,720,000.00"},null,{"v":134400,"d":"R134,400.00"}]
["Year 20",null,{"v":0.02,"d":"2%"},{"v":580000,"d":"R580,000.00"},null,{"v":6960000,"d":"R6,960,000.00"},null,{"v":139200,"d":"R139,200.00"}]
["Total",{"$nulls":4},{"$f":"SUM(F57:G76)","v":{"v":93600000,"d":"R93,600,000.00"}},null,{"$f":"SUM(H57:I76)","v":{"v":1872000,"d":"R1,872,000.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Convenience Store Sales"]
["Year",null,"Profit %","Monthly Sales",null,"Annual Sales",null,"Annual Profit"]
["Year 1",null,{"v":0.01,"d":"1%"},{"v":100000,"d":"R100,000.00"},null,{"$f":"D82*12","v":{"v":1200000,"d":"R1,200,000.00"}},null,{"$f":"(D82*C82)*12","v":{"v":12000,"d":"R12,000.00"}},null,"Type in the estimated monthly sales for each year. Suggest average is used.\n\nThe proposed ACSA profit percentage is 1%. \nYou can change the percentage if required. \n\nFormulae: \nAnnual Sales = Monthly Sales X 12\nAnnual Profit = Profit percentage of Annual Sales"]
["Year 2",null,{"v":0.01,"d":"1%"},{"v":120000,"d":"R120,000.00"},null,{"$f":"D83*12","v":{"v":1440000,"d":"R1,440,000.00"}},null,{"v":14400,"d":"R14,400.00"}]
["Year 3",null,{"v":0.01,"d":"1%"},{"v":140000,"d":"R140,000.00"},null,{"v":1680000,"d":"R1,680,000.00"},null,{"v":16800,"d":"R16,800.00"}]
["Year 4",null,{"v":0.01,"d":"1%"},{"v":160000,"d":"R160,000.00"},null,{"v":1920000,"d":"R1,920,000.00"},null,{"v":19200,"d":"R19,200.00"}]
["Year 5",null,{"v":0.01,"d":"1%"},{"v":180000,"d":"R180,000.00"},null,{"v":2160000,"d":"R2,160,000.00"},null,{"v":21600,"d":"R21,600.00"}]
["Year 6",null,{"v":0.01,"d":"1%"},{"v":200000,"d":"R200,000.00"},null,{"v":2400000,"d":"R2,400,000.00"},null,{"v":24000,"d":"R24,000.00"}]
["Year 7",null,{"v":0.01,"d":"1%"},{"v":220000,"d":"R220,000.00"},null,{"v":2640000,"d":"R2,640,000.00"},null,{"v":26400,"d":"R26,400.00"}]
["Year 8",null,{"v":0.01,"d":"1%"},{"v":240000,"d":"R240,000.00"},null,{"v":2880000,"d":"R2,880,000.00"},null,{"v":28800,"d":"R28,800.00"}]
["Year 9",null,{"v":0.01,"d":"1%"},{"v":260000,"d":"R260,000.00"},null,{"v":3120000,"d":"R3,120,000.00"},null,{"v":31200,"d":"R31,200.00"}]
["Year 10",null,{"v":0.01,"d":"1%"},{"v":280000,"d":"R280,000.00"},null,{"v":3360000,"d":"R3,360,000.00"},null,{"v":33600,"d":"R33,600.00"}]
["Year 11",null,{"v":0.01,"d":"1%"},{"v":300000,"d":"R300,000.00"},null,{"v":3600000,"d":"R3,600,000.00"},null,{"v":36000,"d":"R36,000.00"}]
["Year 12",null,{"v":0.01,"d":"1%"},{"v":320000,"d":"R320,000.00"},null,{"v":3840000,"d":"R3,840,000.00"},null,{"v":38400,"d":"R38,400.00"}]
["Year 13",null,{"v":0.01,"d":"1%"},{"v":340000,"d":"R340,000.00"},null,{"v":4080000,"d":"R4,080,000.00"},null,{"v":40800,"d":"R40,800.00"}]
["Year 14",null,{"v":0.01,"d":"1%"},{"v":360000,"d":"R360,000.00"},null,{"v":4320000,"d":"R4,320,000.00"},null,{"v":43200,"d":"R43,200.00"}]
["Year 15",null,{"v":0.01,"d":"1%"},{"v":380000,"d":"R380,000.00"},null,{"v":4560000,"d":"R4,560,000.00"},null,{"v":45600,"d":"R45,600.00"}]
["Year 16",null,{"v":0.01,"d":"1%"},{"v":400000,"d":"R400,000.00"},null,{"v":4800000,"d":"R4,800,000.00"},null,{"v":48000,"d":"R48,000.00"}]
["Year 17",null,{"v":0.01,"d":"1%"},{"v":420000,"d":"R420,000.00"},null,{"v":5040000,"d":"R5,040,000.00"},null,{"v":50400,"d":"R50,400.00"}]
["Year 18",null,{"v":0.01,"d":"1%"},{"v":440000,"d":"R440,000.00"},null,{"v":5280000,"d":"R5,280,000.00"},null,{"v":52800,"d":"R52,800.00"}]
["Year 19",null,{"v":0.01,"d":"1%"},{"v":460000,"d":"R460,000.00"},null,{"v":5520000,"d":"R5,520,000.00"},null,{"v":55200,"d":"R55,200.00"}]
["Year 20",null,{"v":0.01,"d":"1%"},{"v":480000,"d":"R480,000.00"},null,{"v":5760000,"d":"R5,760,000.00"},null,{"v":57600,"d":"R57,600.00"}]
["Total",{"$nulls":4},{"$f":"SUM(F82:G101)","v":{"v":69600000,"d":"R69,600,000.00"}},null,{"$f":"SUM(H82:I101)","v":{"v":696000,"d":"R696,000.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Sales of Other Activities"]
["Year",null,"Profit %","Monthly Sales",null,"Annual Sales",null,"Annual Profit"]
["Year 1",null,{"v":0.01,"d":"1%"},{"v":20000,"d":"R20,000.00"},null,{"$f":"D107*12","v":{"v":240000,"d":"R240,000.00"}},null,{"$f":"(D107*C107)*12","v":{"v":2400,"d":"R2,400.00"}},null,"Type in the estimated monthly sales for each year. Suggest average is used.\n\nThe proposed ACSA profit percentage is 1%. \nYou can change the percentage if required. \n\nFormulae: \nAnnual Sales = Monthly Sales X 12\nAnnual Profit = Profit percentage of Annual Sales"]
["Year 2",null,{"v":0.01,"d":"1%"},{"v":25000,"d":"R25,000.00"},null,{"v":300000,"d":"R300,000.00"},null,{"v":3000,"d":"R3,000.00"}]
["Year 3",null,{"v":0.01,"d":"1%"},{"v":30000,"d":"R30,000.00"},null,{"v":360000,"d":"R360,000.00"},null,{"v":3600,"d":"R3,600.00"}]
["Year 4",null,{"v":0.01,"d":"1%"},{"v":35000,"d":"R35,000.00"},null,{"v":420000,"d":"R420,000.00"},null,{"v":4200,"d":"R4,200.00"}]
["Year 5",null,{"v":0.01,"d":"1%"},{"v":40000,"d":"R40,000.00"},null,{"v":480000,"d":"R480,000.00"},null,{"v":4800,"d":"R4,800.00"}]
["Year 6",null,{"v":0.01,"d":"1%"},{"v":45000,"d":"R45,000.00"},null,{"v":540000,"d":"R540,000.00"},null,{"v":5400,"d":"R5,400.00"}]
["Year 7",null,{"v":0.01,"d":"1%"},{"v":50000,"d":"R50,000.00"},null,{"v":600000,"d":"R600,000.00"},null,{"v":6000,"d":"R6,000.00"}]
["Year 8",null,{"v":0.01,"d":"1%"},{"v":55000,"d":"R55,000.00"},null,{"v":660000,"d":"R660,000.00"},null,{"v":6600,"d":"R6,600.00"}]
["Year 9",null,{"v":0.01,"d":"1%"},{"v":60000,"d":"R60,000.00"},null,{"v":720000,"d":"R720,000.00"},null,{"v":7200,"d":"R7,200.00"}]
["Year 10",null,{"v":0.01,"d":"1%"},{"v":65000,"d":"R65,000.00"},null,{"v":780000,"d":"R780,000.00"},null,{"v":7800,"d":"R7,800.00"}]
["Year 11",null,{"v":0.01,"d":"1%"},{"v":70000,"d":"R70,000.00"},null,{"v":840000,"d":"R840,000.00"},null,{"v":8400,"d":"R8,400.00"}]
["Year 12",null,{"v":0.01,"d":"1%"},{"v":75000,"d":"R75,000.00"},null,{"v":900000,"d":"R900,000.00"},null,{"v":9000,"d":"R9,000.00"}]
["Year 13",null,{"v":0.01,"d":"1%"},{"v":80000,"d":"R80,000.00"},null,{"v":960000,"d":"R960,000.00"},null,{"v":9600,"d":"R9,600.00"}]
["Year 14",null,{"v":0.01,"d":"1%"},{"v":85000,"d":"R85,000.00"},null,{"v":1020000,"d":"R1,020,000.00"},null,{"v":10200,"d":"R10,200.00"}]
["Year 15",null,{"v":0.01,"d":"1%"},{"v":90000,"d":"R90,000.00"},null,{"v":1080000,"d":"R1,080,000.00"},null,{"v":10800,"d":"R10,800.00"}]
["Year 16",null,{"v":0.01,"d":"1%"},{"v":95000,"d":"R95,000.00"},null,{"v":1140000,"d":"R1,140,000.00"},null,{"v":11400,"d":"R11,400.00"}]
["Year 17",null,{"v":0.01,"d":"1%"},{"v":100000,"d":"R100,000.00"},null,{"v":1200000,"d":"R1,200,000.00"},null,{"v":12000,"d":"R12,000.00"}]
["Year 18",null,{"v":0.01,"d":"1%"},{"v":105000,"d":"R105,000.00"},null,{"v":1260000,"d":"R1,260,000.00"},null,{"v":12600,"d":"R12,600.00"}]
["Year 19",null,{"v":0.01,"d":"1%"},{"v":110000,"d":"R110,000.00"},null,{"v":1320000,"d":"R1,320,000.00"},null,{"v":13200,"d":"R13,200.00"}]
["Year 20",null,{"v":0.01,"d":"1%"},{"v":115000,"d":"R115,000.00"},null,{"v":1380000,"d":"R1,380,000.00"},null,{"v":13800,"d":"R13,800.00"}]
["Total",{"$nulls":4},{"$f":"SUM(F107:G126)","v":{"v":16200000,"d":"R16,200,000.00"}},null,{"$f":"SUM(H107:I126)","v":{"v":162000,"d":"R162,000.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Profit and Loss Statement for three years"]
["Sales Revenue",null,null,"Year 1",null,"Year 2",null,"Year 3"]
["All fuel types",null,null,{"v":2500000,"d":"R2,500,000.00"},null,{"v":3000000,"d":"R3,000,000.00"},null,{"v":3500000,"d":"R3,500,000.00"},null,"Change the Product / Service description with an appropriate description of sales e.g. Unleaded Fuel. Change the descriptions for a maximum of 6 categories. Leave the description as is if you do not require it.\nType in the estimated Sales for the first three years in the respective columns."]
[]
[]
[]
[]
[]
["Sales Subtotal",null,null,{"$f":"SUM(D132:E137)","v":{"v":2500000,"d":"R2,500,000.00"}},null,{"$f":"SUM(F132:G137)","v":{"v":3000000,"d":"R3,000,000.00"}},null,{"$f":"SUM(H132:I137)","v":{"v":3500000,"d":"R3,500,000.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
["Cost of Sales",null,null,"Year 1",null,"Year 2",null,"Year 3"]
[{"$f":"A132","v":"All fuel types"},null,null,{"v":1500000,"d":"R1,500,000.00"},null,{"v":1800000,"d":"R1,800,000.00"},null,{"v":2000000,"d":"R2,000,000.00"},null,"Change the Product / Service description with an appropriate description of sales e.g. Deliveries. Change the descriptions for a maximum of 6 categories. Leave the description as is if you do not require it.\nType in the estimated Cost of Sales for the first three years in the respective columns."]
[0]
[0]
[0]
[0]
[0]
["Cost of Sales Subtotal",null,null,{"$f":"SUM(D141:E146)","v":{"v":1500000,"d":"R1,500,000.00"}},null,{"$f":"SUM(F141:G146)","v":{"v":1800000,"d":"R1,800,000.00"}},null,{"$f":"SUM(H141:I146)","v":{"v":2000000,"d":"R2,000,000.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
["Gross Profit",null,null,{"$f":"D138-D147","v":{"v":1000000,"d":"R1,000,000.00"}},null,{"$f":"F138-F147","v":{"v":1200000,"d":"R1,200,000.00"}},null,{"$f":"H138-H147","v":{"v":1500000,"d":"R1,500,000.00"}},null,"No action is required from the Bidder.\nFormula = Total Sales - Total Cost of Sales for the year "]
[]
["Operating Expenses",null,null,"Year 1",null,"Year 2",null,"Year 3"]
["Salaries and Wages",null,null,{"v":300000,"d":"R300,000.00"},null,{"v":350000,"d":"R350,000.00"},null,{"v":400000,"d":"R400,000.00"},null,"Change the Summary Expense description with an appropriate description of expenses e.g. Stationery. Change the descriptions for a maximum of 12 categories. Leave the description as is if you do not require it.\nType in the estimated Expense for the first three years in the respective columns."]
["Rent and Utilities",null,null,{"v":100000,"d":"R100,000.00"},null,{"v":120000,"d":"R120,000.00"},null,{"v":140000,"d":"R140,000.00"}]
["Advertising",null,null,{"v":50000,"d":"R50,000.00"},null,{"v":60000,"d":"R60,000.00"},null,{"v":70000,"d":"R70,000.00"}]
["Maintenance and Repairs",null,null,{"v":80000,"d":"R80,000.00"},null,{"v":90000,"d":"R90,000.00"},null,{"v":100000,"d":"R100,000.00"}]
["Insurance   ",null,null,{"v":40000,"d":"R40,000.00"},null,{"v":45000,"d":"R45,000.00"},null,{"v":50000,"d":"R50,000.00"}]
["Other Expenses ",null,null,{"v":10000,"d":"R10,000.00"},null,{"v":12000,"d":"R12,000.00"},null,{"v":14000,"d":"R14,000.00"}]
["Summary Expense 7"]
["Summary Expense 8"]
["Summary Expense 9"]
["Summary Expense 10"]
["Summary Expense 11"]
["Summary Expense 12"]
["Operating Expenses Subtotal",null,null,{"$f":"SUM(D152:E163)","v":{"v":580000,"d":"R580,000.00"}},null,{"$f":"SUM(F152:G163)","v":{"v":677000,"d":"R677,000.00"}},null,{"$f":"SUM(H152:I163)","v":{"v":774000,"d":"R774,000.00"}},null,"No action is required from the Bidder. \nFormula = Sum of all expenses for the year "]
[]
["Income from Operations",null,null,{"$f":"D149-D164","v":{"v":420000,"d":"R420,000.00"}},null,{"$f":"F149-F164","v":{"v":523000,"d":"R523,000.00"}},null,{"$f":"H149-H164","v":{"v":726000,"d":"R726,000.00"}},null,"No action is required from the Bidder. \nFormula = Gross profit - Operating Expenses for the year "]
[]
["Taxes",null,null,{"v":100000,"d":"R100,000.00"},null,{"v":125000,"d":"R125,000.00"},null,{"v":170000,"d":"R170,000.00"},null,"Type is the estimated taxes payable for each year."]
[]
["Net Profit",null,null,{"$f":"D166-D168","v":{"v":320000,"d":"R320,000.00"}},null,{"$f":"F166-F168","v":{"v":398000,"d":"R398,000.00"}},null,{"$f":"H166-H168","v":{"v":556000,"d":"R556,000.00"}},null,"No action is required from the Bidder. \nFormula = Income from Operations - Taxes for the year "]
["Percent of net profit payable to ACSA",null,null,{"v":0.1,"d":"10%"},null,{"v":0.12,"d":"12%"},null,{"v":0.14,"d":"14%"},null,"Type is the estimated profit percentage payable for each year for ACSA."]
["Estimated R value",null,null,{"$f":"D170*D171","v":{"v":32000,"d":"R32,000.00"}},null,{"$f":"F170*F171","v":{"v":47760,"d":"R47,760.00"}},null,{"$f":"H170*H171","v":{"v":77840.00000000001,"d":"R77,840.00"}},null,"No action is required from the Bidder. \nFormula = Net Profit X ACSA Percentage of Net Profit for each year "]

{"sheet":"Summary","index":2,"n_rows":26,"n_cols":10,"rows_kept":26,"merged":[[0,0,0,8],[1,0,1,3],[1,4,1,8],[2,0,2,1],[2,2,2,8],[2,9,3,9],[3,0,3,1],[3,2,3,8],[4,0,4,1],[4,2,4,8],[5,0,5,4],[5,5,5,8],[6,0,6,7],[7,0,7,7],[8,0,8,7],[9,0,9,8],[9,9,25,9],[10,0,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[11,0,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[12,0,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[13,0,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[14,0,14,2],[14,3,14,4],[14,5,14,6],[14,7,14,8],[15,0,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[16,0,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[17,0,17,2],[17,3,17,4],[17,5,17,6],[17,7,17,8],[18,0,18,2],[18,3,18,4],[18,5,18,6],[18,7,18,8],[19,0,19,2],[19,3,19,4],[19,5,19,6],[19,7,19,8],[20,0,20,2],[20,3,20,4],[20,5,20,6],[20,7,20,8],[21,0,21,2],[21,3,21,4],[21,5,21,6],[21,7,21,8],[22,0,22,2],[22,3,22,4],[22,5,22,6],[22,7,22,8],[23,0,23,2],[23,3,23,4],[23,5,23,6],[23,7,23,8],[24,0,25,2]]}
["Summary Page",{"$nulls":8},"The information you need to type onto this document."]
["Name of Tenderer (Bidding Entity)",{"$nulls":8},"Type the Bidder's company name."]
["Tel Number",{"$nulls":8},"Type the Bidder's contact information."]
["Email"]
["Name of Contact",{"$nulls":8},"Type the name and surname of your tender contact person."]
["National Treasury CSD Registration Number",{"$nulls":8},"Type the Bidder's company CSD number."]
["Bid for OR Tambo Airport (Y/N)",{"$nulls":7},{"$f":"'OR Tambo'!I3","v":"Y"},"No action required from the Bidder."]
["Bid for Bram Fischer (Y/N)",{"$nulls":7},{"$f":"'Bram Fischer'!I3","v":"N"},"No action required from the Bidder."]
["Bid for George Airport (Y/N)",{"$nulls":7},{"$f":"George!I3","v":"N"},"No action required from the Bidder."]
[{"$nulls":9},"No action required from the Bidder.\n\nThe information is linked to any details you complete in the OR Tambo, Bram Fischer and George sheets.\n\nRemember to sign (initial) or stamp the bottom of the page for inclusion in your hardcopy submission AND attached this spreadsheet to your electronic submission."]
[{"$nulls":3},"OR Tambo",null,"Bram Fischer",null,"George"]
["Estimate of Capital Investment",null,null,{"$f":"'OR Tambo'!H6","v":{"v":0,"d":"R0.00"}},null,{"$f":"'Bram Fischer'!H5","v":{"v":0,"d":"R0.00"}},null,{"$f":"George!H5","v":{"v":0,"d":"R0.00"}}]
["Hurdle Rate",null,null,{"$f":"'OR Tambo'!H10","v":{"v":0,"d":"0%"}},null,{"$f":"'Bram Fischer'!H9","v":{"v":0,"d":"0%"}},null,{"$f":"George!H9","v":{"v":0,"d":"0%"}}]
["Internal Rate of Return (IRR)",null,null,{"$f":"'OR Tambo'!H14","v":{"v":0,"d":"0%"}},null,{"$f":"'Bram Fischer'!H13","v":{"v":0,"d":"0%"}},null,{"$f":"George!H13","v":{"v":0,"d":"0%"}}]
["20 Year Projected Land Lease",null,null,{"$f":"'OR Tambo'!H52","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM('Bram Fischer'!H31:I50)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(George!H31:I50)","v":{"v":0,"d":"R0.00"}}]
["20 Year Projected Fuel Sales",null,null,{"$f":"'OR Tambo'!F77","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM('Bram Fischer'!H55:I74)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(George!H55:I74)","v":{"v":0,"d":"R0.00"}}]
["20 Year Project Profit on Fuel",null,null,{"$f":"'OR Tambo'!H77","v":{"v":0,"d":"R0.00"}}]
["20 Year Projected Convenience Store Sales",null,null,{"$f":"'OR Tambo'!F102","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM('Bram Fischer'!H79:I98)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(George!H79:I98)","v":{"v":0,"d":"R0.00"}}]
["20 Year Projected Profit on Convenience Store Sales",null,null,{"$f":"'OR Tambo'!H102","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM('Bram Fischer'!H80:I99)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(George!H80:I99)","v":{"v":0,"d":"R0.00"}}]
["20 Year Projected Amenities Sales",null,null,{"$f":"'OR Tambo'!F127","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM('Bram Fischer'!H103:I122)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(George!H103:I122)","v":{"v":0,"d":"R0.00"}}]
["20 Year Projected Profit on Amenities Sales",null,null,{"$f":"'OR Tambo'!H127","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM('Bram Fischer'!H104:I123)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(George!H104:I123)","v":{"v":0,"d":"R0.00"}}]
["Gross Profit for three years",null,null,{"$f":"SUM('OR Tambo'!D149:I149)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM('Bram Fischer'!D144:I144)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(George!D144:I144)","v":{"v":0,"d":"R0.00"}}]
["Net Profit for three years",null,null,{"$f":"SUM('OR Tambo'!D170:I170)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM('Bram Fischer'!D165:I165)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(George!D165:I165)","v":{"v":0,"d":"R0.00"}}]
["ACSA Profit for three years",null,null,{"$f":"SUM('OR Tambo'!D172:I172)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM('Bram Fischer'!D167:I167)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(George!D167:I167)","v":{"v":0,"d":"R0.00"}}]
["Construction Timeline",null,null,"From","To","From","To","From","To"]
[{"$nulls":3},{"$f":"'OR Tambo'!G27","v":"00:00:00"},{"$f":"'OR Tambo'!H27","v":"00:00:00"},{"$f":"'Bram Fischer'!G26","v":"00:00:00"},{"$f":"'Bram Fischer'!H26","v":"00:00:00"},{"$f":"George!G26","v":"00:00:00"},{"$f":"George!H26","v":"00:00:00"}]

{"sheet":"OR Tambo","index":3,"n_rows":172,"n_cols":10,"rows_kept":172,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,7],[3,0,3,1],[3,2,3,8],[4,0,4,8],[5,0,5,6],[5,7,5,8],[5,9,13,9],[6,0,6,6],[6,7,6,8],[7,0,7,6],[7,7,7,8],[8,0,8,6],[8,7,8,8],[9,0,9,6],[9,7,9,8],[10,0,10,6],[10,7,10,8],[11,0,11,6],[11,7,11,8],[12,0,12,6],[12,7,12,8],[13,0,13,6],[13,7,13,8],[14,0,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,5],[18,0,18,5],[18,9,24,9],[19,0,19,5],[20,0,20,5],[21,0,21,5],[22,0,22,5],[23,0,23,5],[24,0,24,5],[25,0,25,8],[26,0,26,5],[26,9,27,9],[27,0,27,8],[28,0,28,8],[29,0,29,8],[30,0,30,3],[30,5,30,6],[30,7,30,8],[31,0,31,3],[31,5,31,6],[31,7,31,8],[31,9,50,9],[32,0,32,3],[32,5,32,6],[32,7,32,8],[33,0,33,3],[33,5,33,6],[33,7,33,8],[34,0,34,3],[34,5,34,6],[34,7,34,8],[35,0,35,3],[35,5,35,6],[35,7,35,8],[36,0,36,3],[36,5,36,6],[36,7,36,8],[37,0,37,3],[37,5,37,6],[37,7,37,8],[38,0,38,3],[38,5,38,6],[38,7,38,8],[39,0,39,3],[39,5,39,6],[39,7,39,8],[40,0,40,3],[40,5,40,6],[40,7,40,8],[41,0,41,3],[41,5,41,6],[41,7,41,8],[42,0,42,3],[42,5,42,6],[42,7,42,8],[43,0,43,3],[43,5,43,6],[43,7,43,8],[44,0,44,3],[44,5,44,6],[44,7,44,8],[45,0,45,3],[45,5,45,6],[45,7,45,8],[46,0,46,3],[46,5,46,6],[46,7,46,8],[47,0,47,3],[47,5,47,6],[47,7,47,8],[48,0,48,3],[48,5,48,6],[48,7,48,8],[49,0,49,3],[49,5,49,6],[49,7,49,8],[50,0,50,3],[50,5,50,6],[50,7,50,8],[51,0,51,6],[51,7,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,8],[55,0,55,1],[55,3,55,4],[55,5,55,6],[55,7,55,8],[56,0,56,1],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,75,9],[57,0,57,1],[57,3,57,4],[57,5,57,6],[57,7,57,8],[58,0,58,1],[58,3,58,4],[58,5,58,6],[58,7,58,8],[59,0,59,1],[59,3,59,4],[59,5,59,6],[59,7,59,8],[60,0,60,1],[60,3,60,4],[60,5,60,6],[60,7,60,8],[61,0,61,1],[61,3,61,4],[61,5,61,6],[61,7,61,8],[62,0,62,1],[62,3,62,4],[62,5,62,6],[62,7,62,8],[63,0,63,1],[63,3,63,4],[63,5,63,6],[63,7,63,8],[64,0,64,1],[64,3,64,4],[64,5,64,6],[64,7,64,8],[65,0,65,1],[65,3,65,4],[65,5,65,6],[65,7,65,8],[66,0,66,1],[66,3,66,4],[66,5,66,6],[66,7,66,8],[67,0,67,1],[67,3,67,4],[67,5,67,6],[67,7,67,8],[68,0,68,1],[68,3,68,4],[68,5,68,6],[68,7,68,8],[69,0,69,1],[69,3,69,4],[69,5,69,6],[69,7,69,8],[70,0,70,1],[70,3,70,4],[70,5,70,6],[70,7,70,8],[71,0,71,1],[71,3,71,4],[71,5,71,6],[71,7,71,8],[72,0,72,1],[72,3,72,4],[72,5,72,6],[72,7,72,8],[73,0,73,1],[73,3,73,4],[73,5,73,6],[73,7,73,8],[74,0,74,1],[74,3,74,4],[74,5,74,6],[74,7,74,8],[75,0,75,1],[75,3,75,4],[75,5,75,6],[75,7,75,8],[76,0,76,4],[76,5,76,6],[76,7,76,8],[77,0,77,8],[78,0,78,8],[79,0,79,8],[80,0,80,1],[80,3,80,4],[80,5,80,6],[80,7,80,8],[81,0,81,1],[81,3,81,4],[81,5,81,6],[81,7,81,8],[81,9,100,9],[82,0,82,1],[82,3,82,4],[82,5,82,6],[82,7,82,8],[83,0,83,1],[83,3,83,4],[83,5,83,6],[83,7,83,8],[84,0,84,1],[84,3,84,4],[84,5,84,6],[84,7,84,8],[85,0,85,1],[85,3,85,4],[85,5,85,6],[85,7,85,8],[86,0,86,1],[86,3,86,4],[86,5,86,6],[86,7,86,8],[87,0,87,1],[87,3,87,4],[87,5,87,6],[87,7,87,8],[88,0,88,1],[88,3,88,4],[88,5,88,6],[88,7,88,8],[89,0,89,1],[89,3,89,4],[89,5,89,6],[89,7,89,8],[90,0,90,1],[90,3,90,4],[90,5,90,6],[90,7,90,8],[91,0,91,1],[91,3,91,4],[91,5,91,6],[91,7,91,8],[92,0,92,1],[92,3,92,4],[92,5,92,6],[92,7,92,8],[93,0,93,1],[93,3,93,4],[93,5,93,6],[93,7,93,8],[94,0,94,1],[94,3,94,4],[94,5,94,6],[94,7,94,8],[95,0,95,1],[95,3,95,4],[95,5,95,6],[95,7,95,8],[96,0,96,1],[96,3,96,4],[96,5,96,6],[96,7,96,8],[97,0,97,1],[97,3,97,4],[97,5,97,6],[97,7,97,8],[98,0,98,1],[98,3,98,4],[98,5,98,6],[98,7,98,8],[99,0,99,1],[99,3,99,4],[99,5,99,6],[99,7,99,8],[100,0,100,1],[100,3,100,4],[100,5,100,6],[100,7,100,8],[101,0,101,4],[101,5,101,6],[101,7,101,8],[102,0,102,8],[103,0,103,8],[104,0,104,8],[105,0,105,1],[105,3,105,4],[105,5,105,6],[106,0,106,1],[106,3,106,4],[106,5,106,6],[106,7,106,8],[106,9,125,9],[107,0,107,1],[107,3,107,4],[107,5,107,6],[107,7,107,8],[108,0,108,1],[108,3,108,4],[108,5,108,6],[108,7,108,8],[109,0,109,1],[109,3,109,4],[109,5,109,6],[109,7,109,8],[110,0,110,1],[110,3,110,4],[110,5,110,6],[110,7,110,8],[111,0,111,1],[111,3,111,4],[111,5,111,6],[111,7,111,8],[112,0,112,1],[112,3,112,4],[112,5,112,6],[112,7,112,8],[113,0,113,1],[113,3,113,4],[113,5,113,6],[113,7,113,8],[114,0,114,1],[114,3,114,4],[114,5,114,6],[114,7,114,8],[115,0,115,1],[115,3,115,4],[115,5,115,6],[115,7,115,8],[116,0,116,1],[116,3,116,4],[116,5,116,6],[116,7,116,8],[117,0,117,1],[117,3,117,4],[117,5,117,6],[117,7,117,8],[118,0,118,1],[118,3,118,4],[118,5,118,6],[118,7,118,8],[119,0,119,1],[119,3,119,4],[119,5,119,6],[119,7,119,8],[120,0,120,1],[120,3,120,4],[120,5,120,6],[120,7,120,8],[121,0,121,1],[121,3,121,4],[121,5,121,6],[121,7,121,8],[122,0,122,1],[122,3,122,4],[122,5,122,6],[122,7,122,8],[123,0,123,1],[123,3,123,4],[123,5,123,6],[123,7,123,8],[124,0,124,1],[124,3,124,4],[124,5,124,6],[124,7,124,8],[125,0,125,1],[125,3,125,4],[125,5,125,6],[125,7,125,8],[126,0,126,4],[126,5,126,6],[126,7,126,8],[127,0,127,8],[128,0,128,8],[129,0,129,8],[130,0,130,2],[130,3,130,4],[130,5,130,6],[130,7,130,8],[131,0,131,2],[131,3,131,4],[131,5,131,6],[131,7,131,8],[131,9,136,9],[132,0,132,2],[132,3,132,4],[132,5,132,6],[132,7,132,8],[133,0,133,2],[133,3,133,4],[133,5,133,6],[133,7,133,8],[134,0,134,2],[134,3,134,4],[134,5,134,6],[134,7,134,8],[135,0,135,2],[135,3,135,4],[135,5,135,6],[135,7,135,8],[136,0,136,2],[136,3,136,4],[136,5,136,6],[136,7,136,8],[137,0,137,2],[137,3,137,4],[137,5,137,6],[137,7,137,8],[138,0,138,8],[139,0,139,2],[139,3,139,4],[139,5,139,6],[139,7,139,8],[140,0,140,2],[140,3,140,4],[140,5,140,6],[140,7,140,8],[140,9,145,9],[141,0,141,2],[141,3,141,4],[141,5,141,6],[141,7,141,8],[142,0,142,2],[142,3,142,4],[142,5,142,6],[142,7,142,8],[143,0,143,2],[143,3,143,4],[143,5,143,6],[143,7,143,8],[144,0,144,2],[144,3,144,4],[144,5,144,6],[144,7,144,8],[145,0,145,2],[145,3,145,4],[145,5,145,6],[145,7,145,8],[146,0,146,2],[146,3,146,4],[146,5,146,6],[146,7,146,8],[147,0,147,8],[148,0,148,2],[148,3,148,4],[148,5,148,6],[148,7,148,8],[149,0,149,8],[150,0,150,2],[150,3,150,4],[150,5,150,6],[150,7,150,8],[151,0,151,2],[151,3,151,4],[151,5,151,6],[151,7,151,8],[151,9,162,9],[152,0,152,2],[152,3,152,4],[152,5,152,6],[152,7,152,8],[153,0,153,2],[153,3,153,4],[153,5,153,6],[153,7,153,8],[154,0,154,2],[154,3,154,4],[154,5,154,6],[154,7,154,8],[155,0,155,2],[155,3,155,4],[155,5,155,6],[155,7,155,8],[156,0,156,2],[156,3,156,4],[156,5,156,6],[156,7,156,8],[157,0,157,2],[157,3,157,4],[157,5,157,6],[157,7,157,8],[158,0,158,2],[158,3,158,4],[158,5,158,6],[158,7,158,8],[159,0,159,2],[159,3,159,4],[159,5,159,6],[159,7,159,8],[160,0,160,2],[160,3,160,4],[160,5,160,6],[160,7,160,8],[161,0,161,2],[161,3,161,4],[161,5,161,6],[161,7,161,8],[162,0,162,2],[162,3,162,4],[162,5,162,6],[162,7,162,8],[163,0,163,2],[163,3,163,4],[163,5,163,6],[163,7,163,8],[164,0,164,8],[165,0,165,2],[165,3,165,4],[165,5,165,6],[165,7,165,8],[166,0,166,8],[167,0,167,2],[167,3,167,4],[167,5,167,6],[167,7,167,8],[168,0,168,8],[169,0,169,2],[169,3,169,4],[169,5,169,6],[169,7,169,8],[170,0,170,2],[170,3,170,4],[170,5,170,6],[170,7,170,8],[171,0,171,2],[171,3,171,4],[171,5,171,6],[171,7,171,8]]}
[{"$nulls":9},"The information you need to type onto this document."]
[{"$f":"\"The information for submitting a bid for \nOR Tambo Airport Service Station with Convenient Store Operations for \"&CHAR(10)&Summary!E2","v":"The information for submitting a bid for \nOR Tambo Airport Service Station with Convenient Store Operations for \n"},{"$nulls":8},"The heading includes the company name you typed on the summary page. No action is required from the Bidder."]
["Proposal for OR Tambo Airport (Y/N)",{"$nulls":7},"Y","Select or type Y if you are submitting a proposal for this site."]
["Name of Bidder",null,{"$f":"Summary!E2","v":0},{"$nulls":6},"No action required from the Bidder."]
[]
["Estimate of Capital Investment",{"$nulls":6},{"v":0,"d":"R0.00"},null,"Type the information applicable for this site."]
["The expected business growth over the duration of the concession (%)",{"$nulls":6},{"v":0,"d":"0.0%"}]
["Working capital required to start the business (year 1)",{"$nulls":6},{"v":0,"d":"R0.00"}]
["Total square meters of the Development",{"$nulls":6},{"v":0,"d":"0.00"}]
["Hurdle Rate",{"$nulls":6},{"v":0,"d":"0.0%"}]
["Net Present Value (NPV) using 20 year period DCF",{"$nulls":6},{"v":0,"d":"0.00"}]
["Return on Investment (ROI) year 1",{"$nulls":6},{"v":0,"d":"0.00"}]
["Average year-on-year over the 20-year lease duration",{"$nulls":6},{"v":0,"d":"0.00"}]
["Internal Rate of Return (IRR)",{"$nulls":6},{"v":0,"d":"0.0%"}]
[]
[]
["Estimate Time Line for the Framework for Infrastructure Delivery and Procurement Management (FIPDM) Project Stages"]
["Stage",{"$nulls":5},"Start","End","Working Days"]
["1. Initiation",{"$nulls":7},{"$f":"NETWORKDAYS(G19,H19)","v":0},"Type in the estimated start and end dates using the format yyyy/mm/dd e.g. 2023/09/01\n\nThe working days will be calculated for you.\nFormula: Networkdays(Start Date, End Date)."]
["2. Concept",{"$nulls":7},{"$f":"NETWORKDAYS(G20,H20)","v":0}]
["3. Design Development",{"$nulls":7},0]
["4. Design Documentation",{"$nulls":7},0]
["5. Works",{"$nulls":7},0]
["6. Handover",{"$nulls":7},0]
["7. Close out",{"$nulls":7},0]
[]
["Construction estimated from start and end ",{"$nulls":5},{"$f":"MIN(G19:G25)","v":"00:00:00"},{"$f":"MAX(H19:H25)","v":"00:00:00"},0,"The earliest start date, latest end date and working days are calcuated. Holidays are no applicable for this exercise. \nNo action is required from the Bidder."]
[]
[]
["Land Lease Projection"]
["Year",{"$nulls":3},"Escalation %","Monthly Land Lease",null,"Annual Land Lease"]
["Year 1 ",{"$nulls":3},"-",null,null,{"$f":"F32*12","v":{"v":0,"d":"R0.00"}},null,"Type in the monthly lease you propose for the first year.\n\nNo other months are required because the percentage escalation is applied.\n\nThe ACSA minimum percentage increase is 8%. \nYou can change the percentage if required. The percentage will be revisited at the mid point of the contract i.e. year 10.\nThe percentage escalation applies from the second year onwards.\n\nFormulae: \nMonthly Land Lease = Monthly Land Lease from previous year + Escalation percentage of Monthly Land Lease from previous year\nAnnual Land Lease = Monthly Land Lease X 12"]
["Year 2",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"$f":"(F32*(1+E33))","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"R0.00"}]
["Year 3",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 4",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 5",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 6",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 7",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 8",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 9",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 10",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 11",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"$f":"(F41*(1+E42))","v":{"v":0,"d":"R0.00"}},null,{"$f":"F42*12","v":{"v":0,"d":"R0.00"}}]
["Year 12",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 13",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 14",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F45*12","v":{"v":0,"d":"R0.00"}}]
["Year 15",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F46*12","v":{"v":0,"d":"R0.00"}}]
["Year 16",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F47*12","v":{"v":0,"d":"R0.00"}}]
["Year 17",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F48*12","v":{"v":0,"d":"R0.00"}}]
["Year 18",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F49*12","v":{"v":0,"d":"R0.00"}}]
["Year 19",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 20",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Total",{"$nulls":6},{"$f":"SUM(H32:I51)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Fuel Sales"]
["Year",null,"Profit %","Monthly Sales",null,"Annual Sales",null,"Annual Profit"]
["Year 1",null,{"v":0.1,"d":"10%"},null,null,{"$f":"D57*12","v":{"v":0,"d":"R0.00"}},null,{"$f":"(D57*C57)*12","v":{"v":0,"d":"R0.00"}},null,"Type in the estimated monthly sales for each year. Suggest average is used.\n\nThe proposed ACSA profit percentage is 10%. \nYou can change the percentage if required. \n\nFormulae: \nAnnual Sales = Monthly Sales X 12\nAnnual Profit = Profit percentage of Annual Sales"]
["Year 2",null,{"v":0.1,"d":"10%"},null,null,{"$f":"D58*12","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"R0.00"}]
["Year 3",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 4",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 5",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 6",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 7",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 8",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 9",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 10",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 11",null,{"v":0.1,"d":"10%"},null,null,{"$f":"D67*12","v":{"v":0,"d":"R0.00"}},null,{"$f":"(D67*C67)*12","v":{"v":0,"d":"R0.00"}}]
["Year 12",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 13",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 14",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 15",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 16",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 17",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 18",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 19",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 20",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Total",{"$nulls":4},{"$f":"SUM(F57:G76)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H57:I76)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Convenience Store Sales"]
["Year",null,"Profit %","Monthly Sales",null,"Annual Sales",null,"Annual Profit"]
["Year 1",null,{"v":0.01,"d":"1%"},null,null,{"$f":"D82*12","v":{"v":0,"d":"R0.00"}},null,{"$f":"(D82*C82)*12","v":{"v":0,"d":"R0.00"}},null,"Type in the estimated monthly sales for each year. Suggest average is used.\n\nThe proposed ACSA profit percentage is 1%. \nYou can change the percentage if required. \n\nFormulae: \nAnnual Sales = Monthly Sales X 12\nAnnual Profit = Profit percentage of Annual Sales"]
["Year 2",null,{"v":0.01,"d":"1%"},null,null,{"$f":"D83*12","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"R0.00"}]
["Year 3",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 4",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 5",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 6",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 7",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 8",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 9",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 10",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 11",null,{"v":0.01,"d":"1%"},null,null,{"$f":"D92*12","v":{"v":0,"d":"R0.00"}},null,{"$f":"(D92*C92)*12","v":{"v":0,"d":"R0.00"}}]
["Year 12",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 13",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 14",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 15",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 16",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 17",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 18",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 19",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 20",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Total",{"$nulls":4},{"$f":"SUM(F82:G101)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H82:I101)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Sales of Other Activities"]
["Year",null,"Profit %","Monthly Sales",null,"Annual Sales",null,"Annual Profit"]
["Year 1",null,{"v":0.01,"d":"1%"},null,null,{"$f":"D107*12","v":{"v":0,"d":"R0.00"}},null,{"$f":"(D107*C107)*12","v":{"v":0,"d":"R0.00"}},null,"Type in the estimated monthly sales for each year. Suggest average is used.\n\nThe proposed ACSA profit percentage is 1%. \nYou can change the percentage if required. \n\nFormulae: \nAnnual Sales = Monthly Sales X 12\nAnnual Profit = Profit percentage of Annual Sales"]
["Year 2",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 3",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 4",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 5",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 6",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 7",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 8",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 9",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 10",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 11",null,{"v":0.01,"d":"1%"},null,null,{"$f":"D117*12","v":{"v":0,"d":"R0.00"}},null,{"$f":"(D117*C117)*12","v":{"v":0,"d":"R0.00"}}]
["Year 12",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 13",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 14",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 15",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 16",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 17",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 18",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 19",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 20",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Total",{"$nulls":4},{"$f":"SUM(F107:G126)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H107:I126)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Profit and Loss Statement for three years"]
["Sales Revenue",null,null,"Year 1",null,"Year 2",null,"Year 3"]
["Product / Service 1",{"$nulls":8},"Change the Product / Service description with an appropriate description of sales e.g. Unleaded Fuel. Change the descriptions for a maximum of 6 categories. Leave the description as is if you do not require it.\nType in the estimated Sales for the first three years in the respective columns."]
["Product / Service 2"]
["Product / Service 3"]
["Product / Service 4"]
["Product / Service 5"]
["Product / Service 6"]
["Sales Subtotal",null,null,{"$f":"SUM(D132:E137)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(F132:G137)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H132:I137)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
["Cost of Sales",null,null,"Year 1",null,"Year 2",null,"Year 3"]
[{"$f":"A132","v":"Product / Service 1"},{"$nulls":8},"Change the Product / Service description with an appropriate description of sales e.g. Deliveries. Change the descriptions for a maximum of 6 categories. Leave the description as is if you do not require it.\nType in the estimated Cost of Sales for the first three years in the respective columns."]
["Product / Service 2"]
["Product / Service 3"]
["Product / Service 4"]
["Product / Service 5"]
["Product / Service 6"]
["Cost of Sales Subtotal",null,null,{"$f":"SUM(D141:E146)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(F141:G146)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H141:I146)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
["Gross Profit",null,null,{"$f":"D138-D147","v":{"v":0,"d":"R0.00"}},null,{"$f":"F138-F147","v":{"v":0,"d":"R0.00"}},null,{"$f":"H138-H147","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = Total Sales - Total Cost of Sales for the year "]
[]
["Operating Expenses",null,null,"Year 1",null,"Year 2",null,"Year 3"]
["Summary Expense 1",{"$nulls":8},"Change the Summary Expense description with an appropriate description of expenses e.g. Stationery. Change the descriptions for a maximum of 12 categories. Leave the description as is if you do not require it.\nType in the estimated Expense for the first three years in the respective columns."]
["Summary Expense 2"]
["Summary Expense 3"]
["Summary Expense 4"]
["Summary Expense 5"]
["Summary Expense 6"]
["Summary Expense 7"]
["Summary Expense 8"]
["Summary Expense 9"]
["Summary Expense 10"]
["Summary Expense 11"]
["Summary Expense 12"]
["Operating Expenses Subtotal",null,null,{"$f":"SUM(D152:E163)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(F152:G163)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H152:I163)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder. \nFormula = Sum of all expenses for the year "]
[]
["Income from Operations",null,null,{"$f":"D149-D164","v":{"v":0,"d":"R0.00"}},null,{"$f":"F149-F164","v":{"v":0,"d":"R0.00"}},null,{"$f":"H149-H164","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder. \nFormula = Gross profit - Operating Expenses for the year "]
[]
["Taxes",{"$nulls":8},"Type is the estimated taxes payable for each year."]
[]
["Net Profit",null,null,{"$f":"D166-D168","v":{"v":0,"d":"R0.00"}},null,{"$f":"F166-F168","v":{"v":0,"d":"R0.00"}},null,{"$f":"H166-H168","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder. \nFormula = Income from Operations - Taxes for the year "]
["Percent of net profit payable to ACSA",{"$nulls":8},"Type is the estimated profit percentage payable for each year for ACSA."]
["Estimated R value",null,null,{"$f":"D170*D171","v":{"v":0,"d":"R0.00"}},null,{"$f":"F170*F171","v":{"v":0,"d":"R0.00"}},null,{"$f":"H170*H171","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder. \nFormula = Net Profit X ACSA Percentage of Net Profit for each year "]

{"sheet":"Bram Fischer","index":4,"n_rows":172,"n_cols":10,"rows_kept":172,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,7],[3,0,3,1],[3,2,3,8],[4,0,4,8],[5,0,5,6],[5,7,5,8],[5,9,13,9],[6,0,6,6],[6,7,6,8],[7,0,7,6],[7,7,7,8],[8,0,8,6],[8,7,8,8],[9,0,9,6],[9,7,9,8],[10,0,10,6],[10,7,10,8],[11,0,11,6],[11,7,11,8],[12,0,12,6],[12,7,12,8],[13,0,13,6],[13,7,13,8],[14,0,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,5],[18,0,18,5],[18,9,24,9],[19,0,19,5],[20,0,20,5],[21,0,21,5],[22,0,22,5],[23,0,23,5],[24,0,24,5],[25,0,25,8],[26,0,26,5],[26,9,27,9],[27,0,27,8],[28,0,28,8],[29,0,29,8],[30,0,30,3],[30,5,30,6],[30,7,30,8],[31,0,31,3],[31,5,31,6],[31,7,31,8],[31,9,50,9],[32,0,32,3],[32,5,32,6],[32,7,32,8],[33,0,33,3],[33,5,33,6],[33,7,33,8],[34,0,34,3],[34,5,34,6],[34,7,34,8],[35,0,35,3],[35,5,35,6],[35,7,35,8],[36,0,36,3],[36,5,36,6],[36,7,36,8],[37,0,37,3],[37,5,37,6],[37,7,37,8],[38,0,38,3],[38,5,38,6],[38,7,38,8],[39,0,39,3],[39,5,39,6],[39,7,39,8],[40,0,40,3],[40,5,40,6],[40,7,40,8],[41,0,41,3],[41,5,41,6],[41,7,41,8],[42,0,42,3],[42,5,42,6],[42,7,42,8],[43,0,43,3],[43,5,43,6],[43,7,43,8],[44,0,44,3],[44,5,44,6],[44,7,44,8],[45,0,45,3],[45,5,45,6],[45,7,45,8],[46,0,46,3],[46,5,46,6],[46,7,46,8],[47,0,47,3],[47,5,47,6],[47,7,47,8],[48,0,48,3],[48,5,48,6],[48,7,48,8],[49,0,49,3],[49,5,49,6],[49,7,49,8],[50,0,50,3],[50,5,50,6],[50,7,50,8],[51,0,51,6],[51,7,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,8],[55,0,55,1],[55,3,55,4],[55,5,55,6],[55,7,55,8],[56,0,56,1],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,75,9],[57,0,57,1],[57,3,57,4],[57,5,57,6],[57,7,57,8],[58,0,58,1],[58,3,58,4],[58,5,58,6],[58,7,58,8],[59,0,59,1],[59,3,59,4],[59,5,59,6],[59,7,59,8],[60,0,60,1],[60,3,60,4],[60,5,60,6],[60,7,60,8],[61,0,61,1],[61,3,61,4],[61,5,61,6],[61,7,61,8],[62,0,62,1],[62,3,62,4],[62,5,62,6],[62,7,62,8],[63,0,63,1],[63,3,63,4],[63,5,63,6],[63,7,63,8],[64,0,64,1],[64,3,64,4],[64,5,64,6],[64,7,64,8],[65,0,65,1],[65,3,65,4],[65,5,65,6],[65,7,65,8],[66,0,66,1],[66,3,66,4],[66,5,66,6],[66,7,66,8],[67,0,67,1],[67,3,67,4],[67,5,67,6],[67,7,67,8],[68,0,68,1],[68,3,68,4],[68,5,68,6],[68,7,68,8],[69,0,69,1],[69,3,69,4],[69,5,69,6],[69,7,69,8],[70,0,70,1],[70,3,70,4],[70,5,70,6],[70,7,70,8],[71,0,71,1],[71,3,71,4],[71,5,71,6],[71,7,71,8],[72,0,72,1],[72,3,72,4],[72,5,72,6],[72,7,72,8],[73,0,73,1],[73,3,73,4],[73,5,73,6],[73,7,73,8],[74,0,74,1],[74,3,74,4],[74,5,74,6],[74,7,74,8],[75,0,75,1],[75,3,75,4],[75,5,75,6],[75,7,75,8],[76,0,76,4],[76,5,76,6],[76,7,76,8],[77,0,77,8],[78,0,78,8],[79,0,79,8],[80,0,80,1],[80,3,80,4],[80,5,80,6],[80,7,80,8],[81,0,81,1],[81,3,81,4],[81,5,81,6],[81,7,81,8],[81,9,100,9],[82,0,82,1],[82,3,82,4],[82,5,82,6],[82,7,82,8],[83,0,83,1],[83,3,83,4],[83,5,83,6],[83,7,83,8],[84,0,84,1],[84,3,84,4],[84,5,84,6],[84,7,84,8],[85,0,85,1],[85,3,85,4],[85,5,85,6],[85,7,85,8],[86,0,86,1],[86,3,86,4],[86,5,86,6],[86,7,86,8],[87,0,87,1],[87,3,87,4],[87,5,87,6],[87,7,87,8],[88,0,88,1],[88,3,88,4],[88,5,88,6],[88,7,88,8],[89,0,89,1],[89,3,89,4],[89,5,89,6],[89,7,89,8],[90,0,90,1],[90,3,90,4],[90,5,90,6],[90,7,90,8],[91,0,91,1],[91,3,91,4],[91,5,91,6],[91,7,91,8],[92,0,92,1],[92,3,92,4],[92,5,92,6],[92,7,92,8],[93,0,93,1],[93,3,93,4],[93,5,93,6],[93,7,93,8],[94,0,94,1],[94,3,94,4],[94,5,94,6],[94,7,94,8],[95,0,95,1],[95,3,95,4],[95,5,95,6],[95,7,95,8],[96,0,96,1],[96,3,96,4],[96,5,96,6],[96,7,96,8],[97,0,97,1],[97,3,97,4],[97,5,97,6],[97,7,97,8],[98,0,98,1],[98,3,98,4],[98,5,98,6],[98,7,98,8],[99,0,99,1],[99,3,99,4],[99,5,99,6],[99,7,99,8],[100,0,100,1],[100,3,100,4],[100,5,100,6],[100,7,100,8],[101,0,101,4],[101,5,101,6],[101,7,101,8],[102,0,102,8],[103,0,103,8],[104,0,104,8],[105,0,105,1],[105,3,105,4],[105,5,105,6],[106,0,106,1],[106,3,106,4],[106,5,106,6],[106,7,106,8],[106,9,125,9],[107,0,107,1],[107,3,107,4],[107,5,107,6],[107,7,107,8],[108,0,108,1],[108,3,108,4],[108,5,108,6],[108,7,108,8],[109,0,109,1],[109,3,109,4],[109,5,109,6],[109,7,109,8],[110,0,110,1],[110,3,110,4],[110,5,110,6],[110,7,110,8],[111,0,111,1],[111,3,111,4],[111,5,111,6],[111,7,111,8],[112,0,112,1],[112,3,112,4],[112,5,112,6],[112,7,112,8],[113,0,113,1],[113,3,113,4],[113,5,113,6],[113,7,113,8],[114,0,114,1],[114,3,114,4],[114,5,114,6],[114,7,114,8],[115,0,115,1],[115,3,115,4],[115,5,115,6],[115,7,115,8],[116,0,116,1],[116,3,116,4],[116,5,116,6],[116,7,116,8],[117,0,117,1],[117,3,117,4],[117,5,117,6],[117,7,117,8],[118,0,118,1],[118,3,118,4],[118,5,118,6],[118,7,118,8],[119,0,119,1],[119,3,119,4],[119,5,119,6],[119,7,119,8],[120,0,120,1],[120,3,120,4],[120,5,120,6],[120,7,120,8],[121,0,121,1],[121,3,121,4],[121,5,121,6],[121,7,121,8],[122,0,122,1],[122,3,122,4],[122,5,122,6],[122,7,122,8],[123,0,123,1],[123,3,123,4],[123,5,123,6],[123,7,123,8],[124,0,124,1],[124,3,124,4],[124,5,124,6],[124,7,124,8],[125,0,125,1],[125,3,125,4],[125,5,125,6],[125,7,125,8],[126,0,126,4],[126,5,126,6],[126,7,126,8],[127,0,127,8],[128,0,128,8],[129,0,129,8],[130,0,130,2],[130,3,130,4],[130,5,130,6],[130,7,130,8],[131,0,131,2],[131,3,131,4],[131,5,131,6],[131,7,131,8],[131,9,136,9],[132,0,132,2],[132,3,132,4],[132,5,132,6],[132,7,132,8],[133,0,133,2],[133,3,133,4],[133,5,133,6],[133,7,133,8],[134,0,134,2],[134,3,134,4],[134,5,134,6],[134,7,134,8],[135,0,135,2],[135,3,135,4],[135,5,135,6],[135,7,135,8],[136,0,136,2],[136,3,136,4],[136,5,136,6],[136,7,136,8],[137,0,137,2],[137,3,137,4],[137,5,137,6],[137,7,137,8],[138,0,138,8],[139,0,139,2],[139,3,139,4],[139,5,139,6],[139,7,139,8],[140,0,140,2],[140,3,140,4],[140,5,140,6],[140,7,140,8],[140,9,145,9],[141,0,141,2],[141,3,141,4],[141,5,141,6],[141,7,141,8],[142,0,142,2],[142,3,142,4],[142,5,142,6],[142,7,142,8],[143,0,143,2],[143,3,143,4],[143,5,143,6],[143,7,143,8],[144,0,144,2],[144,3,144,4],[144,5,144,6],[144,7,144,8],[145,0,145,2],[145,3,145,4],[145,5,145,6],[145,7,145,8],[146,0,146,2],[146,3,146,4],[146,5,146,6],[146,7,146,8],[147,0,147,8],[148,0,148,2],[148,3,148,4],[148,5,148,6],[148,7,148,8],[149,0,149,8],[150,0,150,2],[150,3,150,4],[150,5,150,6],[150,7,150,8],[151,0,151,2],[151,3,151,4],[151,5,151,6],[151,7,151,8],[151,9,162,9],[152,0,152,2],[152,3,152,4],[152,5,152,6],[152,7,152,8],[153,0,153,2],[153,3,153,4],[153,5,153,6],[153,7,153,8],[154,0,154,2],[154,3,154,4],[154,5,154,6],[154,7,154,8],[155,0,155,2],[155,3,155,4],[155,5,155,6],[155,7,155,8],[156,0,156,2],[156,3,156,4],[156,5,156,6],[156,7,156,8],[157,0,157,2],[157,3,157,4],[157,5,157,6],[157,7,157,8],[158,0,158,2],[158,3,158,4],[158,5,158,6],[158,7,158,8],[159,0,159,2],[159,3,159,4],[159,5,159,6],[159,7,159,8],[160,0,160,2],[160,3,160,4],[160,5,160,6],[160,7,160,8],[161,0,161,2],[161,3,161,4],[161,5,161,6],[161,7,161,8],[162,0,162,2],[162,3,162,4],[162,5,162,6],[162,7,162,8],[163,0,163,2],[163,3,163,4],[163,5,163,6],[163,7,163,8],[164,0,164,8],[165,0,165,2],[165,3,165,4],[165,5,165,6],[165,7,165,8],[166,0,166,8],[167,0,167,2],[167,3,167,4],[167,5,167,6],[167,7,167,8],[168,0,168,8],[169,0,169,2],[169,3,169,4],[169,5,169,6],[169,7,169,8],[170,0,170,2],[170,3,170,4],[170,5,170,6],[170,7,170,8],[171,0,171,2],[171,3,171,4],[171,5,171,6],[171,7,171,8]]}
[{"$nulls":9},"The information you need to type onto this document."]
[{"$f":"\"The information for submitting a bid for \nBram Fischer Airport Service Station with Convenient Store Operations for \"&CHAR(10)&Summary!E2","v":"The information for submitting a bid for \nBram Fischer Airport Service Station with Convenient Store Operations for \n"},{"$nulls":8},"The heading includes the company name you typed on the summary page. No action is required from the Bidder."]
["Proposal for Bram Fischer Airport (Y/N)",{"$nulls":7},"N","Select or type Y if you are submitting a proposal for this site."]
["Name of Bidder",null,{"$f":"Summary!E2","v":0},{"$nulls":6},"No action required from the Bidder."]
[]
["Estimate of Capital Investment",{"$nulls":6},{"v":0,"d":"R0.00"},null,"Type the information applicable for this site."]
["The expected business growth over the duration of the concession (%)",{"$nulls":6},{"v":0,"d":"0.0%"}]
["Working capital required to start the business (year 1)",{"$nulls":6},{"v":0,"d":"R0.00"}]
["Total square meters of the Development",{"$nulls":6},{"v":0,"d":"0.00"}]
["Hurdle Rate",{"$nulls":6},{"v":0,"d":"0.0%"}]
["Net Present Value (NPV) using 20 year period DCF",{"$nulls":6},{"v":0,"d":"0.00"}]
["Return on Investment (ROI) year 1",{"$nulls":6},{"v":0,"d":"0.00"}]
["Average year-on-year over the 20-year lease duration",{"$nulls":6},{"v":0,"d":"0.00"}]
["Internal Rate of Return (IRR)",{"$nulls":6},{"v":0,"d":"0.0%"}]
[]
[]
["Estimate Time Line for the Framework for Infrastructure Delivery and Procurement Management (FIPDM) Project Stages"]
["Stage",{"$nulls":5},"Start","End","Working Days"]
["1. Initiation",{"$nulls":7},{"$f":"NETWORKDAYS(G19,H19)","v":0},"Type in the estimated start and end dates using the format yyyy/mm/dd e.g. 2023/09/01\n\nThe working days will be calculated for you.\nFormula: Networkdays(Start Date, End Date)."]
["2. Concept",{"$nulls":7},{"$f":"NETWORKDAYS(G20,H20)","v":0}]
["3. Design Development",{"$nulls":7},0]
["4. Design Documentation",{"$nulls":7},0]
["5. Works",{"$nulls":7},0]
["6. Handover",{"$nulls":7},0]
["7. Close out",{"$nulls":7},0]
[]
["Construction estimated from start and end ",{"$nulls":5},{"$f":"MIN(G19:G25)","v":"00:00:00"},{"$f":"MAX(H19:H25)","v":"00:00:00"},0,"The earliest start date, latest end date and working days are calcuated. Holidays are no applicable for this exercise. \nNo action is required from the Bidder."]
[]
[]
["Land Lease Projection"]
["Year",{"$nulls":3},"Escalation %","Monthly Land Lease",null,"Annual Land Lease"]
["Year 1 ",{"$nulls":3},"-",null,null,{"$f":"F32*12","v":{"v":0,"d":"R0.00"}},null,"Type in the monthly lease you propose for the first year.\n\nNo other months are required because the percentage escalation is applied.\n\nThe ACSA minimum percentage increase is 8%. \nYou can change the percentage if required. The percentage will be revisited at the mid point of the contract i.e. year 10.\nThe percentage escalation applies from the second year onwards.\n\nFormulae: \nMonthly Land Lease = Monthly Land Lease from previous year + Escalation percentage of Monthly Land Lease from previous year\nAnnual Land Lease = Monthly Land Lease X 12"]
["Year 2",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"$f":"(F32*(1+E33))","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"R0.00"}]
["Year 3",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 4",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 5",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 6",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 7",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 8",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 9",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 10",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 11",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 12",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 13",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 14",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F45*12","v":{"v":0,"d":"R0.00"}}]
["Year 15",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F46*12","v":{"v":0,"d":"R0.00"}}]
["Year 16",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F47*12","v":{"v":0,"d":"R0.00"}}]
["Year 17",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F48*12","v":{"v":0,"d":"R0.00"}}]
["Year 18",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F49*12","v":{"v":0,"d":"R0.00"}}]
["Year 19",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 20",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Total",{"$nulls":6},{"$f":"SUM(H32:I51)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Fuel Sales"]
["Year",null,"Profit %","Monthly Sales",null,"Annual Sales",null,"Annual Profit"]
["Year 1",null,{"v":0.1,"d":"10%"},null,null,{"$f":"D57*12","v":{"v":0,"d":"R0.00"}},null,{"$f":"(D57*C57)*12","v":{"v":0,"d":"R0.00"}},null,"Type in the estimated monthly sales for each year. Suggest average is used.\n\nThe proposed ACSA profit percentage is 10%. \nYou can change the percentage if required. \n\nFormulae: \nAnnual Sales = Monthly Sales X 12\nAnnual Profit = Profit percentage of Annual Sales"]
["Year 2",null,{"v":0.1,"d":"10%"},null,null,{"$f":"D58*12","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"R0.00"}]
["Year 3",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 4",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 5",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 6",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 7",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 8",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 9",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 10",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 11",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 12",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 13",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 14",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 15",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 16",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 17",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 18",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 19",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 20",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Total",{"$nulls":4},{"$f":"SUM(F57:G76)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H57:I76)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Convenience Store Sales"]
["Year",null,"Profit %","Monthly Sales",null,"Annual Sales",null,"Annual Profit"]
["Year 1",null,{"v":0.01,"d":"1%"},null,null,{"$f":"D82*12","v":{"v":0,"d":"R0.00"}},null,{"$f":"(D82*C82)*12","v":{"v":0,"d":"R0.00"}},null,"Type in the estimated monthly sales for each year. Suggest average is used.\n\nThe proposed ACSA profit percentage is 1%. \nYou can change the percentage if required. \n\nFormulae: \nAnnual Sales = Monthly Sales X 12\nAnnual Profit = Profit percentage of Annual Sales"]
["Year 2",null,{"v":0.01,"d":"1%"},null,null,{"$f":"D83*12","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"R0.00"}]
["Year 3",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 4",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 5",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 6",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 7",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 8",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 9",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 10",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 11",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 12",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 13",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 14",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 15",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 16",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 17",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 18",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 19",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 20",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Total",{"$nulls":4},{"$f":"SUM(F82:G101)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H82:I101)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Sales of Other Activities"]
["Year",null,"Profit %","Monthly Sales",null,"Annual Sales",null,"Annual Profit"]
["Year 1",null,{"v":0.01,"d":"1%"},null,null,{"$f":"D107*12","v":{"v":0,"d":"R0.00"}},null,{"$f":"(D107*C107)*12","v":{"v":0,"d":"R0.00"}},null,"Type in the estimated monthly sales for each year. Suggest average is used.\n\nThe proposed ACSA profit percentage is 1%. \nYou can change the percentage if required. \n\nFormulae: \nAnnual Sales = Monthly Sales X 12\nAnnual Profit = Profit percentage of Annual Sales"]
["Year 2",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 3",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 4",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 5",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 6",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 7",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 8",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 9",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 10",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 11",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 12",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 13",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 14",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 15",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 16",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 17",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 18",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 19",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 20",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Total",{"$nulls":4},{"$f":"SUM(F107:G126)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H107:I126)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Profit and Loss Statement for three years"]
["Sales Revenue",null,null,"Year 1",null,"Year 2",null,"Year 3"]
["Product / Service 1",{"$nulls":8},"Change the Product / Service description with an appropriate description of sales e.g. Unleaded Fuel. Change the descriptions for a maximum of 6 categories. Leave the description as is if you do not require it.\nType in the estimated Sales for the first three years in the respective columns."]
["Product / Service 2"]
["Product / Service 3"]
["Product / Service 4"]
["Product / Service 5"]
["Product / Service 6"]
["Sales Subtotal",null,null,{"$f":"SUM(D132:E137)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(F132:G137)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H132:I137)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
["Cost of Sales",null,null,"Year 1",null,"Year 2",null,"Year 3"]
[{"$f":"A132","v":"Product / Service 1"},{"$nulls":8},"Change the Product / Service description with an appropriate description of sales e.g. Deliveries. Change the descriptions for a maximum of 6 categories. Leave the description as is if you do not require it.\nType in the estimated Cost of Sales for the first three years in the respective columns."]
["Product / Service 2"]
["Product / Service 3"]
["Product / Service 4"]
["Product / Service 5"]
["Product / Service 6"]
["Cost of Sales Subtotal",null,null,{"$f":"SUM(D141:E146)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(F141:G146)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H141:I146)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
["Gross Profit",null,null,{"$f":"D138-D147","v":{"v":0,"d":"R0.00"}},null,{"$f":"F138-F147","v":{"v":0,"d":"R0.00"}},null,{"$f":"H138-H147","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = Total Sales - Total Cost of Sales for the year "]
[]
["Operating Expenses",null,null,"Year 1",null,"Year 2",null,"Year 3"]
["Summary Expense 1",{"$nulls":8},"Change the Summary Expense description with an appropriate description of expenses e.g. Stationery. Change the descriptions for a maximum of 12 categories. Leave the description as is if you do not require it.\nType in the estimated Expense for the first three years in the respective columns."]
["Summary Expense 2"]
["Summary Expense 3"]
["Summary Expense 4"]
["Summary Expense 5"]
["Summary Expense 6"]
["Summary Expense 7"]
["Summary Expense 8"]
["Summary Expense 9"]
["Summary Expense 10"]
["Summary Expense 11"]
["Summary Expense 12"]
["Operating Expenses Subtotal",null,null,{"$f":"SUM(D152:E163)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(F152:G163)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H152:I163)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder. \nFormula = Sum of all expenses for the year "]
[]
["Income from Operations",null,null,{"$f":"D149-D164","v":{"v":0,"d":"R0.00"}},null,{"$f":"F149-F164","v":{"v":0,"d":"R0.00"}},null,{"$f":"H149-H164","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder. \nFormula = Gross profit - Operating Expenses for the year "]
[]
["Taxes",{"$nulls":8},"Type is the estimated taxes payable for each year."]
[]
["Net Profit",null,null,{"$f":"D166-D168","v":{"v":0,"d":"R0.00"}},null,{"$f":"F166-F168","v":{"v":0,"d":"R0.00"}},null,{"$f":"H166-H168","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder. \nFormula = Income from Operations - Taxes for the year "]
["Percent of net profit payable to ACSA",{"$nulls":8},"Type is the estimated profit percentage payable for each year for ACSA."]
["Estimated R value",null,null,{"$f":"D170*D171","v":{"v":0,"d":"R0.00"}},null,{"$f":"F170*F171","v":{"v":0,"d":"R0.00"}},null,{"$f":"H170*H171","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder. \nFormula = Net Profit X ACSA Percentage of Net Profit for each year "]

{"sheet":"George","index":5,"n_rows":172,"n_cols":10,"rows_kept":172,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,7],[3,0,3,1],[3,2,3,8],[4,0,4,8],[5,0,5,6],[5,7,5,8],[5,9,13,9],[6,0,6,6],[6,7,6,8],[7,0,7,6],[7,7,7,8],[8,0,8,6],[8,7,8,8],[9,0,9,6],[9,7,9,8],[10,0,10,6],[10,7,10,8],[11,0,11,6],[11,7,11,8],[12,0,12,6],[12,7,12,8],[13,0,13,6],[13,7,13,8],[14,0,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,5],[18,0,18,5],[18,9,24,9],[19,0,19,5],[20,0,20,5],[21,0,21,5],[22,0,22,5],[23,0,23,5],[24,0,24,5],[25,0,25,8],[26,0,26,5],[26,9,27,9],[27,0,27,8],[28,0,28,8],[29,0,29,8],[30,0,30,3],[30,5,30,6],[30,7,30,8],[31,0,31,3],[31,5,31,6],[31,7,31,8],[31,9,50,9],[32,0,32,3],[32,5,32,6],[32,7,32,8],[33,0,33,3],[33,5,33,6],[33,7,33,8],[34,0,34,3],[34,5,34,6],[34,7,34,8],[35,0,35,3],[35,5,35,6],[35,7,35,8],[36,0,36,3],[36,5,36,6],[36,7,36,8],[37,0,37,3],[37,5,37,6],[37,7,37,8],[38,0,38,3],[38,5,38,6],[38,7,38,8],[39,0,39,3],[39,5,39,6],[39,7,39,8],[40,0,40,3],[40,5,40,6],[40,7,40,8],[41,0,41,3],[41,5,41,6],[41,7,41,8],[42,0,42,3],[42,5,42,6],[42,7,42,8],[43,0,43,3],[43,5,43,6],[43,7,43,8],[44,0,44,3],[44,5,44,6],[44,7,44,8],[45,0,45,3],[45,5,45,6],[45,7,45,8],[46,0,46,3],[46,5,46,6],[46,7,46,8],[47,0,47,3],[47,5,47,6],[47,7,47,8],[48,0,48,3],[48,5,48,6],[48,7,48,8],[49,0,49,3],[49,5,49,6],[49,7,49,8],[50,0,50,3],[50,5,50,6],[50,7,50,8],[51,0,51,6],[51,7,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,8],[55,0,55,1],[55,3,55,4],[55,5,55,6],[55,7,55,8],[56,0,56,1],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,75,9],[57,0,57,1],[57,3,57,4],[57,5,57,6],[57,7,57,8],[58,0,58,1],[58,3,58,4],[58,5,58,6],[58,7,58,8],[59,0,59,1],[59,3,59,4],[59,5,59,6],[59,7,59,8],[60,0,60,1],[60,3,60,4],[60,5,60,6],[60,7,60,8],[61,0,61,1],[61,3,61,4],[61,5,61,6],[61,7,61,8],[62,0,62,1],[62,3,62,4],[62,5,62,6],[62,7,62,8],[63,0,63,1],[63,3,63,4],[63,5,63,6],[63,7,63,8],[64,0,64,1],[64,3,64,4],[64,5,64,6],[64,7,64,8],[65,0,65,1],[65,3,65,4],[65,5,65,6],[65,7,65,8],[66,0,66,1],[66,3,66,4],[66,5,66,6],[66,7,66,8],[67,0,67,1],[67,3,67,4],[67,5,67,6],[67,7,67,8],[68,0,68,1],[68,3,68,4],[68,5,68,6],[68,7,68,8],[69,0,69,1],[69,3,69,4],[69,5,69,6],[69,7,69,8],[70,0,70,1],[70,3,70,4],[70,5,70,6],[70,7,70,8],[71,0,71,1],[71,3,71,4],[71,5,71,6],[71,7,71,8],[72,0,72,1],[72,3,72,4],[72,5,72,6],[72,7,72,8],[73,0,73,1],[73,3,73,4],[73,5,73,6],[73,7,73,8],[74,0,74,1],[74,3,74,4],[74,5,74,6],[74,7,74,8],[75,0,75,1],[75,3,75,4],[75,5,75,6],[75,7,75,8],[76,0,76,4],[76,5,76,6],[76,7,76,8],[77,0,77,8],[78,0,78,8],[79,0,79,8],[80,0,80,1],[80,3,80,4],[80,5,80,6],[80,7,80,8],[81,0,81,1],[81,3,81,4],[81,5,81,6],[81,7,81,8],[81,9,100,9],[82,0,82,1],[82,3,82,4],[82,5,82,6],[82,7,82,8],[83,0,83,1],[83,3,83,4],[83,5,83,6],[83,7,83,8],[84,0,84,1],[84,3,84,4],[84,5,84,6],[84,7,84,8],[85,0,85,1],[85,3,85,4],[85,5,85,6],[85,7,85,8],[86,0,86,1],[86,3,86,4],[86,5,86,6],[86,7,86,8],[87,0,87,1],[87,3,87,4],[87,5,87,6],[87,7,87,8],[88,0,88,1],[88,3,88,4],[88,5,88,6],[88,7,88,8],[89,0,89,1],[89,3,89,4],[89,5,89,6],[89,7,89,8],[90,0,90,1],[90,3,90,4],[90,5,90,6],[90,7,90,8],[91,0,91,1],[91,3,91,4],[91,5,91,6],[91,7,91,8],[92,0,92,1],[92,3,92,4],[92,5,92,6],[92,7,92,8],[93,0,93,1],[93,3,93,4],[93,5,93,6],[93,7,93,8],[94,0,94,1],[94,3,94,4],[94,5,94,6],[94,7,94,8],[95,0,95,1],[95,3,95,4],[95,5,95,6],[95,7,95,8],[96,0,96,1],[96,3,96,4],[96,5,96,6],[96,7,96,8],[97,0,97,1],[97,3,97,4],[97,5,97,6],[97,7,97,8],[98,0,98,1],[98,3,98,4],[98,5,98,6],[98,7,98,8],[99,0,99,1],[99,3,99,4],[99,5,99,6],[99,7,99,8],[100,0,100,1],[100,3,100,4],[100,5,100,6],[100,7,100,8],[101,0,101,4],[101,5,101,6],[101,7,101,8],[102,0,102,8],[103,0,103,8],[104,0,104,8],[105,0,105,1],[105,3,105,4],[105,5,105,6],[106,0,106,1],[106,3,106,4],[106,5,106,6],[106,7,106,8],[106,9,125,9],[107,0,107,1],[107,3,107,4],[107,5,107,6],[107,7,107,8],[108,0,108,1],[108,3,108,4],[108,5,108,6],[108,7,108,8],[109,0,109,1],[109,3,109,4],[109,5,109,6],[109,7,109,8],[110,0,110,1],[110,3,110,4],[110,5,110,6],[110,7,110,8],[111,0,111,1],[111,3,111,4],[111,5,111,6],[111,7,111,8],[112,0,112,1],[112,3,112,4],[112,5,112,6],[112,7,112,8],[113,0,113,1],[113,3,113,4],[113,5,113,6],[113,7,113,8],[114,0,114,1],[114,3,114,4],[114,5,114,6],[114,7,114,8],[115,0,115,1],[115,3,115,4],[115,5,115,6],[115,7,115,8],[116,0,116,1],[116,3,116,4],[116,5,116,6],[116,7,116,8],[117,0,117,1],[117,3,117,4],[117,5,117,6],[117,7,117,8],[118,0,118,1],[118,3,118,4],[118,5,118,6],[118,7,118,8],[119,0,119,1],[119,3,119,4],[119,5,119,6],[119,7,119,8],[120,0,120,1],[120,3,120,4],[120,5,120,6],[120,7,120,8],[121,0,121,1],[121,3,121,4],[121,5,121,6],[121,7,121,8],[122,0,122,1],[122,3,122,4],[122,5,122,6],[122,7,122,8],[123,0,123,1],[123,3,123,4],[123,5,123,6],[123,7,123,8],[124,0,124,1],[124,3,124,4],[124,5,124,6],[124,7,124,8],[125,0,125,1],[125,3,125,4],[125,5,125,6],[125,7,125,8],[126,0,126,4],[126,5,126,6],[126,7,126,8],[127,0,127,8],[128,0,128,8],[129,0,129,8],[130,0,130,2],[130,3,130,4],[130,5,130,6],[130,7,130,8],[131,0,131,2],[131,3,131,4],[131,5,131,6],[131,7,131,8],[131,9,136,9],[132,0,132,2],[132,3,132,4],[132,5,132,6],[132,7,132,8],[133,0,133,2],[133,3,133,4],[133,5,133,6],[133,7,133,8],[134,0,134,2],[134,3,134,4],[134,5,134,6],[134,7,134,8],[135,0,135,2],[135,3,135,4],[135,5,135,6],[135,7,135,8],[136,0,136,2],[136,3,136,4],[136,5,136,6],[136,7,136,8],[137,0,137,2],[137,3,137,4],[137,5,137,6],[137,7,137,8],[138,0,138,8],[139,0,139,2],[139,3,139,4],[139,5,139,6],[139,7,139,8],[140,0,140,2],[140,3,140,4],[140,5,140,6],[140,7,140,8],[140,9,145,9],[141,0,141,2],[141,3,141,4],[141,5,141,6],[141,7,141,8],[142,0,142,2],[142,3,142,4],[142,5,142,6],[142,7,142,8],[143,0,143,2],[143,3,143,4],[143,5,143,6],[143,7,143,8],[144,0,144,2],[144,3,144,4],[144,5,144,6],[144,7,144,8],[145,0,145,2],[145,3,145,4],[145,5,145,6],[145,7,145,8],[146,0,146,2],[146,3,146,4],[146,5,146,6],[146,7,146,8],[147,0,147,8],[148,0,148,2],[148,3,148,4],[148,5,148,6],[148,7,148,8],[149,0,149,8],[150,0,150,2],[150,3,150,4],[150,5,150,6],[150,7,150,8],[151,0,151,2],[151,3,151,4],[151,5,151,6],[151,7,151,8],[151,9,162,9],[152,0,152,2],[152,3,152,4],[152,5,152,6],[152,7,152,8],[153,0,153,2],[153,3,153,4],[153,5,153,6],[153,7,153,8],[154,0,154,2],[154,3,154,4],[154,5,154,6],[154,7,154,8],[155,0,155,2],[155,3,155,4],[155,5,155,6],[155,7,155,8],[156,0,156,2],[156,3,156,4],[156,5,156,6],[156,7,156,8],[157,0,157,2],[157,3,157,4],[157,5,157,6],[157,7,157,8],[158,0,158,2],[158,3,158,4],[158,5,158,6],[158,7,158,8],[159,0,159,2],[159,3,159,4],[159,5,159,6],[159,7,159,8],[160,0,160,2],[160,3,160,4],[160,5,160,6],[160,7,160,8],[161,0,161,2],[161,3,161,4],[161,5,161,6],[161,7,161,8],[162,0,162,2],[162,3,162,4],[162,5,162,6],[162,7,162,8],[163,0,163,2],[163,3,163,4],[163,5,163,6],[163,7,163,8],[164,0,164,8],[165,0,165,2],[165,3,165,4],[165,5,165,6],[165,7,165,8],[166,0,166,8],[167,0,167,2],[167,3,167,4],[167,5,167,6],[167,7,167,8],[168,0,168,8],[169,0,169,2],[169,3,169,4],[169,5,169,6],[169,7,169,8],[170,0,170,2],[170,3,170,4],[170,5,170,6],[170,7,170,8],[171,0,171,2],[171,3,171,4],[171,5,171,6],[171,7,171,8]]}
[{"$nulls":9},"The information you need to type onto this document."]
[{"$f":"\"The information for submitting a bid for \nGeorge Airport Service Station with Convenient Store Operations for \"&CHAR(10)&Summary!E2","v":"The information for submitting a bid for \nGeorge Airport Service Station with Convenient Store Operations for \n"},{"$nulls":8},"The heading includes the company name you typed on the summary page. No action is required from the Bidder."]
["Proposal for George Airport (Y/N)",{"$nulls":7},"N","Select or type Y if you are submitting a proposal for this site."]
["Name of Bidder",null,{"$f":"Summary!E2","v":0},{"$nulls":6},"No action required from the Bidder."]
[]
["Estimate of Capital Investment",{"$nulls":6},{"v":0,"d":"R0.00"},null,"Type the information applicable for this site."]
["The expected business growth over the duration of the concession (%)",{"$nulls":6},{"v":0,"d":"0.0%"}]
["Working capital required to start the business (year 1)",{"$nulls":6},{"v":0,"d":"R0.00"}]
["Total square meters of the Development",{"$nulls":6},{"v":0,"d":"0.00"}]
["Hurdle Rate",{"$nulls":6},{"v":0,"d":"0.0%"}]
["Net Present Value (NPV) using 20 year period DCF",{"$nulls":6},{"v":0,"d":"0.00"}]
["Return on Investment (ROI) year 1",{"$nulls":6},{"v":0,"d":"0.00"}]
["Average year-on-year over the 20-year lease duration",{"$nulls":6},{"v":0,"d":"0.00"}]
["Internal Rate of Return (IRR)",{"$nulls":6},{"v":0,"d":"0.0%"}]
[]
[]
["Estimate Time Line for the Framework for Infrastructure Delivery and Procurement Management (FIPDM) Project Stages"]
["Stage",{"$nulls":5},"Start","End","Working Days"]
["1. Initiation",{"$nulls":7},{"$f":"NETWORKDAYS(G19,H19)","v":0},"Type in the estimated start and end dates using the format yyyy/mm/dd e.g. 2023/09/01\n\nThe working days will be calculated for you.\nFormula: Networkdays(Start Date, End Date)."]
["2. Concept",{"$nulls":7},{"$f":"NETWORKDAYS(G20,H20)","v":0}]
["3. Design Development",{"$nulls":7},0]
["4. Design Documentation",{"$nulls":7},0]
["5. Works",{"$nulls":7},0]
["6. Handover",{"$nulls":7},0]
["7. Close out",{"$nulls":7},0]
[]
["Construction estimated from start and end ",{"$nulls":5},{"$f":"MIN(G19:G25)","v":"00:00:00"},{"$f":"MAX(H19:H25)","v":"00:00:00"},0,"The earliest start date, latest end date and working days are calcuated. Holidays are no applicable for this exercise. \nNo action is required from the Bidder."]
[]
[]
["Land Lease Projection"]
["Year",{"$nulls":3},"Escalation %","Monthly Land Lease",null,"Annual Land Lease"]
["Year 1 ",{"$nulls":3},"-",null,null,{"$f":"F32*12","v":{"v":0,"d":"R0.00"}},null,"Type in the monthly lease you propose for the first year.\n\nNo other months are required because the percentage escalation is applied.\n\nThe ACSA minimum percentage increase is 8%. \nYou can change the percentage if required. The percentage will be revisited at the mid point of the contract i.e. year 10.\nThe percentage escalation applies from the second year onwards.\n\nFormulae: \nMonthly Land Lease = Monthly Land Lease from previous year + Escalation percentage of Monthly Land Lease from previous year\nAnnual Land Lease = Monthly Land Lease X 12"]
["Year 2",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"$f":"(F32*(1+E33))","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"R0.00"}]
["Year 3",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 4",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 5",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 6",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 7",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 8",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 9",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 10",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 11",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 12",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 13",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 14",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F45*12","v":{"v":0,"d":"R0.00"}}]
["Year 15",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F46*12","v":{"v":0,"d":"R0.00"}}]
["Year 16",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F47*12","v":{"v":0,"d":"R0.00"}}]
["Year 17",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F48*12","v":{"v":0,"d":"R0.00"}}]
["Year 18",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"$f":"F49*12","v":{"v":0,"d":"R0.00"}}]
["Year 19",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 20",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Total",{"$nulls":6},{"$f":"SUM(H32:I51)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Fuel Sales"]
["Year",null,"Profit %","Monthly Sales",null,"Annual Sales",null,"Annual Profit"]
["Year 1",null,{"v":0.1,"d":"10%"},null,null,{"$f":"D57*12","v":{"v":0,"d":"R0.00"}},null,{"$f":"(D57*C57)*12","v":{"v":0,"d":"R0.00"}},null,"Type in the estimated monthly sales for each year. Suggest average is used.\n\nThe proposed ACSA profit percentage is 10%. \nYou can change the percentage if required. \n\nFormulae: \nAnnual Sales = Monthly Sales X 12\nAnnual Profit = Profit percentage of Annual Sales"]
["Year 2",null,{"v":0.1,"d":"10%"},null,null,{"$f":"D58*12","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"R0.00"}]
["Year 3",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 4",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 5",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 6",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 7",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 8",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 9",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 10",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 11",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 12",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 13",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 14",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 15",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 16",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 17",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 18",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 19",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 20",null,{"v":0.1,"d":"10%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Total",{"$nulls":4},{"$f":"SUM(F57:G76)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H57:I76)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Convenience Store Sales"]
["Year",null,"Profit %","Monthly Sales",null,"Annual Sales",null,"Annual Profit"]
["Year 1",null,{"v":0.01,"d":"1%"},null,null,{"$f":"D82*12","v":{"v":0,"d":"R0.00"}},null,{"$f":"(D82*C82)*12","v":{"v":0,"d":"R0.00"}},null,"Type in the estimated monthly sales for each year. Suggest average is used.\n\nThe proposed ACSA profit percentage is 1%. \nYou can change the percentage if required. \n\nFormulae: \nAnnual Sales = Monthly Sales X 12\nAnnual Profit = Profit percentage of Annual Sales"]
["Year 2",null,{"v":0.01,"d":"1%"},null,null,{"$f":"D83*12","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"R0.00"}]
["Year 3",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 4",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 5",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 6",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 7",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 8",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 9",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 10",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 11",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 12",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 13",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 14",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 15",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 16",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 17",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 18",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 19",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 20",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Total",{"$nulls":4},{"$f":"SUM(F82:G101)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H82:I101)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Sales of Other Activities"]
["Year",null,"Profit %","Monthly Sales",null,"Annual Sales",null,"Annual Profit"]
["Year 1",null,{"v":0.01,"d":"1%"},null,null,{"$f":"D107*12","v":{"v":0,"d":"R0.00"}},null,{"$f":"(D107*C107)*12","v":{"v":0,"d":"R0.00"}},null,"Type in the estimated monthly sales for each year. Suggest average is used.\n\nThe proposed ACSA profit percentage is 1%. \nYou can change the percentage if required. \n\nFormulae: \nAnnual Sales = Monthly Sales X 12\nAnnual Profit = Profit percentage of Annual Sales"]
["Year 2",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 3",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 4",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 5",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 6",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 7",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 8",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 9",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 10",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 11",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 12",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 13",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 14",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 15",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 16",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 17",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 18",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 19",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Year 20",null,{"v":0.01,"d":"1%"},null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["Total",{"$nulls":4},{"$f":"SUM(F107:G126)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H107:I126)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
[]
["Projected Profit and Loss Statement for three years"]
["Sales Revenue",null,null,"Year 1",null,"Year 2",null,"Year 3"]
["Product / Service 1",{"$nulls":8},"Change the Product / Service description with an appropriate description of sales e.g. Unleaded Fuel. Change the descriptions for a maximum of 6 categories. Leave the description as is if you do not require it.\nType in the estimated Sales for the first three years in the respective columns."]
["Product / Service 2"]
["Product / Service 3"]
["Product / Service 4"]
["Product / Service 5"]
["Product / Service 6"]
["Sales Subtotal",null,null,{"$f":"SUM(D132:E137)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(F132:G137)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H132:I137)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
["Cost of Sales",null,null,"Year 1",null,"Year 2",null,"Year 3"]
[{"$f":"A132","v":"Product / Service 1"},{"$nulls":8},"Change the Product / Service description with an appropriate description of sales e.g. Deliveries. Change the descriptions for a maximum of 6 categories. Leave the description as is if you do not require it.\nType in the estimated Cost of Sales for the first three years in the respective columns."]
["Product / Service 2"]
["Product / Service 3"]
["Product / Service 4"]
["Product / Service 5"]
["Product / Service 6"]
["Cost of Sales Subtotal",null,null,{"$f":"SUM(D141:E146)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(F141:G146)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H141:I146)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = sum(rows above)"]
[]
["Gross Profit",null,null,{"$f":"D138-D147","v":{"v":0,"d":"R0.00"}},null,{"$f":"F138-F147","v":{"v":0,"d":"R0.00"}},null,{"$f":"H138-H147","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder.\nFormula = Total Sales - Total Cost of Sales for the year "]
[]
["Operating Expenses",null,null,"Year 1",null,"Year 2",null,"Year 3"]
["Summary Expense 1",{"$nulls":8},"Change the Summary Expense description with an appropriate description of expenses e.g. Stationery. Change the descriptions for a maximum of 12 categories. Leave the description as is if you do not require it.\nType in the estimated Expense for the first three years in the respective columns."]
["Summary Expense 2"]
["Summary Expense 3"]
["Summary Expense 4"]
["Summary Expense 5"]
["Summary Expense 6"]
["Summary Expense 7"]
["Summary Expense 8"]
["Summary Expense 9"]
["Summary Expense 10"]
["Summary Expense 11"]
["Summary Expense 12"]
["Operating Expenses Subtotal",null,null,{"$f":"SUM(D152:E163)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(F152:G163)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(H152:I163)","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder. \nFormula = Sum of all expenses for the year "]
[]
["Income from Operations",null,null,{"$f":"D149-D164","v":{"v":0,"d":"R0.00"}},null,{"$f":"F149-F164","v":{"v":0,"d":"R0.00"}},null,{"$f":"H149-H164","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder. \nFormula = Gross profit - Operating Expenses for the year "]
[]
["Taxes",{"$nulls":8},"Type is the estimated taxes payable for each year."]
[]
["Net Profit",null,null,{"$f":"D166-D168","v":{"v":0,"d":"R0.00"}},null,{"$f":"F166-F168","v":{"v":0,"d":"R0.00"}},null,{"$f":"H166-H168","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder. \nFormula = Income from Operations - Taxes for the year "]
["Percent of net profit payable to ACSA",{"$nulls":8},"Type is the estimated profit percentage payable for each year for ACSA."]
["Estimated R value",null,null,{"$f":"D170*D171","v":{"v":0,"d":"R0.00"}},null,{"$f":"F170*F171","v":{"v":0,"d":"R0.00"}},null,{"$f":"H170*H171","v":{"v":0,"d":"R0.00"}},null,"No action is required from the Bidder. \nFormula = Net Profit X ACSA Percentage of Net Profit for each year "]

{"sheet":"References","index":6,"n_rows":6,"n_cols":9,"rows_kept":6,"merged":[[0,0,0,8]]}
[{"$f":"\"List of References for Bidder \"&CHAR(10)&Summary!E2","v":"List of References for Bidder \n"}]
["Nature of Bidders Activities","Client or Company Name","Description of the Services Rendered","Practical Completion Date","Project Start Date","Project End Date","Project Value","Contact Person Details: Initials, Surname and  Contact Information","Additional Comments "]
["Select from the list. \nDeveloper mean that your company was responsible for building the infrastructure only.\nOperator = your company was responsible for managing the day-to-day functioning of the service station and any other facilities.\nDeveloper and Operator = your company was responsible for both roles above.\nManaging specialist sub-contractors is assumed.","The name of the Client or Company - this could be your own name if your infrastructure or operation.","Additional space for describing services or functions performed especially those comparable to this proposal","If the project is in progress then state the expected completion time like this eta 2024/06/30 for June 30th 2024.\n\nType the date in this format: YYYY/MM/DD","The date the project started work on site, from site establishment.\n\nType the date in this format: YYYY/MM/DD","The date work on site was concluded\n\nType the date in this format: YYYY/MM/DD","The total all inclusive project value.","Contactable references that ACSA evaluation team may contact regarding the project you specified","Any additional information that can assist the evaluation team or provide supporting information of documentation."]
["Developer","New Fuel (Pty) Ltd","Turnkey construction","eta 2024/11/30","2023-01-16","eta 2024/11/30",{"v":6000000,"d":"R6,000,000.00"},"Mr Abie Gumede, cell 071-480-2323, 1 New Street, Centurion, George, Email Abie@NewFuel.com","This is an example"]
["Operator","Joe Blogg Service Station and Coffee Shop","Existing infrastructure that we refurbished and operated for 16 years","2003-06-30","2002-05-02","2003-05-30",{"v":3000000,"d":"R3,000,000.00"},"Ms Jo-Ann Blogg, office 014-345-6578, 12 Main Road, Upington, JB@JoesService.com","This is an example"]
["Developer and Operator","Our Service Station #1","Developed the site and operate the service station, mechanic workshop and convenience store","2000-12-01","1990-01-21","2000-10-30",{"v":1000000,"d":"R1,000,000.00"},"Mr Jack Black, OurFuel (Pty) Ltd, 26 Jo Slovo Street, New Town, Cape Town, Office: 012-123-4567 email: Jack@BlackFuel.co.za","This is an example"]

{"sheet":"Documentation","index":7,"n_rows":106,"n_cols":4,"rows_kept":106,"merged":[[28,0,28,3],[42,0,42,3],[56,0,56,3],[62,0,62,3],[65,0,65,3],[85,0,85,3],[92,0,92,3]]}
["Document Name\n*If required","Construction","Operation","Handover and Contract Conclusion"]
["Construction Plans","Y"]
["Contact Schedule","Y","Y","Y"]
["Design Development Report","Y"]
["Detailed Design Study of the Mounting Structure incl. calculation sheets","Y"]
["Fire Detection Design","Y"]
["Fire Detection Spare Parts","Y","Y"]
["Fire Water Design",null,null,"Y"]
["Fire Water Spare Parts",null,null,"Y"]
["Hazard Identification and Risk Assessment (HIRA)","Y","Y","Y"]
["Health and Safety Plan",null,"Y","Y"]
["HVAC Design",null,"Y"]
["HVAC Spare Parts","Y"]
["Loop Calculations - Fire Detection ","Y"]
["Material datasheets for Equipment","Y","Y","Y"]
["Meeting Administration like Minutes etc.",null,"Y","Y"]
["Method Statement",null,null,"Y"]
["Minimum inventory list",null,null,"Y"]
["Operational Plans",null,null,"Y"]
["Photo Progress Reports",null,null,"Y"]
["Plumbing Design",null,null,"Y"]
["Plumbing Spare Parts",null,"Y"]
["Progress Progress Reports",null,"Y"]
["Project Management Plan",null,"Y"]
["Risk Response Plan",null,"Y"]
["Safety",null,"Y"]
["Stakeholder Meeting",null,"Y"]
["The Contract Documentation",null,"Y"]
["Applications and Approvals listed but not limited to and where applicable"]
["Council","Y"]
["*Civil Aviation Authority (CAA)","Y"]
["ACSA Permit - Hot Works","Y"]
["ACSA Permit - Safety File","Y"]
["Any Other Regulatory (BY-laws)","Y"]
["Department of Transport","Y"]
["Design Stage Approval","Y"]
["Environmental Impact Assessment (EIA)","Y"]
["ESKOM","Y","Y"]
["Municipal - Approval","Y","Y"]
["Municipal - Building Permit","Y"]
["Municipal - Excavation Permit","Y"]
["Traffic Impact Assessment (TIA)","Y"]
["Drawings, Layouts  listed but not limited to and where applicable"]
["As Build Drawings","Y"]
["Assembly plans and drawing sections of Equipment","Y"]
["Building Layouts and Drawings (formats .pdf .dwg risa)","Y"]
["Design Drawings","Y"]
["Electrical Layouts and Drawings (formats .pdf .dwg risa)","Y"]
["Fire Detection System (formats .pdf .dwg risa)","Y"]
["Fire Water System (formats .pdf .dwg risa)","Y"]
["HVAC System  (formats .pdf .dwg risa)","Y"]
["IT Cabling Layouts and Drawings (formats .pdf .dwg risa)","Y"]
["Mechanical Layouts and Drawings (formats .pdf .dwg risa)","Y"]
["Piping and Instrumentation Diagrams (formats .pdf .dwg risa)","Y"]
["Rough Sketches","Y"]
["Shop Drawings","Y"]
["Manuals listed but not limited to and where applicable"]
["O & M Manual - Plumbing Design",null,null,"Y"]
["Installation methodology for Equipment",null,null,"Y"]
["O & M Manual - Fire Detection Design",null,null,"Y"]
["O & M Manual - Fire Water Design",null,null,"Y"]
["O & M Manual - HVAC Design",null,null,"Y"]
["Specifications listed but not limited to and where applicable"]
["For Equipment",null,null,"Y"]
["For Safe Operation",null,null,"Y"]
["Commissioning and Testing listed but not limited to and where applicable"]
["Test protocols of the Pull-out tests",null,null,"Y"]
["Completion Test for compliance to Grid Code Compliance (national and local grid code compliance)",null,null,"Y"]
["Factory Acceptance Certificates for Equipment",null,null,"Y"]
["Fire Detection Water Pressure Test Results",null,null,"Y"]
["Fire Water: Water Pressure Test Results",null,null,"Y"]
["HVAC Ambient Average Temperature for Heating/Cooling Test Results",null,null,"Y"]
["HVAC Electrical Levels Test Results",null,null,"Y"]
["HVAC Noise Levels Test Results",null,null,"Y"]
["HVAC Pitout Tube Readings to Confirm Total Air Flows Test Results",null,null,"Y"]
["HVAC Refrigeration Piping Pressure Test Results",null,null,"Y"]
["HVAC Refrigeration Piping Vacuum Test Results",null,null,"Y"]
["HVAC Ventilation for Extraction Test Results",null,null,"Y"]
["HVAC Ventilation for Fresh Air Test Results",null,null,"Y"]
["IEC 62446 Phase 1: Provisional Acceptance Test for confirmation that the performance ratio of the plant and design quality, construction and correction operation supervised by an Independent Technical Advisor",null,null,"Y"]
["IEC 62446 Phase 2: Intermediate Acceptance Test for Performance and Availability Verification - 1 year in duration",null,null,"Y"]
["IEC 62446 Phase 3: Final Acceptance Test performed 2 years after Provisional Acceptance Test",null,null,"Y"]
["Mechanical Completion Test for correlation between design and as-built",null,null,"Y"]
["Plumbing Water Pressure Test Results",null,null,"Y"]
["Torque tightening verification values",null,null,"Y"]
["Training listed but not limited to and where applicable"]
["Training records - Attendance register, Certificates",null,"Y","Y"]
["Fire Detection Training Certificates",null,"Y","Y"]
["Fire Water Training Certificates",null,"Y","Y"]
["HVAC Training Certificates",null,"Y","Y"]
["Plumbing Training Certificates",null,"Y","Y"]
["Training material",null,"Y","Y"]
["Certificates listed but not limited to and where applicable"]
["Solar Plant Equipment Certificates","Y",null,"Y"]
["Compliance Certificate - Fire Detection Mechanical Engineer SANS form 4","Y",null,"Y"]
["Compliance Certificate - Fire Detection SANS 10139","Y",null,"Y"]
["Compliance Certificate - Fire Detection SAQCC","Y",null,"Y"]
["Compliance Certificate - Fire Water ASIB","Y",null,"Y"]
["Compliance Certificate - Fire Water Mechanical Engineer SANS form 4","Y",null,"Y"]
["Compliance Certificate - Fire Water SANS 10139","Y",null,"Y"]
["Compliance Certificate - Fire Water SAQCC","Y",null,"Y"]
["Compliance Certificate - HVAC Electrical ","Y",null,"Y"]
["Compliance Certificate - HVAC Mechanical Engineer SANS form 4","Y",null,"Y"]
["Compliance Certificate - HVAC Refrigeration SAQCC","Y",null,"Y"]
["Compliance Certificate - Mechanical Engineer SANS form 4","Y",null,"Y"]
["Compliance Certificate - Plumbing SAQCC","Y",null,"Y"]