{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Operating in Year 2","Fee-for-service","Equipment Explanation "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":11,"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":"Operating in Year 2","index":0,"n_rows":98,"n_cols":7,"rows_kept":98,"cut":false,"hidden":false,"merged":[[0,0,1,4],[5,1,5,3],[97,0,97,4],[96,0,96,4],[95,0,95,4],[94,0,94,4],[93,0,93,4]]}
["SMILES DENTAL PROJECT SAMPLE BUSINESS PLAN TEMPLATE"]
[]
["(Operating in Year 2)"]
[]
[]
[null,"YEAR",null,null,"YEAR"]
[null,1,null,null,2]
[null,"(Start-up or Expansion)",null,null,"(1st year of Operation)"]
["REVENUE:"]
["Number of Patients Per Day ",null,null,null,6,null,"Consider providing care at before and after care  - need to consider set up, break down, school holidays"]
["Number of Clinical Care Days Per Year ",null,null,null,108]
["Total EncountersA",null,null,null,{"$f":"E10*E11","v":648}]
["Medicaid Encounters %",null,null,null,0.3]
["Ave. Medicaid Reimbursement RateB",null,null,null,{"$f":"'Fee-for-service'!E19","v":282.31}]
["Medicaid Collection Rate %",null,null,null,1]
["Estimated Medicaid Revenue",null,null,null,{"$f":"E12*E13*E14*E15","v":54881.063999999998}]
["Sliding Fee Scale Encounters %",null,null,null,0.3]
["Sliding Fee Scale Rate",null,null,null,20]
["Sliding Fee Scale Collection Rate %",null,null,null,1]
["Estimated Sliding Fee Scale Revenue",null,null,null,{"$f":"E12*E17*E18*E19","v":3888}]
["CHP+ Encounters %",null,null,null,0.3]
["CHP+ Encounters RateC",null,null,null,{"$f":"'Fee-for-service'!G19","v":0}]
["CHP+ Collection Rate %",null,null,null,1]
["Estimated CHP+ Revenue",null,null,null,{"$f":"E12*E21*E22*E23","v":0}]
["Private Insurance Encounters %",null,null,null,0.1]
["Private Insurance Rate",null,null,null,{"$f":"E14","v":282.31}]
["Private Insurance Collection Rate %",null,null,null,1]
["Estimated Private Insurance Revenue",null,null,null,{"$f":"E12*E25*E26*E27","v":18293.687999999998}]
["Total Revenue",null,null,null,{"$f":"SUM(E28,E24, E20,E16)","v":77062.751999999993}]
["EXPENSES:"]
["Personnel:"]
["Number of FTE Dentists",null,null,null,0.1,null,"consider dentist time in relation to RDH time"]
["Rate FTE Dentists",null,null,null,150000,"Median = >$140,000"]
["Number of FTE Dental Hygienists",null,null,null,0.6]
["Rate FTE Hygienist",null,null,null,70000,"Range  = $50,000 to $70,000","Pay RDH for 10 hours a day to cover administrative time"]
["Number of FTE Patient Navigator",null,null,null,1]
["Rate FTE Patient Navigator ",null,null,null,35000,"Range = $30,000 to $40,000"]
["Number of Intake Specialists",null,null,null,0.25]
["Rate of FTE Intake Specialists ",null,null,null,35000]
["Total Personnel",null,null,null,{"$f":"(E32*E33)+(E34*E35)+(E36*E37)+(E38*E39)","v":100750}]
["Fringe Benefits "]
["Total Fringe Benefits",null,null,null,{"$f":"$G$42*E40","v":24180},"Fringe Benefit Percentage",0.24]
["Equipment:"]
["Operatory Equipment:","QTY.","PRICE","TOTAL COST"]
["Portable Dental Unit",1,4470,{"$f":"SUM(B45*C45)","v":4470}]
["Cavitron Select SPS Scaler ",1,2000,{"$f":"SUM(B46*C46)","v":2000}]
["Adult Patient Chair",1,3834,{"$f":"SUM(B47*C47)","v":3834}]
["Child Patient Chair",0,3500,{"$f":"SUM(C48*B48)","v":0}]
["Portable Drs Stool  ",1,783,{"$f":"SUM(B49*C49)","v":783}]
["Light, LED W/Wheeled Floor Stand",1,1763,1763]
["Electronic Dental Record License",1,5250,{"$f":"SUM(B51*C51)","v":5250}]
["PC  Laptop",1,1600,1600]
["Printer/Scanner",1,70,70]
["Total Operatory Cost ",null,{"$f":"SUM(C45:C53)","v":23270},{"$f":"SUM(D45:D53)","v":19770}]
["X-Ray & Camera Equipment:"]
["NOMAD Pro2 60kV X-Ray BLK ",1,7892,{"$f":"SUM(B56*C56)","v":7892}]
["DEXIS Platinum Digital X-ray System includes In Office Training, 1 year DEXcare. Includes sensor, software and accessories ",1,14995,{"$f":"SUM(B57*C57)","v":14995}]
["DEXcam 4 ",1,5995,{"$f":"SUM(B58*C58)","v":5995}]
["Lead Apron",2,250,{"$f":"B59*C59","v":500}]
["Total X-Ray & Camera Equipment Cost",null,null,{"$f":"SUM(D56:D58)","v":28882}]
["Sterilization Equipment"]
["M3 UltraFast Auto Sterilizer ",1,5299,{"$f":"SUM(B62*C62)","v":5299}]
["Ultrasonic Cleaner w/Digital ",1,400,{"$f":"SUM(B63*C63)","v":400}]
["Ultrasonic Accessory Package ",1,126,{"$f":"SUM(B64*C64)","v":126}]
["Total Sterilization Equipment Cost",null,null,{"$f":"SUM(D62:D64)","v":5825}]
["Instruments etc."]
["One-time Instrument PurchaseD",1,3968,{"$f":"B67*C67","v":3968}]
["Total Instruments",null,null,{"$f":"SUM(D67)","v":3968}]
["Total Equipment",null,null,{"$f":"SUM(D68,D65,D60,D54)","v":58445}]
["Supplies"]
["Total SuppliesE",null,null,null,{"$f":"G71*E12","v":5184},"Rate Per Encounter",8]
["Other Expenses"]
["Operating Costs: Nominal rent, Phone, Internet, server & IT support",null,null,null,{"$f":"E29*0.1","v":7706.2752}]
["Administration Costs (Includes Program Management, accounting & billing)",null,null,null,{"$f":"G74*E12","v":4984.6153846153848},"Rate Per Encounter ",{"$f":"10000/1300","v":7.6923076923076925}]
["Local Travel",null,null,null,{"$f":"G75*0.572","v":0},"Average Trip Mileage "]
["National Travel",null,null,null,null,"Rate Per FTE Staff Needed"]
["Recruitment of dental staff",null,null,null,{"$f":"G77*(E32+E34+E36)","v":3400},"Rate Per FTE Staff Needed",2000]
["Repairs and maintenance",null,null,null,null,"Rate Per Pieces of Equipment",{"$f":"1000/3","v":333.33333333333331}]
["Postage",null,null,null,{"$f":"G79*E12","v":43.78378378378379},"Rate Per Encounter ",{"$f":"250/3700","v":6.7567567567567571E-2}]
["Marketing/Outreach",null,null,null,{"$f":"G80*E12","v":700.54054054054063},"Rate Per Encounter ",{"$f":"4000/3700","v":1.0810810810810811}]
["Miscellaneous",null,null,null,{"$f":"G81*E12","v":61.297297297297298},"Rate Per Encounter ",{"$f":"350/3700","v":9.45945945945946E-2}]
["Total Other Expenses",null,null,null,{"$f":"SUM(E73:E81)","v":16896.512206237006}]
[]
["One Time Capital Cost",null,null,{"$f":"SUM(D69)","v":58445},0]
["Ongoing Costs",null,null,0,{"$f":"SUM(E82+E71+E42+E40)","v":147010.51220623701}]
["Total Expenses",null,null,{"$f":"SUM(,D69)","v":58445},{"$f":"SUM(E82,E71,E42,E40)","v":147010.51220623701}]
[]
["Net Profit/Loss",null,null,{"$f":"D29-D86","v":-58445},{"$f":"E29-E86","v":-69947.760206237013}]
[]
["Cost Per Encounter",null,null,null,{"$f":"E86/E12","v":226.86807439234107}]
["Cost Per Patient",null,null,null,{"$f":"E90*2.3","v":521.79657110238441}]
[]
[]
["ADefined as a face-to-face encounter between a dentist or dental hygienist and a client for the purpose of prevention, assessment, or treatment of a dental problem, including restoration. "]
["BMedicaid reimbursement per encounter, see Fee-for service tab, Cell C7."]
["CCHP+ Reimbursement per encounter, see Fee-for service tab, Cell D7."]
["DSee Equipment Explanation tab, Cell B22."]
["E See Equipment Explanation tab, Cell B24."]

{"sheet":"Fee-for-service","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[9,7,12,8],[1,7,7,8],[15,7,17,8]]}
["CODE","DESCRIPTION","CODE SELECTED (CHECKED=TRUE, UNCHECKED = FALSE)","MEDICAID REIMBURSEMENT (hide)","MEDICAID REIMBURSEMENT","CHP+ REIMBURSEMENT","CHP+ REIMBURSEMENT"]
[null,"Intraoral - complete series of radiographic images",true,78.75,{"$f":"IF(C2=TRUE,D2,IF(C2=FALSE,0))","v":78.75},47.45,0]
[null,"Intraoral - periapical first radiographic image",true,11.74,{"$f":"IF(C3=TRUE,D3,IF(C3=FALSE,0))","v":11.74},null,0]
[null,"Intraoral - periapical each additional radiographic image",false,11.74,0,null,0]
[null,"Bitewings - two radiographic images",true,19.739999999999998,19.739999999999998,null,0]
[null,"Bitewings - four radiographic images",false,27.75,0,null,0]
[null,"Comprehensive oral evaluation ",true,36.83,{"$f":"IF(C7=TRUE,D7,IF(C7=FALSE,0))","v":36.83},28.86,0]
[null,"Periodic oral evaluation",false,21.36,{"$f":"IF(C8=TRUE,D8,IF(C8=FALSE,0))","v":0},16.2,0]
[null,"Protection restoration/Interim therapeutic restoration - primary dentition",false,49.09,{"$f":"IF(C9=TRUE,D9*I9,IF(C9=FALSE,0))","v":0},36.520000000000003,0,"Average percentage of patients needing ITR = ",1]
[null,"Prophylaxis - adult ",false,39.21,0,34.14,0]
[null,"Prophylaxis - child ",true,29.2,{"$f":"IF(C11=TRUE,D11,IF(C11=FALSE,0))","v":29.2},23.42,0]
[null,"Topical application of fluoride varnish",true,29.35,29.35,15.07,0]
[null,"Topical application of fluoride - excluding varnish",true,10.9,10.9,0,0]
[null,"Sealant - per tooth",true,32.9,{"$f":"IF(C14=TRUE,(D14*I14),IF(C14=FALSE,0))","v":65.8},18.53,0,"Average number of sealants = ",2]
[null,null,null,null,178]
[null,"Caries risk assessment and documentation, with a finding of low risk",null,null,"N/A",null,"N/A"]
[null,"Caries risk assessment and documentation, with a finding of moderate risk",null,null,"N/A",null,"N/A"]
[null,"Caries risk assessment and documentation, with a finding of high risk",null,null,"N/A",null,"N/A"]
["Total",null,null,null,{"$f":"SUM(E2:E14)","v":282.31},null,{"$f":"SUM(G2:G14)","v":0}]

{"sheet":"Equipment Explanation ","index":2,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["EQUIPMENT DESCRIPTION","EXPLANATION"]
["GENERAL EQUIPMENT"]
["Portable Dental Unit","Self-contained dental system that contains 2 air handpiece connections, 3-way air/water syringes, high volume evacuator, saliva ejector. "]
["Cavitron Select SPS Scaler ","Ultrasonic cleaning device"]
["Adult Patient Chair","Portable patient chair with a scissor base for adult up to 500 lbs. "]
["Portable Drs Stool  ","Self-explanatory"]
["Light","LED W/Wheeled Floor Stand"]
["Electronic Health Care Software","Self-explanatory"]
["PC  Laptop","PC Laptop required for DEXIS software"]
["X-RAY/CAMERA"]
["NOMAD Pro2 60kV X-Ray BLK ","X-ray machine"]
["DEXIS Platinum Digital X-ray System includes In Office Training, 1 year DEXcare. Includes sensor, software and accessories ","X-ray sensor and software"]
["DEXcam 4 ","Intraoral camera"]
["STERILIZATION"]
["M3 UltraFast Auto Sterilizer ","Delicate instrument autoclave sterilizer"]
["Ultrasonic Cleaner w/Digital ","Sterilizer for all other instruments"]
["Ultrasonic Accessory Package ","Self-explanatory"]
["INSTRUMENTS"]
["Instruments","Includes basic exam, preventative, and ITR instruments, such as mouth mirrors, explorers, periodontal probes, prophy angle, spoon excavator, amalgamator (triturator), curing light, cotton forceps, etc."]
["SUPPLIES"]
["Supplies ","Includes basic disposables items for preventative care and infection control, such as floss, disclosing solution, fluoride products and trays, etc. It also includes Glass Ionomer restorative material and conditioner. "]