{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Drop Down Lists","Intro","A-10 Financial Proposal"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":38,"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":"Drop Down Lists","index":0,"n_rows":179,"n_cols":3,"rows_kept":179,"cut":false,"hidden":true,"merged":[]}
["ListYes_No",null,"Select one"]
[null,null,"Yes"]
[null,null,"No"]
[]
["List_GEOMap",null,"Select one"]
[null,null,"Zip Code Dispersion"]
[null,null,"Center of Zip Code"]
[null,null,"Geo-coding (Employee Zip Code address)"]
[]
["ListYesNo",null,"Select one"]
[null,null,"Yes"]
[null,null,"No - See Section A-15: Deviations"]
[]
["ListYesNowithCost",null,"Select one"]
[null,null,"Yes, at no additional cost to the State"]
[null,null,"Yes, at an additional cost to the State described below"]
[null,null,"Not offered"]
[]
["List_Agree",null,"Select one"]
[null,null,"Agree"]
[]
["List_Offered",null,"Select one"]
[null,null,"Offered"]
[null,null,"Not offered"]
[]
["List_Complete",null,"Select one"]
[null,null,"Completed"]
[null,null,"Not completed"]
[]
["List_Attached",null,"Select one"]
[null,null,"Attached"]
[null,null,"Not attached"]
[]
["ListCorpTaxStatus",null,"Select one"]
[null,null,"For profit"]
[null,null,"Not for profit"]
[]
["List_NCQA_Accreditation",null,"Select one"]
[null,null,"Accredited"]
[null,null,"Accredation Not Requested"]
[null,null,"Appealed by Plan"]
[null,null,"Denied"]
[null,null,"Full"]
[null,null,"In Process"]
[null,null,"One year"]
[null,null,"Provisional"]
[]
["List_JCAHO_Accreditation",null,"Select one"]
[null,null,"Accreditation Denied"]
[null,null,"Accreditation not requested"]
[null,null,"Accreditation with Commendation"]
[null,null,"Accreditation with Full standards of Compliance"]
[null,null,"Accreditation with Requirements for Improvement"]
[null,null,"Conditional Accreditation"]
[null,null,"Preliminary Denial of  Accreditation"]
[null,null,"Provisional Accreditation"]
[]
["List_URAC_Accreditation",null,"Select one"]
[null,null,"Accreditation Denied"]
[null,null,"Accreditation in Proceess"]
[null,null,"Accreditation Not Required"]
[null,null,"Accreditation Voluntarily Withdrawn"]
[null,null,"Conditional Accreditation"]
[null,null,"Corrective Action"]
[null,null,"Full Accreditation"]
[null,null,"Provisional Accreditation"]
[]
["List_Designated",null,"Select one"]
[null,null,"Dedicated staff"]
[null,null,"Designated staff"]
[]
["List_L14_Q3",null,"Select one"]
[null,null,"Confirmed"]
[null,null,"Not confirmed"]
[]
["List_L14_Q12",null,"Select one"]
[null,null,"0 - 5%"]
[null,null,"6 - 10%"]
[null,null,"Higher than 10%"]
[]
["List_L14_Q16",null,"Select one"]
[null,null,"Yes, a decrease in the network size"]
[null,null,"Yes, an increase in the network size"]
[null,null,"No material change in the network size"]
[]
["List_L14_Q20",null,"Select one"]
[null,null,"Reviewed or verified"]
[null,null,"Not reviewed or verified"]
[]
["List_L14_Q27",null,"Select one"]
[null,null,"Annually"]
[null,null,"Once every two years"]
[null,null,"Other"]
[]
["List_L14_Q32",null,"Select one"]
[null,null,"Less than 3 years"]
[null,null,"3 - 5 years"]
[null,null,"6 or more years"]
[]
["List_L14_Q37",null,"Select one"]
[null,null,"Global Capitation"]
[null,null,"Per Diem"]
[null,null,"Discounted Fee for Service"]
[null,null,"Other"]
[]
["List_L14_Q44",null,"Select one"]
[null,null,"Less than 5%"]
[null,null,"5 - 10%"]
[null,null,"10 - 15%"]
[null,null,"More than 15%"]
[]
["List_L14_Q47",null,"Select one"]
[null,null,"Less than 2 weeks"]
[null,null,"2 - 4 weeks"]
[null,null,"More than 4 weeks"]
[]
["List_L14_Q58",null,"Select one"]
[null,null,"Pay and pursue"]
[null,null,"Pursue and Pay"]
[]
["List_L14_Q67",null,"Select one"]
[null,null,"Yes, both in-network and out-of-network"]
[null,null,"Yes, out-of-network only"]
[null,null,"No"]
[]
["List_L14_Q73",null,"Select one"]
[null,null,"Quarterly"]
[null,null,"Annually"]
[null,null,"Other"]
[]
["List_L14_Q74",null,"Select one"]
[null,null,"Less than 1%"]
[null,null,"1 - 2%"]
[null,null,"3 - 5%"]
[null,null,"5 - 10%"]
[null,null,"More than 10%"]
[]
["List_L14_Q86",null,"Select one"]
[null,null,"Less than 5%"]
[null,null,"5 - 10%"]
[null,null,"10 - 15%"]
[null,null,"More than 15%"]
[]
["List_L14_Q108",null,"Select one"]
[null,null,"Less than 5%"]
[null,null,"5 - 10%"]
[null,null,"10 - 15%"]
[null,null,"More than 15%"]
[]
["List_L14_Q115",null,"Select one"]
[null,null,"24 hour delay"]
[null,null,"48 hour delay"]
[null,null,"Greater than 48 hour delay"]
[]
["List_L14_Q77",null,"Select one"]
[null,null,"Automated process"]
[null,null,"Manual process"]
[]
["List_L14_Q126",null,"Select one"]
[null,null,"Automatically tracked only"]
[null,null,"Automatically tracked with reporting capabilities"]
[null,null,"Not tracked or reported by the system"]
[]
["List_Exp_Dev",null,"Select one"]
[null,null,"Explanation"]
[]
["List_RxVolume",null,"Select one"]
[null,null,"Increase"]
[null,null,"Decrease"]
[null,null,"No change"]
[]
["List_Confirm",null,"Select one"]
[null,null,"Confirmed"]
[null,null,"Not confirmed"]
[]
["List_Formulary",null,"Select one"]
[null,null,"Preferred Brand"]
[null,null,"Non-Preferred Brand"]
[null,null,"Generic"]

{"sheet":"Intro","index":1,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["South Carolina Public Employee Benefit Authority"]
["Insurance Benefits"]
["202 Arbor Lake Drive"]
["Columbia, South Carolina 29223"]
[]
[]
[]
["Pharmacy Benefit Management Services"]
["Offeror's Financial Proposal Response"]

{"sheet":"A-10 Financial Proposal","index":2,"n_rows":117,"n_cols":10,"rows_kept":117,"cut":false,"hidden":true,"merged":[[6,0,6,9],[12,0,12,9],[8,0,8,9],[64,1,64,6],[16,2,16,6],[17,2,17,6],[14,7,14,9],[15,1,15,6],[11,0,11,9],[19,7,19,9],[63,7,63,9],[20,1,20,6],[9,0,9,9],[10,0,10,9],[108,1,108,9],[109,1,109,6],[113,1,113,6],[111,1,111,6],[115,1,115,6]]}
[]
[]
[]
["Request for Proposal for Pharmacy Benefit Management Services"]
["Tab A-10: Financial Proposal"]
[]
["Representations made by the Offeror in this Proposal become contractual obligations that must be met during the contract term."]
[]
["Instructions: Please complete the financial exhibit below in its entirety.  It is South Carolina Public Employee Benefit Authority's (PEBA) intent to conduct as fair and equitable analysis as possible, and for that reason the information requested is very detailed.\n\nThe Financial Proposal is based on the current program in which the PBM will pass-through 100% of all costs and pharmaceutical manufacturer revenue to PEBA for all participants.  For those participants who opt-out of EGWP and into the Commercial Plan, PEBA will continue to utilize the Retiree Drug Subsidy program. All PEBA pharmacy benefits will be provided on a self-funded basis. "]
["The EGWP Plan will provide pharmacy benefits for all Medicare primary participants covered by the State Health Plan.\n\nThe Commercial Plan will provide pharmacy coverage for all non-Medicare participants in the State Health Plan, MUSC Health Plan, and all Medicare Primary participants who have opted out of the EGWP Plan."]
["The administrative fees and pricing guarantees for ingredient costs, dispensing fees and rebates must be provided in accordance with the instructions found in Part 5 of the RFP, Information for Offerors to Submit, 5.2 Business Proposal, Offeror’s Financial Proposal Response for Tab A-10."]
["In Table I below, all-inclusive administrative fees must be provided on a per member per month, or PMPM, basis.  Fees shall be quoted separately for the Commercial Plan and EGWP.  The administrative fees must include the cost associated with providing PEBA with all the required services described in Part 3, Scope of Work,  of the RFP. The administrative fees must also include the cost associated with any additional clinical and/or administrative programs the Offeror chooses to include (per Part 3 Scope of Work, Section A Pricing and Cost Containment, Item 10.bbb)., #9(ccc)) .  These additional programs must be listed in the cover letter of the Offeror's Financial Proposal.  No additional supplemental pricing information (i.e. optional programs, deviations or caveats to the specifications of the RFP) shall be submitted in the Offeror's response to the RFP. "]
["In Table II below, please provide the requested pricing information for participants enrolled in the EGWP plan.\n\nIn Table III below, please provide the requested pricing information for participants not enrolled in the EGWP plan."]
[]
[null,"Table I",null,null,null,null,null,"GUARANTEES"]
[null,"Administrative Fees (PMPM)",null,null,null,null,null,"1/1/21 - 12/31/21","1/1/22 - 12/31/22","1/1/23 - 12/31/23"]
[null,"1.","Commerical Plan Administrative Fee (per member per month)"]
[null,"2.","EGWP Administrative Fee (per member per month)"]
[]
[null,"Table II",null,null,null,null,null,"GUARANTEES"]
[null,"EGWP Plan",null,null,null,null,null,"1/1/21 - 12/31/21","1/1/22 - 12/31/22","1/1/23 - 12/31/23"]
[null,"INGREDIENT COSTS (Percent off AWP)"]
[null,"1.","Retail*"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"2.","Retail 90"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"3.","Mail"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"4.","Specialty (Contractor affiliated pharmacy)"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"5.","Specialty (Non-Contractor affiliated pharmacy)"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"* Pricing guarantees for  ingredient costs and dispensing fees shown above at retail pharmacies excludes PEBA-defined locally-owned pharmacies."]
[null,"DISPENSING FEES (Per Script)"]
[null,"6.","Retail*"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"7.","Retail 90"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"8.","Mail"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"9.","Specialty (Contractor affiliated pharmacy)"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"10.","Specialty (Non-Contractor affiliated pharmacy)"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"* Pricing guarantees for  ingredient costs and dispensing fees shown above at retail pharmacies excludes PEBA-defined locally-owned pharmacies."]
[null,"REBATES (Per Brand Script)"]
[null,"11.","Guaranteed Pharma Revenue"]
[null,null,"a.)","per Brand Script at a Retail pharmacy"]
[null,null,"b.)","per Brand Script at a Retail 90 pharmacy"]
[null,null,"c.)","per Brand Script at the Mail Order pharmacy"]
[null,null,"d.)","per Brand Script at the Contractor affiliated Specialty pharmacy"]
[null,null,"e.)","per Brand Script at a non-Contractor affiliated Specialty pharmacy"]
[]
[null,"Table III",null,null,null,null,null,"GUARANTEES"]
[null,"Commerical Plan",null,null,null,null,null,"1/1/21 - 12/31/21","1/1/22 - 12/31/22","1/1/23 - 12/31/23"]
[null,"INGREDIENT COSTS (Percent off AWP)"]
[null,"1.","Retail*"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"2.","Retail 90"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"3.","Mail"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"4.","Specialty (Contractor affiliated pharmacy)"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"5.","Specialty (Non-Contractor affiliated pharmacy)"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"* Pricing guarantees for  ingredient costs and dispensing fees shown above at retail pharmacies excludes PEBA-defined locally-owned pharmacies."]
[null,"DISPENSING FEES (Per Script)"]
[null,"6.","Retail*"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"7.","Retail 90"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"8.","Mail"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"9.","Specialty (Contractor affiliated pharmacy)"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"10.","Specialty (Non-Contractor affiliated pharmacy)"]
[null,null,"a.)","Brand "]
[null,null,"b.)","Generic"]
[null,"* Pricing guarantees for  ingredient costs and dispensing fees shown above at retail pharmacies excludes PEBA-defined locally-owned pharmacies."]
[null,"REBATES (Per Brand Script)"]
[null,"11.","Guaranteed Pharma Revenue"]
[null,null,"a.)","per Brand Script at a Retail pharmacy"]
[null,null,"b.)","per Brand Script at a Retail 90 pharmacy"]
[null,null,"c.)","per Brand Script at the Mail Order pharmacy"]
[null,null,"d.)","per Brand Script at the Contractor affiliated Specialty pharmacy"]
[null,null,"e.)","per Brand Script at a non-Contractor affiliated Specialty pharmacy"]
[]
[]
[null,"I hereby certify that the fixed, single, all-inclusive PMPM administrative fees offered in Table I above  include the costs associated with providing PEBA with all required services described in the Pharmacy Benefit Management Services RFP, including but not limited to Part III, Scope of Work, Sections A through L.  Furthermore, the pricing guarantees offered in Table II and Table III above have been developed in accordance to the specifications described in the RFP, including but not limited to Part V: Information for Offerors to Submit, Section B: Financial Proposal, sub-section 2., and shall remain unchanged, subject to the Change Order provision of the RFP, for the initial three (3) year term of the contract."]
[]
[null,"Offeror Name"]
[]
[null,"Printed Name of Authorized Representative"]
[]
[null,"Signature Authorized Representative"]
[]
[null,"Date"]