1 / 12

Shared Leave Training with Excel Model Detail

Shared Leave Training with Excel Model Detail. DISCLAIMER The most recent version of the Excel model is available on the SAFS website, and may differ slightly from the model presented here. History.

keiko-gill
Download Presentation

Shared Leave Training with Excel Model Detail

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Shared Leave Trainingwith Excel Model Detail DISCLAIMER The most recent version of the Excel model is available on the SAFS website, and may differ slightly from the model presented here.

  2. History • Prior to 2010, school district employees could only share leave with employees of the same district. • ESSB 6724 removed that limitation. • Now up to board of directors to determine if employees are allowed to share leave outside of the district.

  3. Implementation • Implementation is being handled in two parts. • Part I: Formal WACs • OSPI has filed rule changes with Code Reviser’s office. • Proposed WACs can be found at http://www.k12.wa.us/safs/PUB/WAC/wac.asp • Public Hearing scheduled for April 5 at 10:00 AM. • Part II: Excel Model • Based on model used by OFM for state agencies. • Two sheets: one for donor and one for donee.

  4. Calculation • Intent is to get the hourly salary rate for employees. • Model based off of existing OFM model for shared leave between state employees. • Complications: • Length of work year • Length of work day • Benefits • Pay frequency • Earned leave

  5. Donor Sheet Sample

  6. Selected Field Descriptions: Donor • Certificated/Classified • In-cell dropdown • Determines Benefit Rate • Contract Pay Frequency • In-cell dropdown • Annual, monthly, hourly • Based on how the employee’s pay rate is defined, NOT how often they are paid.

  7. Selected Field Descriptions: Donor • Hourly rate (calculated) • If employee is paid hourly, this is their base pay rate. • If employee is not hourly, this is their equivalent hourly rate. • Benefit Rate • Equal to 1+ the Benefit Rate as identified in the Omnibus Appropriations Act. • Varies whether employee is Certificated or Classified. • Total Salary Rate • Hourly Rate * Benefit Rate

  8. Donee Sheet Sample

  9. Selected Field Descriptions: Donee A few are similar to the Donor form: • Certificated/Classified • Pay Frequency • Hourly Rate (calculated) • Total Salary Rate

  10. Selected Field Descriptions: Donee • Contract Other Days Accrued • Applies to sick days, annual (vacation) leave, personal days, etc. • While receiving shared leave, the recipient is still an employee of the district. • Unless board policy dictates otherwise, they still accrue monthly leave. • Total Contract Annual Leave Days (calculated) • % of Contract: The total number of leave days divided by the total number of contract work days.

  11. Selected Field Descriptions: Donee • Benefit Rate • Portion based on Certificated/Classified employee type. • Portion based on Contract Days Accrued. • Total Salary Rate = Hourly Rate * Benefit Rate • Dollars Donated • Hours Received • Dollars Donated ÷ Total Salary Rate • Days Received • Hours Received ÷ Hours/Contract Day, or • Dollars Donated ÷ Total Salary Rate ÷ Hours/contract day

  12. Excel Model • Beta version of Excel model available on SAFS Tools page. • http://www.k12.wa.us/safs/TT/tools.asp

More Related