ࡱ> 9;8_ bjbjPP 4(y:<\y:<\&&, jc e e e e e e $N"%   999c 9c 999g.9O  0 9%%996%o9  %&> d: PAYROLL WORKSHEET BY COLUMN The following description, by table and column, indicates which cells are for department adjustment or entry (entry) and which ones may have formulas or data that is feed to a formula and should not be changed (formula): Table 1. Current as of: (Formula) Date and time the report was last updated and saved Data thru LD#: (Entry) Last pay period number on the Organization Detail Activity report. This information is found on the management report due date schedule. LD date is: (Formula) Ending date of pay period identified above (Data thru LD#) Table 2. Benefit Type (Formulas) Listing of benefit types by Payroll Job Categories or Employee Class Table 3. Leave and Benefit Rates (Formulas) Listing of leave and benefit rates by job categories Column A. (Entry) Employee name enter employee name as listed on Job Form, including UAID # might be a helpful tool for research purposes. Column B. (Entry) Hourly wage, for adjunct faculty enter full amount per contract & 1 in Hrs Per Day (column H) Column C. (Entry) Employee Object code category (i.e. 1401, 1251, 1101) Column D. (Entry) Employee Position Control Number, use PCN (include suffix if employee job suffix changes periodically). i.e. adjunct faculty may have the same PCN with a different suffix for each semester. Column E. (Entry) Benefit Code from Benefit Type table Column F. (Entry) Beginning date, listed on Job Form or employment contract Column G. (Entry) End date, listed on Job Form or employment contract, should not go beyond 6/30 Column H. (Entry) Number of hours worked each day listed on Job Form Column I. (Formula) Date adjustment calculation Column J. (Formula) Date adjustment calculation Column K. Days Per Contract (Formula) Calculates the total days per contract based on the start and stop dates of employment Column L. Days Rem (Formula) Calculates the remaining days of employment based on the stop date of employment and the number of pay periods remaining thru 6/30 Column M. Sick (Entry) Projected days of sick leave from the last recorded pay period through 6/30 (Record entry as a negative figure and update the projections accordingly) or allow the formula in column Q to calculate at a rate of 15% Column N. Holiday (Formula) Remaining holidays through 6/30 Column O. Annual (Entry) Projected days of annual leave from the last recorded pay period through 6/30 (Record entry as a negative figure and update projections accordingly) or allow the formula in column Q to calculate at a rate of 15% Column P. Personal (Formula) Projected personal holiday use through 6/30 Column Q. Other (Formula) Optional - automatically calculates leave totals at a rate of 15% based on Benefit Type Column R. Total Days of Leave (Formula) summarizes the total remaining leave days through 6/30 Column S. (Entry) Optional- Adjustment column (hours) Column T. Net Hours Remaining (Formula) Calculation converts the number of days into hours Column U. Gross Earnings (Formula) Calculates gross earning based on net hours times hourly rate Column V-X. Annual, Sick, Holiday Leave (Formulas) Calculation of annual, sick and holiday charges based on gross earning and benefit type Column Y. Total Leave (Formula) Total leave charges from columns V thru X LABOR PROJECTIONS: Column Z. Total Salary (Formula) Total gross earning and leave charges Column AA. Total Benefits (Formula) Calculates staff benefit charges on gross earnings and leave charges based on benefit type Column AB. Total Labor (Formula) Total labor (Salary + staff benefits) TOTAL PAYROLL PROJECTIONS: The total payroll projections for this worksheet will automatically transfer to the detail sheet in your management report workbook. gh _ h C L Y    *    < R S ѲѢѲіѢъѢѲ{ѢѲ{Ѳohz CJOJQJaJhL:hCJOJQJaJh(3sCJOJQJaJhCJOJQJaJhL:h;5CJOJQJaJ%hL:h;B*CJOJQJaJphhCJOJQJaJhL:h;CJOJQJaJhL:h"CJOJQJaJ hL:h;0JCJOJQJaJ+ Q C L S $ [ M} [$\$gd[$\$`gd [$\$gd"$[$\$a$gd"S \ ] e f w x  # $ - . 5 H Z [ d e l w :DLMV}*34=;௣ྯhhCJOJQJaJhz CJOJQJaJhCJOJQJaJhL:hCJOJQJaJhL:h)CJOJQJaJ%hL:h;B*CJOJQJaJphhL:h;CJOJQJaJhL:h;5CJOJQJaJ5*,3z# [$\$gdxJp [$\$gd) [$\$gd"=)-xy{X\'+,56<FNOQŹxxxh)h)CJOJQJaJhxJpCJOJQJaJ%hz h)B*CJOJQJaJph%hL:h;B*CJOJQJaJphhCJOJQJaJh5CJOJQJaJhL:h;5CJOJQJaJhL:h)CJOJQJaJhL:h;CJOJQJaJ/3<=Qz#.񤕃sddshL:hxJpCJOJQJaJhL:hxJp5CJOJQJaJ"hL:h;5CJOJQJ\aJhxJp5CJOJQJ\aJhL:h"CJOJQJaJ%hL:h;B*CJOJQJaJphhL:h;5CJOJQJaJhL:hL:CJOJQJaJhxJpCJOJQJaJhL:h;CJOJQJaJ$.<=nչչժ}n_hL:hM2CJOJQJaJhL:h)CJOJQJaJhz CJOJQJaJhL:h;CJOJQJaJ"hL:h;5CJOJQJ\aJhL:h"CJOJQJaJhxJpCJOJQJaJhL:hxJp5CJOJQJaJhL:hxJpCJOJQJaJhxJp5CJOJQJaJhxJphxJpCJOJQJaJgd"21h:p"/ =!"#$% s2&6FVfv2(&6FVfv&6FVfv&6FVfv&6FVfv&6FVfv&6FVfv8XV~ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@_HmH nH sH tH @`@ NormalCJ_HaJmH sH tH DA D Default Paragraph FontRiR  Table Normal4 l4a (k (No List B^@B ; Normal (Web)dd[$\$*W`* ;Strong5\HH @ Balloon TextCJOJQJ^JaJN/!N @Balloon Text CharCJOJQJ^JaJPK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭VvnB`2ǃ,!"E3p#9GQd; H xuv 0F[,F᚜K sO'3w #vfSVbsؠyX p5veuw 1z@ l,i!b I jZ2|9L$Z15xl.(zm${d:\@'23œln$^-@^i?D&|#td!6lġB"&63yy@t!HjpU*yeXry3~{s:FXI O5Y[Y!}S˪.7bd|n]671. tn/w/+[t6}PsںsL. J;̊iN $AI)t2 Lmx:(}\-i*xQCJuWl'QyI@ھ m2DBAR4 w¢naQ`ԲɁ W=0#xBdT/.3-F>bYL%׭˓KK 6HhfPQ=h)GBms]_Ԡ'CZѨys v@c])h7Jهic?FS.NP$ e&\Ӏ+I "'%QÕ@c![paAV.9Hd<ӮHVX*%A{Yr Aբ pxSL9":3U5U NC(p%u@;[d`4)]t#9M4W=P5*f̰lk<_X-C wT%Ժ}B% Y,] A̠&oʰŨ; \lc`|,bUvPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!R%theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] (S =.  8@0(  B S  ?333  SS$$[[MM + + , , 6 < N O 3 3 = Q  ##  SS$$[[MM + + , , 6 < N O 3 3 = Q  ## h'T_UddQ'@T_UddT_UXT_Uddua[T_Udd (bT_Udd*QgT_Udd\g`vT_Udd|\gdd21fkO)6K8c i Ha # Ui ES p ( W, iTC13g]&iK}V:{ch;X_,HFAS8j~#%: <u{Ta)VXl|@ ^!K"7#dt#]$%v%-)&Y'EE(P(N)[*5+ d.si.Gs012L2.3?:3ff35Z<5#]5w5 6v6Q7Ws9L:R&<M=fb= >@(@M@P2ArNAQBHCsOC D#qE(FkFJG}GmJNKQMF?MNSNwN5OSq U U?VW0WjLXYLYeJZ[#U[`y[S-]LcdWdje7hSVi[id`i{kFmdmQ/nqKn+oDojoqo pxJpbpnUrE\rE2s(3sD/tctdltLptQuuW+uv%wxNxHzozL{8c{z{kU|n| }0uD`/@YI 0B3VJ"? ^96PoB'<9hR#vY9a%]7?J^Hkc  mH?'rviF6(=Puhx+I70X `f49eM2LRi EV bEg'<2@FBu3+Nk)V5H KSasyPp fQl]kWPax. ^'a|Dt/ "")'DIs z 3w>N|`x~)@(Z d@?\cLSR \V@@UnknownG*Ax Times New Roman5Symbol3. *Cx Arial7.@Calibri9. ")Segoe UIA$BCambria Math"h(g8G98`+` +` !243QHP ?L2!xx DETAIL SHEET INSTRUCTIONS Brian deZeeuw Rhoda A BrownOh+'0 (4 T ` l xDETAIL SHEET INSTRUCTIONSBrian deZeeuwNormalRhoda A Brown8Microsoft Office Word@@:i @$@(.E@ g+` ՜.+,0 hp   ¼ϲʿ DETAIL SHEET INSTRUCTIONS Title  !"#$%&')*+,-./1234567:Root Entry Fŵg<1Table%WordDocument4(SummaryInformation((DocumentSummaryInformation80CompObjr  F Microsoft Word 97-2003 Document MSWordDocWord.Document.89q