{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Vendor Worksheet Instructions","Vendor Worksheet","Certification Instructions","Vendor Summary & Certification"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Vendor Worksheet Instructions","index":0,"n_rows":102,"n_cols":2,"rows_kept":102,"cut":false,"hidden":false,"merged":[[45,1,48,8],[50,1,50,8],[101,0,102,8],[96,0,99,8],[52,1,53,8],[67,1,68,8],[70,1,70,8],[90,1,92,8],[84,1,84,8],[86,1,86,8],[94,1,94,8],[88,1,88,8],[59,1,63,8],[71,1,71,8],[39,1,43,8],[34,1,35,8],[3,0,7,8],[27,1,28,8],[23,1,25,8],[37,0,38,8]]}
["SB 616 - EMPLOYEE SICK LEAVE 2024 RATE ADJUSTMENT"]
["WORKSHEET INSTRUCTIONS"]
[]
["These instructions are for the Vendor Worksheet.  After you read these instructions, please go to the “Vendor Worksheet” tab to begin.  You will ONLY be able to fill-in and select from the shaded fields on this worksheet.  The information you submit on this worksheet will be reviewed by the regional center.  If additional information is needed the regional center will contact you.  After the review, the regional center will respond to your request accordingly."]
[]
[]
[]
[]
[]
["SECTION A:  PROGRAM INFORMATION"]
[]
["Row 1","Please enter the Service Provider Name."]
[]
["Row 2","Please enter the six-digit Vendor Number."]
[]
["Row 3","Please enter the three-digit Service Code."]
[]
["Row 4","Please enter the Subcode if applicable."]
[]
["Row 5","Please enter the Staffing Ratio."]
[]
["Row 6","Please enter the number of Enrolled Consumers."]
[]
["Row 7","Please enter the dates for the beginning and end of a review period of 3 consecutive months.  If you have been recently vendored and have less that 3 months of payroll and billing data, please enter the dates for an applicable review period of up to 3 months.  Then select number of consecutive months of the review period, from the drop-down list."]
[]
[]
[]
["Row 8","Please enter the current rate as established by the Department and select the Unit Type, either Daily, Hourly or Monthly from the drop-down list."]
[]
[]
["Rows 9 & 10","Rate information will populate automatically here."]
[]
["Row 11","Select the Vendoring Regional Center from the drop-down list."]
[]
["Row 12-14","Select the User Regional Center(s), if applicable, from the drop-down list.  If you need to list additional user regional centers, please add rows by clicking as instructed on the designated button."]
[]
[]
["SECTION B:  EMPLOYEE WAGE INFORMATION - Applicable to only those employed staff needing to additional paid leave benefit of 2 days or 16 hours annually as described in SB 616."]
[]
["Column A","Please enter the name or initials of the employed staff who were paid during the review period, followed by their position title.  For any employee/position who received two or more different hourly wages during the review period being reported, please list only the most current wage paid with the requested information in columns B through I.  If additional rows are needed, please click on the designated button."]
[]
[]
[]
[]
[]
[null,"DO NOT include staff who are providing these services that are funded by another source, such as through a contract with a school district.  Also, DO NOT include wages paid to consumers while receiving these services or any worker who is paid through other sources such as contract funding."]
[]
[]
[]
[]
["Column B","Please enter the Position Title of the Employee."]
[]
["Column C","Please enter the current Hourly Wage paid to the employee(s) reported during the Review Period."]
[]
[]
["Columns D & E","Wage information will calculate automatically here."]
[]
["Column F","Please enter the Workers' Compensation Insurance Employer Rate as a percentage."]
[]
["Column G","Please enter your Total Unemploment Insurance contribution rate as a percentage,  including the net Federal and State rates, and the Employment Training Tax of 0.1%.  (Refer to your Form DE-2088 that you receive from the State of California Employment Development Department (EDD) for your contribution rates for Unemployment Insurance and Employment Training Tax.) "]
[]
[]
[]
[]
[]
["Column H","Wage information will calculate automatically here."]
[]
["Column I","Please enter the actual Total Hours Worked During the Review Period by each of the reported employee(s)."]
[]
[]
["Column J","Annualized hourly information will calculate automatically here."]
[]
["Column K","Please enter number of average number of hours staff would work in a standard scheduled day."]
[]
["Column L","Required Annualized Sick Leave Hours Earned, effective January 1, 2024, will automatically calculate here. "]
[]
["Column M","Please enter the Total Annualized Earned Sick Leave Staff Earned as of December 31, 2023. "]
[]
["Column N","SB 616 difference in earned sick leave will calculate automatically here. "]
[]
["Column O","Annualized cost of SB 616 difference of employee sick leave benefits will calculate automatically here."]
[]
["SECTION C:  RATE ADJUSTMENT CALCULATION"]
[]
["Row 1","Total wages, payroll taxes, workers' compensation, and other mandated employer costs will calculate automatically here."]
[]
["Row 2","Total Actual Number of Units of Services Billed to all Regional Centers during the \nreview period will calculate automatically here."]
[]
["Row 3","Total Annualized Number of Units of Services Billed to all Regional Centers will calculate automatically here."]
[]
["Rows 4 - 10","Please select the individual regional center(s) billed in the Review Period and enter the total units billed in the Review Period for the selected regional center(s).  If you need to list additional regional centers, please click the designated button."]
[]
[]
[]
["Row 11","The rate change will calculate automatically here and populate Row 9 in Section A, Program Information."]
[]
["Please review ALL the information you have entered on the worksheet.  Also, specifically review rows 9 - 10 in Section A, and row 11 in Section C.  These rows should have calculated rate information based on the data you have entered.  If there is an error message in these rows, you may need to re-enter the information in Sections A, B, and/or C."]
[]
[]
[]
[]
["Before submitting, please save your workbook using the vendor number in the title of the file.  Failure to do so results in the submission of an empty workbook."]

{"sheet":"Vendor Worksheet","index":1,"n_rows":158,"n_cols":16,"rows_kept":158,"cut":false,"hidden":false,"merged":[[14,2,14,6],[15,2,15,6],[17,2,17,6],[4,2,4,6],[5,2,5,6],[6,2,6,6],[8,2,8,6],[9,2,9,6],[16,2,16,6],[10,7,10,9],[11,3,11,5],[12,3,12,5],[12,7,12,9],[13,3,13,5],[13,7,13,9],[10,3,10,5],[23,14,26,14],[23,15,26,15],[23,10,26,10],[25,1,26,1],[23,3,26,3],[23,4,26,4],[23,6,26,6],[23,9,26,9],[23,5,26,5],[23,2,26,2],[23,8,26,8],[23,7,26,7],[23,11,26,11],[23,13,26,13],[23,12,26,12]]}
["Senate Bill No. 616 - Employee Sick Leave Rate Adjustment Calculation Worksheet"]
["Effective January 1, 2024"]
[]
["SECTION A:  PROGRAM INFORMATION"]
[1,"Service Provider Name"]
[2,"Vendor Number"]
[3,"Service Code"]
[4,"Sub-code (if applicable)"]
[5,"Staffing Ratio"]
[6,"Number of Enrolled Consumers"]
[7,"Review Period: (Enter Beginning & End)",null,"Select Number of Months in Review Period:"]
[8,"Current Rate:",null,"Select Unit Type: Daily or Hourly or Monthly"]
[9,"Rate Adjustment:",{"$f":"G96","v":{"$error":"#DIV/0!"}}]
[10,"New Rate:",{"$f":"C12+G96","v":{"$error":"#DIV/0!"}}]
[11,"Select Vendoring Regional Center from Drop Down Menu"]
[12,"Select User Regional Centers from Drop Down Menu"]
[{"$f":"A16+1","v":13},"Select User Regional Centers"]
[{"$f":"A17+1","v":14},"Select User Regional Centers"]
[]
[]
[]
["SECTION B:  EMPLOYEE WAGE INFORMATION"]
[null,"A","B","C","D","E ","F","G","H","I","J","K","L","M","N","O"]
[null,"Name or Initials of Staff Employee(s)","Position Title","Hourly Wage","Employer Social Security Tax @ 6.2%","Employer Medicare Tax @ 1.45%","Workers Compensation as a %","Total Unemployment Insurance as a %","Total Hourly Wage plus Mandate Payroll Costs","Total Hours Worked During the Review Period","Annualized Hours","Number of Hours Worked in a Standard Scheduled Day","Required Annualized Sick Leave Hours Earned eff. 1/1/2024","Total Standard Annual Sick Leave Hours Earned on 12/31/2023","Earned Sick Leave","Cost of the Employee Sick Leave Benefit"]
[]
["Row","(Please See Instructions for Listing Employees Receiving more than One Wage)"]
["#"]
[1,"Staff 1",null,null,{"$f":"D28*0.062","v":0},{"$f":"D28*0.0145","v":0},null,null,{"$f":"SUM(D28+E28+F28)+(D28*G28)+(D28*H28)","v":0},null,{"$f":"IFERROR((J28/$G$11)*12.01,0)","v":0},null,{"$f":"IF(L28>0,MAX(L28*5,40),0)","v":0},null,{"$f":"IF(IF(L28>8,MIN(M28-N28,L28*2),MIN(M28-N28,16))<0,0,IF(L28>8,MIN(M28-N28,L28*2),MIN(M28-N28,16)))","v":0},{"$f":"O28*I28","v":0}]
[2,"Staff 2 ",null,null,{"$f":"D29*0.062","v":0},{"$f":"D29*0.0145","v":0},null,null,{"$f":"SUM(D29+E29+F29)+(D29*G29)+(D29*H29)","v":0},null,{"$f":"IFERROR((J29/$G$11)*12.01,0)","v":0},null,{"$f":"IF(L29>0,MAX(L29*5,40),0)","v":0},null,{"$f":"IF(IF(L29>8,MIN(M29-N29,L29*2),MIN(M29-N29,16))<0,0,IF(L29>8,MIN(M29-N29,L29*2),MIN(M29-N29,16)))","v":0},0]
[3,"Staff 3",null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[4,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[5,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[6,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[7,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[8,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[9,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[{"$f":"A36+1","v":10},null,null,null,{"$f":"D37*0.062","v":0},{"$f":"D37*0.0145","v":0},null,null,{"$f":"SUM(D37+E37+F37)+(D37*G37)+(D37*H37)","v":0},null,0,null,0,null,0,0]
[{"$f":"A37+1","v":11},null,null,null,{"$f":"D38*0.062","v":0},{"$f":"D38*0.0145","v":0},null,null,{"$f":"SUM(D38+E38+F38)+(D38*G38)+(D38*H38)","v":0},null,{"$f":"IFERROR((J38/$G$11)*12.01,0)","v":0},null,{"$f":"IF(L38>0,MAX(L38*5,40),0)","v":0},null,{"$f":"IF(IF(L38>8,MIN(M38-N38,L38*2),MIN(M38-N38,16))<0,0,IF(L38>8,MIN(M38-N38,L38*2),MIN(M38-N38,16)))","v":0},{"$f":"O38*I38","v":0}]
[12,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[13,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[14,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[15,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[16,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[17,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[18,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[19,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[20,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[21,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[22,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[23,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[24,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[25,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[26,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[27,null,null,null,{"$f":"D54*0.062","v":0},{"$f":"D54*0.0145","v":0},null,null,{"$f":"SUM(D54+E54+F54)+(D54*G54)+(D54*H54)","v":0},null,{"$f":"IFERROR((J54/$G$11)*12.01,0)","v":0},null,{"$f":"IF(L54>0,MAX(L54*5,40),0)","v":0},null,{"$f":"IF(IF(L54>8,MIN(M54-N54,L54*2),MIN(M54-N54,16))<0,0,IF(L54>8,MIN(M54-N54,L54*2),MIN(M54-N54,16)))","v":0},{"$f":"O54*I54","v":0}]
[28,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[29,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[30,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[31,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[32,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[33,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[34,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[35,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[36,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[37,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[38,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[39,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[40,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[41,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[42,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[43,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[44,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[45,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[46,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[47,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[48,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[49,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[50,null,null,null,0,0,null,null,0,null,0,null,0,null,0,0]
[null,null,null,null,null,null,null,null,"Totals",{"$f":"SUM(J28:J77)","v":0},0,0,0,0,0]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost of Sick Leave Benefit",{"$f":"SUM(P28:P78)","v":0}]
[]
[]
[]
[]
["SECTION C:  RATE ADJUSTMENT CALCULATION"]
[1,null,null,null,null,"Total Cost of the Earned Sick Leave Benefit:",{"$f":"P79","v":0}]
[2,null,null,null,null,"Actual Number of Units of Services Billed to all Regional Centers for the Review Period:",{"$f":"SUM(G89:G95)","v":0}]
[3,null,null,null,null,"Annualized Number of Units of Service:",{"$f":"G86*4","v":0}]
[]
[4,"Select Regional Center from Drop Down Menu:",null,null,null,"Enter Total No. of Units for Review Period"]
[5,"Select Regional Center:",null,null,null,"Enter Total No. of Units for Review Period"]
[6,"Select Regional Center:",null,null,null,"Enter Total No. of Units for Review Period"]
[7,"Select Regional Center:",null,null,null,"Enter Total No. of Units for Review Period"]
[8,"Select Regional Center:",null,null,null,"Enter Total No. of Units for Review Period"]
[9,"Select Regional Center:",null,null,null,"Enter Total No. of Units for Review Period"]
[10,"Select Regional Center:",null,null,null,"Enter Total No. of Units for Review Period"]
[11,"Rate Change (Section C, Row 1: Total Cost of Earned Sick Leave Benefit/Section C, Row 3: Annualized Number of Units of Service)",null,null,null,null,{"$f":"ROUND(G85/G87,2)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Daily","Daily"]
["Hourly","Hourly"]
["Monthly","Monthly"]
[]
["ACRC","ACRC"]
["CVRC","CVRC"]
["ELARC","ELARC"]
["FDLRC","FDLRC"]
["FNRC","FNRC"]
["GGRC","GGRC"]
["HRC","HRC"]
["IRC","IRC"]
["KRC","KRC"]
["NBRC","NBRC"]
["NLACRC","NLACRC"]
["RCEB","RCEB"]
["RCOC","RCOC"]
["RCRC","RCRC"]
["SARC","SARC"]
["SCLARC","SCLARC"]
["SDRC","SDRC"]
["SGPRC","SGPRC"]
["TCRC","TCRC"]
["VMRC","VMRC"]
["WRC","WRC"]
[]
[1]
[2]
[3]

{"sheet":"Certification Instructions","index":2,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,0,30,8],[3,0,5,8],[7,0,9,8],[11,0,13,8],[17,0,20,8],[24,0,27,8],[22,0,22,8],[15,0,15,8]]}
["SB 616 - EMPLOYEE SICK LEAVE 2024 RATE ADJUSTMENT"]
["SUMMARY & CERTIFICATION INSTRUCTIONS"]
[]
["These instructions are for the Vendor Summary & Certification.   After you read these instructions, please go to the “Vendor Summary & Certification” tab.  Please review the Program Information and enter the service address associated with the information submitted on this workbook.  If your program has a different mailing address than the service address, please enter this information."]
[]
[]
[]
["Please enter the requested Contact Information for the individual responsible for completing this workbook.  This information will include Contact Name, Contact Phone Number, Email Address, and Executive Director/Owner."]
[]
[]
[]
["Please review the current rate, proposed rate change, and the proposed new rate, which are calculated based on the information you have entered on the worksheet.  If there is an error message in the rate information, go back and review the information in the worksheet. "]
[]
[]
[]
[]
[]
["We ask that you save this workbook using your vendor number and service code in the title of the file name.  For example, \"H12345 510.xlsm\", then email the workbook to the regional center at ratequestions@altaregional.org. Please ensure you keep copies for your records."]
[]
[]
[]
[]
["PLEASE NOTE:  By submitting the worksheet to the regional center, you certify that the information provided is specific to payroll costs necessary to meet the requirements of SB 616, that went into effect on January 1, 2024.  You additionally certify to the best of your knowledge and belief that the information submitted is true and correct, and subject to verification by all record keeping and audit processes, procedures, and guidelines under the Lanterman Act and Title 17 of the California Code of Regulations (CCR)."]
[]
["You must retain ALL backup documentation which supports the information being submitted in this workbook.  The backup information for the information provided on this workbook is subject to all record keeping and audit processes, procedures, and guidelines under the Lanterman Act and Title 17, CCR.  "]
[]
[]
[]
[" "]
["EMAIL ADDRESS:"]
["ratequestions@altaregional.org"]

{"sheet":"Vendor Summary & Certification","index":3,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[[24,2,24,5],[25,2,25,5],[5,2,5,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[22,2,22,5],[23,2,23,5],[18,2,18,5]]}
["SB 616 - EMPLOYEE SICK LEAVE 2024 RATE ADJUSTMENT"]
["SUMMARY & CERTIFICATION SHEET"]
[]
["PROGRAM INFORMATION"]
[]
["Service Provider Name:",null,{"$f":"'Vendor Worksheet'!C5:G5","v":0}]
["Vendor Number:",null,{"$f":"'Vendor Worksheet'!C6:G6","v":0}]
["Service Code:",null,{"$f":"'Vendor Worksheet'!C7:G7","v":0}]
["Subcode (if applicable):",null,{"$f":"'Vendor Worksheet'!C8","v":0}]
[]
["Service Address:"]
[]
[]
[]
[]
["Mailing Address:"]
["(if different than service address)"]
[]
[]
[]
["CONTACT INFORMATION"]
[null,null,"Individual Responsible for Completing Worksheet:"]
["Contact Name:"]
["Contact Phone Number:"]
["Email Address:"]
["Executive Director/Owner:"]
[]
["Current Rate:",null,{"$f":"'Vendor Worksheet'!C12","v":0}]
["Proposed Rate Change:",null,{"$f":"'Vendor Worksheet'!C13","v":{"$error":"#DIV/0!"}}]
["Proposed New Rate:",null,{"$f":"'Vendor Worksheet'!C14","v":{"$error":"#DIV/0!"}}]
["Unit Type:",null,{"$f":"'Vendor Worksheet'!G12","v":0}]