{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["Mission Vision & Values","Broad Salary Considerations","Holiday","Floor Plan","Billing","Scheduling","COGS","Sheet6","Monthly Costs","Bank Loan and Interest","P&L Overall"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Mission Vision & Values","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,3,0],[5,0,8,0],[10,0,13,0]]}
["Mission"]
[]
[]
[]
[]
["Vision"]
[]
[]
[]
[]
["Values"]

{"sheet":"Broad Salary Considerations","index":1,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Providers","Annual Salary","FTE","Fringe Rate","Fringe","Total Comp","Hourly","Daily","Weekly","Monthy"]
["Provider I",85000,1,0.25,{"$f":"(B2*D2)","v":21250},{"$f":"SUM(B2+E2)","v":106250},{"$f":"F2/2080","v":51.081730769230766},{"$f":"F2/260","v":408.65384615384613},{"$f":"F2/52","v":2043.2692307692307},{"$f":"F2/12","v":8854.1666666666661}]
["Provider II",75000,1,0.25,{"$f":"(B3*D3)","v":18750},{"$f":"SUM(B3+E3)","v":93750},{"$f":"F3/2080","v":45.072115384615387},{"$f":"F3/260","v":360.57692307692309},{"$f":"F3/52","v":1802.8846153846155},{"$f":"F3/12","v":7812.5}]
["Provider III",75000,1,0.25,18750,93750,{"$f":"F4/2080","v":45.072115384615387},{"$f":"F4/260","v":360.57692307692309},1802.8846153846155,{"$f":"F4/12","v":7812.5}]
["Receptionist ",38000,1,0.25,9500,47500,22.83653846153846,182.69230769230768,913.46153846153845,3958.3333333333335]
["Part time receptionist/biller",38000,1,0.05,1900,{"$f":"SUM(B6+E6)","v":39900},19.182692307692307,153.46153846153845,767.30769230769226,3325]
[]
[]
[{"$nulls":5},{"$f":"SUM(F2:F6)","v":381150},183.24519230769232,1465.9615384615386,{"$f":"SUM(I2:I6)","v":7329.8076923076924},{"$f":"SUM(J2:J6)","v":31762.499999999996}]
[]
[]
[]
[]
[]
[]
[{"$nulls":11},"**This sheet makes broad assumptions: 2,080 working hours per year with a 30% fringe rate. You may change these values to be more precise (eg fringe may need to increase)"]
[{"$nulls":11},"A fringe rate, or benefit rate, is the cost of an employee's benefits divided by the wages paid to an employee for the hours working on the job."]
[{"$nulls":11},"What's included in fringe? To learn more: https://www.zenefits.com/workest/what-are-fringe-benefits-small-business-explainer/"]

{"sheet":"Holiday","index":2,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Holiday List"]
[]
["New Year’s Day – January 1st "]
["Martin Luther King Jr’s birthday –January 20th "]
["Washington’s birthday (President’s Day) – February 17th "]
["Memorial Day –May 25th "]
["Independence Day – July 4th "]
["Labor Day – September 7th "]
["Columbus Day – October 12th "]
["Veterans Day – November 11th "]
["Thanksgiving Day – November 26th "]
["Christmas Day – December 25th "]

{"sheet":"Floor Plan","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Billing","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Scheduling","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"COGS","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet6","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Monthly Costs","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Bank Loan and Interest","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"P&L Overall","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}