Employee Contract Template by fmi50884

VIEWS: 246 PAGES: 16

More Info
									                                                                 National PW Template V1.1 Jan 2010 Excel 2007

                                                                                    INSTRUCTIONS TO ENABLE MACROS (TWO STEPS)
                                               MACROS must be
                                              ENABLED to use this                   STEP 1:

                                                   form!!!!                         1. Open the Excel workbook and override the initial Security Warning.
                                                                                    2. A new screen will open – Select the radial button for “Enable this
                                                                                    content”
                                          This PW must be saved as                  3. Select OK – Let the Office Enterprise Configuration run – it will take a
                                           a "Excel Macro Enabled                   couple of minutes.
                                                                                    4. Then let the Install run
                                                 Workbook"                          5. DO NOT reboot your system now – Cancel or NO
                                                                                    6. Now a window will open showing the dates of Cost Code Updates.

***Notes***                                                                         STEP 2:

** This file is a national template. It should be saved before entering any data.   1. Click on the Office Icon (upper left)
(Save As an “Excel Macro Enabled Workbook”)                                         2. Select “Excel Options” (bottom right)
                                                                                    3. Click on “Popular” (top left)
                                                                                    4. Select the radial button “Show Developer tab in the Ribbon”
** Only print pages that are used.
                                                                                    5. Select “OK”. The “Developer” Tab will now be shown.
                                                                                    6. Click on “Developer” Tab
** If pages do not print correctly, select “View” and “Page Break Preview” and
                                                                                    7. Select “Macro Security”. A new screen will Open
adjust manually.
                                                                                    8. Select “Macro Settings” (middle left)
                                                                                    9. Select the radial button for “Enable all macros (not recommended;
** Press “CTRL q” to realign all pages.                                             potentially dangerous code can run)”
                                                                                    10. Now the Cost Codes to work - On the Main tab Update Cost Codes.



  Update Cost Codes
FEMA Disaster Assistance Fact Sheet #9580.5   Page 2 of 16   Elements of a Project Worksheet
FEMA Disaster Assistance Fact Sheet #9580.5   Page 3 of 16   Elements of a Project Worksheet
FEMA Disaster Assistance Fact Sheet #9580.5   Page 4 of 16   Elements of a Project Worksheet
FEMA Disaster Assistance Fact Sheet #9580.5   Page 5 of 16   Elements of a Project Worksheet
FEMA Disaster Assistance Fact Sheet #9580.5   Page 6 of 16   Elements of a Project Worksheet
   TABLE OF CONTENTS                                                                                 PROJECT DETAILS
Check the box if included in PW package
                                                                Information input in yellow fields will be automatically populated to the appropriate fields on each form.
       Click on title to link to tab

  Project Worksheet                                                                                  PW Date:
                                          DISASTER
                                           DETAILS
  DDD-SOW Continuation                                                                            Disaster No:
  Scope Notes                                                                                  Disaster Type:
  Cost Continuation                                                                                       State:
                                            APPLICANT DETAILS




  Special Considerations                                                                               County:
  Hazard Mitigation Proposal                                                                 Applicant Name:
  Force Account Summary                                                                               FIPS No:
  Payroll Data                                                                       Kick Off Meeting Date:
  Fringe Benefits                                                                Applicant Representative:
  Labor                                                                    Applicant Representative Title:
  Equipment Inventory                                               Applicant Representative Phone No:
  Equipment                                                                                          Category:
  Contracts                                                                         PW Reference Number:
                                          PROJECT
                                          DETAILS




  Materials                                                                                          Location:
  Rental Equipment                                                                         Damaged Facility:
  Photos                                                                         Year Facility Constructed:
  Location Map                                                                              PW Prepared By:
                                            KEY STAFF




  FIRMETTE                                                                                     Preparer Title:

  Narrative                                                                               PAC Crew Leader:

  Site Costs                                                                          State Representative:
  Hazard Mitigation Summary                                             State Contact Info (Name & Title):
                                            STATE INFO




  Repetitive Loss                                                             State Contact Info (Facility):
  PNP Questionnaire                                                          State Contact Info (Address):
  Exit Interview                                                    State Contact Info (Phone Numbers):
                                                           FEDERAL EMERGENCY MANAGEMENT AGENCY

                                                            COST SUMMARY RECORD
APPLICANT                                                         PW REF NO.     CATEGORY        FIPS NO.           DISASTER

                                                    CLAIM COST                 COMMENTS (FEMA USE ONLY)             ELIGIBLE COSTS


  FORCE ACCOUNT LABOR
                                                $           -                                                       $              -
     REGULAR TIME




  FORCE ACCOUNT LABOR
                                                $           -                                                       $              -
       OVERTIME




         FORCE ACCOUNT
                                                $           -                                                       $              -
           EQUIPMENT




              MATERIALS                         $           -                                                       $              -




      RENTAL EQUIPMENT                          $           -                                                       $              -




             CONTRACTS                          $           -                                                       $              -




                  TOTAL                         $           -                                                       $              -



I certify that the above information was transcribed from timesheets, payroll records, equipment log, invoices, stock records or other
documents which are available for audit.
Certified by:                                                           Title:                              Date:


Applicant's records have been reviewed and found correct with the exceptions as noted.




National PW Template V1.1 Jan 2010 Excel 2007
                                                                           Answer theses questions before                                                                   INSTRUCTIONS
                                                                               completing this page
                                                                                                                                                                           SORT PAYROLL
                                                                 1 - Use average fringe benefit rate from "FRINGE" sheet?             YES                                      DATA
                                                                 2 - After review of the pay policy, are EXEMPT employees
                                                                 eligible for OT?                                                                                          ADD ADDITIONAL
                                                                                                                                                                            ROW AT TOP
                                                                 3 - Enter the OT Rate(s) -                            OT-1   OT-2    OT-3
                                                                 If only one OT rate, use OT-1 Only
                                                                                                                                                                           DELETE 2ND ROW

                                                                                  FEDERAL EMERGENCY MANAGEMENT AGENCY

                                                                              EMPLOYEE PAYROLL DATA
                          APPLICANT                                  PW REF NO.                  CATEGORY                        FIPS NO.                            DISASTER #
                                                                                                                                                        FEMA
                                                TITLE         STATUS *    HOURLY RATE                                                  BENEFITS                                        FRINGE
        EMPLOYEE NAME
                                                  OR                          REG            VAC       SICK    HOL      RET    SS     MEDC UNEMP    HEALTH   LIFE     WC   OTHER      BENEFITS
                                                             SEE BELOW
    LAST NAME, FIRST NAME                  JOB DESCRIPTION                     $              %         %       %        %     %        %       %     %       %       %      %      REG     OT
Example: Doe, John                Example: Policeman
                                                                FT            $18.00       10.00%     10.00%   5.00%          6.20%   1.45%         12.00%   2.00%                  7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%

                                                                                                                                                                                    7.65%




           Certified By: _______________
           Title: _____________________                       I CERTIFY THAT THE INFORMATION BELOW WAS TRANSCRIBED FROM PAYROLL
           Date: _____________________                            RECORDS OR OTHER DOCUMENTS WHICH ARE AVAILABLE FOR AUDIT.                                                  Page 9 of 16
                                                       FEDERAL EMERGENCY MANAGEMENT AGENCY

                                         APPLICANT'S BENEFITS CALCULATION WORKSHEET
APPLICANT                                                                PW REF NO.         FIPS NO.      CATEGORY             DISASTER




                                                                              ENTER TOTAL ANNUAL PAYROLL




                                                                                           REGULAR TIME %                  OVERTIME %


Holidays                                                                                                                   If the benefit is
                                                                                                                            applied to the
Vacation Leave                                                                                                             overtime fringe
                                                                                                                           rate, select the
                                                                                                                              proper box
Sick Leave


* Social Security                                                                                6.20%             FALSE




* Medicare                                                                                       1.45%             FALSE




* Unemployment                                                                                                     FALSE




* Worker's Comp                                                                                                    FALSE




** Retirement                                                                                                      FALSE




Health Benefits

Life Insurance Benefits

Other (Describe here)           ________________                                                                   FALSE




                                                      Total (in % of annual salary)              7.65%
                                                                    (FIGURES IN BLUE AUTOMATICALLY "GO" TO THE FORCE ACCOUNT LABOR SHEETS)
COMMENTS:




   I CERTIFY THAT THE INFORMATION ABOVE WAS TRANSCRIBED FROM PAYROLL RECORDS OR OTHER DOCUMENTS
   WHICH ARE AVAILABLE FOR AUDIT.


            CERTIFIED:


                    TITLE:


                    DATE:




* Only categories for overtime fringe benefits.
** Only an overtime fringe benefit when supported by employee contract
National PW Template V1.1 Jan 2010 Excel 2007
                                                                                                                     FEDERAL EMERGENCY MANAGEMENT AGENCY

                                                                                                                FORCE ACCOUNT LABOR RECORD
APPLICANT                                                                                                                  PW REF NO.            CATEGORY                      FIPS NO.                                               DISASTER #
                                                                                                                                                                                                                FEMA
                                                                                                              DATES & HOURS WORKED EACH WEEK




                                                         REG / OT
                                                STATUS
                                                                                                                                                                                                                                       RATES / COSTS
                                                                                                                                                                                                                            HOURLY   BENEFIT
                                                                                                                                                                                                                TOTAL HRS                      TOTAL HOURLY        TOTAL COST
                                                                    1/1   1/2   1/3   1/4   1/5   1/6   1/7    1/8   1/9   1/10   1/11   1/12   1/13   1/14   1/15   1/16   1/17    1/18   1/19   1/20   1/21                RATE     RATE

Name                                                     REG
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                         OT1
                                                                                                                                                                                                                            $   -              $        -      $            -
Title                                                    OT2
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                         OT3
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                         REG
Name                                                                                                                                                                                                                        $   -              $        -      $            -
                                                         OT1
                                                                                                                                                                                                                            $   -              $        -      $            -
Title                                                    OT2
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                         OT3
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                         REG
Name                                                                                                                                                                                                                        $   -              $        -      $            -
                                                         OT1
                                                                                                                                                                                                                            $   -              $        -      $            -
Title                                                    OT2
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                         OT3
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                         REG
Name                                                                                                                                                                                                                        $   -              $        -      $            -
                                                         OT1
                                                                                                                                                                                                                            $   -              $        -      $            -
Title                                                    OT2
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                         OT3
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                         REG
Name                                                                                                                                                                                                                        $   -              $        -      $            -
                                                         OT1
                                                                                                                                                                                                                            $   -              $        -      $            -
Title                                                    OT2
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                         OT3
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                         REG
Name                                                                                                                                                                                                                        $   -              $        -      $            -
                                                         OT1
                                                                                                                                                                                                                            $   -              $        -      $            -
Title                                                    OT2
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                         OT3
                                                                                                                                                                                                                            $   -              $        -      $            -
                                                                                                                                                                                            TOTAL HOURS                                REG TIME SUBTOTAL $                  -
                                                                                                                                                                                   GRAND TOTAL HOURS                                           O/T SUBTOTAL $               -
                                                                                                                                                                                     SHEET REG HOURS                                    REG GRAND TOTAL $                   -
                                                                                                                                                                                       SHEET OT HOURS                                    O/T GRAND TOTAL $                  -
I certify that the above information was obtained from Payroll records, invoices, or other documents that are available for audit.                                                                                                   GRAND TOTAL               $            -



CERTIFIED                                                                                                                                                                   TITLE                                                                             DATE
National PW Template V1.1 Jan 2010 Excel 2007




                                                                                                                       FORCE ACCOUNT LABOR PAGE 11 OF 16
        INSTRUCTIONS                INSERT ROW    SORT LIST BY NAME              DELETE ROW            FEMA COST CODE SEARCH
                                                      FEDERAL EMERGENCY MANAGEMENT AGENCY

                                                   EQUIPMENT INVENTORY FORM
                       APPLICANT:                             FIPS NO.                 DISASTER             CATEGORY             PW REF NO.
                           0                                     0                 0           0              #REF!                  0
                                                                                                                    ADJUSTED
                                                                                            CAPACITY    FEMA COST
    EQUIPMENT (UNIT NO.)             OPERATOR            MAKE            MODEL     HP                               COST CODE     COMMENTS
                                                                                              SIZE        CODE
                                                                                                                    UNIT PRICE

Truck, Pickup, (Example)     Example: Doe, John   Chevrolet          1500         250                     8073




                                                     EQUIPMENT INVENTORY PAGE 12 OF 16
                                                                                                                     FEDERAL EMERGENCY MANAGEMENT AGENCY

                                                                                                             FORCE ACCOUNT EQUIPMENT RECORD
APPLICANT                                                                                                                                      PW REF NO.          CATEGORY                      FIPS NO.                                         DISASTER #
                                                                                                                                                                                                                           FEMA

                       EQUIPMENT / OPERATOR INFORMATION                                                                                        DATES / HOURS USED EACH DAY                                                                                   TOTALS

     Indicate size, capacity,                        CAPACIT   EQUIP.
                                                HP
                                                        Y      CODE #
                                                                        OPERATOR'S NAME   UNIT   1/1   1/2   1/3   1/4     1/5    1/6    1/7   1/8   1/9   1/10   1/11   1/12   1/13   1/14   1/15   1/16   1/17   1/18   1/19   1/20   1/21   TOTAL   EQUIP RATE       TOTAL COST
 horsepower, make, model, etc.


                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           MI                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                           HR                                                                                                                                                          $     -      $                -

                                                                                                                                                                                                                             SHEET TOTAL                            $                -

                                                                                                                                                                                                                            GRAND TOTAL                             $                -
I CERTIFY THAT THE ABOVE INFORMATION WAS OBTAINED FROM PAYROLL RECORDS, INVOICES, OR OTHER DOCUMENTS THAT ARE AVAILABLE FOR AUDIT.




CERTIFIED                                                                                                                        TITLE                                                                                                         DATE
National PW Template V1.1 Jan 2010 Excel 2007




                                                                                                                         FORCE ACCOUNT EQUIPMENT PAGE 13 OF 16
                   ADD NEW PAGE                                                                         INSTRUCTIONS                                                           DELETE LAST PAGE

                                                                                        FEDERAL EMERGENCY MANAGEMENT AGENCY

                                                                                   CONTRACT SUMMARY RECORD
APPLICANT                                                                                                                   PW REF NO.           CATEGORY                  FIPS NO.            DISASTER

                                                                                                                                                 Total Invoice       Total Claim
                  Vendor                           Description of work performed                       Invoice No:         Dates Worked:                                               Comments
                                                                                                                                                   Amount             Amount




                                                                                                                                                        Total Cost

                                                                                                                                           Total From All Pages
Certified By:                                                                                                                                  Title:                                  Date:


I certify that the above information was transcribed from daily logs, vendor invoices, or other documents which are available for audit.
National PW Template V1.1 Jan 2010 Excel 2007

                                                                                               CONTRACTS PAGE 14 OF 16
                    ADD NEW PAGE                                                                      INSTRUCTIONS                                                  DELETE LAST PAGE

                                                                                       FEDERAL EMERGENCY MANAGEMENT AGENCY

                                                                FORCE ACCOUNT MATERIALS SUMMARY RECORD
APPLICANT                                                                                           PW REF NO.                  CATEGORY              FIPS NO.                    DISASTER

                                                                                                    Total Invoice         Total Claim       Date    Date     Source of Data
                  Vendor                                      Description                                                                                                            Comments
                                                                                                      Amount               Amount          Purch.   Used   Invoice No     Stock




                                                                                                           Total Cost

                                                                                            Total From All Pages
Certified By:                                                                                     Title:                                                                Date:


I certify that the above information was transcribed from daily logs, vendor invoices, or other documents which are available for audit.
National PW Template V1.1 Jan 2010 Excel 2007


                                                                                               MATERIALS PAGE 15 OF 16
                    ADD NEW PAGE                                                                       INSTRUCTIONS                                                DELETE LAST PAGE

                                                                                        FEDERAL EMERGENCY MANAGEMENT AGENCY

                                                                                     RENTED EQUIPMENT RECORD
APPLICANT                                                                                              PW REF NO.                 CATEGORY          FIPS NO.                 DISASTER

                                                 Date &               Rate Per Hour                                                                      Invoice     Check
                                                                                                            Total Cost                     Vendor                                Comments
         Equipment Type                         hours used      W/ Operator       Wo/ Operator                                                           Number     Number




                                                                                    Total Cost

                                                                      Total From All Pages
Certified By:                                                                                      Title:                                                          Date:


I certify that the above information was transcribed from daily logs, vendor invoices, or other documents which are available for audit.
National PW Template V1.1 Jan 2010 Excel 2007

                                                                                         RENTED EQUIPMENT PAGE 16 OF 16

								
To top