ࡱ>  ZO\pSheila S. Phillips Ba= =pi-8Z@"1Arial1Arial1Arial1Arial1Arial1Arial1QTahoma1 Arial1$Arial1QTahoma1QTahoma1Arial1Arial1 Arial1Tahoma1& Tahoma-Bold1 SymbolMT1Tahoma1Arial1 Arial1& Tahoma-Bold1Tahoma1 Arial1QTahoma1 Tahoma1Arial1QTahoma1Tahoma1Arial1Tahoma1Arial1Arial1Arial1Arial1Arial1 Arial1Arial14Arial1 Arial1Arial1Arial1,6Arial16Arial16Arial1>141<Arial1?Arial1*h6 Calibri Light1Arial1 Arial1( 'segoe ui' "$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0 "$"#,##0.00 "$"#,##0.0=8_("$"* #,##0.0_);_("$"* \(#,##0.0\);_("$"* "-"??_);_(@_)94_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_) #,##0.0)$"$"#,##0.000_);[Red]\("$"#,##0.000\)+&"$"#,##0.0000_);[Red]\("$"#,##0.0000\)% "$"#,##0.0_);[Red]\("$"#,##0.0\)A<_("$"* #,##0.000_);_("$"* \(#,##0.000\);_("$"* "-"??_);_(@_)C>_("$"* #,##0.0000_);_("$"* \(#,##0.0000\);_("$"* "-"??_);_(@_)E@_("$"* #,##0.00000_);_("$"* \(#,##0.00000\);_("$"* "-"??_);_(@_)GB_("$"* #,##0.000000_);_("$"* \(#,##0.000000\);_("$"* "-"??_);_(@_)0.0 mm/dd/yy4/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_)0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_)83_(* #,##0.000_);_(* \(#,##0.000\);_(* "-"??_);_(@_):5_(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"??_);_(@_) 0.0%mmmm\ d\,\ yyyy94_(* #,##0.000_);_(* \(#,##0.000\);_(* "-"???_);_(@_)<7_(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"????_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off" 0.000% 0.0000% "$"#,##0.000 "$"#,##0.0000 0.000 [$$-409]#,##0[$$-409]#,##0.00$[$-409]dddd\,\ mmmm\ dd\,\ yyyy mm/dd/yy;@[$-409]h:mm:ss\ AM/PM 0.0000[$$-409]#,##0.000[$$-409]#,##0.0000 #,##0.0000 0.00000#,###.00;\(#,###.00\);0.00 \$#,##0.00 000000#[$-409]dddd\,\ mmmm\ d\,\ yyyy                #  #  #  #  #  #  #  #  #  #  #  #  $  $  $  $  $  $  $  $  $  $  $  $  %  &   ' ff + ) , * (  )  * P + P ,  ,  -   . ` /  !    0   1 2 a 3 1*< *8 #<  *< *8 "< !< "< 1"< "8 1 "< "< "< "< "<  "<  ( "< 1 , !<  , *8 1*< 1*Z< 1*< *<  *  *  *  * *  "     " "< *<  , *8  (  "\ !< "\  " "8!@ 1"<!@ *8!@ "<!@  *X   ( +  *8a@ 1*<a@  @ "< 1"| *< 1"|  *X 1*| (x *8!@ %(< +< % <a@ (< +< +< (< +< *< 1*<a@ 1 , 1 , 8"@ @  8" @ 8"@ 8"@   8"@ 8"@ 8"@ 8"@  8"@   8"@ 8"@ 8"@ 8"@ 8"@ 8" @    )\   !\*   )\ "1 , 1!< 4x   4x   "x *| %(| %(| % (|  *| *x 4x   4|   4 |   4|   !8 )8 !8 )8a@ !8 1!< )8 )x  |  < "x 1"| 4|   "| "|  #<a@  *<a@ 1"< 1"< "0 ||~}<} yyyy00\)ef_);_(@_)}<} yyyy00\)ef_);_(@_)}<} yyyy00\)ef_);_(@_)}<} yyyy00\)ef_);_(@_)}<} yyyy00\)ef_);_(@_)}<} yyyy00\)ef _);_(@_)}<} yyyy00\)L_);_(@_)}<} yyyy00\)L_);_(@_)}<} yyyy00\)L_);_(@_)}<} yyyy00\)L_);_(@_)}<} yyyy00\)L_);_(@_)}<} yyyy00\)L _);_(@_)}<} yyyy00\)23_);_(@_)}<} yyyy00\)23_);_(@_)}<} yyyy00\)23_);_(@_)}<} yyyy00\)23_);_(@_)}<}  yyyy00\)23_);_(@_)}<}! yyyy00\)23 _);_(@_)}<}" yyyy00\)_);_(@_)}<}# yyyy00\)_);_(@_)}<}$ yyyy00\)_);_(@_)}<}% yyyy00\)_);_(@_)}<}& yyyy00\)_);_(@_)}<}' yyyy00\) _);_(@_)}<}( yyyy00\)_);_(@_)}}) }yyyy00\)_);_(@_)   }}* yyyy00\)_);_(@_)??? ??? ??? ???}(}/ yyyy00\)}<}1 ayyyy00\)_);_(@_)}<}2 yyyy00\)_);_(@_)}<}3 yyyy00\)?_);_(@_)}<}4 yyyy00\)23_);_(@_)}(}5 yyyy00\)}}7 ??vyyyy00\)̙_);_(@_)   }<}8 }yyyy00\)_);_(@_)}<}9 eyyyy00\)_);_(@_)}x}:yyyy00\)_);_(@_)  }}; ???yyyy00\)_);_(@_)??? ??? ??? ???}-}= yyyy00\)}P}> yyyy00\)_);_(@_) }(}? yyyy00\)}} yyyy00\)_);_(@_)   }x} yyyy00\)_);_(@_)  }} yyyy00\)_);_(@_)   }} yyyy00\)_);_(@_)   }} yyyy00\)_);_(@_)   }x} yyyy00\)_);_(@_)  }} yyyy00\)_);_(@_)    20% - Accent1H 20% - Accent1 ef  20% - Accent2H" 20% - Accent2 ef  20% - Accent3H& 20% - Accent3 ef  20% - Accent4H* 20% - Accent4 ef  20% - Accent5H. 20% - Accent5 ef  20% - Accent6H2 20% - Accent6  ef  40% - Accent1H 40% - Accent1 L  40% - Accent2H# 40% - Accent2 L˭  40% - Accent3H' 40% - Accent3 L  40% - Accent4H+ 40% - Accent4 L  40% - Accent5H/ 40% - Accent5 L  40% - Accent6H3 40% - Accent6  L  60% - Accent1H 60% - Accent1 23  60% - Accent2H$ 60% - Accent2 23  60% - Accent3H( 60% - Accent3 23  60% - Accent4H, 60% - Accent4 23f  60% - Accent5H0 60% - Accent5 23 ! 60% - Accent6H4 60% - Accent6  23Ў  "Accent1<Accent1 [  #Accent2<!Accent2 }1  $Accent3<%Accent3   %Accent4<)Accent4   &Accent5<-Accent5 Dr  'Accent6<1Accent6  pG (Bad4Bad  ) Calculation| Calculation  } * Check Cellz Check Cell  ????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextB5Explanatory Text 0 : Followed Hyperlink 1Good6Good  a2 Heading 1B Heading 1 DTj[3 Heading 2B Heading 2 DTj?4 Heading 3B Heading 3 DTj235 Heading 44 Heading 4 DTj6( Hyperlink 7InputpInput ̙ ??v 8 Linked CellF Linked Cell } 9Neutral<Neutral  e"Normal :Noteb Note   ;OutputrOutput  ???????????? ???<$Percent =Title1Title DTj% >TotalHTotal [[? Warning Text: Warning Text XTableStyleMedium9PivotStyleLight16`jGeneral InstructionsHire Dates Tab' filled Time Salary Calculations Wages_Bonus!  ;5ff`@x8$. 3  @@  sTotal%FICAFringeBenefits Position BaseSalary Health CrPersonalServices Distribution Health Ins DisabilityDef Comp% of CashRetire Hire DateNo payrolls expensed for FY Total CostBased on SelectionHourly Rate or Bonus AmountWages - Maximum of 1500 hours1 Hour for Bonus% of Total BenefitsSalary B% of Payrolls Expensed* (To be listed on the distribution column))51Saving your file:NSave your file to a unique identifier, as not to be confused with other files. (automatic)NOTE:See Note Below See Note #2#2Enter 100% as 1.00Enter all % < 100% as .XXExample:50% would be entered as .5075% would be entered as .75 #1 Health25% would be entered as .25NameVEach form operates in basically the same manner. For example purposes, the processes <for the FULL TIME SALARY CALCULATIONS TAB is outlined below: See Note #3#3oThis entry represents the account split. EX: If all salary will be from one (1) account, the entry would be 1.0MedicalNo. of payrolls remaining$No. of payrolls expensed until 11/256111261115611166111761138"Must be 6114X (or 61131 for Bonus)61113 " 61121 - Administrative Faculty " 61123 - Classified/Staff' " 61126 - Teaching and Research Faculty" " 61127 - Law Enforcement Officers3 " 61128  Information Technology (IT) Professionals61114 Group LifeTeach.Ins.&Annuity2 = Employee plus OneIndexFundOrgnProg61111 61118 Account BANNER FOAP8Enter one of these: 61121, 61123, 61126, 61127 or 61128 S4. Column D - H - Enter BANNER FOAP for the position. (Column G, account must be:) It is critical that the correct account (sub-object code) is used because the employee's classification determines the benefits schedule.:% of Payrolls Expensed* (Enter in the distribution column) To complete the salary calculator form, choose the tab at the bottom of this file that meets your criteria. (Full time and Wages/Bonus).P* Be sure to use the % number in the correct format (.XXXX) as shown in column F\Purpose: To assist staff in the calculation of salaries and benefits for new employees, wage(positions, salary increases, or bonuses.r1. Column A - Enter the last name of the person hired in the position. If the position is vacant, indicate vacant. Note: The percentage of benefits changes with each position. Benefits are cash benefits only and does not include the cost of sick leave, annual leave, or paid holidays.,Use this percentage for Aug 11 faculty hires 4= WaivedDeferred Comp?Yes/No COVa CARE 1 = Single5= Single HDHP6=Employee + One HDHP 7=Family HDHP#Salary Calculator Form Instructions2. Column B - Enter the position number of the person. If the estimate is being done for a new position indicate TBA (To Be Assigned). -3. Column C (Medical Plan choice for Full Time Salary Only) - Enter 1, 2, 3, 4, 5, 6, or 7. The cost of medical insurance dramatically affects the total cost of employment. If preparing an estimate and the medical insurance needs are unknown, use a midrange estimate for the medical insurance needs. X5. Column I - Enter "Yes" or "No" for particiapation in the Deferred Compensation Plan.  u5. Column J - Enter the base salary for the incumbent or an estimate if the form is being used for planning purposes. 76. Column K - Enter the position distribution (split).}7. Column L - Enter the number of pay periods the employee will be paid retrieved from the "Hire Dates Tab" in this workbook. 8. Column M - Y salary and benefits will calculate automatically and total across and at the bottom in the appropriate category.5If using this account delete the formula in Column N.]Use this account unless you are certain 61118 is being used. Delete the formula in Column T.10-Jun25-Jun10-Jul25-Jul10-Aug11-Aug25-Aug10-Sep25-Sep10-Oct25Oct10-Nov25-Nov10-Dec25-Dec10-Jan25-Jan10-Feb25-Feb10-Mar25-Mar10-Apr25-Apr10-May25-May$This % comes from the Hire Dates Tab VRS Hybrid61166 FSubtract this amount from 61111 if new hire. All others delete formula@(See Note #1 At Bottom) Enter Health Status: 1, 2, 3, 4, 5, 6, 7  3 = FamilyFY24FY26UI IOIsJ*KCLMMXO%PQ<TS U ZY(ZoZ&Zn[\ccB$PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭VY]*ߢ S,Tʵ H %69^8@,U 40총Ӂ+t&-Kސ!#?yO|e{߾/x/.CJW~3_/݌:f ,vo~_淿lZS`n}/gYkS^0- ~1"Awꩈ Dpcl:9i_0ll-H̏dg\Oyrq:o;@:f%M*f>(hS,,]vq>' YƳ>'FH[$l P9yn3ڴ >7!m0SÍZI)JHMF7,qS. +L3kaΛd0XG@.a?D2AΚt>FY#'Y$oI؇ RYO3?"!(=ᾚ>^M&fbygF7tb}^I;ߒzQvI}HzCpAuÞ/`}[bѭ=9غ/ s1W;`PʩV\?1\ʝ CJb1[[W'+d)i"6Wp",% ^!%9֗d>LpB,ԍdbQ]s&OJǂiK-]6?+|tK/\J5dI Ȝ!x7WFyAZNߟBaVuZ#Su&,"N\ ?,jzj~X$zmtF7[;nMAo2~0{i[ :ם[]7Z^בnި?F/-wʮ{PK! ѐ'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-!a$theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]  ZO X&,r:ʗZ"zB Ұb*  dMbP?_*+%,&?'?(?)?MSecure Print MFD on VSU-PRINT-S odXXLetterPRIV0''''D\KhC4HSMTJXerox GPD PS V3.2.303.16.0LeadingEdgePageSizeLetterPageRegionDuplexNoneResolution600x600dpiD1NRX F= @MSCF ,90R"//Uncompressed-Data//SF"CKY[lUfWEVa[KKvm^,BZ  m^hcKD@L,{!(rD H015*I?gftgd{o?lSΉ9`ij^Լ=G6ghȚUlϚV+e} YҗX_ƪZmd5D; UC5jQóYM#:Zkhga{+ZЁi~p?Fa5czb6XO|J6Yj)O:gȬ]|D۝wT]Cda7Gɥ>?bbyPm MnyB47][ʪޘtº yh75p1ͣV5/bhĀӛzӯ~; =r5mg}@ۍrImH#gn^{Fn<,oa*&5AmE`{>-A/.}ʱ^ ct CN^le4Нi>۱a]̄2=U+yB=Yјٷ<|Sk.=le?E$m K <~ΦΟ:Z<<9Y!;PQ9cbmqNrխ9Ho ƚ.8`.~,u/݇F(smUO,8j҆m.(~ ,\-nT_d/E/>芐^ŕD>W9W-h[ODg =O*j-\ u\8/9J:{!ƚW5\sp cKpg$եݟm8YgGFmp-.Q~^!yrˏE(6Znwk3D;̲*JrlH)Nqk%r\aõÆoLq~@flZIEv*4u^f:ϖ4W'KpRQpdteRx.5ZE1W8.c'gW(lU\[eqq#ǰDu[F0x$hFFttv:t42stt4::7IGGSh&hHMDɌ{Ȉ.⑸nk?&f 7nW"qN˹#v>}Gw }Gw }Gw 9IhAGJ*EJ%YwWpc|ʑRjj㑸ZZdp_+0QtF%"܉ǔp9V,{ۂU y<&%t\<=J*m+n14:Ο%l=W`pqipuǸikqhPt#:v 2+'#kn] qWQ|QX#ņ{(^K gQ} ^_-e>W7(|+r[k)>, lƿJpK#[XwuO0uZ Ux^~"COM5excel.exedxjones 14.0.6126.500310.5.53.127$>"dXX??&U} i} $ &;J ;w@w@;v;w@ w@ w@ g , v@,@),w@w@w@w@w@w@@,@,@,@@,@w@,@g@  ` S T Q - . U a b N < = > ? @ O c d e fDl            ,@!u@",@#@$,@%w@&w@'w@ (w@)w@*w@+w@,w@-w@.w@/w@0w@1w@2w@3w@4w@5w@6w@7w@8w@9w@:w@;w@<w@=w@>w@?w@ !g" #V$ % &'(),Dl    @w@Aw@Bw@Cw@Dw@Ew@Fw@Gw@Hw@Iw@Jw@Kw@Lw@Mw@Nw@Ow@Pw@Qw@Rw@Sw@Tw@Uw@Vw@Ww@Xw@Yw@Zw@[w@\w@]w@^w@_w@Dl`w@aw@bw@cw@dw@ew@fw@gw@hw@iw@jw@kw@lw@mw@nw@ow@pw@qw@rw@sw@tw@uw@vw@ww@xw@yw@zw@{w@|w@}w@~w@w@Dlw@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@Dlw@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@Dlw@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@Dlw@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@Dlw@w@w@w@w@w@w@w@w@ w@ w@ w@ w@ w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@Dl w@!w@"w@#w@$w@%w@&w@'w@(w@)w@*w@+w@,w@-w@.w@/w@0w@1w@2w@3w@4w@5w@6w@7w@8w@9w@:w@;w@<w@=w@>w@?w@Dl@w@Aw@Bw@Cw@Dw@Ew@Fw@Gw@Hw@Iw@Jw@Kw@Lw@Mw@Nw@Ow@Pw@Qw@Rw@Sw@Tw@Uw@Vw@Ww@Xw@Yw@Zw@[w@\w@]w@^w@_w@Dl`w@aw@bw@cw@dw@ew@fw@gw@hw@iw@jw@kw@lw@mw@nw@ow@pw@qw@rw@sw@tw@uw@vw@ww@xw@yw@zw@{w@|w@}w@~w@w@Dlw@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@Dlw@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@Dlw@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@Dlw@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@Dlw@w@w@w@w@w@w@w@w@ w@ w@ w@ w@ w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@Dl w@!w@"w@#w@$w@%w@xdPH0(  ><d&&&7ggD ZO   dMbP?_*+%&?'?(?)?M PVIR0224-01 on VSU-PRINT-02VDS odXXLetterPRIV0''''h\ \KhC)sChSMTJXHP UnivehSMTJXIUPH"xM/A84=mTjW Y xkD|/ѣ*M?vٴV%DNgMyiVb\IoWkWHҤgaH>6G' <{]->z*zkkio]MDDDq eYzPDDmL}%9}ٓNO ezoJIլK cٽVwDDSw BXE[k?[ #Qai'g$V$nJR\#$q˿^ee,`Ճ _"iX*[QJDn/yv0?ih?~4/*}[˚Jfz竉z:Zn<"dXX??&U} } $} $} } } mr@J@@@,@@t@,@,@ ,@ ,@ ,@ ,@ ,@,@,@,@,@,@,@,@,@,@,@,@,@,,Z [ \3 \4 ] ]P ^R~ Z? jZ8@Z&@j?j? Dz~ Z@ kZ7@Z$@!g? DD!g? DDz~ Z@ lZ6@Z"@!gUUUUUU? DDgUUUUUU? LDz~ Z@ mZ5@Z @!g? DDg?z~ Z@ nZ4@Z@!g? DDg?zZ o ZZi@T@i? qW~ Z@ pZ3@Z@gUUUUUU? LDgUUUUUU? zr~ Z@ qZ2@Z@g?g?  zp~ Z @ r Z1@Z@ g?  g?  z~ Z"@ s Z0@Z@ gUUUUUU?  gUUUUUU?  z~ Z$@ t Z.@Z@ g?  g?  z~ Z&@ u Z,@Z? g?  g?  z~ Z(@ v~ o*@ o gUUUUUU?  gUUUUUU? z~ Z*@ w~ Z(@Zg?g?z~ Z,@ x~ Z&@ZgUUUUUU?gUUUUUU?z~ Z.@ y~ Z$@Zg?g?z~ Z0@ z~ Z"@Zg?g?z~ Z1@ {~ Z @ZgUUUUUU?gUUUUUU?z~ Z2@ |~ Z@Zg?g? zu~ Z3@ }~ Z@Zg?g?z~ Z4@ ~~ Z@Zg?g?z~ Z5@ ~ Z@ZgUUUUUU?gUUUUUU?z~ Z6@ ~ Z@Zg?g?z~ Z7@ ~ Z@ZgUUUUUU?gUUUUUU?z~ Z8@ ~ Z?ZgUUUUUU?gUUUUUU?z~ Z9@ j~ aa_g `~ Z:@ k~ aa__ `<^eJ~zzzz||||||||||||k  PH  0(   >  7ggD ZO $ iP   dMbP?_*+%`]&C&"Arial,Bold"&1451 Salary Calculations For FY 17&"Arial,Regular"&10 &L &8&F &A &D &T&p= ף?'Q?(= ףp=?)?MSecure-Print Color on VSU-PRINS KXX11x17PRIV''''D\KhC4HSMTJXerox GPSMTJXerox GPD PS V4.0.548.8.0LeadingEdgePageSizeTabloidPageRegionDuplexNoneResolution600x600dpiD1NRX L.C    MSCFs ,90R O//Uncompressed-Data//Tf OCK\ pT>{7S xda7<fI| HiHH$P<_P)EVfhkV"O#ȔA@k;je:-v(<}^{Οssي1.' UTέr?CŃ+Av;PfȰ{ vO'+\슅oq[|,PUrzzyDJ_/̮7u:~ߠ7t&bD“a0nfu r^3ϝs1BP~ {^ ؽ _7NΧKN#G(3Ļt׮UoL"y!?X>r]vj2*3P^ހ+9U o ( ?>gb;;DM*Qr`*ג!O ڡ9*Ro'.scFODRBd3y!wj^1~(h`9ɹ嬗Y{u~>l6,NT@;@#@tr24a2z Aq)!RǬ+!y6h3z7{$ǐIv G|_O)gp+&A)ǿE8r3BtpHScP@yLT+|)+i .l9Ν~+Aߕh?Cqo2v"%Lg8:G4؅)ؽ.|/=oWi $~~(ok;*ciS2x Ŀ/|> _or%\ة}X 0EʹܴLn,s4uՠ/jxO S+{wb `!\>5h[$\% 5 u;X!}Vߗb|Q~M+(bL%8B. Cr*aC0P6a_~MNtMc.q홢T[OŸP^x=AMz #c]E>$辱F691q.'-ɋs㊌| qt<ig] h5(_אW@AZ_Cc_]=GװW@?q[GtOPd 6cBgOG z{ܘ8?񈮯U򲯾ZS_ hUHk}uAL}5c%1Vjye:2u9#"?a>D dtc'bp&j)`؃g/?GF`7+8!"p5qJ} IISOvn@M8R<_R2p?#'i&D&D+Jj+ni2U!6Mg85JʛVni5 iURpK4D(uK3g$}niF󌴹-hpK3gdҌ rK3Wj0MZ\#vKvwiy*<84"y,7#+w4z%w=Qy'g{%9oGZ iVgpeQHt-Z@ԉfNH.XE8}Bp#HSO%5iF8瑖u쫦yK ,ūV|:q4}Y1';#-v +n޾i.r-\G0-jj-XMT.jz7 Wyi5T.{ 1SHezmjگuj:CpjzS5XMUij>e{jڬOGjڭO!T |jk5SͧgV|ji5mQ͗sRT^L4kf廜GGN[Xj4ͥiVTcO"!{ ;b'J{eB  1ppx2 ߬4 -,P+b?]X6AtQSi71pp2fʏפjvPXDjUDlc)B$5iB~ V'ȳ;>svS' Cόs֩\ጁ~>GsO?Qtw z.|DvgH+$ y5O COM5excel.exesphillips  16.0.10417.2000710.26.52.1333W"KXX??&U} } R} m P} mQ} m R} mQ} $ S} P} P} m T} $ P} m P} P} $ P}  P} P} $ P} mP} P} P} $ P} $} $ PColumn AtFt{zyxwvutsrqponmlkjihgfedcba`UHII  I I   |iI |h |  D EEE XME Y  W  W  G  {I y5 yA y6 y7 w8 {J H9 { H I J H L HZ  K  I  I  G  x I IB I I L xC I I I I I , H I2 HE HF HG HK HHH  K  e#  e/  b  DI/$?v<,Ԋ? c"MǺ?NHPx?N9v?O~@N? I I I D  ??  D  V  # Ln4@?K# AL@A #LV-?L/$?BA# LD 3# )L D[LLL D\LLL D]LLL L D_LLlL D`LLBL DaLLIncorrect Code""""""BIncorrect Code3# LD # DL~ 4# *LYes DL B-# -V# LL LG# LL L(# LL( # L LBP   ??   $ LLL 2  H  Incorrect Code  ~  ? V(A(   ??     #Incorrect Code~  %333333?D =(4A(    ??     T Incorrect Code~ V % 333333?D V(4(   ??       ' 7 Incorrect Code~ %O333333?D C(T(   ??          Incorrect Code   V~        O (7 A (   ??     0   V   Incorrect Code   (~    0   333333?L     0 ( A (    ??             Incorrect Code   ~            (A (    ??            Incorrect Code    ~           * (D A (    ??        P O  Incorrect Code > ~       Q    (  (    ??        Incorrect Code@C ~  3((   ??     QIncorrect Code@~   )H($(    ??  (  (  (((Incorrect Code((D~ ((2 (V((5(O(    ??  (  (K (((Incorrect Code((K~ ((F (1((((    ??  (  (#  (S ( (Incorrect Code(N(I ~ (( ((((.(    ??  (   ( (((Incorrect Code(H(~ (( ((( (D(    ??  (  ( ( (%(Incorrect Code(1($~ ((((5(H(    ??  (  (; (((Incorrect Code((-~ (% =333333?D ((((C(    ??  (  ( (9(I(Incorrect Code(Q(J~ (% 333333?D ( ((8((   ??  (  (! ((/(Incorrect Code(J(~ (((()(&(    ??  (  (E (((Incorrect Code((#~ ((((( (    ??  (  ( (((Incorrect Code(C(~ (% N333333?D ((((V(    ??  (  (T (((Incorrect Code($(P~ ((((<(4(    ??  (  (S ($((Incorrect Code( ( ~ (("((E(7("    ??  (   ( (C(K(Incorrect Code(;()~ (% G333333?D ((( (I(    1@?  (  ( (((Incorrect Code( (~ (% /333333?D (V(((+(    ??  (  ( ( ((Incorrect Code((<~ (% 333333?D ('(()(6(    ??  (  ( (((Incorrect Code(F("~ (%  333333?D (((( (  DDl4.&%%8%%%%%% !"#$%&'()*+,-./0123456789:;<=>?  ??  (   (:   (: (H ( Incorrect Code (  ( ~  ( %  333333?D  (  (; (  (I  (!  ! ! ?? ! (! ! ("  !(!(!(!Incorrect Code!(!!(!~ !!(!!!(!!(!!(!(!!('  " " ?? " (" " (" "(""("("Incorrect Code"("("~ ""(""(5""* 333333?L"(1"(""(""((""(#  # # ?? # (# # (7 #(#(##(#Incorrect Code#(##(#~ ##(##(O"#(F#(##(B#(R##($  $ $ ?? $ ($ $ ($$ $C Ln4@?$(-$K$C AL@A #LV-?L/$?B$(U$$C LD$ ($$3$C )L D[LLL D\LLL D]LLL L D_LLlL D`LLBL DaLLIncorrect Code""""""BIncorrect Code$(;$$C LD$(7$$C DL~ $$($$4$C *LYes DL B$($ "$(U$$C -$($$$C LL$ L(;$$C LL$ L(F$$C LL$$( $$C L LBP % % ?? % (% % %D LLL% (%$ %(S$%(%$%(%$Incorrect Code%( $%( $~ %%(%$%("%(%$%(%$%( $%($%%(& $ & & ?? & (&% & (&$ &(&$&(&$&(&$Incorrect Code&(&$&(&$~ &&(&$&(F"&($&(&$&('$&(C$&&(. $ ' ' ?? ' ('% ' (,$ '('$'($'('$Incorrect Code'(*$'('$~ ''('$'('"'(V$'('$'('$'($''(( $ ( ( ?? ( ((% ( (:$ ((%$((*$((($Incorrect Code((($((%$~ (((($((("(( $((($((:$(($((() $ ) ) ?? ) () % ) ()$ )(4 $)($)()$Incorrect Code)($$)($~ ))()$)(")()$)()$)($)(6$))(* $ * * ?? * (*% * ($ *(* $*(6$*(*$Incorrect Code*(*$*(*$~ **(*$*(*"*( $*(*$*(L$*(V$**(+ $ + + ?? + (+% + (+$ +( $+(+$+(+$Incorrect Code+(+$+($~ ++(+$++(&$+(+$+(+$+($++(, $ , , ?? , (,% , ($ ,(,$,($,(,$Incorrect Code,(,$,($~ ,,(,$%, ,333333?D, ,($,(,$,(P$,(!$,,(% $ - - ?? - (- % - (-$ -(6$-(1 $-(-$Incorrect Code-(5$-( $~ --(-$--(L$-(-$-(-$-($--(0 $ . . ?? . (.% . (.$ .(.$.(.$.(.$Incorrect Code.($.(-$~ ..(.$..($.(.$.(.$.(-$..(/ $ / / ?? / (/ % / (/$ /(B$/(/$/(/$Incorrect Code/(/$/(/$~ //(/$%/ Q333333?D/ /(<$/(/$/($/(&$//(- $ 0 0 C@? 0 (0% 0 (0$ 0(0$0(Q$0(0$Incorrect Code0(, $0(0$~ 00(0$00(U $0(0$0(L $0(?$00(1 $ 1 1 ;@? 1 (1% 1 ("$ 1(1$1(1$1(1$Incorrect Code1(9 $1(;$~ 11(1$11(1$1(1$1($1(I$11(2 $ 2 2 ?? 2 (2% 2 ( $ 2(2$2($2(2$Incorrect Code2($2(2$~ 22(2$%2 333333?D2 2(2$2( $2(2$2(/$22(4 $ 3 3 ?? 3 (3% 3 (,$ 3(3$3(3$3(3$Incorrect Code3(3 $3($~ 33(3$33(3$3(3$3(S$3($33(5 $ 4 4 ?? 4 (4% 4 (B$ 4(+ $4(4$4(4$Incorrect Code4(4$4($~ 44(4$%4 4333333?D4 4(V$4(4$4($4( $44(3 $ 5 5 ?? 5 (5 % 5 (5$ 5( $5($5(5$Incorrect Code5(%$5(E$~ 55(5$55($5(5$5(9$5($55(6 $ 6 6 ?? 6 (6% 6 (& $ 6(6 $6(6$6(6$Incorrect Code6(+$6(6$~ 66(6$%6 6333333?D6 6(,$6(6$6(Q$6(*$66(7 $ 7 7 ?? 7 (7% 7 ( $ 7($7(7$7(7$Incorrect Code7(=$7(2$~ 77(7$%7  333333?D7 7(B$7(7$7(T$7(A$77(8 $ 8 8 ?? 8 (8% 8 (8$ 8($8(8$8(8$Incorrect Code8(8$8(8$~ 88(8$88($8(8$8(G$8($88(9 $ 9 9 ?? 9 (9% 9 (!$ 9(9$9($9(9$Incorrect Code9(9$9(9$~ 99(9$99(3$9(9$9(9$9( $99(: $ : : ?? : (:% : ( $ :(($:(> $:(:$Incorrect Code:($:(:$~ ::(:$%: :333333?D: :( $:(:$:(:$:($::(; $ ; ; ?? ; (; % ; (;$ ;($;(1$;(;$Incorrect Code;( $;(%$~ ;;(;$%; G333333?D; ;(;$;(;$;(D$;(!$;;(< $ < < ?? < (<% < (<$ <($<(K$<(<$Incorrect Code<($<(<$~ <<(<$<<(<$<(<$<($<( $<<(= $ = = ?? = (=% = (=$ =(=$=($=(=$Incorrect Code=(H$=(=$~ ==(=$=(= ==B333333?L=(=$=(=$=($=(M$==(> $ > > ?? > (>% > ( $ >(>$>(>$>(>$Incorrect Code>(0$>(7$~ >>(>$>(>=>(>$>(>$>()$>(E$>>(? $ ? ? ?? ? (?% ? (?$ ?('$?(A $?(?$Incorrect Code?(?$?(?$~ ??(?$?(?=?(M$?(?$?(@$?(L$??(@ $ DYHl%8:%%%%%%%%8@ABCDEFGHIJKLMNOPQRSTUVA WYZ[\]^_@ @ ?? @ (@% @ ($ @(@$@(@ $@(@$Incorrect Code@(@$@($~ @@(@$@(@=@(R$@(@$@($@($@@(A $ A A ?? A (A% A (A$ A(. $A(A$A(A$Incorrect CodeA(O$A(A$~ AA(A$A(>=A($A(A$A(N$A($AA(B $ B B ?? B (B % B (B$ B(F $B(?$B(B$Incorrect CodeB(B$B(F$~ BB(B$B(B=B($B(B$B(B$B($BB(C $ C C ?? C (C% C ( $ C(:$C(;$C(C$Incorrect CodeC(C$C($~ CC(C$CC(#$C(C$C(($C(?$CC(K $ D D ?? D (D% D ( D Dc Ln4@?D(DDKDUAL@A #LV-?L/$?BD(DDDU LDD(DD3DU)L D[LLL D\LLL D]LLL L D_LLlL D`LLBL DaLLIncorrect Code""""""BIncorrect CodeD(QDDU LDD(DDDU DL~ DD(DD4DU*LYes DL B%D )333333?DD D(EDDc -D(DDDc LLDL(7DDc LLDL(8DDV LLDD(E DDUL LBP E E 6@? E (E E Ed LLLE (ED E(EDE(EDE(EDIncorrect CodeE( DE(D~ EE(EDEE(DE(EDE(JDE(5DEE(F D F F ?? F (FE F (D F(8 DF(DF(FDIncorrect CodeF(SDF(RD~ FF(FDFF(FDF(%DF(FDF( DFF(G D G G ?? G (GE G (GD G(>DG(GDG(GDIncorrect CodeG( DG(D~ GG(GD%G 9333333?DG G(0DG(GDG(DG(@DGG(H D H H ?? H (HE H (=D H(( DH(DH(HDIncorrect CodeH( DH(HD~ HH(HDHH(GDH(HDH(DH($DHH(I D I I ?? I (IE I (7 D I(IDI(DI(IDIncorrect CodeI(DDI(! D~ II(IDII(DI(IDI(KDI(/DII(J D J J ?? J (J E J (JD J(D DJ(UDJ(JDIncorrect CodeJ(:DJ(JD~ JJ(JDJJ(JDJ(JDJ(JDJ(SDJJ(L D K K ?? K (K E K (KD K(2DK(ADK(KDIncorrect CodeK($DK(TD~ KK(KDK(KKKP333333?LK(HDK(KDK(2DK(DKK(D D L L ?? L (LE L (LD L(LDL(LDL(LDIncorrect CodeL(LDL(LD~ LL(LDL(MKL(>DL(LDL(3DL( DLL(M D M M ?? M (ME M (MD M(M DM(MDM(MDIncorrect CodeM(MDM(,D~ MM(MDM(-KM(TDM(MDM(MDM(,DMM(N D N N ?? N (NE N (ND N( DN("DN(NDIncorrect CodeN(N DN(ND~ NN(NDN(NKN(ADN(NDN(NDN(?DNN(O D O O ?? O (OE O (OD O(O DO(< DO(ODIncorrect CodeO(IDO(MD~ OO(ODO(KO(ODO(ODO(5DO(DOO(P D P P ?? P (PE P (PD P(PDP(2DP(PDIncorrect CodeP(PDP(PD~ PP(PDP(P KP(JDP(PDP(PDP(*DPP(Q D Q Q ?? Q (Q E Q (QD Q(DQ( DQ(QDIncorrect CodeQ(5DQ(D~ QQ(QDQQ(BDQ(QDQ(UDQ(#DQQ(R D R R D@? R (RE R (.D R(RDR('DR(RDIncorrect CodeR(RDR(RD~ RR(RDRR(6DR(RDR(RDR( DRR(S D S S D@? S (SE S (R D S(SDS(G DS(SDIncorrect CodeS(4DS((D~ SS(SDSS(KDS(SDS(SDS(DSS(T D T T D@? T (TE T (TD T(DT(TDT(TDIncorrect CodeT()DT(<D~ TT(TD%T T 333333?DT T( DT(TDT(#DT(/DTT(U D U U ?? U (UE U ( D U(UDU(KDU(UDIncorrect CodeU(UDU(UD~ UU(UD%U 333333?DU U(UDU(UDU(IDU(+DUU(D V VVstttttt#V  %U  V V (V VV  -V (V V(@V V(V V V(CV V(.V V(GV V(V V(4V V(NV V(8V V(VV V(DV(DV Y!YQRRRRRPTTP YT Z* Z[ZQ ZZRRRRPTTP ZT[ [\[h~ [hZ@[hhhhPTTP [T \D\h~ \ht@\hhhhPTTP \T ]]h~ ]h@]hhhhPTTP ^RX^h~ ^h^hhhhPTTP _R]_h~ _h@_hhhhPTTP BH7X%%8%%<8ZVLBB`abcdefghijklmnopqrstuvwxyz{|}~ `R^`h~ `ht@`hhhhPTTP aR_ah~ ah@ahhhhPTTP bQhhhhhPTTP c$ cR%cQRRRRRPTTP dR&dQ dR' dRR d(dRRPTT d P) dP+ e1ed fd g0 gR%gQRRRRRPTTP hR&hQ hR' hRR h(hRRPTT h P) hP+ iifEEE iEEjdkdldmdndodpdqdrdsdtdudvdwdxdydzd{d|d}d~ddDlBB <r<r. dddddddddddddddd$,  o  P 00(  ~ , <2} XPP? L]4,@ t,/IBI  <Not all employees will choose to have a deferred Comp. plan. Calculation of this field will be T4*K(current row). Update this column if you know the employee has chosen deferred comp.< l B2} XPP?C*]4l@ uNEotaK$ <If you are sure 61118 should be used, update the calculation to S4 times L current row. For example, if calculating benefits for line 5 the calculation would be S4*L5. Key this formula on the correct row in this column. Be sure to zero out the formula for 61111 for the current row. <K 0 ! B02} XPP? `q[]4!@ r=*JEX  < Employee will have either 61118 or 61111 but not both. Calculation will be automatically made in this column. Zero out this column if you are sure that 61118 should be used. Follow directions in cell S 3 to calculate 61118 if needed. <0~~  <2} XPP? `]4@ QƇLPbsS <Not all employees will choose to have a deferred Comp. plan. Calculation of this field will be T4*K(current row). Update this column if you know the employee has chosen deferred comp.<B 0 H?Line 235  ]`B 0 H?Line 236EU]`B 0 H?Line 236Uf]` !jharrupljharrup,RandersoRanderso><pdedbeA  7ggD ZO g   dMbP?_*+%he&C&"Arial,Bold"&1451 Wage & Bonus Calculations For FY 16 &"Arial,Regular"&10 &L &8&F &A &D &T&RQ?'{Gz?(Q?)?M PVIR0224-01 on VSU-PRINT-02V$S oS,,LetterPRIV0''''h< \KhC)sChSMTJXHP Universal Printing PS (v5.6.5)HPDocUISUITrueESPRITSupportedTrueHPOrientationHPOrientationPortraitHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPOrientRotate180FalsePostScriptCustomPageSizeFalseDuplexNoneHPReverseOrderForFold_StitchTrueHPBestGlossDefaultInputSlot*UseFormTrayTableHPDuplicateJobNameOverrideSWFWPageSizeLETTERPageRegionLeadingEdgeMediaTypeAUTOHPMediaTypeTreeviewPopupTrueCollateTrueJCLHPPrintOnBothSidesManuallyFalseJCLEconomodeFalseOutputBinAutoStapleLocationNonePunchingNoneTextAsBlackFalseAlternateLetterHeadFalseJCLResolution600dpiJCLPrintQualityNoneJCLFastResNoneHPConsumerCustomPaperTruePrintQualityGroupPQGroup_23JRHDInstalledJRHDOffHPNUseDiffFirstPageChoiceTrueHPPageExceptionsFileHPCPE150HPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsCoverInsertionHPEnableRAWSpoolingTrueHPDocPropResourceDataHPCabFileNameRGBColorNoCmdCMYKInksNoCmdJRConstraintsJRCHDFullHPColorSmartAutomaticHPColorSmart_ColorOptions_EdgeControlNoCmdHPColorSmart_ColorOptions_HalftoneNoCmdHPColorModeCOLOR_MODEHPColorSmart_Text_NeutralGraysNoCmdHPColorSmart_Text_HalftoneNoCmdHPColorSmart_Text_RGBColorNoCmdHPColorSmart_Graphics_NeutralGraysNoCmdHPColorSmart_Graphics_HalftoneNoCmdHPColorSmart_Graphics_RGBColorNoCmdHPColorSmart_Photo_NeutralGraysNoCmdHPColorSmart_Photo_HalftoneNoCmdHPColorSmart_Photo_RGBColorNoCmdHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_GROUPNAMEHPBornOnDateHPBODHPJobByJobOverrideJBJOHPJobAccWoPinTruePSAlignmentFileHPCLS150HPSmartHubInet_SID_263_BID_514_HID_265HPColorAsGrayFalseCNOutputNoneCNStapleNoneCNOffsetFalseCNPunchingNoneCNFoldingNoneIUPH"x.QؐX4LZuK\hE]ƭ x.=JJ}:LZ7rΜ9g&ևv dNp$^ $&aHiCNǁ\q|K(M->(#il˪XԉVه^+Ɉ=_txǦV%}Śe2k%H@;T&`ij%Q~RT bX(132n/K#y}׳\{5y`/ADDXYPt!43a-?7HEY}ѕj(56iQGU GnZ"S,,??&U} P} Q}  Q}  Q} R} Q} S} P} P} $ P  H I I  A A A A A D EEE X:E F YF H; I J L K KK  I  I  I k lE lF lG }K lH mm n k/$?  k  I@@@@@! DDW ~ AD@@ DV-?D/$?B!  D D! C *D @@@@@! DDF 0D61144 D/$?B!  D D! C *D @@@@@! DDF  0D61144 D/$?B!  D D! C *D UVVVVV! DDF  0D61144 D/$?B!  D D! C *D  D@@@@@  -      Bp$    ZPB(  ~  <2} XPP? a5 ]4@ ,%fGF#4 <Bonus payment is lump sum, and one time, thus column H is 1. For adjunct faculty, use the number of credit hours in column H. Use the following rates in column G: Instructor - $650/ch Ass't - $700/ch Assoc. - $750/ch Full Prof - $800 Amounts differ for summer school. < '  xx  6`2}XPP?   ]4@ [.K97 MX *<+Use 1113 for wages, 1112 for bonus pay. < $) *!~~  <2} XPP? a ]4@ Bo>-Eo2; <If bonus is based on a percentage of salary, use the formula of: =base salary*% of increase. Example: =30000*.10 This is a $30k salary with a 10% bonus. <(@~~  <2} XPP?  ]4@  +DNDE~ <WAGE Classifications 61141 - Wages, General 61142 - Wages, Graduate Asst. 61143 - Wages, Over Time 61144 - Wages, Students 61145 - Wages, T & R Pt.Time 61149 - Wages, OIT employees <d Randerso RandersoRandersoRanderso><ddebe 7ggD Oh+'0HP\x vsuSheila S. PhillipsMicrosoft Excel@C)@@D ՜.+,0HP X`hp x  General InstructionsHire Dates Tab filled Time Salary Calculations Wages_Bonus  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~    Root Entry FWorkbookrSummaryInformation( DocumentSummaryInformation8