{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Salary Benefit Calculations"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Salary Benefit Calculations","index":0,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[22,0,22,2],[1,5,1,6],[8,0,8,7],[7,0,7,7],[10,1,10,6],[17,1,18,1],[19,1,19,6],[20,0,20,7],[12,2,13,2]]}
["Revised 10-04-2024",null,null,null,null,168600,"FICA Cap Rate (changes happen in January)"]
[null,null,null,null,null,"Ret Rates - Drop Down Box Options"]
[null,null,null,null,null,0,"* All Benefits are calculated for any 'Total FTE'"]
[null,null,null,null,null,0.25019999999999998,"* 61205 - Regular State Ret Rate"]
[null,null,null,null,null,0.1409,"* 61220 - Optional State Ret Rate"]
["Position Benefit Calculator",null,null,null,null,0,"* LEO Additional 5% Retirement"]
["(Calculator only works for single FOAP Positions)",null,null,null,null,0.05,"* 61210 - Police Officer Ret Rate"]
["Input Salary Dollars and FTE to calculate total amount needed"]
[]
[null,"Salary Dollars","Total FTE","Benefits %",null,"Benefits Dollars\nto Transfer","Object Code"]
[]
["Max AMOUNT",{"$f":"IF(B14<=$F$1,B14,$F$1)","v":0},null,7.6499999999999999E-2,"=",{"$f":"ROUND(B12*D12,0)","v":0},"61202 - Social Security"]
["Amount Over\nAMOUNT",{"$f":"IF(B14>$F$1,B14-$F$1,0)","v":0},"All Benefits must be budgeted for any 'Total FTE'",1.4500000000000001E-2,"=",{"$f":"ROUND(B13*D13,0)","v":0},"61202 - Social Security - CAP Amount"]
["Total Salary",null,null,0,"=",{"$f":"ROUND(B14*D14,0)","v":0},"Choose from the Drop Down Menu"]
[null,null,null,{"$f":"VLOOKUP(D14,F3:G5,2,FALSE)","v":"* All Benefits are calculated for any 'Total FTE'"}]
[null,null,null,0,"=",{"$f":"ROUND(B14*D16,0)","v":0},"Choose from the Drop Down Menu"]
[null,null,null,{"$f":"VLOOKUP(D16,F6:G7,2,FALSE)","v":"* LEO Additional 5% Retirement"}]
[null,null,null,7557,"=",{"$f":"ROUND(D18*C12,0)","v":0},"61270 - Health Insurance"]
[null,null,null,null,null,{"$f":"ROUND(B12+B13+F12+F13+F14+F16+F18,0)","v":0}]
[]
["Input Total Funding Available to calculate total amount needed"]
[]
[null,null,null,null,null,"Click 'Calculate' --->"]
[null,null,null,{"$f":"F19-D23","v":0}]