Filetype Excel XLSX | Posted on 08 Jul 2022 | 3 years ago
Authentication
digital resources
198x Filetype XLSX File size 0.08 MB Source: www.purdue.edu
Sheet 1: Instructions
| How to use the calculator: | |||||||||||
| This tool is used for calculating cost distribution for each period during the summer. It is best suited for calculating cost distribution for individuals that are on multiple accounts throughout a pay period. It is NOT required by Payroll or Managerial Accounting to be used, but rather is a tool to help make the cost distribution calculation easier since cost distribution for Summer Pay for AY employees is required to be the same for the entire pay period and since effort is certified by period. | |||||||||||
| Note, one spreadsheet is needed for each individual. | |||||||||||
| 1) Choose the appropriate set of tabs depending upon the type of employee that you are working on (Monthly (MO) or Bi-weekly(BW)) | |||||||||||
| 2) On the tab "Summer Calendar Information" enter account numbers to charge time to in row 4 (generally this information comes from the summer calendar). | |||||||||||
| 2) Then enter percentage of time spent under each account on each day. | |||||||||||
| 3) The cost distribution to be entered for the payroll cycle will be calculated on the "Cost Distribution" tab. | |||||||||||
| Summer Dates for Each Campus: | |||||||||||
| AY Summer Start date | AY Summer End date | ||||||||||
| West Lafayette | 5/16/2022 | 8/14/2022 | |||||||||
| Fort Wayne | 5/12/2022 | 8/14/2022 | |||||||||
| Northwest | 5/15/2022 | 8/14/2022 | |||||||||
| SUMMER COST DISTRIBUTION TOOL 2022 | ||||||||||||||||||
| Account 1 | Account 2 | Account 3 | Account 4 | Account 5 | Account 6 | Account 7 | Account 8 | Account 9 | Account 10 | Account 11 | Account 12 | |||||||
| Day | F.90015241.02.061 | F.90002441.06.007 | F.90002441.05.001 | 3200004977 | 3200008944 | Enter Acct # | 100% Cost Distribution Flag | |||||||||||
| 5/15/2022 | ||||||||||||||||||
| 5/16/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 5/17/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 5/18/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 5/19/2022 | 70 | 30 | Enter % on each Acct | 100 | ||||||||||||||
| 5/20/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 5/21/2022 | ||||||||||||||||||
| 5/22/2022 | ||||||||||||||||||
| 5/23/2022 | Enter % on each Acct | |||||||||||||||||
| 5/24/2022 | Enter % on each Acct | |||||||||||||||||
| 5/25/2022 | Enter % on each Acct | |||||||||||||||||
| 5/26/2022 | Enter % on each Acct | |||||||||||||||||
| 5/27/2022 | Enter % on each Acct | |||||||||||||||||
| 5/28/2022 | ||||||||||||||||||
| 5/29/2022 | ||||||||||||||||||
| 5/30/2022 | ||||||||||||||||||
| 5/31/2022 | 50 | 50 | Enter % on each Acct | 100 | ||||||||||||||
| 6/1/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 6/2/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 6/3/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 6/4/2022 | ||||||||||||||||||
| 6/5/2022 | ||||||||||||||||||
| 6/6/2022 | 25 | 25 | 25 | 25 | Enter % on each Acct | 100 | ||||||||||||
| 6/7/2022 | 25 | 25 | 25 | 25 | Enter % on each Acct | 100 | ||||||||||||
| 6/8/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 6/9/2022 | 20 | 20 | 60 | Enter % on each Acct | 100 | |||||||||||||
| 6/10/2022 | 40 | 40 | 20 | Enter % on each Acct | 100 | |||||||||||||
| 6/11/2022 | ||||||||||||||||||
| 6/12/2022 | ||||||||||||||||||
| 6/13/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 6/14/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 6/15/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 6/16/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 6/17/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 6/18/2022 | ||||||||||||||||||
| 6/19/2022 | ||||||||||||||||||
| 6/20/2022 | 25 | 25 | 25 | 25 | Enter % on each Acct | 100 | ||||||||||||
| 6/21/2022 | 25 | 25 | 25 | 25 | Enter % on each Acct | 100 | ||||||||||||
| 6/22/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 6/23/2022 | 20 | 20 | 60 | Enter % on each Acct | 100 | |||||||||||||
| 6/24/2022 | 40 | 40 | 20 | Enter % on each Acct | 100 | |||||||||||||
| 6/25/2022 | ||||||||||||||||||
| 6/26/2022 | ||||||||||||||||||
| 6/27/2022 | 30 | 70 | Enter % on each Acct | 100 | ||||||||||||||
| 6/28/2022 | 50 | 50 | Enter % on each Acct | 100 | ||||||||||||||
| 6/29/2022 | 50 | 50 | Enter % on each Acct | 100 | ||||||||||||||
| 6/30/2022 | 25 | 75 | Enter % on each Acct | 100 | ||||||||||||||
| 7/1/2022 | 25 | 75 | Enter % on each Acct | 100 | ||||||||||||||
| 7/2/2022 | ||||||||||||||||||
| 7/3/2022 | ||||||||||||||||||
| 7/4/2022 | ||||||||||||||||||
| 7/5/2022 | 20 | 20 | 20 | 20 | 20 | Enter % on each Acct | 100 | |||||||||||
| 7/6/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 7/7/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 7/8/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 7/9/2022 | ||||||||||||||||||
| 7/10/2022 | ||||||||||||||||||
| 7/11/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 7/12/2022 | 50 | 50 | Enter % on each Acct | 100 | ||||||||||||||
| 7/13/2022 | 50 | 50 | Enter % on each Acct | 100 | ||||||||||||||
| 7/14/2022 | 50 | 50 | Enter % on each Acct | 100 | ||||||||||||||
| 7/15/2022 | 50 | 50 | Enter % on each Acct | 100 | ||||||||||||||
| 7/16/2022 | ||||||||||||||||||
| 7/17/2022 | ||||||||||||||||||
| 7/18/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 7/19/2022 | 50 | 50 | Enter % on each Acct | 100 | ||||||||||||||
| 7/20/2022 | 50 | 50 | Enter % on each Acct | 100 | ||||||||||||||
| 7/21/2022 | 50 | 50 | Enter % on each Acct | 100 | ||||||||||||||
| 7/22/2022 | 50 | 50 | Enter % on each Acct | 100 | ||||||||||||||
| 7/23/2022 | ||||||||||||||||||
| 7/24/2022 | ||||||||||||||||||
| 7/25/2022 | 20 | 20 | 20 | 20 | 20 | Enter % on each Acct | 100 | |||||||||||
| 7/26/2022 | 20 | 20 | 20 | 20 | 20 | Enter % on each Acct | 100 | |||||||||||
| 7/27/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 7/28/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 7/29/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 7/30/2022 | ||||||||||||||||||
| 7/31/2022 | ||||||||||||||||||
| 8/1/2022 | 30 | 70 | Enter % on each Acct | 100 | ||||||||||||||
| 8/2/2022 | 30 | 70 | Enter % on each Acct | 100 | ||||||||||||||
| 8/3/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 8/4/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 8/5/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 8/6/2022 | ||||||||||||||||||
| 8/7/2022 | ||||||||||||||||||
| 8/8/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 8/9/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 8/10/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 8/11/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 8/12/2022 | 100 | Enter % on each Acct | 100 | |||||||||||||||
| 8/13/2022 | ||||||||||||||||||
| 8/14/2022 | ||||||||||||||||||
| Keying Cost Distribution - Summer 2022 | ||||||||||||||
| Account 1 | Account 2 | Account 3 | Account 4 | Account 5 | Account 6 | Account 7 | Account 8 | Account 9 | Account 10 | Account 11 | Account 12 | Total | ||
| PP | Cost Distribution Dates | F.90015241.02.061 | F.90002441.06.007 | F.90002441.05.001 | 3200004977 | 3200008944 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| PP05 | 5/15/22-5/31/22 | 25.00% | 20.00% | 55.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 100.00% |
| PP06 | 6/1/22-6/30/22 | 12.50% | 17.73% | 50.45% | 19.32% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 100.00% |
| PP07 | 7/1/22 -7/31/22 | 9.25% | 18.00% | 18.00% | 11.75% | 43.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 100.00% |
| PP08 | 8/1/22 - 8/14/22 | 36.00% | 14.00% | 10.00% | 40.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 100.00% |
| Reference Summer Payroll Training for additional guidance | ||||||||||||||
no reviews yet
Please Login to review.
