Excel Sheet Download 30922 | Project Worksheet Template

Partial file snippet.

Sheet 1: Procedures

FEMA and CalEMA Required Documentation

In order to process your request for Project Worksheet (PW) funding, FEMA and Cal EMA are requesting documentation supporting your request for funding for those expenses incurred to complete the work. The costs must be itemized and outlined in an easy to read manner, preferably on the enclosed forms. If you use your own forms or computer generated printouts, the information and layout should be similar to the attached forms.

A Cost Summary Report that breaks out the costs for each category of expenses. This will include the totals from each of the categories below.

Detailed summary sheets for labor, equipment, material, rental equipment, and contracts that show that the work performed and costs incurred were directly related to the scope of work. Actual invoices, payments, contracts, and timesheets are not required unless specifically requested. For instance, the force account labor summary sheet would include the name of each employee that performed work at that PW site, reference to the site, dates worked, base pay, overtime pay, benefits pay, and the total amount received. If the PW is for emergency work (Categories A or B), only overtime pay is eligible.

Documentation of force account labor. Documentation must include regular time and overtime; a salary rates chart; a fringe benefits percentage and components rate chart; and time expense sheets (who, what, when, where, and how long for each employee). For emergency work (categories A and B), only overtime pay is allowed, however regular time can be included to substantiate equipment time usage.

Documentation of force account equipment costs. Documentation is to include an equipment rates chart and equipment expense sheets (what equipment, who used it, doing what, when, where, the hourly rate, and for how long for each day of use). Standby and idle time are not eligible although a full day may be eligible if a piece of equipment is used intermittently for the majority of the day.

Documentation of rental equipment costs. Vendor equipment invoices must identify what was done, when, where, for how long, what kind of equipment, and the charges per project.

Documentation of force account material costs. These costs are to be included on the Materials Summary Report. Reimbursement is based on the purchase price and quantities taken from the applicant’s stock. If invoices are not available, costs can be developed from the applicant’s historical data or from vendors in the area. Donated materials are not eligible, although the value may be credited towards the applicant’s cost share. Documentation is to include material use summary sheets (what was used, who used it, when, where, the quantity, and the unit price).

Documentation of purchased material and supply costs. These costs are to be included on the Materials Summary Report. Documentation is to include receipts and payment vouchers for each item and material use summary sheets (what was used, who used it, when, where, the quantity, and the unit price).

Documentation of contract costs. Contracts are to include a copy of the signed contract and any change orders, payment invoices, and payment vouchers, especially the final acceptance and payment. The Contract documents need to include the signature pages, the pages describing the scope of work to be performed, and copies of required insurances. On large projects, include a "Notice of Completion" if possible.

Sheet 2: Cost Summary Record

COST SUMMARY RECORD

Fill out the information requested in the header portion of this form. The information will be copied to each of the subsequent forms.
Boxes with light blue background have formulas in them. Hours and costs on this summary form are filled in as you fill out the subsequent forms.

Applicant
FEMA ID
FEMA Disaster #
PW #

Location/Site

Type over 'GPS N' with the actual GPS coordinates

GPS N

Type over 'GPS W' with the actual GPS coordinates.
GPS W
CDAA ID
CDAA Disaster #
Category

Description of Work Performed:

Hours
Costs
Comments

Force Account Labor: Regular Time
0.00
$0.00

Force Account Labor: Overtime
0.00
$0.00

Force Account Equipment
0.00
$0.00

Force Account Material

$0.00

Rental Equipment

$0.00

Contracts

$0.00

Total

$0.00

Sheet 3: FA Labor Summary

FORCE ACCOUNT LABOR SUMMARY RECORD

Applicant
GPS N
FEMA ID
PW #
CDAA Disaster #
FEMA Disaster #

0
GPS N
0
0
0
0

Location/Site
GPS W
CDAA ID
Category
Period Covering

0
GPS W
0
0

Description of Work Performed:

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Type over 'Name' with the name of the employee.

Name
Reg.

Type over 'Job Title' with the title for the employee from above.

Job Title
O.T.

Type over 'Name' with the name of the employee.

Name
Reg.

Type over 'Job Title' with the title for the employee from above.

Job Title
O.T.

Type over 'Name' with the name of the employee.

Name
Reg.

Type over 'Job Title' with the title for the employee from above.

Job Title
O.T.

Type over 'Name' with the name of the employee.

Name
Reg.

Type over 'Job Title' with the title for the employee from above.

Job Title
O.T.

Type over 'Name' with the name of the employee.

Name
Reg.

Type over 'Job Title' with the title for the employee from above.

Job Title
O.T.

Type over 'Name' with the name of the employee.

Name
Reg.

Type over 'Job Title' with the title for the employee from above.

Job Title
O.T.

Type over 'Name' with the name of the employee.

Name
Reg.

Type over 'Job Title' with the title for the employee from above.

Job Title
O.T.

Type over 'Name' with the name of the employee.

Name
Reg.

Type over 'Job Title' with the title for the employee from above.

Job Title
O.T.

Type over 'Name' with the name of the employee.

Name
Reg.

Type over 'Job Title' with the title for the employee from above.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Other Pages Force Account Labor Regular Time
0.00

Other Pages Force Account Labor Overtime
0.00

Total Cost for Force Account Labor Regular Time
0.00

Total Cost for Force Account Labor Overtime
0.00

I CERTIFY THAT THE ABOVE INFORMATION WAS TRANSCRIBED FROM PAYROLL RECORDS, VENDOR INVOICES, OR OTHER DOCUMENTS THAT ARE AVAILABLE FOR AUDIT

Certified
Title
Date

Page 1

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 2

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 3

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 4

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 5

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 6

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 7

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 8

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 9

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 10

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 11

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 12

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 13

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 14

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 15

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 16

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 17

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 18

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 19

Name
Hours Worked Each Week

Job Title
Week of

Total Hours
Hourly Rate
Benefit Rate/Hr
Total Hourly
Total Costs

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

Name
Reg.

Job Title
O.T.

This Page Force Account Labor Regular Time
0.00

This Page Force Account Labor Overtime
0.00

Page 20

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet procedures fema and calema required documentation in order to process your request for project worksheet pw funding cal ema are requesting supporting those expenses incurred complete the work costs must be itemized outlined an easy read manner preferably on enclosed forms if you use own or computer generated printouts information layout should similar attached a cost summary report that breaks out each category of this will include totals from categories below detailed sheets labor equipment material rental contracts show performed were directly related scope actual invoices payments timesheets not unless specifically requested instance force account would name employee at site reference dates worked base pay overtime benefits total amount received is emergency b only eligible regular time salary rates chart fringe percentage components rate expense who what when where how long nbsp allowed however can included substantiate usage used it doing hourly day standby idle although ful...

COST SUMMARY RECORD						Fill out the information requested in the header portion of this form. The information will be copied to each of the subsequent forms. Boxes with light blue background have formulas in them. Hours and costs on this summary form are filled in as you fill out the subsequent forms.
Applicant			FEMA ID	FEMA Disaster #	PW #

Location/Site	Type over 'GPS N' with the actual GPS coordinates GPS N	Type over 'GPS W' with the actual GPS coordinates. GPS W	CDAA ID	CDAA Disaster #	Category

Description of Work Performed:

	Hours	Costs	Comments
Force Account Labor: Regular Time	0.00	$0.00
Force Account Labor: Overtime	0.00	$0.00
Force Account Equipment	0.00	$0.00
Force Account Material		$0.00
Rental Equipment		$0.00
Contracts		$0.00
Total		$0.00

Related files

Share

Help

Related files

Share

Share to social media

Help

Login Area