{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Clinic Cost"],"not_rendered":{"images":2,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Clinic Cost","index":0,"n_rows":129,"n_cols":5,"rows_kept":129,"flags":["formulas_cached_only"]}
[]
[" "]
[]
["2022 City of Knoxville On-Site Clinic Vendor - Financial Comparison"]
[" "]
["On-Site Clinic Cost Components",null,"Premise Health\n(current annual fee)",null,"Your Company Name Here"]
["Staffing Fees/Model:*"]
["Benefits",353243.64,{"v":353243.64,"d":"$353,243.64"}]
["G&A Fee",null,{"v":321046.08,"d":"$321,046.08"}]
["  - Doctor Rate (40 hr/wk)",null,"Unable to determine"]
["  - Mid-Level Provider (40 hr/wk)",null,"Unable to determine"]
[" RN - Site Manager (40 hr/wk)",null,"Unable to determine"]
["  - LPNs (40 hr/wk)",null,"Unable to determine"]
["  - Health Risk Condition RN (40 hr/wk)",null,"Unable to determine"]
["  - Case Manager (40 hr/wk)",null,"Unable to determine"]
["  - Medical Assistant (40 hr/wk)",null,"Unable to determine"]
["  - RN  (40 hr/wk)",null,"Unable to determine"]
["  - Health Coach (2) (40 hr/wk)",null,"Unable to determine"]
["  - Physical Therapist (20 hr/wk)",null,"Unable to determine"]
["  - Assistant Physical Therapist (40 hr/wk)",null,"Unable to determine"]
["  - Admin Assistant (40 hr/wk)",null,"Unable to determine"]
["Total Spent on Staff",null,{"v":1103882.94,"d":"$1,103,883"}]
["Lab Work (count included in RFP)"]
["Total Spent on Lab Work in 2020",null,{"v":88720.55000000002,"d":"$88,720.55"}]
["Drug Screen"]
["  - NIDA-5/ SAP-5"," ","unknown"]
["  - NIDA-5/ SAP-5 After hours",null,"unknown"]
["  - NIDA-10/ SAP-10",null,"unknown"]
["  - After hours drug screen",null,"unknown"]
["Alcohol"]
["  - BAT with drug screen",null,"unknown"]
["  - BAT Alone",null,"unknown"]
["MRO Services"]
["  - Random Selection/ Database Fee per month",null,"unknown"]
["  - Negative Tests (per test)",null,"unknown"]
["  - Non-negative Tests (per test)",null,"unknown"]
["  - Safety Sensitive Tests (per test)",null,"unknown"]
["  - Saliva Drug Tests (per test)",null,"unknown"]
["  - Maintaining Database",null,"unknown"]
["Wellness Program Fees"]
["  - Health Risk Assessments (outside of any\n lab work or clinician work stated above)",null,{"v":7872.27,"d":"$7,872.27"}]
["Reporting Fees",null,"Unable to determine"]
["Portal (Display fee in PEPM)",null,"unknown"]
["Miscellaneous Fees (count included in RFP)"]
["  - Serum Lead Test",null,"unable to determine"]
["  - Blood Mercury Levels",null,"unable to determine"]
["  - DOT",null,"Unable to determine"]
["  - CDL",null,"Unable to determine"]
["  - Hazmat",null,"Unable to determine"]
["  - Health Fair Supplies",null,"Unable to determine"]
["  - Communications",null,"Unable to determine"]
["  - Travel/Transportation Costs",null,"Unable to determine"]
["  - Late Fees",null,"N/A"]
["  - Other",null,"Unable to determine"]
[]
[]
[]
[]
["Start-Up Fees",null,{"v":0,"d":"$0.00"}]
[]
[null,null,"Premise Health\n(Current Fee)"]
["Estimated Eligible Employee Count",null,{"v":1500,"d":"1,500"}]
["Staffing Fees",null,{"v":1778172.6600000001,"d":"$1,778,172.66"}]
["Start-Up Fees",null,{"v":0,"d":"$0.00"}]
["Lab/Pathology",null,{"v":88720.55000000002,"d":"$88,720.55"}]
["Other Expenses",null,{"v":323579.5299999999,"d":"$323,579.53"}]
["Management Fee",null,{"v":72964.97,"d":"$72,964.97"}]
["Wellness Program Fees",null,"unable to determine"]
["Reporting Fees",null,"unable to determine"]
["Portal Fees",null,"unable to determine"]
["Miscellaneous Fees",null,"unable to determine"]
[]
["Estimated Annual Cost",null,{"v":2254306.3600000003,"d":"$2,254,306.36"},null,{"v":0,"d":"$0"}]
["Estimated Annual Clinic Cost (On-Going)"]
["Contract Period",null,"3 years",null,"3 years"]
["Annual Increase",null,{"v":0.03,"d":"3.00%"},null,{"v":0,"d":"0%"}]
["*Show all rates based on the hours requested in  column A."]
{"$rows_empty":44}
[{"$nulls":4},3640]
[{"$nulls":4},93388]
[{"$nulls":4},25.656043956043955]
[]
[{"$nulls":4},24993]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},13.057993730407523]