{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Vendor Worksheet Instructions","Vendor Worksheet","Certification Instructions","Vendor Summary & Certification"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":2,"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":78,"n_cols":2,"rows_kept":78,"cut":false,"hidden":false,"merged":[[77,0,80,8],[38,1,39,8],[41,1,42,8],[46,1,47,8],[53,1,53,8],[62,1,65,8],[71,1,71,8],[73,1,73,8],[75,1,75,8],[31,1,36,8],[27,1,27,8],[3,0,5,8],[20,1,21,8],[17,1,18,8]]}
["MINIMUM WAGE 2014 RATE ADJUSTMENT"]
["WORKSHEET INSTRUCTIONS"]
[]
["These instructions are for completing the Vendor Worksheet.  After you have 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 of Orange County (RCOC).  If additional information is needed, RCOC will contact you.  "]
[]
[]
[]
["SECTION A:  PROGRAM INFORMATION"]
[]
["Row 1","Please enter the Service Provider Name on the Vendor Worksheet (next tab)."]
[]
["Row 2","Please enter the six-digit Vendor Number on the Vendor Worksheet (next tab)."]
[]
["Row 3","Please enter the three-digit Service Code on the Vendor Worksheet (next tab)."]
[]
["Row 4","Please enter the Subcode if applicable on the Vendor Worksheet (next tab)."]
[]
["Row 5","Please enter actual data for the quarter of October 1, 2013 through December 31, 2013.  This is the Review Period.  If data is not available for this period, please enter an applicable Review Period of up to three (3) months, thereafter, for which actual data is available."]
[]
[]
["Row 6","Please enter the current rate as established by RCOC and select the Unit Type, either Daily or Hourly, from the drop-down list."]
[]
[]
["Rows 7 & 8","Rate information will populate automatically here."]
[]
["Row 9","Select the Vendoring Regional Center from the drop-down list."]
[]
["Row 10","RCOC is the User Regional Center."]
[]
["SECTION B:  EMPLOYEE WAGE INFORMATION"]
[]
["Column A","Please enter the name or initials of the employee(s) who were paid wages less than the new California minimum wage of $9.00 per hour during the Review Period.  For any employee who received two or more different wages at less than $9.00 per hour in the Review Period being reported, please list this employee as many times as necessary to separately reflect each wage paid with the requested information in columns B through H.  If additional rows are needed, please click on the designated button."]
[]
[]
[]
[]
[]
[]
[null,"Please DO NOT submit costs associated with staff hired to supplement staffing ratios for non-mobile consumers pursuant to Title 17, CCR, section 56756(b). "]
[]
[]
["Column B","Please enter the Current Hourly Wage paid to the employee(s) reported during the Review Period."]
[]
[]
["Columns C & D","Wage information will calculate automatically here."]
[]
["Column E","Please enter the Actual Hours Worked During the Review Period by each of the employee(s) reported."]
[]
[]
["Column F","Wage information will calculate automatically here."]
[]
["Column G","Please calculate the Workers' Compensation Employer Rate and enter as a percentage."]
[]
["Column H","Workers' Compensation Employer Cost information will calculate automatically here."]
[]
["Row I","Wage and Workers' Compensation totals will calculate automatically here."]
[]
["SECTION C:  PAYROLL TAXES, WORKERS' COMPENSATION INSURANCE, AND OTHER MANDATED"]
[null,"EMPLOYER COSTS"]
[]
["Rows J-M","Payroll Taxes and Workers' Compensation Insurance will calculate automatically here."]
[]
["Rows N & O","Please enter the total dollar amount and describe any other applicable mandated employer costs.  ONLY costs associated with the increase in the employee’s hourly wage to the new California minimum wage of $9.00 should be included.   DO NOT include Federal and State Unemployment Insurance Taxes."]
[]
[]
[]
[]
["Row P","Mandated employer costs will calculate automatically here."]
[]
["SECTION D:  RATE ADJUSTMENT CALCULATION"]
[]
["Row Q","Total wages, payroll taxes, workers' compensation, and other mandated employer costs will calculate automatically here."]
[]
["Row R","Total Actual Number of Units of Services Billed to RCOC will calculate automatically here."]
[]
["Row S","The rate change will calculate automatically here and populate Row 7 in Section A, Program Information."]
[]
["Please review ALL of the information you have entered on the worksheet, specifically rows 7 and 8 in Section A, and row S in Section D.  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 B, C, and/or D."]

{"sheet":"Vendor Worksheet","index":1,"n_rows":97,"n_cols":9,"rows_kept":97,"cut":false,"hidden":false,"merged":[[9,7,9,8],[10,7,10,8],[11,7,11,8],[9,3,9,5],[10,3,10,5],[11,3,11,5],[22,1,23,1],[55,2,55,5],[56,2,56,5],[54,2,54,5],[4,2,4,6],[12,2,12,6],[5,2,5,6],[6,2,6,6],[8,2,8,6],[51,2,51,5],[52,2,52,5],[53,2,53,5],[7,2,7,6],[13,2,13,6],[50,2,50,5]]}
["Minimum Wage Increase Calculation Worksheet"]
["Effective July 1, 2014"]
[]
["SECTION A:  PROGRAM INFORMATION"]
[1,"Service Provider Name","Parent Example for Personal Assistance"]
[2,"Vendor Number","H1111"]
[3,"Service Code",62]
[4,"Subcode (if Applicable)"]
[5,"Review Period:  (Enter Beginning & End Date of the Review Period) (See Note A)","October 1, 2013 through December 31, 2013"]
[6,"Current Rate:",8,"Select Unit Type: Daily or Hourly"]
[7,"Rate Change (Will Calculate Automatically based on Information Entered Below):",{"$f":"+G63","v":1.0900000000000001},null,null,{"$f":"F10","v":0},{"$f":"G10","v":0}]
[8,"New Rate (Will Calculate Automatically based on Information Entered Below):",{"$f":"+C10+C11","v":9.09},null,null,{"$f":"F10","v":0},{"$f":"G10","v":0}]
[9,"Select Vendoring Regional Center from Drop Down Menu","RCOC"]
[10,"Select User Regional Centers from Drop Down Menu (Please List All)","RCOC"]
[{"$f":"A14+1","v":11}]
[{"$f":"A15+1","v":12}]
[]
[]
["SECTION B:  EMPLOYEE WAGE INFORMATION"]
[null,"A","B","C","D","E","F","G","H"]
[null,null,null,null,null,"Actual","Actual","Workers'","Workers'"]
[null,"Name or Initials of Employee(s) Paid Less Than $9.00 per Hour",null,"New","Hourly","Hours Worked","Total Change","Compensation","Compensation"]
[null,"(Please See Instructions for Listing Employees Receiving More Than One Wage at Less Than $9.00 per Hour)","Hourly","Hourly","Wage Change","During","In Wages","Employer","Employer Cost"]
[null,null,"Wage","Wage","(C-B)","Review Period","(D x E)","Rate as %","(F x G)"]
[1,"Example only",8,9,{"$f":"IF(D25-C25>0,D25-C25,0)","v":1},100,{"$f":"ROUND(+E25*F25,2)","v":100},0.01,{"$f":"G25*H25","v":1}]
[2,null,null,9,{"$f":"IF(D26-C26>0,D26-C26,0)","v":9},null,{"$f":"ROUND(+E26*F26,2)","v":0},null,{"$f":"G26*H26","v":0}]
[{"$f":"A26+1","v":3},null,null,9,{"$f":"IF(D27-C27>0,D27-C27,0)","v":9},null,{"$f":"ROUND(+E27*F27,2)","v":0},null,{"$f":"G27*H27","v":0}]
[{"$f":"A27+1","v":4},null,null,9,9,null,0,null,0]
[4,null,null,9,9,null,0,null,0]
[5,null,null,9,9,null,0,null,0]
[6,null,null,9,9,null,0,null,0]
[7,null,null,9,9,null,0,null,0]
[8,null,null,9,9,null,0,null,0]
[9,null,null,9,9,null,0,null,0]
[10,null,null,9,9,null,0,null,0]
[11,null,null,9,9,null,0,null,0]
[12,null,null,9,9,null,0,null,0]
[13,null,null,9,9,null,0,null,0]
[14,null,null,9,9,null,0,null,0]
[15,null,null,9,9,null,0,null,0]
[16,null,null,9,9,null,0,null,0]
[17,null,null,9,9,null,0,null,0]
[18,null,null,9,9,null,0,null,0]
[19,null,null,9,9,null,0,null,0]
[{"$f":"A44+1","v":20},null,null,9,9,null,{"$f":"ROUND(+E45*F45,2)","v":0},null,{"$f":"G45*H45","v":0}]
["I","Total Actual Wages for the Review Period",null,null,null,null,{"$f":"SUM(G25:G45)","v":100},null,{"$f":"SUM(I25:I45)","v":1}]
[]
[]
[]
["SECTION C:  PAYROLL TAXES, WORKERS' COMPENSATION INSURANCE, AND OTHER"]
["J","Employer Social Security Tax @ 6.2%",null,null,null,null,{"$f":"+G46*0.062","v":6.2}]
["K","Employer Medicare Tax @1.45%",null,null,null,null,{"$f":"+G46*0.0145","v":1.4500000000000002}]
["L","Total Payroll Taxes for the Review Period",null,null,null,null,{"$f":"SUM(G51:G52)","v":7.65}]
["M","Workers' Compensation Insurance for the Review Period",null,null,null,null,{"$f":"I46","v":1}]
["N","Other Mandated Employer Costs (Describe Expense) (See Note B):",null,null,null,null,0]
["O","Other Mandated Employer Costs (Describe Expense) (See Note B):",null,null,null,null,0]
["P","Total Other Payroll Expenses for the Review Period",null,null,null,null,{"$f":"SUM(G55:G56)","v":0}]
[]
["SECTION D:  RATE ADJUSTMENT CALCULATION"]
["Q","Total Wages, Payroll Taxes, Workers' Comp, and Other (I+L+M+P)",null,null,null,null,{"$f":"+G46+G53+G54+G57","v":108.65}]
["R","Actual Number of Units of Services Billed to all Regional Centers for the Review Period:",null,null,null,null,{"$f":"SUM(G62:G62)","v":100}]
[1,"Select Regional Center from Drop Down Menu:","RCOC",null,null,"Enter Total No. of Units for Review Period",100]
["S","Rate Change (Q x R)",null,null,null,null,{"$f":"ROUND(G60/G61,2)","v":1.0900000000000001}]
[]
[]
[]
["Note A:  If information is not available for October 1, 2013 through December 31, 2013, please enter an applicable Review Period, thereafter, for which actual data is available."]
["Note B:  Please include only mandated employer costs impacted by minimum wage increase."]
[]
[]
[]
[]
[]
["Daily"]
["Hourly"]
[]
["ACRC"]
["CVRC"]
["ELARC"]
["FDLRC"]
["FNRC"]
["GGRC"]
["HRC"]
["IRC"]
["KRC"]
["NBRC"]
["NLACRC"]
["RCEB"]
["RCOC"]
["RCRC"]
["SARC"]
["SCLARC"]
["SDRC"]
["SGPRC"]
["TCRC"]
["VMRC"]
["WRC"]

{"sheet":"Certification Instructions","index":2,"n_rows":39,"n_cols":1,"rows_kept":39,"cut":false,"hidden":false,"merged":[[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]]}
["MINIMUM WAGE 2014 RATE ADJUSTMENT"]
["SUMMARY & CERTIFICATION INSTRUCTIONS"]
[]
["These instructions are for completing 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 in 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. "]
[]
[]
[]
["Please ensure you click on the \"I AGREE\" checkbox prior to saving or sending the workbook."]
[]
["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 RCOC at \"minwage@rcocdd.com” by clicking on the “SUBMIT” button on the bottom of the Vendor Summary & Certification worksheet.  Please ensure that you submit a copy to the vendoring regional center and to keep a copy for your records."]
[]
[]
[]
[]
["PLEASE NOTE:  By clicking on the “SUBMIT” button at the bottom of the “Vendor Summary & Certification” worksheet, you certify that the information provided to RCOC is specific to payroll costs associated with any increase necessary to adjust employee pay only to the extent necessary to bring pay into compliance with the increased California minimum wage of $9.00 per hour, and shall not be used as a wage enhancement for employees paid above the increased minimum wage.  You additionally certify that to the best of your knowledge and belief the information submitted is true and correct, and subject to verification by all recordkeeping 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 submitted in this workbook.  The backup information for the information provided on this workbook is subject to all recordkeeping and audit processes, procedures, and guidelines under the Lanterman Act and Title 17, CCR.  "]
[]
[]
[]
[" "]
["EMAIL ADDRESS:"]
["minwage@rcocdd.com"]
[]
["MAILING ADDRESS:"]
["Regional Center of Orange County"]
["Attention:  Minimum Wage Rate Adjustment Requests"]
["P.O. Box 22010"]
["Santa Ana, CA  92702-2010"]
[]
["(714) 796-5250 "]

{"sheet":"Vendor Summary & Certification","index":3,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[[15,2,15,5],[16,2,16,5],[17,2,17,5],[22,2,22,5],[23,2,23,5],[18,2,18,5],[5,2,5,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[24,2,24,5],[25,2,25,5],[32,0,39,8],[47,0,47,3],[48,0,48,3],[47,5,47,7],[48,5,48,7],[43,0,44,8]]}
["MINIMUM WAGE 2014 RATE ADJUSTMENT"]
["SUMMARY & CERTIFICATION SHEET"]
[]
["PROGRAM INFORMATION"]
[]
["Service Provider Name:",null,{"$f":"'Vendor Worksheet'!C5:G5","v":"Parent Example for Personal Assistance"}]
["Vendor Number:",null,{"$f":"'Vendor Worksheet'!C6:G6","v":"H1111"}]
["Service Code:",null,{"$f":"'Vendor Worksheet'!C7:G7","v":62}]
["Subcode (if applicable):",null,{"$f":"'Vendor Worksheet'!C8:G8","v":0}]
[]
["Service Address:",null,"123 Any Street"]
[null,null,"Santa Ana, CA  92705"]
[]
[]
[]
["Mailing Address:"]
["(if different than service address)"]
[]
[]
[]
["CONTACT INFORMATION"]
[null,null,"Individual Responsible for Completing Worksheet:"]
["Contact Name:",null,"Parent Example"]
["Contact Phone Number:",null,"714-111-1111"]
["Email Address:",null,"Parent @example.com"]
["Executive Director/Owner:",null,"Parent Example"]
[]
["Current Rate:",null,{"$f":"'Vendor Worksheet'!C10","v":8}]
["Proposed Rate Change:",null,{"$f":"'Vendor Worksheet'!C11","v":1.0900000000000001}]
["Proposed New Rate:",null,{"$f":"'Vendor Worksheet'!C12","v":9.09}]
["Unit Type:",null,{"$f":"'Vendor Worksheet'!G10","v":0}]
[]
["By checking the box below, I certify that information provided to RCOC is specific to payroll costs associated with any increase necessary to adjust employee pay only to the extent necessary to bring pay into compliance with the increased California minimum wage of $9.00 per hour and shall not be used as a wage enhancement for employees paid above the increased minimum wage.  I additionally certify that to the best of my knowledge and belief the information submitted is true and correct, and subject to verification by all recordkeeping and audit processes, procedures, and guidelines under the Lanterman Act and Title 17 of the California Code of Regulations.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"I AGREE"]
[]
["To submit this completed 'Vendor Summary & Certification' and 'Vendor Worksheet' electronically, please save the document as instructed on the Certification Instructions, then click on the following 'SUBMIT' button."]
[]
[]
[]
[]
[]
[]
["Please keep a copy for your records and submit a copy to the vendoring regional center."]