jagomart
digital resources
picture1_Cost Sheet Format In Excel 41021 | Unclassified   12 Month Kbor1


 138x       Filetype XLSX       File size 0.02 MB       Source: www.pittstate.edu


File: Cost Sheet Format In Excel 41021 | Unclassified 12 Month Kbor1
total cost of unclassified positions choices are to enter the hourly rate option 1 the biweekly rate option 2 or the annual salary option 3 option 1 enter hourly rate ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
                                                                                                                   Total Cost of
                                                                                                            Unclassified Positions
                                   Choices are to enter the Hourly Rate (Option 1), the Bi-Weekly Rate (Option 2), or the Annual Salary (Option 3).
                                                             OPTION 1 - Enter Hourly Rate in blue box and Health Insurance Coverage in green box.
                                                                                                                    FULL TIME                              PART TIME                             PART TIME 
                                                                                                              BENEFITS ELIGIBLE                             BENEFITS                          NON-BENEFITS
                                                                                                             Fringes            Fringes             Fringes            Fringes             Fringes           Fringes
                                   UNCLASSIFIED - Non-exempt                                                FY 2021             FY 2022            FY 2021             FY 2022            FY 2021           FY 2022
                                   12 Month
                                   enter hourly rate
                                   Hourly Rate                                                $18.39
                                   Bi-Weekly Rate                                         $1,471.20 
                                   Annual Salary                                        $38,251.20              6,664.89            7,009.15            6,664.89           7,009.15          3,413.54          3,375.29 
                                   Enter GHI Coverage FY - 20 or 21
                                        **Health Insurance - Annual                   20                     $8,092.24 .                            $8,092.24 .                                $0.00                      -   
                                                                                      21                                         $8,335.82                              $8,335.82 
                                   TOTAL Annual Fringes                                                       14,757.13           15,344.97           14,757.13          15,344.97           3,413.54          3,375.29 
                                   TOTAL COST OF UNCLASSIFIED POSITION                                      $53,008.33         $53,596.17          $53,008.33         $53,596.17         $41,664.74        $41,626.49 
                                   Fringe Rates:
                                                 Full/Part Time - Benefits   Part Time - No Benefits
                                   FY 2021             17.424%                      8.924%
                                   FY 2022             18.324%                      8.824%
                                                          OPTION 2 - Enter Bi-Weekly Rate in blue box and Health Insurance Coverage in green box.
                                                                                                                    FULL TIME                              PART TIME                             PART TIME 
                                                                                                              BENEFITS ELIGIBLE                             BENEFITS                          NON-BENEFITS
                                                                                                             Fringes            Fringes             Fringes            Fringes             Fringes           Fringes
                                   UNCLASSIFIED - Exempt                                                    FY 2021             FY 2022            FY 2021             FY 2022            FY 2021           FY 2022
                                   12 Month
                                   Hourly Rate                                               $37.88 
                                   enter bi-weekly rate
                                   Bi-Weekly Rate                                         $3,030.12 
                                   Annual Salary                                        $78,783.12            13,727.17           14,436.22           13,727.17          14,436.22           7,030.61          6,951.82 
                                   Enter GHI Coverage FY - 20 or 21
                                        **Health Insurance - Annual                   21                     $8,092.24 .                            $8,092.24 .                                $0.00                      -   
                                                                                      22                                         $8,335.82                              $8,335.82 
                                   TOTAL Annual Fringes                                                       21,819.41           22,772.04           21,819.41          22,772.04           7,030.61          6,951.82 
                                   TOTAL COST OF UNCLASSIFIED POSITION                                    $100,602.53         $101,555.16        $100,602.53         $101,555.16         $85,813.73        $85,734.94 
                                   Fringe Rates:
                                                 Full/Part Time - Benefits   Part Time - No Benefits
                                   FY 2021             17.424%                      8.924%
                                   FY 2022             18.324%                      8.824%
                                                       OPTION 3 - Enter Annual Salary Rate in blue box and Health Insurance Coverage in green box.
                                                                                                                    FULL TIME                              PART TIME                             PART TIME 
                                                                                                              BENEFITS ELIGIBLE                             BENEFITS                          NON-BENEFITS
                                                                                                             Fringes            Fringes             Fringes            Fringes             Fringes           Fringes
                                   UNCLASSIFIED - Exempt                                                    FY 2021             FY 2022            FY 2021             FY 2022            FY 2021           FY 2022
                                   12 Month
                                   Hourly Rate                                               $43.79 
                                   Bi-Weekly Rate                                         $3,503.27 
                                   enter annual salary
                                   Annual Salary                                        $91,085.00            15,870.65           16,690.42           15,870.65          16,690.42           8,128.43          8,037.34 
                                   Enter GHI Coverage FY - 20 or 21
                                        **Health Insurance - Annual                   21                     $8,092.24 .                            $8,092.24 .                                $0.00                      -   
                                                                                      22                                         $8,335.82                              $8,335.82 
                                   TOTAL Annual Fringes                                                       23,962.89           25,026.24           23,962.89          25,026.24           8,128.43          8,037.34 
                                   TOTAL COST OF UNCLASSIFIED POSITION                                    $115,047.89         $116,111.24         $115,047.89        $116,111.24         $99,213.43        $99,122.34 
                                   Fringe Rates:
                                                 Full/Part Time - Benefits   Part Time - No Benefits
                                   FY 2021             17.424%                      8.924%
                                   FY 2022             18.324%                      8.824%
                                                   Group Health Insurance Rates                                                 FY 2021            FY 2022
                                   Beginning with FY19 Budget began using a flat rate to Budget GHI.
file:///home/storage/public_html/st1/folder41/41021/unclassified___12_month_kbor1.xlsx                                                                                                                                                     08/14/2022
                                                                                             Total Cost of
                                                                                       Unclassified Positions
                            Budgeted Flat Rate                                                          $8,092.24     $    8,335.82 
file:///home/storage/public_html/st1/folder41/41021/unclassified___12_month_kbor1.xlsx                                                                                                        08/14/2022
The words contained in this file might help you see if this file matches what you are looking for:

...Total cost of unclassified positions choices are to enter the hourly rate option biweekly or annual salary in blue box and health insurance coverage green full time part benefits eligible nonbenefits fringes nonexempt fy month ghi position fringe rates fullpart no exempt group beginning with budget began using a flat filehomestoragepublic htmlstfolderunclassified kborxlsx budgeted...

no reviews yet
Please Login to review.