A-10_Exhibit_9_Inspection_Scores_Calculation.pdf

PDF 59 KB Posted

Attached to
Tree Planting Services Federal contract opportunity
Solicitation number
1282MK18Q0006
Issued by
Department of Agriculture Forest Service R2-Rocky Mountain Region

About this file

From the source

Exhibit 9

View the file

Other files for this federal contract opportunity

Other files attached to Tree Planting Services, newest first.
File Type Posted
A-10_Exhibit_11_Employment_of_Eligible_Workers.docx DOCX document
A-10_Exhibit_10_-__Fire_Control_Plan.pdf PDF
A-10_1282MK18Q0006.pdf PDF
A-10_Exhibit_4_Planting_Inspection_Sheet.doc DOC document
A-10_Exhibit_6_Wage_Determination_01162018.pdf PDF
A-10_Exhibit_3_FSH2409.17.doc DOC document
A-10_Exhibit_2-Maps.pdf PDF
A-10_Exhibit_5_Sample_Inspection.doc DOC document
A-10_Exhibit_7_Safety.docx DOCX document
A-10_Exhibit_8_Images.docx DOCX document
A-10_Exhibit_1_Detailed_Info_Chart.docx DOCX document
Show all 11

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Exhibit 9 Example of the Inspection Score Summarization and Payment Price Determination

Summary of Inspection Plots by Sub-Item

3/14/2018

2018 GMUG Tree Planting Contract

Unit = Sub-Item

All plots are 1/50th-acre.

Contract and FACTS Acres are rounded to nearest whole.

= Input Field

The inspection scores for sub-items 1-10, 1-11 and 1-12 are simulated to show how the spreadsheet works.

Values in Sub-item Number, FACTS Acres, GIS Net Planting Acres, Percent Plantable From Pre-planting Survey, Planned Trees Plant per Acre and Planned Trees Plant in Unit fields are from Exhibit 1 -- Detailed Info Chart for the 2018 contract.

Col. 3 Col. 4 Col. 5 Col. 6 Col. 7 Col. 8 Col. 9 Col. 10 Col. 11

Sub-item

Number

FACTS

Acres

GIS Net

Planting

Acres

Desired

Number of

Plantable

Spots

Number of

Unplantable

Spots

Actual

Number of

Plantable

Spots

Maximum

Number

Allowable

Trees

Number

Planted

Trees

Number

Wasted

Trees

Number

Trees

Satisfactory

Above

Ground

Number

Trees

Dug

Number

Trees

Satisfactory

Below

Ground

Inspection

Score for

Sub-Item

Expanded

Number of

Wasted

Trees in

Sub-Item

Sum of

Planted

Trees in

Plots

(Col. 7)

Number of Plots

Percent

Spatial

Area

Sampled

Based on

Contract

Acres

Percent

Plantable

From

Inspection

Col.5

Calculated

Planted

Trees per

Acre

Calculated

Trees

Planted in

Unit

Box Count

Trees

Planted in

Unit

Discrepancy

Between

Calculated and Box

Count

Percent

Difference

Calculated and Box

Count

Percent

Plantable

From Pre-planting

Survey

Planned

Trees

Plant per

Acre

Planned

Trees Plant in Unit

Number of Trees

Planted in Sub-item Minus

Wasted Trees

(Box Count, not

G.5.1.2)

Price by

Item at

$100/m by

Box Count

Price By Item

Minus Wasted

Tree Charge

1-10 30 30 135 11 124 165 170 5 137 46 43 103.278 500 170 15 1.0% 92% 567 17,000 15,800 1,200 7.1% 85% 436 11,200 15,300 350.00$ 1,580.00$ 1,230.00$

1-11 59 59 270 29 241 330 235 0 218 92 89 87.507 0 235 30 1.0% 89% 392 23,108 22,900 208 0.9% 90% 436 23,200 22,900 -$ 2,290.00$ 2,290.00$

1-12 77 77 351 37 314 429 330 0 314 117 115 98.291 0 330 39 1.0% 89% 423 32,577 32,500 77 0.2% 90% 436 30,300 32,500 -$ 3,250.00$ 3,250.00$

Item 1 166 166 756 77 679 924 735 5 669 255 247 95.436 500 735 84 1.0% 72,685 71,200 1,485 2.0% 64,700 70,700 350.00$ 7,120.00$ 6,770.00$

2-26 7 0.5 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0.0% #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 90% 436 200 #DIV/0! #DIV/0! -$ #DIV/0!

2-3 136 63 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0.0% #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 85% 436 23,400 #DIV/0! #DIV/0! -$ #DIV/0!

2-9 28 27.9 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0.0% #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 63% 538 9,500 #DIV/0! #DIV/0! -$ #DIV/0!

2-9.1 11 10.9 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0.0% #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 72% 538 4,300 #DIV/0! #DIV/0! -$ #DIV/0!

2-9.2 7 6.7 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0.0% #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 60% 302 1,300 #DIV/0! #DIV/0! -$ #DIV/0!

2-47 3 2.6 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0.0% #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 73% 680 1,300 #DIV/0! #DIV/0! -$ #DIV/0!

2-46 13 12.8 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0.0% #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 90% 538 6,200 #DIV/0! #DIV/0! -$ #DIV/0!

Item 2 205 124.4 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0.0% #DIV/0! 0 #DIV/0! #DIV/0! 46,200 #DIV/0! #DIV/0! -$ #DIV/0!

3-1.2.3 245 29 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0.0% #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 70% 538 11,000 #DIV/0! #DIV/0! -$ #DIV/0!

Item 3 245 29 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 0.0% #DIV/0! 0 #DIV/0! #DIV/0! 11,000 #DIV/0! #DIV/0! -$ #DIV/0!

4-1 Spares 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 0% 0 0 #DIV/0! #DIV/0! -$ #DIV/0!

Item 4 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! -$ #DIV/0!

5-1 Spares 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 0% 0 0 #DIV/0! #DIV/0! -$ #DIV/0!

Item 5 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! -$ #DIV/0!

6-1 Spares 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 0% 0 0 #DIV/0! #DIV/0! -$ #DIV/0!

Item 6 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! -$ #DIV/0!

Total All 616 319 756 77 679 924 735 5 669 255 247 95.436 #DIV/0! 735 84 0.5% 438 #DIV/0! 71,200 #DIV/0! #DIV/0! 121,900 #DIV/0! #DIV/0! 7,120.00$ #DIV/0!

152,000

Contracted Price = -$

Wasted

Tree

Charge by

Sub-item at

$1.11/tree

& shade card or

$0.70/tree for non-shade card units

(G.7.1.2 and

G.7.2.2)

File details come from the government source that posted it.