Excel Model for Shared Leave Training 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.
•
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.
2
•
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
–
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.
3
•
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
4
5
•
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.
6
•
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
7
8
A few are similar to the Donor form:
•
Certificated/Classified
•
Pay Frequency
•
Hourly Rate (calculated)
•
Total Salary Rate
9
•
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.
10
•
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
11
•
Beta version of Excel model available on SAFS
Tools page.
•
http://www.k12.wa.us/safs/TT/tools.asp
12
The Excel model for shared leave training detail allows school district employees to share leave both within and outside their district. The model facilitates the calculation of hourly salary rates and benefits for employees interested in participating in the shared leave program. The implementation involves rule changes, including Forma WACs, and is divided into two parts for a comprehensive approach. The model is based on existing OFM models and provides a structured format for determining total salary rates, hours donated, and dollars contributed.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
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.
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. 2
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 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. 3
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 4
Field Sample Butcher Jim Certificated Annual $97,500.00 Source User-entered User-entered In-cell dropdown In-cell dropdown User-entered Donor Last Name Donor First Name Certificated/Classified Pay Frequency Pay Frequency Rate # of Contract Days (Annual) Hours / Contract Day Hourly Rate Benefit Rate Total Salary Rate Hours Donated Dollars Contributed 180 User-entered 6.00 $90.28 1.1379 $102.73 80 $8,218.40 User-entered Calculated Calculated Calculated User-entered Calculated 5
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. 6
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 7
Field Sample Dresden Harry Certificated Hourly $17.99 180 4.00 $17.99 1.1379 12.00 22.00 1.00 35.00 19.44% 1.3323 $9,216 $26,473 $36.77 $8,218.40 223.51 55.88 Source User-entered User-entered In-cell dropdown In-cell dropdown User-entered User-entered User-entered Calculated Calculated User-entered User-entered User-entered Calculated Calculated Calculated Calculated Calculated Calculated User-entered Calculated Calculated Donee Last Name Donee First Name Certificated/Classified Pay Frequency Pay Frequency Rate # of Contract Days (Annual) Hours / contract day Hourly Rate State Benefit Rate Contract Annual Sick Days Accrued Contract Annual Vacation Days Accrued Contract Other Days Accrued Total Contract Annual Leave Days % of contract Effective Benefit Rate Insurance Benefits (annual) Total Annual Salary Rate Total Salary Rate (Hourly) Dollars Donated Hours Received Days Received 8
A few are similar to the Donor form: Certificated/Classified Pay Frequency Hourly Rate (calculated) Total Salary Rate 9
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. 10
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 11
Beta version of Excel model available on SAFS Tools page. http://www.k12.wa.us/safs/TT/tools.asp 12
