{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Instructions","Agency Build","S.1 Respondent Particular","S.2 Methodology and Approach","S.3 Experience and Expertise","S.4 Key Personnel","Instructions for S.5","S.5 Pricing & Resource Mix","Capped Rates","S.6 Reference List","Appendix-->","Capped Expenses","Terms & Definitions","Discount Structure"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":45,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[18,4,18,8],[5,1,5,8],[7,2,7,8],[8,2,8,5],[9,2,9,8],[11,2,13,3],[11,5,11,6],[11,7,13,8],[12,5,12,6],[13,5,13,6],[15,2,15,4],[16,2,16,3],[16,4,16,8],[17,2,17,3],[17,4,17,8],[24,4,24,8],[25,2,26,2],[25,4,25,8],[26,4,26,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,2,23,2],[22,3,23,3],[22,4,22,5],[23,4,23,8]]}
[null,null,null,null,"Instructions for Suppliers\n"]
[null,null,null,null,"PMS (Engagement type 15 only)"]
[null,"PART B - Response Schedule"]
[null,"RFQ Name:",null,"[ RFQ Name ]"]
[null,"RFQ NO. :",null,"[ Insert RFQ Number ]"]
[]
[]
[null,null,"General Instructions"]
[null,null,"Supplier to review each worksheet and provide a response accordingly:\n1. This Response Document should be read in conjunction with Part A",null,null,null,{"$f":"D5","v":"[ Insert RFQ Number ]"}]
[null,null,"2. Supplier is to review each worksheet and provide a response where required in the light yellow shaded cells\n3. Do NOT change the format or structure of this document\n4. Do NOT add any rows or columns to this document (unless there is a button to do that)\n5. If you change the structure of the document it will NOT be considered as a complying bid\n6. A complying bid requires all sections in this RFQ to be completed\n7. All $ bids should be provided in Australian Dollars (AUD), exclusive of the GST\n8. The request covers all engagements across all NSW Government Clusters and Agencies"]
[]
[null,null,"Cell Legend",null,"Table Header","For informational purposes - do not edit",null,"Do NOT change the format or structure of this document. \nDo NOT add any rows or columns to this document (unless there is a button to do that)"]
[null,null,null,null,"Supplier Response","For Suppliers to enter their responses - editable"]
[null,null,null,null,"Locked Cell","These cells are locked and automatically populated, no data input from your side is required. Please do not attempt to modify them"]
[]
[null,null,"There are eight (8) tabs in this Response Schedule"]
[null,null,"Worksheet",null,"Description"]
[null,null,"Instructions",null,"Instructions to complete this workbook. Supplier to review. No response required"]
[null,null,"S.1","Supplier - Respondent  Details","Provide details of your organisation and declare any known conflict of interest relating to this engagement"]
[null,null,"S.2","Methodology and Approach","Provide either a powerpoint (not exceeding 5 slides) or word response (not exceeding 300 words) below"]
[null,null,"S.3","Experience and Expertise","Provide either a powerpoint (not exceeding 5 slides) or word response (not exceeding 300 words) below"]
[null,null,"S.4","Key Personnel and Technical Capability","Provide either a powerpoint (not exceeding 5 slides) or word response (not exceeding 300 words) below"]
[null,null,"S.5","Price and Resource Mix","Pricing model for this engagement will be: "]
[null,null,null,null,"See detailed instructions on tab: `Instructions for S.5`"]
[null,null,"S.6","References ","Provide references (3) of the experience you have had consulting for this category"]
[null,null,"Appendix","Terms & Definitions","Lists the standardised role titles and service definitions for IA engagements. If the supplier's definition/s differ, the listed resource types take precedence. (the supplier must list their organisation's equivalent)"]
[null,null,null,"Capped Expenses","Lists the Expenses policy for each cost element"]

{"sheet":"Agency Build","index":1,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Agency Instructions"]
[null,"PLEASE DELETE THIS TAB UPON COMPLETION OF BELOW SCHEDULE. THIS SCHEDULE IS TO BE SENT AS \"PART B - RESPONSE SHEET\" FOR SUPPLIER SUBMISSION"]
[]
[]
[null,null,"This tab outlines the sections of this commercial framework RFQ response schedule template that the user will need to complete before sending out to suppliers."]
[null,null,"These are listed below along with a link that will take you to the relevant section for completion"]
[]
[null,null,"Instructions "]
[null,null,"Input the RFX Name",null,"Insert RFx Name"]
[null,null,"Input the RFX Number",null,"Insert RFx Number"]
[null,null,"Input the pricing model for this engagement ",null,"Insert Pricing Model"]
[]
[null,null,"S.2 Methodology and Approach"]
[null,null,"Input all questions relating the  consultants method and approach to this engagement",null,"S.2 Methodology and Approach"]
[]
[null,null,"S.3 Experience and Expertise"]
[null,null,"Input all questions relating the  consultants breadth of experience and expertise in the category and service area",null,"S.3 Experience and Expertise"]
[]
[null,null,"S.4 Key Personnel "]
[null,null,"Input all questions relating to the team the consultant intends to use, their roles and experiences",null,"S.4 Key Personnel"]
[]
[null,null,"S.5 Pricing & Resource Mix"]
[null,null,"Review the pricing matrix ",null,"S.5 Pricing & Resource Mix"]
[]
[null,null,"Appendix"]
[null,null,"Refer to appendix for resource mix and disbursement policy information. "]
[]
[null,null,"*Review information upon completion*"]

{"sheet":"S.1 Respondent Particular","index":2,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[13,4,13,6],[6,2,6,7],[7,2,7,7],[10,4,10,6],[11,4,11,6],[12,4,12,6],[29,3,29,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[24,3,24,6],[25,3,27,6]]}
[]
[]
[null,"PART 2A - RFQ Response Spreadsheet","PART B - Response Schedule"]
[null,"RFQ NO: xx",{"$f":"Instructions!B5","v":"RFQ NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFQ Number ]"}]
[]
[]
[null,null,"Instructions for Completion:"]
[null,null,"This worksheet allows you to provide your Company Details\nPlease complete the yellow shaded cells"]
[]
[]
[null,null,null,"Company Details","Response"]
[null,null,null,"Entity Name"]
[null,null,null,"Individuals Name (Sole Proprietor)"]
[null,null,null,"Business Name"]
[null,null,null,"ABN"]
[null,null,null,"ACN"]
[null,null,null,"Registered Office Address"]
[null,null,null,"Site Address"]
[null,null,null,"Postal Address"]
[null,null,null,"Respondent contact name"]
[null,null,null,"Respondent contact number"]
[null,null,null,"Respondent contact email"]
[null,null,null,"Company  - Website"]
[]
[null,null,null,"Conflicts of Interest: In lodging a response to this RFx, are you aware of any real or perceived conflict of interests (including any relevant relationships) existing, which require your disclosure? If yes, please disclose this information below:"]
[]
[]
[]
[]
[null,null,null,"Please confirm that you comply with the following insurance requirements"]
[null,null,null,null,"Indicate Compliance \n(Y / N)","If No please provide Reason"]
[null,null,null,"Public liability cover of $10 million","Comply? (Y/N)"]
[null,null,null,"Professional cover of $10 million ","Comply? (Y/N)"]
[null,null,null,"Workers Compensation insurance ","Comply? (Y/N)"]

{"sheet":"S.2 Methodology and Approach","index":3,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[39,2,48,4],[5,2,5,6],[6,2,6,6],[14,3,14,5],[19,3,19,5],[24,3,24,5]]}
[]
[]
[null,"PART 2A - RFQ Response Spreadsheet","PART B - Response Schedule"]
[null,null,{"$f":"Instructions!B5","v":"RFQ NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFQ Number ]"}]
[]
[null,null,"Instructions for Completion:"]
[null,null,"The following are a list of questions relating to delivery of this engagement.\nAll responses must reflect the project description in Part A - Request for Quotation \nAll responses are to be in PowerPoint presentation format. Please zip all presentations for ease of upload."]
[]
[null,null,"Please provide details regarding the following questions:"]
[]
[null,null,"S.2.1","Please outline your understanding & approach to the delivery of the project outcomes, including indicative timeline. "]
[null,null,null,"What key considerations and insights can you provide with respect to ensuring the success of the delivery of the project?"]
[]
[null,null,null,"Provide either a powerpoint (not exceeding 5 slides) or word response (not exceeding 300 words) below"]
[]
[]
[null,null,"S.2.2","Please provide your stakeholder engagement approach for this project based on information provided in Part A - RFQ section 3.2.2 Stakeholder Engagement and Section 9 Contract Management"]
[]
[null,null,null,"Provide either a powerpoint (not exceeding 5 slides) or word response (not exceeding 300 words) below"]
[]
[]
[null,null,"S.2.3","How will you engage with the dedicated staff on the project to ensure successful knowledge transfer outcomes?"]
[]
[null,null,null,"Provide either a powerpoint (not exceeding 5 slides) or word response (not exceeding 300 words) below"]

{"sheet":"S.3 Experience and Expertise","index":4,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[5,2,5,6],[6,2,6,6],[14,3,14,5],[18,3,18,5]]}
[]
[]
[null,"PART 2A - RFQ Response Spreadsheet","PART B - Response Schedule"]
[null,null,{"$f":"Instructions!B5","v":"RFQ NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFQ Number ]"}]
[]
[null,null,"Instructions for Completion:"]
[null,null,"The following are a list of questions relating to delivery of this engagement.\nAll responses must reflect the Statement of Requirements in Part A - Request for Quotation - [ Please Insert Title ]\nAll responses are to be in PowerPoint presentation format. Please zip all presentations for ease of upload."]
[]
[null,null,"Please provide details regarding the following questions:"]
[]
[]
[null,null,"S.3.1","Please provide insight into your experience and expertise in the category"]
[]
[null,null,null,"Provide either a powerpoint (not exceeding 5 slides) or word response (not exceeding 300 words) below"]
[]
[null,null,"S.3.2","Please provide at a high level, a range of strategic approaches you believe NSW Agency should consider for this project"]
[]
[null,null,null,"Provide either a powerpoint (not exceeding 5 slides) or word response (not exceeding 300 words) below"]

{"sheet":"S.4 Key Personnel","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,2,5,6],[6,2,6,6],[12,3,12,5],[25,2,34,4]]}
[]
[]
[null,"PART 2A - RFQ Response Spreadsheet","PART B - Response Schedule"]
[null,null,{"$f":"Instructions!B5","v":"RFQ NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFQ Number ]"}]
[]
[null,null,"Instructions for Completion:"]
[null,null,"The following are a list of questions relating to delivery of this engagement.\nAll responses must reflect the Statement of Requirements in Part A - Request for Quotation - [ Please Insert Title ]\nAll responses are to be in PowerPoint presentation format. Please zip all presentations for ease of upload."]
[]
[]
[null,null,"S.4.1","Please provide an outline of the key personnel, their roles (according to NSW Government harmonised definitions), their capabilities and any other information related personnel. "]
[]
[null,null,null,"Provide either a powerpoint (not exceeding 5 slides) or word response (not exceeding 300 words) below"]

{"sheet":"Instructions for S.5","index":6,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Infrastructure Advisory Standard Commercial Framework Pricing Template"]
[null,"1) This pricing template is customised for services procured under scheme SCM005 - PMS (engagement type 15)\n2) Supplier to complete this template and attach resource level breakdown when submitting bid for a contract\n3) The template has conditional formats that indicate bids compared with recommended infrastructure advisory standard commercial framework"]
[]
[null,"To use this template, please follow these steps on tab 'S.1 Pricing & Resource Mix':"]
[null,"Step 1. Insert RFT ID"]
[null,"Step 2. Select the pricing model applicable to engagement type"]
[null,"Step 3. Enter estimated engagement start and end dates in the following format DD/MM/YYYY"]
[null,"Step 4. Provide project stages information: Project Stage, Stage Name, Optional Fields 1, 2 and 3 (unhide columns 'E' to 'G' by clicking on '+'), Stage description / Key activities, Stage duration (weeks)"]
[null,"Step 5. Provide resources information. Starting with project stage (dropdown from stages provided on step 4)"]
[null,"Step 6. Select service type from the drop down menu in PMS service type (engagement 15) column"]
[null,"Step 7.  Select service type from the drop down menu in IA service type column. The IA service type column consist of services that are mapped to PMS (engagement type 15) services"]
[null,"Step 8  (Optional). Provide optional information on columns 'E' to 'G' by clicking on '+'. (E.g. resource name, Company role, stages descriptions, etc.)"]
[null,"Step 9.  Select resource type from the drop down menu"]
[null,"Step 10. Select whether the resource is a secondment or not"]
[null,"Step 11. Provide the list of proposed resources daily rate and estimated working days. Please note that details of each individual resource will be in a separate line"]
[null,"Step 12 (Optional). You can add rows if needed by using 'Add_Row_To_Resources' button"]
[null,"Step 13. Provide discount rate as % for secondment and contract size, if applicable"]
[null,"Step 14. Input estimated expenses. Supplier have option to add additional sheet if they need to provide details of reimbursable expenses."]
[null,"Step 15. Input assumptions/comments"]
[null,"Step 16. Sign-off"]
[]
[null,"What do the highlighted colours in the cells mean:"]
[null,"1. Manually entered resource daily rate will highlight to a colour (see legend) based on its variance from the recommended capped rates under the  Infrastructure Advisory Standard Commercial Framework (IA SCF)\n2. The discounts on secondments and contract size discount texts will turn Red if lower than the recommended discounts under the IA SCF\n3. The expense value will turn to Red if above the recommended expense under the IA SCF"]
[]
[null,"Tips: \n1. All manual inputs fields are highlighted in yellow\n2. Ensure macros are enabled within this workbook\n3. The form will highlight daily rates and estimated expenses exceeding the recommended caps in the standard commercial framework"]
[]
[null,"For further assistance/enquiries with this form, please contact NSW Procurement Service Centre on:\n1800 679 289 or email nswbuy@treasury.nsw.gov.au"]

{"sheet":"S.5 Pricing & Resource Mix","index":7,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,1,54,2],[54,3,54,8],[54,10,54,15],[51,2,51,15],[52,1,52,2],[52,3,52,8],[52,10,52,15],[53,1,53,2],[53,3,53,8],[53,10,53,15],[44,1,45,1],[44,2,45,7],[45,9,45,11],[47,1,47,2],[47,3,47,15],[40,1,40,6],[40,7,40,8],[40,9,40,11],[41,9,41,11],[43,1,43,6],[43,9,43,11],[21,11,22,11],[21,12,22,12],[38,1,38,12],[39,1,39,6],[39,7,39,8],[39,9,39,11],[15,2,15,3],[15,7,15,8],[21,14,21,15],[18,2,18,3],[18,7,18,8],[20,1,20,15],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,22,7],[21,8,22,8],[21,9,22,9],[21,10,22,10],[10,7,11,8],[13,2,13,3],[13,7,13,8],[14,2,14,3],[14,7,14,8],[0,9,0,10],[2,3,5,7],[7,1,7,2],[7,3,7,6],[7,11,7,12],[16,2,16,3],[16,7,16,8],[17,2,17,3],[17,7,17,8],[9,1,9,15],[10,1,11,1],[10,2,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,9,11,9],[10,10,11,10],[10,12,11,12],[10,14,10,15],[12,2,12,3],[12,7,12,8]]}
[null,"The IA SCF only applies to PMS (engagement Type 15)",null,"Hidden cells (optional fields) ->"]
[null,null,null,null,null,null,null,null,null,"Daily Rate Legend - comparison with the recommended IA SCF (% above IA SCF)",null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,"<= 10%",null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,">10% to <=25%"]
[null,"RFT ID",null,null,null,null,null,null,null,"> 25%"]
[]
[]
[null,null,null,"Start Date\n(DD/MM/YY)",null,null,null,null,"End Date\n(DD/MM/YY)",null,"Duration \n(working days)",{"$f":"J8-H8","v":0}]
[]
[null,"Project Stages"]
[null,"Project Stage","Stage Name",null,"Optional Field 1","Optional Field 2","Optional Field 3","Stage description / Key activities",null,"Stage duration (weeks)","Estimated resource days\n(1 day = 8 hrs)",null,"Total price before discounts - Subtotal per stage\n(ex GST)",null,"Charged price (After all discounts)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total price after discounts\n(ex GST)"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"IF($B13<>\"\",SUMIF($B$24:$B$36,$B13,K$24:K$36),\"\")","v":0},null,{"$f":"IF($B13<>\"\",SUMIF($B$24:$B$36,$B13,M$24:M$36),\"\")","v":0},null,null,{"$f":"IF($B13<>\"\",SUMIF($B$24:$B$36,$B13,P$24:P$36),\"\")","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"IF($B14<>\"\",SUMIF($B$24:$B$36,$B14,K$24:K$36),\"\")","v":0},null,{"$f":"IF($B14<>\"\",SUMIF($B$24:$B$36,$B14,M$24:M$36),\"\")","v":0},null,null,{"$f":"IF($B14<>\"\",SUMIF($B$24:$B$36,$B14,P$24:P$36),\"\")","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"IF($B15<>\"\",SUMIF($B$24:$B$36,$B15,K$24:K$36),\"\")","v":0},null,{"$f":"IF($B15<>\"\",SUMIF($B$24:$B$36,$B15,M$24:M$36),\"\")","v":0},null,null,{"$f":"IF($B15<>\"\",SUMIF($B$24:$B$36,$B15,P$24:P$36),\"\")","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"IF($B16<>\"\",SUMIF($B$24:$B$36,$B16,K$24:K$36),\"\")","v":0},null,{"$f":"IF($B16<>\"\",SUMIF($B$24:$B$36,$B16,M$24:M$36),\"\")","v":0},null,null,{"$f":"IF($B16<>\"\",SUMIF($B$24:$B$36,$B16,P$24:P$36),\"\")","v":0}]
[null,5,null,null,null,null,null,null,null,null,{"$f":"IF($B17<>\"\",SUMIF($B$24:$B$36,$B17,K$24:K$36),\"\")","v":0},null,{"$f":"IF($B17<>\"\",SUMIF($B$24:$B$36,$B17,M$24:M$36),\"\")","v":0},null,null,{"$f":"IF($B17<>\"\",SUMIF($B$24:$B$36,$B17,P$24:P$36),\"\")","v":0}]
[null,6,null,null,null,null,null,null,null,null,0,null,0,null,null,0]
[null,7,null,null,null,null,null,null,null,null,{"$f":"IF($B19<>\"\",SUMIF($B$24:$B$36,$B19,K$24:K$36),\"\")","v":0},null,{"$f":"IF($B19<>\"\",SUMIF($B$24:$B$36,$B19,M$24:M$36),\"\")","v":0},null,null,{"$f":"IF($B19<>\"\",SUMIF($B$24:$B$36,$B19,P$24:P$36),\"\")","v":0}]
[]
[null,"Resources Breakdown"]
[null,"Project Stage","PMS Service Type (engagement 15)","IA Service Type","Optional Field 1","Optional Field 2","Optional Field 3","Resource Types","Secondment","Daily rate (ex GST) ","Estimated days\n(1 day = 8 hrs)","Estimated days (% of total project duration)","Total price before discounts\n(ex GST)",null,"Charged price (After all discounts)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rate after Discounts","Total price after discounts\n(ex GST)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K24<>\"\",K24/$L$8,\"\"),\"\")","v":""},{"$f":"IF($B24<>\"\",J24*$K24,\"\")","v":""},null,{"$f":"IFERROR($J24*(1-IF(I24=\"Yes\",$H$40,0))*(1-$H$41),0)","v":0},{"$f":"IF($B24<>\"\",O24*$K24,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K25<>\"\",K25/$L$8,\"\"),\"\")","v":""},{"$f":"IF($B25<>\"\",J25*$K25,\"\")","v":""},null,{"$f":"IFERROR($J25*(1-IF(I25=\"Yes\",$H$40,0))*(1-$H$41),0)","v":0},{"$f":"IF($B25<>\"\",O25*$K25,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K26<>\"\",K26/$L$8,\"\"),\"\")","v":""},{"$f":"IF($B26<>\"\",J26*$K26,\"\")","v":""},null,{"$f":"IFERROR($J26*(1-IF(I26=\"Yes\",$H$40,0))*(1-$H$41),0)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K27<>\"\",K27/$L$8,\"\"),\"\")","v":""},{"$f":"IF($B27<>\"\",J27*$K27,\"\")","v":""},null,{"$f":"IFERROR($J27*(1-IF(I27=\"Yes\",$H$40,0))*(1-$H$41),0)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,"","",null,{"$f":"IFERROR($J28*(1-IF(I28=\"Yes\",$D$40+$I$40,0))*(1-$D$41-$I$41),0)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,"","",null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K30<>\"\",K30/$L$8,\"\"),\"\")","v":""},{"$f":"IF($B30<>\"\",J30*$K30,\"\")","v":""},null,0,{"$f":"IF($B30<>\"\",O30*$K30,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"","",null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,"","",null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,"","",null,{"$f":"IFERROR($J33*(1-IF(I33=\"Yes\",$D$40+$I$40,0))*(1-$D$41-$I$41),0)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,"","",null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF($B35<>\"\",J35*$K35,\"\")","v":""},null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,"","",null,0,""]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUMIF(B24:B36,\"<>\"&\"\",K24:K36)","v":0},null,{"$f":"SUM(M24:M36)","v":0},null,"Total",{"$f":"SUM(P24:P36)","v":0}]
[]
[null,"Discounts"]
[null,"Secondment Discount",null,null,null,null,null,0.1,null,"Total secondment Discount",null,null,{"$f":"SUMIF($I$24:$I$36,\"Yes\",$M$24:$M$36)*(H40)","v":0}]
[null,"Contract Size discount structure (%) for above $5M ",null,null,null,null,null,7.0000000000000007E-2,null,"Total Contract Size Discount",null,null,{"$f":"(IF(($M$37-$M$40)>'Discount Structure'!$A$4,(M37-M40)*(H41),0))","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Discount $ (ex GST)",null,null,{"$f":"M40+M41","v":0}]
[]
[null,"Maximum expenses estimated (ex GST) - **Recommeded maximum expenses is 7% of total engagement price after discount",null,null,null,null,null,null,null,"Total engagement price after discount (ex GST)",null,null,{"$f":"M37-M42","v":0}]
[null,"Expenses details (optional)"]
[null,null,null,null,null,null,null,null,null,"Total engagement price after discount and expenses (ex GST)",null,null,{"$f":"H44+M44","v":0}]
[]
[null,"Assumptions/Comments"]
[]
[]
[]
[null,null,"Supplier sign-off"]
[null,"Name",null,null,null,null,null,null,null,"Role"]
[null,"Organisation Name",null,null,null,null,null,null,null,"ABN"]
[null,"Signature",null,null,null,null,null,null,null,"Date"]

{"sheet":"Capped Rates","index":8,"n_rows":12,"n_cols":22,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,8,0,14]]}
[null,"Index","Value",null,null,null,null,null,"Standardised NSW Government Role Type1"]
["Engagement Type",0,{"$f":"IF('Capped Rates'!B2=1, \"Fixed Price\", IF('Capped Rates'!B2=2,\"Time and materials - capped\",IF('Capped Rates'!B2=3,\"Risk/reward - outcome based\", IF('Capped Rates'!B2=4, \"Time and  materials - uncapped\"))))","v":false},null,"2022-03-31",null,null,null,"Graduate/Analyst","Professional / Consultant","Senior Professional / Senior Consultant","Associate / Manager","Principal / Senior Manager","Senior Principal / Director","Executive/ Partner",null,null,"Communication","Contracting","Major Project Procurement/Delivery and Project Management","Risk","Strategy and Planning"]
["Pricing Model",3,{"$f":"IF('Capped Rates'!B3=1, \"Fixed Price\", IF('Capped Rates'!B3=2,\"Time and materials - capped\",IF('Capped Rates'!B3=3,\"Risk/reward - outcome based\", IF('Capped Rates'!B3=4, \"Time and  materials - uncapped\"))))","v":"Risk/reward - outcome based"},null,null,null,null,"Service Strategy and Planning",1085,1340,1750,2100,2600,3000,3600,null,null,"Communication and Stakeholder Engagement","Contract and Financial Management","Design Management","Risk Management","Business Case and Economics"]
["Secondment",1,{"$f":"IF(B4=1, \"TRUE\", \"FALSE\")","v":"TRUE"},null,null,null,null,"Business Case and Economics",1085,1340,1750,2100,2600,3000,3600,null,null,null,null,"Program and Project Management",null,"Service Strategy and Planning"]
[null,null,null,null,null,null,null,"Risk Management",1050,1370,1580,1890,2240,2480,2710,null,null,null,null,"Project Control and Scheduling"]
[null,null,null,null,null,null,null,"Program and Project Management",1080,1360,1500,1650,1890,2070,2410,null,null,null,null,"Project Governance"]
[null,null,null,null,null,null,null,"Project Control and Scheduling",1100,1300,1500,1690,1890,2090,2430,null,null,null,null,"Transaction Management"]
[null,null,null,null,null,null,null,"Project Governance",1040,1230,1620,1910,2150,2430,2920]
[null,null,null,null,null,null,null,"Design Management",760,870,1270,1610,1880,2120,2300]
[null,null,null,null,null,null,null,"Transaction Management",1085,1285,1700,2100,2550,2900,3500]
[null,null,null,null,null,null,null,"Contract and Financial Management",1085,1285,1700,2100,2550,2900,3500]
[null,null,null,null,null,null,null,"Communication and Stakeholder Engagement",890,1210,1510,1810,2100,2390,2670]

{"sheet":"S.6 Reference List","index":9,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[[7,1,7,3],[9,1,11,1],[9,2,11,2],[12,2,13,3],[14,1,21,1],[14,2,21,3],[24,1,24,3],[26,1,28,1],[26,2,28,2],[29,2,30,3],[31,1,38,1],[31,2,38,3],[41,1,41,3],[43,1,45,1],[43,2,45,2],[46,2,47,3],[48,1,55,1],[48,2,55,3]]}
[]
[]
[null,"PART B - Response Schedule"]
[null,{"$f":"Instructions!B5","v":"RFQ NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFQ Number ]"}]
[]
[null,"Please provide 3 references on your consultancy experiences for this engagement type.  "]
[]
[null,"Reference 1 "]
[null,"Contact Name","Position/Title","Contact Details"]
[null,null,null,"Email:"]
[null,null,null,"Phone:"]
[null,null,null,"Mobile:"]
[null,"Project Title & "]
[null,"Location:"]
[null,"Project Scope:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Reference 2 "]
[null,"Contact Name","Position/Title","Contact Details"]
[null,null,null,"Email:"]
[null,null,null,"Phone:"]
[null,null,null,"Mobile:"]
[null,"Project Title & "]
[null,"Location:"]
[null,"Project Scope:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Reference 3"]
[null,"Contact Name","Position/Title","Contact Details"]
[null,null,null,"Email:"]
[null,null,null,"Phone:"]
[null,null,null,"Mobile:"]
[null,"Project Title & "]
[null,"Location:"]
[null,"Project Scope:"]

{"sheet":"Appendix-->","index":10,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"The following two tabs are for your information only. "]

{"sheet":"Capped Expenses","index":11,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[21,2,21,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[29,2,29,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,28,2]]}
[]
[]
[null,"PART 2A - RFQ Response Spreadsheet","PART B - Response Schedule"]
[null,null,{"$f":"Instructions!B5","v":"RFQ NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFQ Number ]"}]
[]
[]
[]
[null,null,"Cost Element",null,"Expenses Policy"]
[null,null,"Expenses Cap",null,"All expenses will be capped at 7% of engagement fees "]
[null,null,"Couriers",null,"At Cost "]
[null,null,"Database and Market Research",null,"No Charge "]
[null,null,"Airfares",null,"Lowest available fare of the day "]
[null,null,null,null,"Maximise advance bookings  "]
[null,null,null,null,"Economy only at cost "]
[null,null,null,null,"At Cost, using Contract 1008 Travel Management Services through FCM, or lower using other means"]
[null,null,"Car Hire",null,"At Cost, using Contract 1008 Travel Management Services through FCM, or lower using other means"]
[null,null,"Accommodation ",null,"At Cost, using Contract 1008 Travel Management Services through FCM, or lower using other means"]
[null,null,"Other Travel",null,"At Cost"]
[null,null,"Meals - Breakfast ",null,"At Cost <$30/day"]
[null,null,"Meals - Lunch ",null,"No Charge "]
[null,null,"Meals - Dinner ",null,"At Cost < $50/day "]
[null,null,"Taxi ",null,"At Cost - prior approval for circumstances other than to/from airports, leaving office after 8 pm, meetings where multiple sites are used"]
[null,null,"Tips & Gratuities ",null,"No Charge "]
[null,null,"Room Hire & catering",null,"At Cost "]
[null,null,"Stationery & postage",null,"No Charge "]
[null,null,"Photocopying",null,"No Charge "]
[null,null,"Telephone & Fax",null,"No Charge "]
[null,null,"Wireless Internet Fees","On (NSW Govt) Site","At Cost "]
[null,null,null,"Off Site","No Charge "]
[null,null,"Secretarial & clerical",null,"No Charge "]

{"sheet":"Terms & Definitions","index":12,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,2,5,6],[13,5,14,5],[20,3,21,3],[22,3,26,3],[17,2,17,6]]}
[]
[]
[null,"PART 2A - RFQ Response Spreadsheet","PART B - Response Schedule"]
[null,null,{"$f":"Instructions!B5","v":"RFQ NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFQ Number ]"}]
[]
[null,null,"Table S.1 - Role titles and descriptions"]
[]
[null,null,null,"Resource type","Description","Minimum years of relevant experience guide"]
[null,null,null,"Graduate / Analyst","Performs data gathering and analysis with technical skills. Low level of industry knowledge.  Works under supervision by more senior team members.","0-2"]
[null,null,null,"Professional / Consultant","Higher level technical skills, broader experience base, business process & industry knowledge.  Requires limited supervision and may lead analyst/ graduate.","2-4"]
[null,null,null,"Senior Professional / Senior Consultant","Field team leadership role, moderate level of technical and subject matter expertise. Further competencies include critical thinking and comms skills and ability to lead simple engagements  ","4-8"]
[null,null,null,"Associate / Manager","Junior management level, specialist technical and subject matter expertise; leads more complex engagements and manages assignment schedules and resource allocation. Ability to lead at client meetings and choose an appropriate solution in responding to a client’s needs.  Authors proposals and pitches.","8+"]
[null,null,null,"Principal / Senior Manager","Senior employee with significant specialist expertise and team leadership capabilities. Practice lead with project management, consulting and facilitation skills and high quality written comms skills including proposals, reports, contractual letters and project plans.   ","10+"]
[null,null,null,"Senior Principal / Director","Management member and experienced practitioner within the industry. Provides strategic and technical advice and leads technical teams. Key in sales activity and client relationship management","15+"]
[null,null,null,null,"Alternately: SME / Domain expert with deep technical skills but limited leadership responsibility"]
[null,null,null,"Executive/ Partner","Senior Management member and highly experienced practitioner with a broad range of experience within the industry. Provides strategic advice and manages overall commercial strategy. Manages senior client relationships at a strategic level.","15+"]
[]
[null,null,"Table S.2 - Service types and descriptions"]
[]
[null,null,null,"Performance Management Services Scheme SCM0005 (Engagement type 15) Sub-engagement Types","Infrastructure Advisory Service Type","Definitions"]
[null,null,null,"Strategy and Planning","Service Strategy and Planning","Defines the core services and outcomes to be delivered to the community,  by a single asset, across an asset portfolio or across a single domain (e.g. Light Rail, a new school) or through a community, town or urban masterplan. Identifies service needs, volumes, performance requirements, metrics, required delivery timescales.  Includes peer review assessment."]
[null,null,null,null,"Business Case and Economics","Evaluates prospective alternatives to meet the service need, comparing alignment with objectives, socio-economic  impact, feasibility, financial appraisal and funding alternatives, delivery model and risks. Includes the definition of project objectives, scope, purpose, deliverables and peer review assessment."]
[null,null,null,"Major Project Procurement/Delivery and Project Management","Program and Project Management","Establishes program/project leadership and executes program/project plans, monitoring and controlling the development of the program/project according to Cost Management plans and Stakeholders and Communication Management plans. The service also includes project initiation, contract management and administration and peer review assessment."]
[null,null,null,null,"Project Control and Scheduling","Monitors cost and schedules, including conducting lifecycle cost analysis, Critical Path Method analysis and scheduling. It reviews and monitors project activities, generates progress against planned reports and recommends actions to recover schedule or improve efficiency.  Contributes to planning and project management activities within a larger project or program. Includes peer review assessment."]
[null,null,null,null,"Project Governance","Designs and establishes a framework for decision making in Infrastructure Programs and Projects. Includes approval pathways, quality assurance mechanisms, stakeholder management approaches, points of accountability. Includes executing processes to oversee program and project progress, and providing peer review assessment."]
[null,null,null,null,"Design Management","Manages the design process including planning and initiating a design, managing and controlling the design process to meet specifications, budget and time constraints. Contributes to planning and project management activities within a larger project or program. Includes peer review assessment."]
[null,null,null,null,"Transaction Management","Plans, executes and manages the procurement process required for successful project delivery across diverse delivery models including Design & Construct (D&C), Construct-only and PPP, by undertaking EOI management, evaluation and shortlisting, tender document preparation, bid and tender evaluation, negotiation and award. Includes peer review assessment."]
[null,null,null,"Contracting","Contract and Financial Management","Manages the contract post-establishment including administering contract requirements on behalf of the client, interpreting and enforcing contract terms and conditions, monitoring contract progress, identifying and resolving any contract issues and managing the termination or renewal of the contract upon its expiration. Also included contract negotiation whenever required.\nForecasts and manages the expenditures of the project, monitoring finances and identifying potential cost risks to prevent spend over budget by collaborating with both internal and external parties, from clients to stakeholders, and provides peer review assessment."]
[null,null,null,"Communication","Communication and Stakeholder Engagement","Advises in management of organisational reputation with the external media or general public, reviewing and developing public relations strategies and planning.\nDevelops community and stakeholders engagement plans, speeches and presentations for internal/external use including technical writing and graphic design activities such as brochures, reports, maps and infographics and provides facilitation services. Develops responses and communication plans for the management of issues. Also includes workshop facilitation and report preparation."]
[null,null,null,"Risk","Risk Management","Identifies, evaluates and manages project risks by designing the risk management strategy and executing risk management plans. Includes identifying, implementing and monitoring mitigation measures needed to prevent exposure to risk, managing and operating risk register and ensuring appropriate communication to project stakeholders. Contributes to planning and project management activities within a larger project or program, and provides peer review assessment."]

{"sheet":"Discount Structure","index":13,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[[2,0,2,1]]}
["Secondment",0.1]
[]
["Contract Size"]
[5000000,7.0000000000000007E-2]