NGWMN_FY24_Attachment_B_Example_Budgets.pdf

Attachment B – Example budgets

Examples are presented here for two hypothetical projects. Example 1 is for a new data provider project and includes work under Objective 1 and Objective 2A. Example 2 is for a project with an existing data provider and includes work under Objectives 2A, 2B, 3, 4, 5, and 6. Each includes the required summary budget for the project, an example of the budget needed for the SF 424-A Form Section B, and the detailed budgets for each objective. All budgets are for the entire project and should not be split into year one and year two budgets for multi-year projects.

The example projects use overhead rate of 31.3%. The actual overhead rate for your agency should be that shown in your organizations Negotiated Rate Agreement. A uniform cost of $40/hour is used for simplicity. In an actual proposal, salaries would vary by employee.

Budgets for Example 1

Example 1 Overall Budget

The example budget summary below summarizes the detailed budgets for Objectives 1 and 2 on the following pages. This simulates an overall budget for a two-year project for a new data provider. In this example, indirect costs are applied only to the Salary budget category.

Indirect cost rate: 31.3%

Category Federal Funding

Agency In-Kind Funding

Total Funding

1a. Salary $19,200.00 $0.00 $19,200.00 1b. Fringe $6,400.00 $0.00 $6,400.00

2. Supplies $0.00 $0.00 $0.00

3. Equipment $0.00 $0.00 $0.00

4. Travel $0.00 $0.00 $0.00

5. Contracts $14,000.00 $0.00 $14,000.00

6. Total Direct (sum of items 1-5) $39,600.00 $0.00 $39,600.00

7. Indirect cost $8,012.80 $0.00 $8,012.80

8. Total Cost (sum of 6 and 7) $47,612.80 $0.00 $47,612.80

Example 1 SF 424-A, SECTION B Budget Categories

The example budget summary below summarizes the federal funding for all objectives and the agency in-kind services for all objectives by budget categories. This is the format that should be used to fill out the Budget Categories section of SF 424-A.

SF 424-A, SECTION B- BUDGET CATEGORIES

6. Object Class Categories GRANT PROGRAM, FUNCTION OR ACTIVITY Total

(5) (1)

(2)

(3)

(4)

a. Personnel $19,200.00 $0.00 $19,200.00

b. Fringe Benefits $6,400.00 $0.00 $6,400.00

c. Travel $0.00 $0.00 $0.00

d. Equipment $0.00 $0.00 $0.00

e. Supplies $0.00 $0.00 $0.00

f. Contractual $14,000.00 $0.00 $14,000.00

g. Travel $0.00 $0.00 $0.00

h. Contracts $0.00 $0.00 $0.00

i. Total Direct Charges (sum of 6a-6h) $39,600.00 $0.00 $39,600.00

j. Indirect Charges $8,012.80 $0.00 $8,012.80

k. TOTALS (sum of 6i and 6j) $47,612.80 $0.00 $47,612.80

National Groundwater Monitoring Network

Agency In- Kind Services

Example 1 Objective Budgets

Objective 1. Become a new data provider for the NGWMN Overhead/indirect rate: 31.3%

USGS funding Total: $36,583.60 In-kind services Total: $0.00 Objective Total: $36,583.60

a) Salary

1) 2) 3) 4) 5) 6) 7) 8) 9) Source of funds

Employee name Task

Hourly rate of compensation

Total hourly rate (a3 + a4)

Number of hours

Salary cost (a5 x a6)

Indirect cost (a7 x indirect rate)

10) 11)

Hourly rate of fringe benefit

Total cost (a7 + a8) Federal

Agency in-kind

Employee 1 Select and classify wells $30.00 $10.00 $40.00 100 $4,000.00 $1,252.00 $5,252.00 $5,252.00 $0.00

Employee 2 Setup web services $30.00 $10.00 $40.00 200 $8,000.00 $2,504.00 $10,504.00 $10,504.00 $0.00 Employee 3 Add sites to well registry $30.00 $10.00 $40.00 100 $4,000.00 $1,252.00 $5,252.00 $5,252.00 $0.00

Employee 4 Document work in final report $30.00 $10.00 $40.00 30 $1,200.00 $375.60 $1,575.60 $1,575.60 $0.00

Totals Total hours

Direct cost total cost total total

Agency total

430 $17,200.00 $5,383.60 $22,583.60 $22,583.60 $0.00

Example Budget 1 Objective 1, continued.

Contracts- Salary

1) 2) 3) 4) 5) 6) Source of funds

Description of work Hourly rate of compensation

Hourly rate of fringe benefit

Total hourly rate (col 2 + col 3)

Number of hours

Salary cost (col 4 x col 5)

7) 8)

Federal Agency in-kind

Establish web services for water-level data $30.00 $10.00 $40.00 250 $10,000.00 $10,000.00 $0.00 Interagency agreement to provide web services for well construction and lithology $30.00 $10.00 $40.00 100 $4,000.00 $4,000.00 $0.00

Totals Total hours

Salary total

Federal total

Agency

350 $14,000.00 $14,000.00 $0.00

Objective 2A. Persistent Data Services Overhead/indirect rate: 31.3% USGS funding Total: $11,029.20

Objective Total: $11,029.20

Employee name Task rate (a3 + a4)

Number of hours

(a7 x indirect rate)

10) 11)

Hourly rate of

Agency in-kind

Employee 1 Oversee persistent data services work $30.00 $10.00 $40.00 40 $1,600.00 $500.80 $2,100.80 $2,100.80 $0.00

Employee 2 Database programming support

$30.00 $10.00 $40.00 40 $1,600.00 $500.80 $2,100.80 $2,100.80 $0.00

Employee 3 Update new wells in well registry $30.00 $10.00 $40.00 80 $3,200.00 $1,001.60 $4,201.60 $4,201.60 $0.00

Employee 4 Assign subnetworks $30.00 $10.00 $40.00 40 $1,600.00 $500.80 $2,100.80 $2,100.80 $0.00

Employee 4 Document work in final report $30.00 $10.00 $40.00 10 $400.00 $125.20 $525.20 $525.20 $0.00

Totals Total hours

Direct cost total total

Agency

210 $8,400.00 $2,629.20 $11,029.20 $11,029.20 $0.00

Budgets for Example 2 Example 2 Overall Budget

The example budget summary below summarizes the detailed budgets for Objectives 2A, 2B, 3, 4, 5, and 6 on the following pages. This simulates an overall budget for a two-year project for an existing data provider. In this example, indirect costs are applied to the Salary, Supplies, Equipment, and Travel budget categories. Indirect costs are not applied to the Contract costs.

This example also shows inclusion of a 10% contingency on contract work under objective 5. The contingency is applied to Salary, Supplies, and Well Drilling contract costs. The costs for continuous water-level monitoring equipment purchases for the two wells being drilled is also included under Objective 5 work. Purchase of continuous water-level monitoring equipment to upgrade 4 existing network wells is included under Objective 4

Indirect cost rate: 31.3%

Category

Funding

Agency In-Kind Funding Total Funding

1a. Salary $29,400.00 $19,530.00 $48,930.00 1b. Fringe $9,800.00 $6,510.00 $16,310.00

2. Supplies $3,470.00 $525.00 $3,995.00

3. Equipment $16,319.69 $1,630.31 $17,950.00

4. Travel $5,118.75 $11,398.50 $16,517.25

5. Contracts $10,981.00 $7,900.00 $18,881.00

6. Total Direct (sum of items 1-5) $75,089.44 $47,493.81 $122,583.25

7. Indirect cost $20,065.94 $12,392.87 $32,458.81

8. Total Cost (sum of 6 and 7) $95,155.38 $59,886.68 $155,042.06

Example 2 SF 424-A, SECTION B Budget Categories

The example budget summary below summarizes the federal funding for all objectives and the agency in-kind services for all objectives by budget categories. This is the format that should be used to fill out the Budget Categories section of SF 424-A.

SF 424-A, SECTION B- BUDGET CATEGORIES

6. Object Class Categories GRANT PROGRAM, FUNCTION OR ACTIVITY Total

(5) (1)

(2)

(3)

(4)

a. Personnel $29,400.00 $19,530.00 $48,930.00

b. Fringe Benefits $9,800.00 $6,510.00 $16,310.00

c. Travel $5,118.75 $11,398.50 $16,517.25

d. Equipment $16,319.69 $1,630.31 $17,950.00

e. Supplies $3,470.00 $525.00 $3,995.00

f. Contractual $10,981.00 $7,900.00 $18,881.00

g. Construction $0.00 $0.00 $0.00

h. Other $0.00 $0.00 $0.00

i. Total Direct Charges (sum of 6a-6h) $75,089.44 $47,493.81 $122,583.25

j. Indirect Charges $20,065.94 $12,392.87 $32,458.81

k. TOTALS (sum of 6i and 6j) $95,155.38 $59,886.68 $155,042.06

National Groundwater Monitoring Network

Agency In- Kind Services

Example 2 Objective Budgets

Objective 2A. Persistent Data Services Overhead/indirect rate: 31.3%

USGS funding Total: $16,596.32

Objective Total: $16,596.32

Employee name Task rate (a3 + a4)

Number of hours

(a7 x indirect rate)

10) 11)

Hourly rate of

Agency in-kind

Employee 1 Oversee persistent data services work $30.00 $10.00 $40.00 120 $4,800.00 $1,502.40 $6,302.40 $6,302.40 $0.00

Employee 2 Database programming support

$30.00 $10.00 $40.00 120 $4,800.00 $1,502.40 $6,302.40 $6,302.40 $0.00

Employee 3 Keep sites in new wells in well registry current

$30.00 $10.00 $40.00 40 $1,600.00 $500.80 $2,100.80 $2,100.80 $0.00

Employee 4 Assign subnetworks to new sites

$30.00 $10.00 $40.00 20 $800.00 $250.40 $1,050.40 $1,050.40 $0.00

Employee 4 Document work in final report $30.00 $10.00 $40.00 16 $640.00 $200.32 $840.32 $840.32 $0.00

Totals Total hours

Direct cost total total

Agency

316 $12,640.00 $3,956.32 $16,596.32 $16,596.32 $0.00

Example Budget 2 Objective 2B. Persistent Data Services Overhead/indirect rate: 31.3%

USGS funding Total: $10,504.00

Objective Total: $10,504.00

Employee name Task rate (a3 + a4)

Number of hours

(a7 x indirect rate)

10) 11)

Hourly rate of

Agency in-kind

Employee 1 Revise web services to account for changes to database

$30.00 $10.00 $40.00 40 $1,600.00 $500.80 $2,100.80 $2,100.80 $0.00

Employee 2 Upgrade web services to serve data using new standards

$30.00 $10.00 $40.00 120 $4,800.00 $1,502.40 $6,302.40 $6,302.40 $0.00

Employee 2 Work with NGWMN Portal staff to map new services

$30.00 $10.00 $40.00 24 $960.00 $300.48 $1,260.48 $1,260.48 $0.00

Employee 2 Document work in final report $30.00 $10.00 $40.00 16 $640.00 $200.32 $840.32 $840.32 $0.00

Totals Total hours

Direct cost total total

Agency

200 $8,000.00 $2,504.00 $10,504.00 $10,504.00 $0.00

Objective 3. Site Information Gap Filling Overhead/indirect rate: 31.3% USGS funding Total: $17,883.06 In-kind services Total: $18,413.52 Objective Total: $36,296.58

Employee name Task rate (a3 + a4)

Number of hours

(a7 x indirect rate)

10) 11)

Hourly rate of

Agency in-kind

Employee 1 GPS Survey of 16 wells $30.00 $10.00 $40.00 120 $4,800.00 $1,502.40 $6,302.40 $6,302.40 $0.00

Employee 2 GPS Survey of 16 wells $30.00 $10.00 $40.00 100 $4,000.00 $1,252.00 $5,252.00 $5,252.00 $0.00

Employee 3 Collect water-level data at 50 NGWMN sites

$30.00 $10.00 $40.00 150 $6,000.00 $1,878.00 $7,878.00 $0.00 $7,878.00

Employee 4 Data entry, QA/QC at 50 NGWMN sites $30.00 $10.00 $40.00 75 $3,000.00 $939.00 $3,939.00 $0.00 $3,939.00

Employee 4 Document work in final report $30.00 $10.00 $40.00 20 $800.00 $250.40 $1,050.40 $0.00 $1,050.40

Totals Total hours

Direct cost total total

Agency

465 $18,600.00 $5,821.80 $24,421.80 $11,554.40 $12,867.40

Objective 3, continued.

b) Supplies

1) 2) 3) 4) 5) 6) Source of funds

Type Cost per unit Number

Cost of supplies (b2 x b3)

Indirect cost (b4 x indirect rate)

Total cost (b4 + b5)

7) 8)

Federal Agency in-kind Survey markers $10.00 32 $320.00 $100.16 $420.16 $420.16 $0.00

Totals Direct cost total Indirect total Total cost Federal total Agency

$320.00 $100.16 $420.16 $420.16 $0.00

c) Equipment

Type

(c2 x c3)

Indirect cost (c4 x indirect rate)

Total cost (c4 + c5)

7) 8)

Federal Agency in-kind Rental of GPS equipment (10 days at $450/day) $450.00 10 $4,500.00 $1,408.50 $5,908.50 $5,908.50 $0.00

Totals Direct cost total Indirect total Total cost Federal total Agency

$4,500.00 $1,408.50 $5,908.50 $5,908.50 $0.00

Objective 3, continued.

d) Travel

1) 2) 3) 4) 5) 6) 7) 8) 9) 10) 11) 12) Source of funds

13) 14)

Traveler name / reason for travel

Number of nights of lodging

Lodging cost per day

Number of days of meals

Meal cost per day

Meal and lodging

((d2 x d3) + (d4 x d5)) Miles traveled Cost per mile

Mileage cost

(d7 x d8) Travel cost (d6 + d9)

Indirect cost (d10 x indirect rate)

Total cost (d10 + d11) Federal

Agency in-kind

Employee 1 (surveying wells)

4 $93.00 5 $51.00 $627.00 250 $0.625 $156.25 $783.25 $245.16 $1,028.41 $0.00 $1,028.41

Employee 2 (surveying wells)

4 $93.00 5 $51.00 $627.00 250 $0.625 $156.25 $783.25 $245.16 $1,028.41 $0.00 $1,028.41

Employee 3 (collect data at

50 NGWMN

wells)

14 $93.00 18 $51.00 $2,200.00 700 $0.625 $437.50 $2,657.50 $831.80 $3,489.30 $0.00 $3,489.30

Totals Direct cost total Indirect total Total cost Federal total Agency total $4,224.00 $1,322.12 $5,546.12 $0.00 $5,546.12

Objective 4. Well Maintenance Overhead/indirect rate: 31.3%

USGS funding Total: $21,915.61 In-kind services Total: $22,350.55 Objective Total: $42,266.16

Employee name Task rate (a3 + a4)

Number of hours

(a7 x indirect rate)

10) 11)

Hourly rate of

Agency in-kind

Employee 1 Well Repairs- Shelter replacement $30.00 $10.00 $40.00 40 $1,600.00 $500.80 $2,100.80 $2,100.80 $0.00

Employee 2 Well Repairs- Shelter replacement $30.00 $10.00 $40.00 40 $1,600.00 $500.80 $2,100.80 $0.00 $2,100.80

Employee 1 Borehole camera survey and well depth measurement

$30.00 $10.00 $40.00 80 $3,200.00 $1,001.60 $4,201.60 $4,201.60 $0.00

Employee 2 Borehole camera survey and well depth measurement

$30.00 $10.00 $40.00 80 $3,200.00 $1,001.60 $4,201.60 $0.00 $4,201.60

Employee 1 Slug testing $30.00 $10.00 $40.00 80 $3,200.00 $1,001.60 $4,201.60 $4,201.60 $0.00 Employee 2 Slug testing $30.00 $10.00 $40.00 80 $3,200.00 $1,001.60 $4,201.60 $0.00 $4,201.60 Employee 3 Slug testing data analysis $30.00 $10.00 $40.00 40 $1,600.00 $500.80 $2,100.80 $0.00 $2,100.80

Employee 1 Document work in final report $30.00 $10.00 $40.00 50 $2,000.00 $626.00 $2,626.00 $0.00 $2,626.00

Totals Total hours

Direct cost total total

490 $19,600.00 $6,134.80 $25,734.80 $10,504.00 $15,230.80

Objective 4, continued.

b) Supplies

Type

(b2 x b3)

Indirect cost (b4 x indirect rate)

Total cost (b4 + b5)

7) 8)

Federal Agency in-kind Padlocks for shelters $25.00 21 $525.00 $164.33 $689.33 $0.00 $689.33 New shelters $150.00 21 $3,150.00 $985.95 $4,135.95 $4,135.95 $0.00

Totals Direct cost total Indirect total Total cost Federal total Agency

$3,675.00 $1,150.28 $4,825.28 $4,135.95 $689.33

Type

(c2 x c3)

Indirect cost (c4 x indirect rate)

Total cost (c4 + c5)

7) 8)

Federal Agency in-kind Tripod for slug tests $100.00 2 $200.00 $62.60 $262.60 $0.00 $262.60 Software for analyzing slug tests $1,000.00 1 $1,000.00 $313.00 $1,313.00 $1,313.00 $0.00

Totals Direct cost total Indirect total Total cost Federal total Agency

$1,200.00 $375.60 $1,575.60 $1,313.00 $262.60

Objective 4, continued.

d) Travel

1) 2) 3) 4) 5) 6) 7) 8) 9) 10) 11) 12) Source of funds

13) 14)

Traveler name / reason for travel

Number of nights of lodging

Lodging cost per day

Number of days of meals

Meal cost per day

Meal and lodging

((d2 x d3) + (d4 x d5)) Miles traveled Cost per mile

Mileage cost

(d7 x d8) Travel cost (d6 + d9)

Indirect cost (d10 x indirect rate)

Total cost (d10 + d11) Federal

Agency in-kind

Employee 1, Replace shelters at 10 wells

4 $93.00 5 $51.00 $627.00 500 $0.625 $312.50 $939.50 $294.06 $1,233.56 $1,233.56 $0.00

Employee 2, Replace shelters at 11 wells

4 $93.00 5 $51.00 $627.00 500 $0.625 $312.50 $939.50 $294.06 $1,233.56 $0.00 $1,233.56

Employee 1, Borehole camera survey and well depth measurement

8 $93.00 10 $51.00 $1,254.00 1000 $0.625 $625.00 $1,879.00 $588.13 $2,467.13 $2,467.13 $0.00

Employee 2, Borehole camera survey and well depth measurement

8 $93.00 10 $51.00 $1,254.00 1000 $0.625 $625.00 $1,879.00 $588.13 $2,467.13 $0.00 $2,467.13

Employee 1, Slug testing 8 $93.00 10 $51.00 $1,254.00 750 $0.625 $468.75 $1,722.75 $539.22 $2,261.97 $2,261.97 $0.00

Employee 2, Slug testing 8 $93.00 10 $51.00 $1,254.00 1000 $0.625 $625.00 $1,879.00 $588.13 $2,467.13 $0.00 $2,467.13

Totals Direct cost total Indirect total Total cost Federal

$9,238.75 $2,891.73 $12,130.48 $5,962.66 $6,167.82

Objective 5. Well Drilling Overhead/indirect rate: 31.3%

USGS funding Total: $17,700.28 In-kind services Total: $12,223.70 Objective Total: $29,923.98

Employee name Task rate (a3 + a4)

Number of hours

(a7 x indirect rate)

10) 11)

Hourly rate of

Agency in-kind

Employee 1 Well drilling support- Well 1 $30.00 $10.00 $40.00 16 $640.00 $200.32 $840.32 $840.32 $0.00

Employee 2 Drilling contract, site scoping and access agreements- Well 1

$30.00 $10.00 $40.00 20 $800.00 $250.40 $1,050.40 $1,050.40 $0.00

Employee 1 Well drilling support- Well 2 $30.00 $10.00 $40.00 16 $640.00 $200.32 $840.32 $0.00 $840.32

Employee 2 Drilling contract, site reconnaissance and access agreements- Well 2

$30.00 $10.00 $40.00 20 $800.00 $250.40 $1,050.40 $0.00 $1,050.40

Employee 2 Document work in final report $30.00 $10.00 $40.00 20 $800.00 $250.40 $1,050.40 $0.00 $1,050.40

Totals Total hours

Direct cost total total

92 $3,680.00 $1,151.84 $4,831.84 $1,890.72 $2,941.12

Objective 5, continued.

Type

Equipment (c2 x c3)

Indirect cost (c4 x indirect rate)

Total cost (c4 + c5)

7) 8)

Federal Agency in-kind Well 1 Pressure Transducer $800.00 1 $800.00 $250.40 $1,050.40 $1,050.40 $0.00 Well 1 datalogger $500.00 1 $500.00 $156.50 $656.50 $656.50 $0.00 Well 1 cable (50 ft @ $2/ft) $2.00 50 $100.00 $31.30 $131.30 $131.30 $0.00 Well 2 Pressure Transducer $800.00 1 $800.00 $250.40 $1,050.40 $1,050.40 $0.00 Well 2 datalogger $500.00 1 $500.00 $156.50 $656.50 $656.50 $0.00 Well 2 cable (200 ft @ $2/ft) $2.00 200 $400.00 $125.20 $525.20 $525.00 $0.00

Totals Direct cost total Indirect total Total cost Federal total Agency

$3,100.00 $970.30 $4,070.30 $4,070.30 $0.00

d) Travel

1) 2) 3) 4) 5) 6) 7) 8) 9) 10) 11) 12) Source of funds

13) 14)

Traveler name / reason for travel

Number of nights of lodging

Lodging cost per day

Number of days of meals

Meal cost per day

Meal and lodging

((d2 x d3) + (d4 x d5)) Miles traveled Cost per mile

Mileage cost

(d7 x d8) Travel cost (d6 + d9)

Indirect cost (d10 x indirect rate)

Total cost (d10 + d11) Federal

Agency in-kind

Employee 1/ well support- Well 1

2 $93.00 3 $51.00 $339.00 300 $0.625 $187.50 $526.50 $164.79 $691.29 $0.00 $691.29

Employee 2/ well support- Well 1

1 $93.00 2 $51.00 $195.00 150 $0.625 $93.75 $288.75 $90.38 $379.13 $379.13 $0.00

Employee 1/ well support- Well 2

2 $93.00 3 $51.00 $339.00 300 $0.625 $187.50 $526.50 $164.79 $691.29 $0.00 $691.29

Employee 2/ well support- Well 2

1 $93.00 2 $51.00 $195.00 150 $0.625 $93.75 $288.75 $90.38 $379.13 $379.13 $0.00

Totals Direct cost total Indirect total Total cost Federal

$1,630.50 $510.34 $2,140.84 $758.26 $1,382.59

Contracts- Salary

1) 2) 3) 4) 5) 6) Source of funds

Description of work Hourly rate of compensation

Hourly rate of fringe benefit

Total hourly rate (col 2 + col 3)

Number of hours

Salary cost (col 4 x col 5)

7) 8)

Federal Agency in-kind Well 1– Driller, Permits $30.00 $10.00 $40.00 4 $160.00 $160.00 $0.00 Well 1- Driller, planning and prep $30.00 $10.00 $40.00 8 $320.00 $0.00 $320.00 Well 1- Driller, Well development $30.00 $10.00 $40.00 8 $320.00 $160.00 $160.00 Well 1- Driller Assistant, Well development $30.00 $10.00 $40.00 8 $320.00 $0.00 $320.00 Well 2– Driller, Permits $30.00 $10.00 $40.00 4 $160.00 $160.00 $0.00 Well 2- Driller, planning and prep $30.00 $10.00 $40.00 8 $320.00 $0.00 $320.00 Well 2- Driller, Well development $30.00 $10.00 $40.00 8 $320.00 $160.00 $160.00 Well 2- Driller Assistant, Well development $30.00 $10.00 $40.00 8 $320.00 $0.00 $320.00 10% contingency for salary contract costs N/A N/A N/A N/A $224.00 $224.00 $0.00

Totals Total hours

Salary total

Federal total

Agency

56 $2,464.00 $864.00 $1,600.00

Contract- Supplies

1) 2) 3) 4) 5) Source of funds

Type

Unit Type (per foot or each)

(col 3 x col 4)

6) 7)

Federal Agency in-kind Well 1- PVC casing per foot $2.00 200 $400.00 $0.00 $400.00 Well 1- PVC screen per foot $2.00 200 $400.00 $0.00 $400.00 Well 1- grout each $100.00 1 $100.00 $0.00 $100.00 Well 1- sand pack each $100.00 1 $100.00 $0.00 $100.00 Well 1- Cap and protective top each $50.00 1 $50.00 $0.00 $50.00 Well 2- PVC casing per foot $2.00 200 $400.00 $400.00 $0.00 Well 2- PVC screen per foot $2.00 200 $400.00 $400.00 $0.00 Well 2- Grout each $100.00 1 $100.00 $100.00 $0.00 Well 2- Sand pack each $100.00 1 $100.00 $100.00 $0.00 Well 2- Cap and protective top each $50.00 1 $50.00 $50.00 $0.00 10% contingency for supplies contract costs N/A N/A N/A $210.00 $210.00 $0.00

Totals Supplies total Federal total Agency

$2,310.00 $1,260.00 $1,050.00

Contract- Travel

1) 2) 3) 4) 5) 6) 7) 8) 9) 10) Source of funds

13) 14)

Traveler name / reason for travel

Number of nights of lodging

Lodging cost per day

Number of days of meals

Meal cost per day

Meal and lodging ((col 2 x col 3) + (col 4 x col 5))

Miles traveled

Cost per mile

Mileage cost

(col 7 x col 8)

Travel cost (col 6 + col 9) Federal

Agency in-kind

Driller 6 $93.00 8 $51.00 $966.00 500 $0.625 $312.50 $1,278.50 $1,278.50 $0.00 Driller assistant 6 $93.00 8 $51.00 $966.00 500 $0.625 $312.50 $1,278.50 $1,278.50 $0.00

Totals Travel total Federal total Agency

$2,557.00 $2,557.00 $0.00

Contract- Well Drilling

1) 2) 3) 4) 5) Source of funds

Type

Unit Type (per foot or each)

(col 3 x col 4)

6) 7)

Federal Agency in-kind Well Drilling- Well 1 per foot $30.00 75 $2,250.00 $1,125.00 $1,125.00 Well Drilling- Well 2 per foot $30.00 125 $3,750.00 $1,875.00 $1,875.00 Mobilization each $1,000.00 2 $2,000.00 $1,000.00 $1,000.00 Site Cleanup each $750.00 2 $1,500.00 $750.00 $750.00 Well development waste disposal each $500.00 2 $1,000.00 $500.00 $500.00 10% contingency for Well drilling contract costs N/A N/A N/A $1,050.00 $1,050.00 $0.00

Totals Supplies total Federal total Agency

$11,550.00 $6,300.00 $5,250.00

Objective 6. Purchase equipment to support continuous water-level data collection Overhead/indirect rate: 31.3%

USGS funding Total: $10,556.11 In-kind services Total: $6,898.91 Objective Total: $17,455.02

Employee name Task rate (a3 + a4)

Number of hours

(a7 x indirect rate)

10) 11)

Hourly rate of

Agency in-kind

Employee 1 Install equipment on well

HCOVA-1234 $30.00 $10.00 $40.00 12 $480.00 $150.24 $630.24 $0.00 $630.24

Employee 1 Install equipment on well

HCOVA-5678 $30.00 $10.00 $40.00 12 $480.00 $150.24 $630.24 $0.00 $630.24

Employee 2 Install equipment on well

HCOVA-2685 $30.00 $10.00 $40.00 12 $480.00 $150.24 $630.24 $0.00 $630.24

Employee 3 Install equipment on well

HCOVA-9101 $30.00 $10.00 $40.00 24 $960.00 $300.48 $1,260.48 $0.00 $1,260.48

Employee 4 Document equipment purchases in final report $30.00 $10.00 $40.00 8 $320.00 $100.16 $420.16 $420.16 $0.00

Totals Total hours

Direct cost total total

68 $2,720.00 $851.36 $3,571.36 $420.16 $3,151.20

Objective 6, continued.

Type equipment (c2 x c3)

Indirect cost (c4 x indirect rate)

Total cost (c4 + c5)

7) 8)

Federal Agency in-kind HCOVA-1234 Pressure Transducer $800.00 1 $800.00 $250.40 $1,050.40 $1,050.40 $0.00 HCOVA-1234 Datalogger $500.00 1 $500.00 $156.50 $656.50 $656.50 $0.00 HCOVA-1234 cable (50 ft @ $2/ft) $2.00 50 $100.00 $31.30 $131.30 $131.30 $0.00 HCOVA-5678 Pressure Transducer $800.00 1 $800.00 $250.40 $1,050.40 $1,050.40 $0.00 HCOVA-5678 Cell Telemetry $1,000 1 $1,000 $313.00 $1,313,00 $949.60 $363.40 HCOVA-5678 cable (50 ft @ $2/ft) $2.00 75 $150.00 $46.95 $196.95 $196.95 $0.00 HCOVA-9101 Pressure Transducer $800.00 1 $800.00 $250.40 $1,050.40 $1,050.40 $0.00 HCOVA-9101 Satellite Telemetry $3,400.00 1 $3,400.00 $1,064.20 $4,464.20 $2,949.60 $1,514.60 HCOVA-9101 cable (50 ft @ $2/ft) $2.00 100 $200.00 $62.60 $262.60 $262.60 $0.00 HCOVA-2685 Pressure Transducer $800.00 1 $800.00 $250.40 $1,050.40 $1,050.40 $0.00 HCOVA-2685 Datalogger $500.00 1 $500.00 $156.50 $656.50 $656.50 $0.00 HCOVA-2685 cable (50 ft @ $2/ft) $2.00 50 $100.00 $31.30 $131.30 $131.30 $0.00

Totals Direct cost total Indirect total Total cost Federal total Agency

$9,150.00 $2,863.95 $12,013.95 $10,135.95 $1,878.00

Objective 6, continued.

d) Travel

1) 2) 3) 4) 5) 6) 7) 8) 9) 10) 11) 12) Source of funds

13) 14)

Traveler name / reason for travel

Number of nights of lodging

Lodging cost per day

Number of days of meals

Meal cost per day

Meal and lodging

((d2 x d3) + (d4 x d5)) Miles traveled Cost per mile

Mileage cost

(d7 x d8) Travel cost (d6 + d9)

Indirect cost (d10 x indirect rate)

Total cost (d10 + d11) Federal

Agency in-kind

Employee 1/ travel for well

HCOVA-1234

1 $93.00 2 $51.00 $195.00 200 $0.625 $125.00 $320.00 $100.16 $420.16 $0.00 $420.16

Employee 1/ travel for well

HCOVA-5678

1 $93.00 2 $51.00 $195.00 200 $0.625 $125.00 $320.00 $100.16 $420.16 $0.00 $420.16

Employee 1/ travel for well

HCOVA-2685

1 $93.00 2 $51.00 $195.00 200 $0.625 $125.00 $320.00 $100.16 $420.16 $0.00 $420.16

Employee 1/ travel for well

HCOVA-9101

2 $93.00 3 $51.00 $339.00 200 $0.625 $125.00 $464.00 $145.23 $609.23 $0.00 $609.23

Totals Direct cost total Indirect total Total cost Federal

$1,424.00 $445.71 $1,869.71 $0.00 $1,869.71

Attachment B – Example budgets