{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["A. Summary","B. QA Key Staff","C. Additional QA Staff","D. QA Suplemental Staff","E. QA Cost Proposal Signature","Reference Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":2,"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":"A. Summary","index":0,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,18,3]]}
["Medicaid Quality Assurance Services "]
["Cost Proposal Summary "]
["Schedule A"]
["Offeror: ",{"$f":"'B. QA Key Staff'!D3","v":0}]
[null,null,null,null,null,null,null,null,"Department approved option for one 3-year extension "]
[]
["Pricing Element","Contract Year 1","Contract Year 2","Contract Year 3","Contract Year 4","Contract Year 5","Contract Year 6","Contract Year 7","Contract Year 8","Contract Year 9","Contract Year 10"]
[" QA Key and Additional Staff\n    (Schedule B and C)",{"$f":"SUM('B. QA Key Staff'!C49+'C. Additional QA Staff'!D39)","v":0},{"$f":"SUM('B. QA Key Staff'!D49+'C. Additional QA Staff'!E39)","v":0},{"$f":"SUM('B. QA Key Staff'!E49+'C. Additional QA Staff'!F39)","v":0},{"$f":"SUM('B. QA Key Staff'!F49+'C. Additional QA Staff'!G39)","v":0},{"$f":"SUM('B. QA Key Staff'!G49+'C. Additional QA Staff'!H39)","v":0},{"$f":"SUM('B. QA Key Staff'!H49+'C. Additional QA Staff'!I39)","v":0},{"$f":"SUM('B. QA Key Staff'!I49+'C. Additional QA Staff'!J39)","v":0},{"$f":"SUM('B. QA Key Staff'!J49+'C. Additional QA Staff'!K39)","v":0},{"$f":"SUM('B. QA Key Staff'!K49+'C. Additional QA Staff'!L39)","v":0},{"$f":"SUM('B. QA Key Staff'!L49+'C. Additional QA Staff'!M39)","v":0}]
[" Department Supplemental Funding\n(hardware, software, solutions tools, licenses, etc.) ",2000000,2000000,1500000,1000000,500000,500000,500000,500000,500000,500000]
["Total for Contract Year\nSchedules B, C ",{"$f":"SUM(B8:B9)","v":2000000},2000000,1500000,1000000,500000,500000,500000,500000,500000,500000]
["Total for Contract Years 1-7\nSchedules B, C",{"$f":"SUM(B10+C10+D10+E10+F10+G10+H10)","v":8000000}]
["Total for Contract Years 8-10\nSchedules B, C",{"$f":"SUM(I10+J10+K10)","v":1500000}]
["Total for all Contract Years\nSchedules B, C",{"$f":"SUM(B11:B12)","v":9500000}]
[]
[" QA Supplemental Staff\n     (Schedule D) ",{"$f":"'D. QA Suplemental Staff'!E32","v":0},{"$f":"'D. QA Suplemental Staff'!H32","v":0},{"$f":"'D. QA Suplemental Staff'!K32","v":0},{"$f":"'D. QA Suplemental Staff'!N32","v":0},{"$f":"'D. QA Suplemental Staff'!Q32","v":0},{"$f":"'D. QA Suplemental Staff'!T32","v":0},{"$f":"'D. QA Suplemental Staff'!W32","v":0},{"$f":"'D. QA Suplemental Staff'!Z32","v":0},{"$f":"'D. QA Suplemental Staff'!AC32","v":0},{"$f":"'D. QA Suplemental Staff'!AF32","v":0}]
["Total for Contract Years 1-7\nSchedules B, C, and D",{"$f":"B11+B15+C15+D15+E15+F15+G15+H15","v":8000000}]
["Total for Contract Years 8-10\nSchedules B, C, and D ",{"$f":"B12+I15+J15+K15","v":1500000}]
["Grand Total - all Contract Years\nSchedules B, C, and D",{"$f":"SUM(B16:B17)","v":9500000}]
["Unused funds will be rolled over from year to year for the duration of the contract. Funds not used by the project at the conclusion of the contract shall be credited back to the Department. "]

{"sheet":"B. QA Key Staff","index":1,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Medicaid Systems Quality Assurance Services "]
["QA Key Staff Rates - Fixed Price",null,null,null,null,null," "]
["Schedule B",null,"Offeror: "]
[]
[null,"Instructions: "]
[null,"Enter your company name in the \"offeror\" gray shaded area. "]
[null,"Do not change the staff titles in the Labor Category column (column B).  "]
[null,"Enter the total cost per staff title for each contract year, as indicated by gray shaded cells. "]
[null,"For the IPA Phase 2 and SDI Systems, enter annual rates for contract year 3 through 7. "]
[null,"Contract years 8 through 10 rate increase will be based rates for contract year 7 and are calculated at an increase of 3% per year, for budgeting purposes. \nActual increase will be the lesser of 3% or CPI percentage.  "]
[null,"Do not enter data into contract years 8 through 10."]
[null,"Check Totals."]
[null,null," "]
[null,null,null,null,"Annual Bill Rate",null,null,null,null,"Department approved option for one 3-year extension "]
[null,"Key Staff ","Contract Year 1","Contract Year 2","Contract Year 3","Contract Year 4","Contract Year 5","Contract Year 6","Contract Year 7","Contract Year 8","Contract Year 9","Contract Year 10"]
[null,"Labor Category (Title/Role)",null," "," "," "," "," "," "," "," "," "]
[null,"QA Engagement Manager ",0,0,0,0,0,0,0,{"$f":"I17*1.03","v":0},{"$f":"J17*1.03","v":0},{"$f":"K17*1.03","v":0}]
[null,"eMedNY QA Senior Project Manager",0,0,0,0,0,0,0,{"$f":"I18*1.03","v":0},{"$f":"J18*1.03","v":0},{"$f":"K18*1.03","v":0}]
[null,"eMedNY QA Senior Technical Analyst ",0,0,0,0,0,0,0,{"$f":"(I19*1.03)","v":0},{"$f":"J19*1.03","v":0},{"$f":"K19*1.03","v":0}]
[null,"eMedNY QA Senior Business Analyst (1)",0,0,0,0,0,0,0,{"$f":"I20*1.03","v":0},0,0]
[null,"eMedNY QA Senior Business Analyst (2)",0,0,0,0,0,0,0,0,0,0]
[null,"NYSOH QA Senior Project Manager",0,0,0,0,0,0,0,0,0,0]
[null,"NYSOH QA Senior Technical Analyst   ",0,0,0,0,0,0,0,0,0,0]
[null,"NYSOH QA Senior Business Analyst (1)",0,0,0,0,0,0,0,0,0,0]
[null,"NYSOH QA Senior Business Analyst (2)",0,0,0,0,0,0,0,0,0,0]
[null,"NYSOH QA Senior System Tester",0,0,0,0,0,0,0,0,{"$f":"J26*1.03","v":0},{"$f":"K26*1.03","v":0}]
[null,"MDW QA Senior Project Manager",0,0,0,0,0,0,0,0,0,0]
[null,"MDW QA Senior Technical Analyst ",0,0,0,0,0,0,0,0,0,0]
[null,"MDW QA Senior Business Analyst (1)",0,0,0,0,0,0,0,0,0,0]
[null,"MDW / IPA (Phase 1) QA Senior Business Analyst (2)",0,0,0,0,0,0,0,0,0,0]
[null,"IPA - Phase 2 - QA Senior Project Manager",0,0,0,0,0,0,0,0,0,0]
[null,"IPA - Phase 2 - QA Senior Technical Analyst ",0,0,0,0,0,0,0,0,0,0]
[null,"IPA - Phase 2 - QA Senior Business Analyst ",0,0,0,0,0,0,0,0,0,0]
[null,"TAS QA Senior Project Manager",0,0,0,0,0,0,0,0,0,0]
[null,"TAS QA Senior Technical Analyst",0,0,0,0,0,0,0,0,0,0]
[null,"TAS QA Senior Business Analyst ",0,0,0,0,0,0,0,0,0,0]
[null,"SDI QA Senior Project Manager",0,0,0,0,0,0,0,0,0,0]
[null,"SDI QA Senior Technical Analyst (1)",0,0,0,0,0,0,0,0,0,0]
[null,"SDI QA Senior Technical Analyst (2)",0,0,0,0,0,0,0,0,0,0]
[null,"SDI QA Senior Business Analyst ",0,0,0,0,0,0,0,0,0,0]
[null,"SDI QA Senior System Tester",0,0,0,0,0,0,0,0,0,0]
[null,"SDI QA Senior Data Analyst ",0,0,0,0,0,0,0,0,0,0]
[null,"MECM QA Senior Project Manager",0,0,0,0,0,0,0,0,0,0]
[null,"MECM QA Senior Technical Analyst ",0,0,0,0,0,0,0,0,0,0]
[null,"MECM QA Senior Business Analyst ",0,0,0,0,0,0,0,0,0,0]
[null,"MECM QA Senior System Tester",0,0,0,0,0,0,0,0,0,0]
[null,"MECM QA Senior Data Analyst ",0,0,0,0,0,0,0,0,0,0]
[null,"MECM QA Security Analyst ",0,0,0,0,0,0,0,0,0,0]
[null,"Total per year: ",{"$f":"SUM(C17:C48)","v":0},0,0,0,0,0,{"$f":"SUM(I17:I48)","v":0},0,0,0,1]
[null,"Key Staff Cost Total for Contract Years 1-7",{"$f":"+SUM(C49+D49+E49+F49+G49+H49+I49)","v":0}]
[null,"Key Staff Cost Total for Contract Years 8-10",{"$f":"SUM(J49+K49+L49)","v":0}]
[null,"Grand Total ",{"$f":"SUM(C50:C51)","v":0}]
[null,null,1]

{"sheet":"C. Additional QA Staff","index":2,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Medicaid Systems Quality Assurance Services "]
["QA Additional Staff Rates - Fixed Price"]
["Schedule C"]
[null,null,"Offeror ",{"$f":"'B. QA Key Staff'!D3","v":0}]
[null,"Instructions:"]
[null,"The first two gray shaded columns use drop-down selection lists. "]
[null,"     Select the system name or \"shared\" if the staff person is to be shared among systems."]
[null,"     Select the position title (Labor Category). Make sure you have selected the title with the appropriate level. "]
[null,"Enter the total cost for the title for the contract years 1-7."]
[null,"     If System selected is IPA Phase 2 or SDI, only enter total cost for contract years 3-7. "]
[null,"Contract years 8 through 10 rate increase will be based rates for contract year 7 and are calculated at an increase of 3% per year, for budgeting purposes. \nActual increase will be the lesser of 3% or CPI percentage.  "]
[null,"Do not enter data into contract years 8 through 10."]
[null,"Copy/Paste additional rows, within the gray shaded rows, if needed. "]
[null,"Check totals. "]
[]
[null,null,null,null,null,"Annual Bill Rate ",null,null,null,null,"Department approved option for one 3-year extension "]
[null,"System ","Additional Staff \nAll are full time positions","Contract Year 1","Contract Year 2","Contract Year 3","Contract Year 4","Contract Year 5","Contract Year 6","Contract Year 7","Contract Year 8","Contract Year 9","Contract Year 10"]
[null,"System or Shared ","Labor Category (Title/Role)"]
[null,null,null,0,0,0,0,0,0,0,{"$f":"J19*1.03","v":0},0,0]
[null,null,null,0,0,0,0,0,0,0,{"$f":"J20*1.03","v":0},0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total per year: ",{"$f":"SUM(D19:D38)","v":0},0,0,0,0,0,{"$f":"SUM(J19:J38)","v":0},0,0,0]
[null,null,"Total Cost for Contract Years 1-7",{"$f":"SUM(D39+E39+F39+G39+H39+I39+J39)","v":0}]
[null,null,"Total Cost for Contract Years 8-10",{"$f":"SUM(K39+L39+M39)","v":0}]
[null,null,"Grand Total ",{"$f":"SUM(D40:D41)","v":0}]

{"sheet":"D. QA Suplemental Staff","index":3,"n_rows":38,"n_cols":32,"rows_kept":38,"cut":false,"hidden":false,"merged":[[32,2,32,3],[33,2,33,3],[34,2,34,3]]}
["Medicaid Systems Quality Assurance Services "]
["Cost Proposal Summary "]
["Schedule D"]
[null,"Offeror ",{"$f":"'B. QA Key Staff'!D3","v":0}]
[null,"Instructions: "]
[null,"Please provide hourly rates for supplemental staff titles, for contract year 1 through 7, as indicted by the gray shaded cells."]
[null,"Contract years 8-10 rate increase will be based rates for contract year 7 and are calculated at an increase of 3% per year, for budgeting purposes. \nActual increase will be the lesser of 3% or CPI percentage.  "]
[null,"Do not enter data into contract years 8 through 10."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Department approved option for one 3-year extension "]
[null,"Supplemental Staff ","Hourly Rate Contract Year 1","Hours per FTE per year*","Annual Cost Contract Year 1\nPer Title","Hourly Rate Contract Year 2","Hours per FTE per year","Annual Cost Contract Year 2\nPer Title","Hourly Rate Contract Year 3","Hours per FTE per year*","Annual Cost Contract Year 3\nPer Title","Hourly Rate Contract Year 4","Hours per FTE per year","Annual Cost Contract Year 4\nPer Title","Hourly Rate Contract Year 5","Hours per FTE per year*","Annual Cost Contract Year 5\nPer Title","Hourly Rate Contract Year 6","Hours per FTE per year","Annual Cost Contract Year 6\nPer Title","Hourly Rate Contract Year 7","Hours per FTE per year*","Annual Cost Contract Year 7\nPer Title","Hourly Rate Contract Year 8","Hours per FTE per year","Annual Cost Contract Year 8\nPer Title","Hourly Rate Contract Year 9","Hours per FTE per year*","Annual Cost Contract Year 9\nPer Title","Hourly Rate Contract Year 10","Hours per FTE per year","Annual Cost Contract Year 10\nPer Title"]
[null,"Labor Category (Title/Role)"]
[1,"QA Senior Project Manager",null,1250,{"$f":"C12*D12","v":0},null,1250,{"$f":"F12*G12","v":0},null,1250,{"$f":"I12*J12","v":0},null,1250,{"$f":"L12*M12","v":0},null,1250,{"$f":"O12*P12","v":0},null,1250,{"$f":"R12*S12","v":0},null,1250,{"$f":"U12*V12","v":0},{"$f":"U12*1.03","v":0},1250,{"$f":"X12*Y12","v":0},{"$f":"X12*1.03","v":0},1250,{"$f":"AA12*AB12","v":0},{"$f":"AA12*1.03","v":0},1250,{"$f":"AD12*AE12","v":0}]
[2,"QA Senior Technical Analyst ",0,1250,{"$f":"C13*D13","v":0},0,1250,{"$f":"F13*G13","v":0},0,1250,{"$f":"I13*J13","v":0},0,1250,{"$f":"L13*M13","v":0},null,1250,{"$f":"O13*P13","v":0},0,1250,{"$f":"R13*S13","v":0},0,1250,{"$f":"U13*V13","v":0},{"$f":"U13*1.03","v":0},1250,{"$f":"X13*Y13","v":0},{"$f":"X13*1.03","v":0},1250,{"$f":"AA13*AB13","v":0},{"$f":"AA13*1.03","v":0},1250,{"$f":"AD13*AE13","v":0}]
[3,"QA Senior Business Analyst",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[4,"QA Senior Data Analyst",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[5,"QA Senior System Tester",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[6,"QA Senior Technical SME ",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[7,"QA Senior Security Analyst",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[8,"QA Project Manager - Mid level",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[9,"QA Technical Analyst - Mid level",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[10,"QA Business Analyst - Mid level",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[11,"QA Data Analyst - Mid level",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[12,"QA System Tester - Mid level",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[13,"QA Admin Support - Mid level",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[14,"QA Senior Technical SME - Mid level",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[15,"QA Admin Support - Entry",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[16,"QA Technical Analyst - Entry level",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[17,"QA Business Analyst - Entry level",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[18,"QA Data Analyst - Entry level",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[19,"QA System Tester - Entry level",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[20,"QA Intern/ Entry-level",0,1250,0,0,1250,0,0,1250,0,0,1250,0,null,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0,0,1250,0]
[null,"Total per year: ",null,null,{"$f":"SUM(E12:E31)","v":0},null,null,{"$f":"SUM(H12:H31)","v":0},null,null,{"$f":"SUM(K12:K31)","v":0},null,null,{"$f":"SUM(N12:N31)","v":0},null,null,{"$f":"SUM(Q12:Q31)","v":0},null,null,{"$f":"SUM(T12:T31)","v":0},null,null,{"$f":"SUM(W12:W31)","v":0},null,null,{"$f":"SUM(Z12:Z31)","v":0},null,null,{"$f":"SUM(AC12:AC31)","v":0},null,null,{"$f":"SUM(AF12:AF31)","v":0}]
[null,"Total Cost for Contract Years 1-7",{"$f":"SUM(E32+H32+K32+N32+Q32+T32+W32)","v":0}]
[null,"Total Cost for Contract Years 8-10",{"$f":"SUM(Z32+AC32+AF32)","v":0}]
[null,"Grand Total ",{"$f":"SUM(C33:C34)","v":0}]
[]
["* This is an estimated number of hours per staff title.  Actual hours may be higher or lower.  There is no guarantee of actual hours. "]
["Unused hours can be rolled forward to future contract years. "]

{"sheet":"E. QA Cost Proposal Signature","index":4,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Attachment B - Cost Proposal "]
[null,"New York State Department of Health"]
[null,"Bid Form "]
[null,"RFP #20506"]
[]
[null,"Medicaid Systems Quality Assurance Services"]
[]
[]
[]
[null,"Bidder Federal ID #: "]
[]
[null,"________________________________________________________ bids a total price of $ __________________"]
[null,"                    (Name of Offeror/Bidder)"]
[null,"____________________________________________________________________________________________"]
[null,"(Bidder Address: Street, City, State and Zip)"]
[]
[null,"By signing this cost proposal form, Bidder agrees that the prices above are binding for 365 days from the proposal due date. "]
[]
[]
[null,"______________________________________________________     Date:  __________________"]
[null,"                 (Offeror/Bidder's Authorized Signature) "]

{"sheet":"Reference Table","index":5,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Shared or System","Labor Category"]
["Shared","QA Senior Project Manager"]
["eMedNY","QA Senior Technical Analyst "]
["NYSOH","QA Senior Business Analyst"]
["MDW","QA Senior Data Analyst"]
["IPA-Phase 2","QA Senior System Tester"]
["TAS","QA Senior Security Analyst"]
["SDI","QA Senior Technical SME "]
["MECM","QA Project Manager - Mid level"]
[null,"QA Technical Analyst - Mid level"]
[null,"QA Business Analyst - Mid level"]
[null,"QA Data Analyst - Mid level"]
[null,"QA System Tester - Mid level"]
[null,"QA Admin Support - Mid level"]
[null,"QA Senior Technical SME - Mid level"]
[null,"QA Admin Support - Entry level"]
[null,"QA Technical Analyst - Entry level"]
[null,"QA Business Analyst - Entry level"]
[null,"QA Data Analyst - Entry level"]
[null,"QA System Tester - Entry level"]
[null,"QA Intern - Entry level"]
[null," "]