{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Data","0 - Cover Page","1- Qualifications of Company","2 - Company Relevant References","3 - Contract Terms","4 - Personnel","5 - Pricing Proposal"],"not_rendered":{"images":35,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":44,"n_cols":4,"rows_kept":44,"merged":[[0,1,0,3],[1,0,43,0],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,3],[30,1,30,3],[37,1,37,3],[38,1,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,1,42,3],[43,2,43,3]]}
[]
[null,"RFP 22-30 - Medical and Prescription Drug Stop Loss Insurance"]
[null,"Hamilton County Schools (HCS)"]
[null,"Effective Date of Coverage: July 1, 2022"]
[]
[null,"INSTRUCTIONS"]
[null,"Please refer to the RFP for detailed response instructions"]
[null,"Questions:  please contact HCDE's Procurement Department:"]
[null,"Debbie Jackson"]
[null,"Procurement Specialist"]
[null,"Hamilton County Schools"]
[null,"3074 Hickory Valley Road"]
[null,"Chattanooga, TN 30421"]
[null,"Email: DOE _Purchasing@HCDE.org"]
[null,"Direct Line: (423-498-7030) "]
[null,"RFP Instructions:"]
[null,"\nInformational Tabs included in this \"Attachment A\" Document:\n   Introduction\n   Data   \nTabs to be completed by proposer in this \"Response Form\" Document:\n   0 - Cover Page\n   1 - Qualifications of Company\n   2 - Company Relevant References\n   3 - Contract Terms\n   4 - Personnel\n   5 - Pricing Proposal"]
[]
[null,"Carrier History"]
[null,"Stop Loss Carrier History","PPO","HDHP and HMO"]
[null,"Current Year (incumbent)","Blue Re","Cigna"]
[null,"Prior Year 1","Blue Re","Cigna"]
[null,"Prior Year 2","Blue Re","Cigna"]
[null,"TPA Carrier History"]
[null,"Current Year (incumbent)","BCBSTN","Cigna"]
[null,"Prior Year 1","BCBSTN","Cigna"]
[null,"Prior Year 2","BCBSTN","Cigna"]
[null,"PPO Network Provider"]
[null,"Current","Network S","Open Access Plus"]
[null,"Proposed","Network S","Open Access Plus"]
[null,"Current Contract"]
[null,"Specific Deductible Level",{"v":375000,"d":"$375,000"},{"v":375000,"d":"$375,000"}]
[null,"Specific Contract Basis","Paid with No New Laser & Rate Cap","Paid"]
[null,"Aggregating Specific Deductible Level","None","None"]
[null,"Lasers","None","None"]
[null,"Rate Tier","Single/Family","Composite"]
[null,"Current Premiums","$14.55/$50.08",{"v":33.86,"d":"$33.86"}]
[null,"Requested Contract"]
[null,"Specific Deductible Levels to be Quoted"]
[null,"Current Plan","$375000/NNLR/50% Rate Cap"]
[null,"Alternate Plan ",{"v":400000,"d":"$400,000"}]
[null,"Alternate Plan",{"v":425000,"d":"$425,000"}]
[null,"Specific Aggregating Deductible Levels to be Quoted"]
[null,null,"None"]

{"sheet":"Data","index":1,"n_rows":53,"n_cols":4,"rows_kept":53,"merged":[[7,1,7,3],[9,1,9,3],[12,1,12,3],[16,1,16,3],[24,1,24,3],[28,1,28,3],[33,1,33,3],[38,1,38,2],[42,1,42,2],[46,1,46,3],[51,1,51,3]]}
[]
[]
[]
[null,"RFP 22-30 - Medical and Prescription Drug Stop Loss Insurance"]
[null,"Hamilton County Schools (HCS)"]
[null,"Effective Date of Coverage: July 1, 2022"]
[]
[null,"DATA"]
[]
[null,"To allow proposers adequate time to review the solicitation documents and prepare a proposal submission package we have included all information currently available. It is HCS' intent to provide data through April 2022 as soon as the report has been completed."]
[]
[]
[null,"Large Claimants - BCBS"]
[null,"2021-2022 (July 1 - March 31)","2020-2021 (July 1 - June 30)","2019-2020 (July 1 - June 30)"]
[]
[]
[null,"Large Claimants - Cigna"]
[null,"2021-2022 (July 1 - March 31)","2020-2021 (July 1 - June 30)","2019-2020 (July 1 - June 30)"]
[]
[]
[null,"Stop Loss Reimbursements - BCBS"]
[null,"2017-2022 YTD"]
[]
[]
[null,"Stop Loss Reimbursements - Cigna"]
[null,2022,2021,2020]
[]
[]
[null,"Claims/Enrollment History - BCBS"]
[null,"2021-2022 (July 1 - March 31)","2020-2021 (July 1 - June 30)","2019-2020 (July 1 - June 30)"]
[]
[]
[]
[null,"Claims/Enrollment History - Cigna"]
[null,"2022 (January 1 - March 31)","2021 (January 1 to December 31)","2020 (January 1 to December 31)"]
[]
[]
[]
[null,"Census"]
[null,"Active","Declined Coverage"]
[]
[]
[null,"Current Stop Loss Policy with Rates"]
[null,"Blue Re","Cigna"]
[]
[]
[null,"SBCs"]
[null,"BCBS-PPO","Cigna-HDHP","Cigna-HMO"]
[]
[]
[]
[null,"SPD/EOC"]
[null,"BCBS-PPO (EOC)","Cigna-HDHP (SPD and Riders)","Cigna-HMO (SPD and Riders)"]

{"sheet":"0 - Cover Page","index":2,"n_rows":23,"n_cols":3,"rows_kept":23,"merged":[[7,1,7,2],[9,1,9,2],[20,1,20,2]]}
[]
[]
[]
[null,"RFP 22-30 - Medical and Prescription Drug Stop Loss Insurance"]
[null,"Hamilton County Schools (HCS)"]
[null,"Effective Date of Coverage: July 1, 2022"]
[]
[null,"Cover Page"]
[]
[null,"To Proposer: Please enter your Company's information in the spaces provided below."]
[null,"Name of Proposer:","[Enter Company's Name Here]"]
[null,"Proposer's Address:","[Enter Company's Address Here]"]
[null,"Company's Contact Person:","[Enter Company's Contact Person Here]"]
[null,"Phone:","[Enter Contact Information Here]"]
[null,"Fax:","[Enter Contact Information Here]"]
[null,"Email Address:","[Enter Contact Information Here]"]
[null,"How many years has Proposer been in business under present name?","[Enter Company's Response Here]"]
[null,"Under what other former names has your organization operated?","[Enter Company's Response Here]"]
[]
[]
[null,"Officer Statement: Please use the drop downs to the right to provide your Company's acknowledgement of the following statements."]
[null,"Proposer acknowledges that the response provided to this proposal in entirety will become part of the contract with Hamilton County Schools. If any part of the contract does not agree with the response provided herein, Proposer will amend the contract or defer to the proposal."]
[null,"Proposer agrees that all existing contractual terms and conditions not addressed in this Request for Proposal will remain unchanged in any future contract or amendment unless Hamilton County Schools decides otherwise.  "]

{"sheet":"1- Qualifications of Company","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"merged":[[7,1,7,2],[9,1,9,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[17,1,17,2]]}
[]
[]
[]
[null,"RFP 22-30 - Medical and Prescription Drug Stop Loss Insurance"]
[null,"Hamilton County Schools (HCS)"]
[null,"Effective Date of Coverage: July 1, 2022"]
[]
[null,"Tab 1 Qualifications of Company"]
[]
[]
[null,"Name of Proposer:","[Enter Company's Name Here]"]
[]
[]
[null,"Provide the following:"]
[null,"Description of your Company, your Company’s experience, underlying philosophy in providing the services as described and requested herein, rating, number of years in business, direct writer or managing general underwriter (MGU), list of special policy features and abilities unique to your Company, number and size of covered entities (specify number of current covered government entities), account management details, renewal process, advance funding options, etc.…"]
[null,"[Enter Company's Response Here]"]
[]
[null,"Provide the contact name and email address of the individual that can answer questions on your proposal."]
[null,"Name:","[Enter Company's Response Here]"]
[null,"Title:","[Enter Company's Response Here]"]
[null,"Phone:","[Enter Company's Response Here]"]
[null,"Email:","[Enter Company's Response Here]"]
[null,"Additional Notes:","[Enter Company's Response Here]"]

{"sheet":"2 - Company Relevant References","index":4,"n_rows":41,"n_cols":3,"rows_kept":41,"merged":[[7,1,7,2],[9,1,9,2],[13,1,13,2],[14,1,14,2],[22,1,22,2],[30,1,30,2],[39,1,39,2]]}
[]
[]
[]
[null,"RFP 22-30 - Medical and Prescription Drug Stop Loss Insurance"]
[null,"Hamilton County Schools (HCS)"]
[null,"Effective Date of Coverage: July 1, 2022"]
[]
[null,"Tab 2 Company Relevant References"]
[]
[]
[null,"Name of Proposer:","[Enter Company's Name Here]"]
[]
[]
[null,"Provide details of a maximum of three (3) projects similar in scope and size to that being requested through this solicitation that your Company has completed recently.  Details for each project example provided should include:"]
[null,"Client Reference #1"]
[null,"Client Name:","[Enter Company's Response Here]"]
[null,"Medical Enrolled Count:","[Enter Company's Response Here]"]
[null,"Point of Contact Name:","[Enter Company's Response Here]"]
[null,"Point of Contact Title:","[Enter Company's Response Here]"]
[null,"Point of Contact Phone:","[Enter Company's Response Here]"]
[null,"Point of Contact Email:","[Enter Company's Response Here]"]
[null,"Additional Notes:","[Enter Company's Response Here]"]
[null,"Client Reference #2"]
[null,"Client Name:","[Enter Company's Response Here]"]
[null,"Medical Enrolled Count:","[Enter Company's Response Here]"]
[null,"Point of Contact Name:","[Enter Company's Response Here]"]
[null,"Point of Contact Title:","[Enter Company's Response Here]"]
[null,"Point of Contact Phone:","[Enter Company's Response Here]"]
[null,"Point of Contact Email:","[Enter Company's Response Here]"]
[null,"Additional Notes:","[Enter Company's Response Here]"]
[null,"Client Reference #3"]
[null,"Client Name:","[Enter Company's Response Here]"]
[null,"Medical Enrolled Count:","[Enter Company's Response Here]"]
[null,"Point of Contact Name:","[Enter Company's Response Here]"]
[null,"Point of Contact Title:","[Enter Company's Response Here]"]
[null,"Point of Contact Phone:","[Enter Company's Response Here]"]
[null,"Point of Contact Email:","[Enter Company's Response Here]"]
[null,"Additional Notes:","[Enter Company's Response Here]"]
[]
[null,"Provide a statement of understanding that your Company recognizes Hamilton County Schools reserves the right to evaluate the proposing Company on their past performance and prior dealings with Hamilton County Schools (i.e., failure to meet specifications, poor workmanship, late delivery, etc.) as part of their experience criteria.  "]
[null,"Please use the drop down to the right to indicate your Company's understanding of the above statement."]

{"sheet":"3 - Contract Terms","index":5,"n_rows":32,"n_cols":3,"rows_kept":32,"merged":[[6,1,6,4],[7,1,7,4],[9,1,9,4],[10,2,10,4],[13,1,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4]]}
[]
[]
[]
[null,"RFP 22-30 - Medical and Prescription Drug Stop Loss Insurance"]
[null,"Hamilton County Schools (HCS)"]
[null,"Effective Date of Coverage: July 1, 2022"]
[]
[null,"Tab 3 Contract Terms"]
[]
[]
[null,"Name of Proposer:","[Enter Company's Name Here]"]
[]
[]
[null,"General Stop Loss"]
[null,"Question","Response"]
[null,"Confirm your proposal is firm and no additional disclosure is required.","[Enter Company's Response Here]"]
[null,"Confirm Actively at Work is waived.","[Enter Company's Response Here]"]
[null,"Confirm your proposal does not include a run-in limit.","[Enter Company's Response Here]"]
[null,"Confirm all claims paid by the medical plan are covered by the stop loss policy based on 100% of the amount paid.","[Enter Company's Response Here]"]
[null,"Confirm your proposal will mirror the Blue Cross Blue Shield and Cigna Plan documents.","[Enter Company's Response Here]"]
[null,"Confirm your proposal covers any claims approved through medical management decisions by the health plan administrators.","[Enter Company's Response Here]"]
[null,"Confirm you proposal will not change as long as enrollment does not fluctuate by 15% or less.","[Enter Company's Response Here]"]
[null,"Does your proposal include a no new laser provision and rate cap?","[Enter Company's Response Here]"]
[null,"Will you agree to offer the no new laser and rate cap for the life of this contract term?","[Enter Company's Response Here]"]
[null,"Confirm your proposal covers active, retirees, and COBRA participants with no limits to enrollment in each category.","[Enter Company's Response Here]"]
[null,"Confirm your proposal will continue to cover spouses and dependents once a retiree reaches 65 and moves to Medicare.","[Enter Company's Response Here]"]
[null,"Please provide a description of your company's payment turnaround timing standards.","[Enter Company's Response Here]"]
[null,"Confirm if Stop loss covers the eligibility as described in the plan of benefits without exceptions.\nIf not, list your exceptions in the Explanation column","[Enter Company's Response Here]"]
[null,"Does your proposal cover all employees covered by BCBS and Cigna?","[Enter Company's Response Here]"]
[null,"Confirm your proposal includes 5% commission to be paid to HCS Advisor.","[Enter Company's Response Here]"]
[null,"Does your proposal provide immediate reimbursement benefit?  If not please provide your average claim reimbursement timeframe.","[Enter Company's Response Here]"]
[null,"Please provide any additional contract/features of your proposal important to be considered in the evaluation process.","[Enter Company's Response Here]"]

{"sheet":"4 - Personnel","index":6,"n_rows":32,"n_cols":3,"rows_kept":32,"merged":[[7,1,7,2],[9,1,9,2],[13,1,13,2],[14,1,14,2],[20,1,20,2],[26,1,26,2]]}
[]
[]
[]
[null,"RFP 22-30 - Medical and Prescription Drug Stop Loss Insurance"]
[null,"Hamilton County Schools (HCS)"]
[null,"Effective Date of Coverage: July 1, 2022"]
[]
[null,"Tab 4 Personnel"]
[]
[]
[null,"Name of Proposer:","[Enter Company's Name Here]"]
[]
[]
[null,"Provide a list of the Company’s specific account management team and implementation team assigned to the Hamilton County Schools' contract.  \n\nProvide resumes, licensure, and certifications of proposed specific project management team, inclusive of sub-Consultants anticipated to be utilized, to be assigned to HCS."]
[null,"Lead Account Team Member 1:"]
[null,"Name:","[Enter Company's Response Here]"]
[null,"Job Title:","[Enter Company's Response Here]"]
[null,"Main Job Functions:","[Enter Company's Response Here]"]
[null,"Resume/Bio Attached?"]
[null,"Contact Information:","[Enter Company's Response Here]"]
[null,"Account Team Member 2:"]
[null,"Name:","[Enter Company's Response Here]"]
[null,"Job Title:","[Enter Company's Response Here]"]
[null,"Main Job Functions:","[Enter Company's Response Here]"]
[null,"Resume/Bio Attached?"]
[null,"Contact Information:","[Enter Company's Response Here]"]
[null,"Implementation Team Member"]
[null,"Name:","[Enter Company's Response Here]"]
[null,"Job Title:","[Enter Company's Response Here]"]
[null,"Main Job Functions:","[Enter Company's Response Here]"]
[null,"Resume/Bio Attached?"]
[null,"Contact Information:","[Enter Company's Response Here]"]

{"sheet":"5 - Pricing Proposal","index":7,"n_rows":32,"n_cols":7,"rows_kept":32,"merged":[[5,1,5,2],[7,1,7,2],[10,1,10,6],[11,2,11,3],[31,1,31,6]]}
[]
[null,"RFP 22-30 - Medical and Prescription Drug Stop Loss Insurance"]
[null,"Hamilton County Schools (HCS)"]
[null,"Effective Date of Coverage: July 1, 2022"]
[]
[null,"Tab 5 Pricing Proposal"]
[]
[]
[null,"Name of Proposer:","[Enter Company's Name Here]"]
[]
[null,"Pricing\nPlease use the column to the far right to indicate your response as it relates to your proposal. Details on the current Stop Loss plan pricing are included in the middle column(s)."]
[null,null,"Current Plan(s)",null,"Vendor Response","Vendor Response","Vendor Response"]
[null,null,"Blue Re","Cigna","Current","Alternate 1","Alternate 2"]
[]
[null,"Individual Stop Loss Limit (ISL)",{"v":375000,"d":"$375,000"},{"v":375000,"d":"$375,000"},{"v":375000,"d":"$375,000"},{"v":400000,"d":"$400,000"},{"v":425000,"d":"$425,000"}]
[null,"ISL Premium:"]
[null,"Single:",{"v":15.32,"d":"$15.32"},null,"Insert Rate","Insert Rate","Insert Rate"]
[null,"Family:",{"v":52.72,"d":"$52.72"},null,"Insert Rate","Insert Rate","Insert Rate"]
[null,"Composite:",null,{"v":33.86,"d":"$33.86"},"Insert Rate","Insert Rate","Insert Rate"]
[null,"Do Rates Cover All Employees (BCBS and Cigna Plans)?",null,null,"Yes/No","Yes/No","Yes/No"]
[null,"Confirm Retirees Are Included",null,null,"Yes/No","Yes/No","Yes/No"]
[]
[null,"Contract Term (Minimum 24/12)","Paid","Paid"]
[null,"Commission 5%",{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"}]
[null,"Other Contract Terms listed below:"]
[null,"Does your proposal include any lasers?",null,null,"Yes/No","Yes/No","Yes/No"]
[null,"If lasers included insert the amount of each laser (Include diagnosis for identification)",null,null,"Each Laser amount","Each Laser Amount","Each Laser Amount"]
[null,"No New Laser?",null,null,"Yes/No","Yes/No","Yes/No"]
[null,"Rate Cap?",null,null,"Yes/No","Yes/No","Yes/No"]
[null,"Any other contract terms to note"]
[]
[null,"Please provide a copy of your underwriting proposal with all terms and conditions listed."]