{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","AGENCY BUILD","S.1 Respondent Particulars","S.2 Methodology and Approach","S.3 Experience and Expertise","S.4 Key Personnel ","Instructions for S.5.","S.5 Pricing & Resource Mix","S.6 Reference List","Appendix -->","P&MS Engagement Types Overview","Definition Guide","Capped Expenses","Capped Rates","Discount Structure","Working Holidays"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":1,"defined_names":29,"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":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[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],[25,2,27,2],[27,4,27,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[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]]}
[null,null,null,null,"Instructions for Suppliers"]
[]
[null,"PART B - Response Schedule"]
[null,"RFx Name:",null,"[ RFx Name ]"]
[null,"RFx NO. :",null,"[ Insert RFx 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 Request for Quotation Part A – Specification and any other relevant documents. ",null,null,null,{"$f":"D5","v":"[ Insert RFx 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\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."]
[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 six (6) 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","Respond to the questions listed in PowerPoint format. Maximum 5 page limit"]
[null,null,"S.3","Experience and Expertise","Please provide response to the questions listed in PowerPoint format. Maximum 5 page limit"]
[null,null,"S.4","Key Personnel and Technical Capability","Please provide response to the questions listed in PowerPoint format. Maximum 5 page limit"]
[null,null,"S.5","Price and Resource Mix","Pricing model for this engagement will be: "]
[null,null,null,null,"To use this checklist, please follow these steps:\nStep 1. Select an capped rate description from 1-6.\nStep 2. Select the pricing model applicable.\nStep 3. Select whether this engagement is a secondment or not.\nStep 4. Enter estimated engagement start and end dates in the following format DD/MM/YY.\nStep 5. Provide the list of proposed resources specifying: resource type, daily rate, and estimated working days.\nStep 6. Provide additional discount rate as % if applicable.\nStep 7. Input estimated expenses."]
[null,null,"S.6","References ","Please provide references (3) of the experience you have had consulting for this category.  "]
[null,null,"Appendix","P&MS Engagement Types Overview","Provides list of engagement types and sub-engagement types under the P&MS scheme. It also provides mapping of engagement types 1-12 into six (6) high level groupings in line with the BAS standard commercial framework."]
[null,null,null,"Definition Guide","1. Lists the standardised resource types and definitions for P&MS engagements. If the supplier's definition/s differ, the listed resource types take precedence.\n2. Lists the definitions for \"Assignment\" and \"Secondment\" applicable under P&MS scheme engagements.\n3. List the definitions for Pricing Models applicable under P&MS Scheme engagements."]
[null,null,null,"Capped Expenses","Please confirm compliance to the capped expenses policy. There is a section in tab S.5 to insert estimated expenses."]

{"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,"Please input the RFX Name",null,"Insert RFx Name"]
[null,null,"Please input the RFX Number",null,"Insert RFx Number"]
[null,null,"Please input the pricing model for this engagement ",null,"Insert Pricing Model"]
[]
[null,null,"S.2 Methodology and Approach"]
[null,null,"Please 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,"Please 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,"Please 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,"Please 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 Particulars","index":2,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[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],[13,4,13,6],[6,2,6,7],[7,2,7,7],[10,4,10,6],[11,4,11,6],[12,4,12,6]]}
[]
[]
[null,"PART 2A - RFQ Response Spreadsheet","PART B - Response Schedule"]
[null,"RFQ NO: xx",{"$f":"Instructions!B5","v":"RFx NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFx 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,"Insurance conditions identified by the Principal","Comply? (Y/N)"]
[null,null,null,"Indemnity conditions identified by the Principal","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":"RFx NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFx 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 5 slide PowerPoint or 300 word response 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,"Please provide either a 5 slide PowerPoint or 300 word response below"]
[]
[]
[null,null,"S.2.2","How will you engage with the dedicated staff on the project to ensure a successful knowledge transfer outcomes?"]
[]
[null,null,null,"Provide either a 5 slide PowerPoint or 300 word response 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":"RFx NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFx 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 5 slide PowerPoint or 300 word response 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 5 slide PowerPoint or 300 word response 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":"RFx NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFx 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 5 slide PowerPoint or 300 word response below"]

{"sheet":"Instructions for S.5.","index":6,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Standard commercial framework compliance checklist"]
[null,"This compliance checklist verifies whether the proposal is compliant with the standard commercial framework. "]
[]
[null,"To use this checklist, please follow these steps:"]
[null,"Step 1. Select an Capped Rate type from 1-6."]
[null,"Step 2. Select the pricing model applicable."]
[null,"Step 3. Select whether this engagement is a secondment or not."]
[null,"Step 4. Enter estimated engagement start and end dates in the following format DD/MM/YY."]
[null,"Step 5. Provide the list of proposed resources specifying: resource type, daily rate, and estimated working days."]
[null,"Step 6. Provide additional discount rate as % if applicable."]
[null,"Step 7. Input estimated expenses."]
[]
[null,"Tips: \n1. All manual inputs fields are highlighted in yellow.\n2. Ensure macros are enabled within this workbook.\n3. The form will not allow daily rates and estimated expenses exceeding the caps in the standard commercial framework.\n4. Engagement start and end dates are limited between 7/1/2020 - 31/12/2029."]
[]
[]
[null,"For further assistance/enquiries with this form, please contact NSW Procurement Service Centre on:\n1800 679 289 or email professionalservices@treasury.nsw.gov.au"]

{"sheet":"S.5 Pricing & Resource Mix","index":7,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[35,1,35,5],[36,4,36,5],[37,4,37,5],[28,1,28,3],[30,4,30,5],[31,4,31,5],[32,1,32,2],[32,4,32,5],[33,1,33,2],[33,3,33,5],[12,1,13,2],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[0,3,0,4],[1,2,1,4],[2,2,3,4],[5,1,5,5],[11,1,11,2],[11,3,11,5]]}
[null,null,null,"P&MS Scheme (SCM005)"]
[null,null,"Supplier - engagement compliance checklist for standard commercial framework"]
[null,null,"Suppliers to complete and attach this checklist when submitting their offer by selecting grouped engagement type from 1-6, which are mapped to the Engagement Types 1-12 (BAS) of the P&MS Scheme to confirm that the standard commercial framework requirements have been met."]
[]
[null,null,null,null,"Agency Reference no."]
[null,"Grouped Engagement Type"]
[]
[]
[]
[]
[]
[null,"Pricing model",null,"Timeframe"]
[null,null,null,"Start Date\n(DD/MM/YY)"]
[null,null,null,"End Date\n(DD/MM/YY)"]
[null,"Secondment",null,"Duration1 \n(working days)",{"$f":"IF(E13=\"\",\"\",IF(NETWORKDAYS(E13,E14)<0,0,NETWORKDAYS(E13,E14,'[1]Working Holidays'!B2:M10)))","v":""}]
[null,"Engagement","Resource Types","Daily rate (ex GST) ","Estimated days\n(1 day = 8 hrs)","Total costs \n(ex GST)"]
[]
[null,null,null,null,null,{"$f":"D18*E18","v":0}]
[null,null,null,null,null,{"$f":"D19*E19","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"$D$28*$E$28","v":0}]
[null,"Total estimated days2|Total costs:",null,null,{"$f":"SUM(INDIRECT(\"E18:E\"&ROW()-1))","v":0},{"$f":"SUM(INDIRECT(\"F18:F\"&ROW()-1))","v":0}]
[]
[null,"Discount structure (%)",{"$f":"IF('Capped Rates'!$C$4=\"TRUE\",10%,VLOOKUP(F29,'Discount Structure'!A10:C14,2,TRUE))","v":0}]
[null,"Maximum expenses estimated**\n(ex GST)",null,null,{"$f":"IF(C31=\"\",(F29*(Add_Discount)),(F29*(C31+Add_Discount)))","v":0}]
[null,"**Expenses are capped at 7% of total engagement cost after discount",null,"Total engagement cost\nafter discount\n(ex GST)",{"$f":"F29-E32","v":0}]
[null,"Estimated engagement cost after discounts and expenses (ex GST)",null,{"$f":"Max_Expenses+Total_Eng_After_Disc","v":0}]
[]
[null,"Internal (client) sign-off"]
[null,"Name",null,"Role"]
[null,"Signature",null,"Date"]

{"sheet":"S.6 Reference List","index":8,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[[41,1,41,3],[43,1,45,1],[43,2,45,2],[46,2,47,3],[48,1,55,1],[48,2,55,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],[7,1,7,3],[9,1,11,1],[9,2,11,2],[12,2,13,3],[14,1,21,1],[14,2,21,3]]}
[]
[]
[null,"PART B - Response Schedule"]
[null,{"$f":"Instructions!B5","v":"RFx NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFx 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":9,"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":"P&MS Engagement Types Overview","index":10,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[8,1,12,1],[8,4,12,4],[13,1,15,1],[13,4,15,4]]}
[]
[null,"P&MS Scheme (SCM0005) - Engagement Types Overview"]
[null,"The Standard Commercial Framework applies to Engagement Types 1 to 12 that are mapped to 6 high level groupings. "]
[null,"Grouped Engagement Types","P&MS Scheme Eng. No.","Engagement Type","Sub-engagement Types"]
[null,"Government & Business Strategy",1,"Government & Business Strategy","1a. Strategy development and planning, \n1b. Strategic business case, \n1c. Business performance reviews, \n1d. Organisational design / transformation, \n1e. Business intelligence, \n1f. Cost management,\n1g. Governance, \n1h. Policy review / development"]
[null,"Financial Services",5,"Financial Services","5a. Accounting services, \n5b. Accounting standards,\n5c.  Finance process reviews, \n5d. Asset management, \n5e. Valuations, \n5f. Financial / economic advisory services,\n5g. Forensic advisory"]
[null,"Audit, Quality Assurance and Risk",6,"Audit, Quality Assurance and Risk","6a. Internal / external audit, \n6b. Risk management, \n6c. Probity services"]
[null,"Marketing and Customer",10,"Marketing and Customer","10a. Market research, \n10b. Customer / customer experience, pricing"]
[null,"Operations",2,"Business Processes","2a. Business process mapping / re-engineering,\n3a. Project management, \n4a. Change management,\n8a. Human capital management, \n8b. Culture, \n8c. Work health and safety (WHS), \n8d. Remuneration, \n8e. Retention, \n8f. Diversity, \n9a. Procurement / sourcing, \n9b. Category management, \n9c. Procurement accreditation, \n9d. Supply chain"]
[null,null,3,"Project Management"]
[null,null,4,"Change Management"]
[null,null,8,"Human Resources"]
[null,null,9,"Procurement & Supply Chain"]
[null,"Transaction, Actuarial, Taxation",7,"Taxation","7a. Goods and services tax (GST), \n7b. Other tax services,\n11a. Actuarial services, \n12a. Transaction services"]
[null,null,11,"Actuarial Services"]
[null,null,12,"Transaction Services"]

{"sheet":"Definition Guide","index":11,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,2,23,3],[1,1,1,3],[2,1,2,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[17,1,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3]]}
[]
[null,"Resource type and definitions guide"]
[null,"The following resource types to be used to obtain quotes from Suppliers. "]
[null,"Resource type","Description","Minimum years of relevant experience guide"]
[null,"Partner","Senior management member",12]
[null,"Director","Management member with deep expertise",10]
[null,"Senior Manager","Senior employee with significant specialist expertise and team leadership capabilities",8]
[null,"Manager","Junior level of entity management, specialist technical and subject matter expertise; manages assignment schedules and resource allocation",6]
[null,"Senior Consultant","Field leadership role, moderate level of technical and subject matter expertise; provides business system advice and consulting services",4]
[null,"Consultant","Performs detailed data and systems analysis, identifies risks, gathers additional data, interprets data and provides recommendations for improvement.  Higher level technical skills, broader experience base, business process & industry knowledge and requiring less supervision than an analyst",2]
[null,"Analyst","Performs data gathering and analysis with strong technical skills. Low level of industry knowledge.  Supervised by more senior members.","0 - 4"]
[]
[null,"Terms","Definition"]
[null,"Assignment","Assignment is a form of Engagement with specific Deliverables, and management of the Engagement is the responsibility of the supplier."]
[null,"Secondment","Secondment is a form of Engagement where the Supplier’s personnel work under the Agency’s supervision and direction to provide Services and/or Deliverables.  "]
[null,"Variation","Variation means any change to an Engagement, including any addition, increase, decrease, omission, removal to or from the scope, timeframe, fees or requirements for an Engagement. "]
[]
[null,"Pricing Models"]
[null,"Pricing Model","The method used to determine the price for products and services. (e.g. Fixed Price,  Time and Material - Capped, Time and Material - Uncapped, Outcome based Risk & Reward)"]
[null,"Fixed Price","The cost for an engagement is agreed as fixed price by both parties before the engagement starts based on a defined scope and deliverables, and is not affected by the actual amount of resources utilised. However, supplier must submit the breakdown of the Fixed Price by Resource Types and Daily rates in compliance with Standard Commercial Framework. \nAny Variations in scope or deliverables after contract award may generate changes to the fixed price."]
[null,"Time and Materials- Capped","The cost for an engagement depends on the actual amount of resources required to achieve the desired outcomes and is variable. Commercials are agreed before the engagement starts at a Daily Rate level for each Resource Type (cost per day of a resource x the number of days). The supplier invoices the client for the full amount of resources utilised during a particular period up to or equal to the agreed capped amount and cannot be exceeded. Engagement cost is capped as agreed between the parties in the contract."]
[null,"Time and Materials- Uncapped","The total cost for an engagement depends on the actual amount of resources required to achieve the desired outcomes and is variable. Commercials are agreed before the engagement starts at a Daily Rate level for each Resource Type (cost per day of a resource x the number of days). The supplier invoices the client for the full amount of resources utilised during a particular period. The engagement cost is not capped."]
[null,"Risk and Reward - Outcome based","The cost for an engagement depends on the supplier’s ability to meet defined outcomes rather than for the actual resourcing requirements and expenses. The supplier is financially rewarded for exceeding expectations but risks penalty or non-payment if outcomes are not delivered. Outcomes based Risk/ Reward is often difficult to monitor and measure and may lead to disputes between parties."]
[null,"Daily","A day is defined as 8 hours of work"]

{"sheet":"Capped Expenses","index":12,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[23,2,23,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],[21,2,21,3],[22,2,22,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,28,2],[29,2,29,3]]}
[]
[]
[null,"PART 2A - RFQ Response Spreadsheet","PART B - Response Schedule"]
[null,null,{"$f":"Instructions!B5","v":"RFx NO. :"},{"$f":"Instructions!D5","v":"[ Insert RFx Number ]"}]
[]
[]
[]
[null,null,"Cost Element",null,"Disbursements Policy"]
[null,null,"Disbursements Cap",null,"All disbursements 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":"Capped Rates","index":13,"n_rows":8,"n_cols":17,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,8,0,14]]}
[null,"Index","Value",null,null,null,null,null,"Standardised NSW Government Role Type1",null,null,null,null,null,null,null,"Engagement"]
["Engagement Type",1,{"$f":"IF('Capped Rates'!B2=1,\"Government and business strategy\",IF('Capped Rates'!B2=2,\"Audit, Quality Assurance and Risk\",IF('Capped Rates'!B2=3,\"Marketing and Customer\",IF('Capped Rates'!B2=4,\"Financial Services\",IF('Capped Rates'!B2=5,\"Operations\",IF('Capped Rates'!B2=6,\"Transaction, Actuarial, Taxation\"))))))","v":"Government and business strategy"},null,"2022-03-31",null,null,null,"Partner","Director","Senior Manager","Manager","Senior Consultant","Consultant","Analyst",null,"Initial engagement"]
["Pricing Model",0,{"$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":false},null,null,null,null,"Government and Business Strategy",3600,3000,2600,2100,1750,1340,1085,null,"Variation "]
["Secondment",0,{"$f":"IF(B4=1, \"TRUE\", \"FALSE\")","v":"FALSE"},null,null,null,null,"Audit, Quality Assurance and Risk",3350,2750,2600,2100,1400,1185,980,null,"Flow-on"]
[null,null,null,null,null,null,null,"Marketing and Customer",3100,2700,2550,2100,1750,1285,1085]
[null,null,null,null,null,null,null,"Financial Services",3500,2900,2550,2100,1700,1285,1085]
[null,null,null,null,null,null,null,"Operations",3500,2900,2550,2100,1700,1285,1085]
[null,null,null,null,null,null,null,"Transaction, Actuarial, Taxation",4025,3700,3050,2450,2200,1900,1650]

{"sheet":"Discount Structure","index":14,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":true,"merged":[[0,1,0,5],[0,6,1,6],[2,6,6,6]]}
[null,null,null,null,null,null,"Secondment"]
[null,1,4.0000000000001004,10,20,50]
[0,0,0,0.01,0.03,0.04,0.1]
[4,0,0,0.03,0.04,0.05]
[12,0.01,0.03,0.04,0.05,7.0000000000000007E-2]
[24,0.03,0.04,0.05,0.08,0.08]
[40,0.04,0.05,7.0000000000000007E-2,0.08,0.1]
[]
[]
[0,0]
[250000.01,0.02]
[500000.01,0.05]
[1000000.01,7.0000000000000007E-2]

{"sheet":"Working Holidays","index":15,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Description",2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029]
["New Years Day","2018-01-01","2019-01-01","2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01"]
["Australia Day","2018-01-26","2019-01-28","2020-01-27","2021-01-26","2022-01-26","2023-01-26","2024-01-26","2025-01-27","2026-01-26","2027-01-26","2028-01-26","2029-01-26"]
["Good Friday","2018-03-30","2019-04-19","2020-04-10","2021-04-02","2022-04-15","2023-04-07","2024-03-29","2025-04-18","2026-04-03","2027-03-26","2028-04-14","2029-03-30"]
["Easter Monday","2018-04-02","2019-04-22","2020-04-13","2021-04-05","2022-04-18","2023-04-10","2024-04-01","2025-04-21","2026-04-06","2027-03-29","2028-04-17","2029-04-02"]
["Anzac Day","2018-04-25","2019-04-25","2020-04-25","2021-04-25","2022-04-25","2023-04-25","2024-04-25","2025-04-25","2026-04-25","2027-04-25","2028-04-25","2029-04-25"]
["Queens Birthday","2018-06-11","2019-06-10","2020-06-08","2021-06-13","2022-06-13","2023-06-12","2024-06-10","2025-06-09","2026-06-08","2027-06-14","2028-06-12","2029-06-11"]
["Labour Day","2018-10-01","2019-10-07","2020-10-05","2021-10-04","2022-10-03","2023-10-02","2024-10-07","2025-10-06","2026-10-05","2027-10-04","2028-10-02","2029-10-01"]
["Christmas Day","2018-12-25","2019-12-25","2020-12-25","2021-12-25","2022-12-25","2023-12-25","2024-12-25","2025-12-25","2026-12-25","2027-12-25","2028-12-25","2029-12-25"]
["Boxing Day","2018-12-26","2019-12-26","2020-12-26","2021-12-26","2022-12-26","2023-12-26","2024-12-26","2025-12-26","2026-12-26","2027-12-26","2028-12-26","2029-12-26"]