NGWMN_FY22_Attach-ment_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 a summary budget for the project followed by the detailed budgets for each objective. The objective budgets are for the entire project and should not be split into year one and year two budgets for multi-year projects.

All budgets use an example 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.

Example Budget 1

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

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

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

Example Budget 2

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 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 $12,800.00 $5,340.00 $18,140.00

4. Travel $4,914.75 $10,990.50 $15,905.25

5. Contracts $9,417.00 $7,900.00 $17,317.00

6. Total Direct (sum of items 1-5) $69,801.75 $50,795.50 $120,597.25

7. Indirect cost $18,900.43 $13,426.29 $32,326.72

8. Total Cost (sum of 6 and 7) $88,702.18 $64,221.79 $152,923.97

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

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,287.46 Objective Total: $36,170.52

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.545 $136.25 $763.25 $238.90 $1,002.15 $0.00 $1,002.15

Employee 2 (surveying wells)

4 $93.00 5 $51.00 $627.00 250 $0.545 $136.25 $763.25 $238.90 $1,002.15 $0.00 $1,002.15

Employee 3 (collect data at

50 NGWMN

wells)

14 $93.00 18 $51.00 $2,200.00 700 $0.545 $381.50 $2,601.50 $814.27 $3,415.77 $0.00 $3,415.77

Totals Direct cost total Indirect total Total cost Federal total Agency total $4,128.00 $1,292.06 $5,420.06 $0.00 $5,420.06

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

USGS funding Total: $22,679.27 In-kind services Total: $22,087.94 Objective Total: $43,767.21

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.545 $272.50 $899.50 $281.54 $1,181.04 $1,181.04 $0.00

Employee 2, Replace shelters at 11 wells

4 $93.00 5 $51.00 $627.00 500 $0.545 $272.50 $899.50 $281.54 $1,181.04 $0.00 $1,181.04

Employee 1, Borehole camera survey and well depth measurement

8 $93.00 10 $51.00 $1,254.00 1000 $0.545 $545.00 $1,799.00 $563.09 $2,362.09 $2,362.09 $0.00

Employee 2, Borehole camera survey and well depth measurement

8 $93.00 10 $51.00 $1,254.00 1000 $0.545 $545.00 $1,799.00 $563.09 $2,362.09 $0.00 $2,362.09

Employee 1, Slug testing 8 $93.00 10 $51.00 $1,254.00 750 $0.545 $408.75 $1662.75 $520.44 $2,183.19 $2,183.19 $0.00

Employee 2, Slug testing 8 $93.00 10 $51.00 $1,254.00 1000 $0.545 $545.00 $1,799.00 $563.09 $2,362.09 $0.00 $2,362.09

Totals Direct cost total Indirect total Total cost Federal

$8,858.75 $2,772.79 $11,631.54 $5,726.32 $5,905.22

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

USGS funding Total: $12,034.47 In-kind services Total: $12,160.69 Objective Total: $24,195.15

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.

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.545 $163.50 $502.50 $157.28 $659.78 $0.00 $659.78

Employee 2/ well support- Well 1

1 $93.00 2 $51.00 $195.00 150 $0.545 $81.75 $276.75 $86.62 $363.37 $363.37 $0.00

Employee 1/ well support- Well 2

2 $93.00 3 $51.00 $339.00 300 $0.545 $163.50 $502.50 $157.28 $659.78 $0.00 $659.78

Employee 2/ well support- Well 2

1 $93.00 2 $51.00 $195.00 150 $0.545 $81.75 $276.75 $86.62 $363.37 $363.37 $0.00

Totals Direct cost total Indirect total Total cost Federal

$1,558.50 $487.81 $2,046.31 $726.75 $1,319.57

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

Totals Total hours

Salary total

Federal total

Agency

56 $2,240.00 $640.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

Totals Supplies total Federal total Agency

$2,100.00 $1,050.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.545 $272.50 $1,238.50 $1,238.50 $0.00 Driller assistant 6 $93.00 8 $51.00 $966.00 500 $0.545 $272.50 $1,238.50 $1,238.50 $0.00

Totals Travel total Federal total Agency

$2,477.00 $2,477.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

Totals Supplies total Federal total Agency

$10,500.00 $5,250.00 $5,250.00

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

USGS funding Total: $10,005.06 In-kind services Total: $11,685.70 Objective Total: $21,690.76

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

(c2 x c3)

Indirect cost (c4 x indirect rate)

Total cost (c4 + c5)

7) 8)

Federal Agency in-kind HCOVA-1234 Pressure Transducer $2,425.00 1 $2,425.00 $759.03 $3,184.03 $3,184.03 $0.00 HCOVA-5678 Pressure Transducer $1,775.00 1 $1,775.00 $555.58 $2,330.58 $2,330.58 $0.00 HCOVA-2685 Pressure Transducer $1,775.00 1 $1,775.00 $555.58 $2,330.58 $2,330.58 $0.00 HCOVA-2685 cell telemetry $1,000.00 1 $1,000.00 $313.00 $1,313.00 $0.00 $1,313.00 HCOVA-9101 Pressure Transducer $1,325.00 1 $1,325.00 $414.73 $1,739.73 $1,739.73 $0.00 HCOVA-9101 satellite telemetry $4,140.00 1 $4,140.00 $1,295.82 $5,435.82 $0.00 $5,435.82

Totals Direct cost total Indirect total Total cost Federal total Agency

$12,440.00 $3,893.72 $16,333.72 $9,584.90 $6,748.82

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.545 $109.00 $304.00 $95.15 $399.15 $0.00 $399.15

Employee 1/ travel for well

HCOVA-5678

1 $93.00 2 $51.00 $195.00 200 $0.545 $109.00 $304.00 $95.15 $399.15 $0.00 $399.15

Employee 1/ travel for well

HCOVA-2685

1 $93.00 2 $51.00 $195.00 200 $0.545 $109.00 $304.00 $95.15 $399.15 $0.00 $399.15

Employee 1/ travel for well

HCOVA-9101

2 $93.00 3 $51.00 $339.00 200 $0.545 $109.00 $448.00 $140.22 $588.22 $0.00 $588.22

Totals Direct cost total Indirect total Total cost Federal

$1,360.00 $425.68 $1,785.68 $0.00 $1,785.68

Attachment B – Example budgets