W911SA26RA004 Attachment 8 Price Schedule CUI.xlsx

XLSX spreadsheet 274 KB Posted

Attached to
Roads and Grounds Service - Fort McCoy, WI Federal contract opportunity
Solicitation number
W911SA26RA004
Issued by
Department of the Army Materiel Command Mission and Installation Contracting Command Fort McCoy

About this file

Written by GovTribe AI ·

This Excel file is a Price Schedule for Roads and Grounds Services at Fort McCoy, Wisconsin, covering a base period and four option years from April 1, 2026, to February 28, 2031. The contract, solicitation number W911SA26RA004, is issued by the Department of the Army Materiel Command Mission and Installation Contracting Command, with a total contract value of $1,257,500 including a six-month extension option.

The contract includes multiple Contract Line Item Numbers (CLINs) for services such as project management, equipment and operating materials, road maintenance (paved and unpaved), snow and ice removal, grounds maintenance, grass cutting, tree and shrub maintenance, fire break maintenance, hazardous material spill cleanup, and various service orders. The pricing structure features fixed plug numbers for RFP service orders and materials, with base period pricing of $220,000 for RFP service orders and $25,000 for materials, and similar amounts for subsequent option years. The document provides a detailed breakdown of potential service requirements, quantities, and unit pricing for each CLIN, allowing for flexible service ordering throughout the contract period.

View the file

Other files for this federal contract opportunity

Other files attached to Roads and Grounds Service - Fort McCoy, WI, newest first.
File Type Posted
W911SA26RA004 Amendment 0005.pdf PDF
W911SA26RA004 Attachment 8 Price Schedule Updated 2-5-2026 - CUI.xlsx XLSX spreadsheet
W911SA26RA004 Amendment 0006.pdf PDF
W911SA26RA004-0004 Conformed Copy thru -0001.pdf PDF
W911SA26RA004 Attachment 8 Price Schedule Final Update CUI.xlsx XLSX spreadsheet
W911SA26RA004-0004 Solicitation Amendment.pdf PDF
W911SA26RA004-0003 Solicitation Amendment.pdf PDF
W911SA26RA004-0003 Conformed Copy thru -0003.pdf PDF
W911SA26RA004-0002 Solicitation Amendment.pdf PDF
W911SA26RA004-0002 Conformed Copy thru -0002.pdf PDF
W911SA26RA004 Attachment 2 Performance Work Statement (PWS) Updated.docx DOCX document
W911SA26RA004-0001 Solicitation Amendment.pdf PDF
W911SA26RA004 Attachment 8 Price Schedule Updated CUI.xlsx XLSX spreadsheet
W911SA26RA004 Attachment 27 Extended CLIN Descriptions.docx DOCX document
W911SA26RA004 Attachment 9 Wage Determination Updated Log.xlsx XLSX spreadsheet
W911SA26RA004 Attachment 26 CBA-2025-257.pdf PDF
W911SA26RA004 Attachment 7 Deliverables Updated.xlsx XLSX spreadsheet
W911SA26RA004 Attachment 12 2025 GIS LM Acreage Data Updated.xlsx XLSX spreadsheet
W911SA26RA004 Site Visit Attendance Roster.pdf PDF
W911SA26RA004-0001 Conformed Copy.pdf PDF
W911SA26RA004 Attachment 16 Mowing Mapbook Updated.pdf PDF
W911SA26RA004 Attachment 19 Snowplow Mapbook.pdf PDF
W911SA26RA004 Attachment 14 Mowing Cantonment Map.pdf PDF
W911SA26RA004 Attachment 18 Snowplow Installation Map.pdf PDF
W911SA26RA004 Attachment 22 Sediment Trap Locations.pdf PDF
W911SA26RA004 Attachment 23 Hazard Tree Survey 2025.pdf PDF
W911SA26RA004 Attachment 9 Wage Determination Log.xlsx XLSX spreadsheet
W911SA26RA004 Attachment 6 Performance Requirements Summary (PRS).xlsx XLSX spreadsheet
W911SA26RA004 Attachment 25 Equipment List.xlsx XLSX spreadsheet
W911SA26RA004 Attachment 16 Mowing Mapbook.pdf PDF
W911SA26RA004 Attachment 20 Roads and Trails Maintenance.pdf PDF
W911SA26RA004 Attachment 4 SERVICE 408 PAV Clearance.docx DOCX document
W911SA26RA004 Attachment 2 Performance Work Statement (PWS).docx DOCX document
W911SA26RA004 Attachment 24 Unpriced Staffing Matrix.xlsx XLSX spreadsheet
W911SA26RA004 Solicitation.pdf PDF
W911SA26RA004 Attachment 13 Airfield Annex A-10.pdf PDF
W911SA26RA004 Attachment 7 Deliverables.xlsx XLSX spreadsheet
W911SA26RA004 Attachment 17 Snowplow Cantonment Map.pdf PDF
W911SA26RA004 Attachment 15 Mowing Installation Map.pdf PDF
W911SA26RA004 Attachment 10 FMF451.pdf PDF
W911SA26RA004 Attachment 11 FMF452.pdf PDF
W911SA26RA004 Attachment 1 AT OPSEC.pdf PDF
W911SA26RA004 Attachment 21 Fire Break Disk Maps.pdf PDF
W911SA26RA004 Attachment 12 2025 GIS LM Acreage Data.xlsx XLSX spreadsheet
W911SA26RA004 Attachment 3 SERVICE 404 Grounds Main.docx DOCX document
W911SA26RA004 Attachment 5 SERVICE 420 Fac Maint Horiz.docx DOCX document
Show all 46

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.

Price Schedule

CUI
Roads and Grounds Services for Fort McCoy, WI Installation
Solicitation Number: W911SA26RA004
Contract Number: TBDINSTRUCTIONS:
CLINDescriptionUnitQuantityUnit PriceTotal**ONLY USE 2 DECIMAL PLACES IN PRICING
0001Project Management (Apr 1, 2026 - Feb 28, 2027)Month11$ - 0$ - 0**FILL IN BLUE SHADED CELLS ONLY!
0002Equipment and Operating Materials (Apr 1, 2026 - Feb 28, 2027Month11$ - 0$ - 0
0003Paved Road, Lots, Runway/ Taxiway (Apr 1, 2026 - Oct 31, 2026)Month7$ - 0$ - 0**GREEN SHADED CELLS CALCUALTE AUTOMATICALLY. TRANSFER DOLLAR VALUES IN GREEN SHADED CELLS TO THE CORRESPONDING CLIN ON THE SF1449.
0004Unpaved Roads and Surfaces (Apr 1, 2026 - Oct 31, 2026)Month7$ - 0$ - 0
0005Trails (Apr 1, 2026 - Oct 31, 2026)Month7$ - 0$ - 0
0006Snow and Ice Removal (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Priority Roads, Sidewalks, and Parking Lots (Nov. 1, 2026 - Mar 31, 2027)Month5$ - 0$ - 0
Service Order RoadMiles50$ - 0$ - 0
Service Order Parking LotMiles50$ - 0$ - 0
Service Order SidewalksLinear Foot2,000$ - 0$ - 0
Service Order Railroad Switch w/Out HeaterEach24$ - 0$ - 0
0007APRIL Operations (Snow and Ice Removal or Mowing Areas Apr 1, 2026-Apr 30, 2026)Month1$ - 0$ - 0
0008Grounds Maintenance Grass Cutting (May 1, 2026 - Oct. 31, 2026) (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Mowing Areas A, A1, B, C, D, and E (May 1, 2026 - Oct. 31, 2026)Month6$ - 0$ - 0
Service Order for Additional Grass Cutting/ Mowing Services by Commercial Riding MowerAcre50$ - 0$ - 0
Service Order for additional Grass Cutting/ Mowing/ Brushing (up to 3") Services by Agricultural Class MowerAcre200$ - 0$ - 0
Service Order Weed TrimmingHour120$ - 0$ - 0
0009Service Order Turf Repair and MaintenanceSquare Yard2,000$ - 0$ - 0
0010Tree/ Shrub Maintenance (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Hazardous Tree Survey (Annual Requirement)Job1$ - 0$ - 0
Service Order Tree Removal 0-18" DBHEach20$ - 0$ - 0
Service Order Tree Removal 19-24" DBHEach15$ - 0$ - 0
Service Order Tree Removal 25" and Greater DBHEach10$ - 0$ - 0
Service Order Stump Removal 0-20"Each5$ - 0$ - 0
Service Order Stump Removal 21-36"Each5$ - 0$ - 0
Service Order Stump Removal 37" or GreaterEach5$ - 0$ - 0
Service Order PruningEach50$ - 0$ - 0
Service Order Tree and Shrub PlantingEach10$ - 0$ - 0
Service Order Tree CagingEach25$ - 0$ - 0
0011Fire Break Maintenance (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Service Order Fire Break Disking (Annual Requirement)Job1$ - 0$ - 0
Service Order Fire Break Maintenance - RFP Service OrdersJob1$ - 0$ - 0
0012Service Order Barrier PlacementEach40$ - 0$ - 0
0013Service Order Maintain Material SitesEach10$ - 0$ - 0
0014Hazardous Material Spill Cleanup and Disposal (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Service Order for Spill clean-up, material transported to B2960, and site restoration.Ton40$ - 0$ - 0
Service Order for loading soil from B2960 (Est. 8 Hrs 2X per year) and vehicle wash facility (Est. 8 hrs once per year) into other contractor solid waste containers.Each4$ - 0$ - 0
0015Service Order Excavate Stream Sediment TrapsEach16$ - 0$ - 0
0016RFP Service Orders - Fixed Plug NumberJob1$ 220,000.00$ 220,000.00
0017Materials (Cost Reimbursable) - Fixed Plug NumberJob1$ 25,000.00$ 25,000.00
0018Phase In Period (March 1, 2026 - March 31, 2026)Job1$ - 0
TOTAL BASE PERIOD$ 245,000.00
CLINDescriptionUnitQuantityUnit PriceTotal
1001Project Management (Mar 1, 2027 - Feb 29, 2028)Month12$ - 0$ - 0
1002Equipment and Operating Materials (Mar 01, 2027 - Feb 29, 2028)Month12$ - 0$ - 0
1003Paved Road, Lots, Runway/ Taxiway (Apr 1, 2027 - Oct 31, 2027)Month7$ - 0$ - 0
1004Unpaved Roads and Surfaces (Apr 1, 2027 - Oct 31, 2027)Month7$ - 0$ - 0
1005Trails (Apr 1, 2027 - Oct 31, 2027)Month7$ - 0$ - 0
1006Snow and Ice Removal (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Priority Roads, Sidewalks, and Parking Lots (Nov. 1, 2027 - Mar. 31, 2028)Month5$ - 0$ - 0
Service Order RoadMiles50$ - 0$ - 0
Service Order Parking LotMiles50$ - 0$ - 0
Service Order SidewalksLinear Foot2,000$ - 0$ - 0
Service Order Railroad Switch w/Out HeaterEach24$ - 0$ - 0
1007APRIL Operations (Snow and Ice Removal or Mowing Areas Apr 1, 2027-Apr 30, 2027)Month1$ - 0$ - 0
1008Grounds Maintenance Grass Cutting (May 1, 2027 - Oct. 31, 2027) (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Mowing Areas A, A1, B, C, D, and E (May 1, 2027 - Oct. 31, 2027)Month6$ - 0$ - 0
Service Order for Additional Grass Cutting/ Mowing Services by Commercial Riding MowerAcre50$ - 0$ - 0
Service Order for additional Grass Cutting/ Mowing/ Brushing (up to 3") Services by Agricultural Class MowerAcre200$ - 0$ - 0
Service Order Weed TrimmingHour120$ - 0$ - 0
1009Service Order Turf Repair and MaintenanceSquare Yard2,000$ - 0$ - 0
1010Tree/ Shrub Maintenance (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Hazardous Tree Survey (Annual Requirement)Job1$ - 0$ - 0
Service Order Tree Removal 0-18" DBHEach20$ - 0$ - 0
Service Order Tree Removal 19-24" DBHEach15$ - 0$ - 0
Service Order Tree Removal 25" and Greater DBHEach10$ - 0$ - 0
Service Order Stump Removal 0-20"Each5$ - 0$ - 0
Service Order Stump Removal 21-36"Each5$ - 0$ - 0
Service Order Stump Removal 37" or GreaterEach5$ - 0$ - 0
Service Order PruningEach50$ - 0$ - 0
Service Order Tree and Shrub PlantingEach10$ - 0$ - 0
Service Order Tree CagingEach25$ - 0$ - 0
1011Fire Break Maintenance (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Service Order Fire Break Disking (Annual Requirement)Job1$ - 0$ - 0
Service Order Fire Break Maintenance - RFP Service OrdersJob1$ - 0$ - 0
1012Service Order Barrier PlacementEach40$ - 0$ - 0
1013Service Order Maintain Material SitesEach10$ - 0$ - 0
1014Hazardous Material Spill Cleanup and Disposal (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Service Order for Spill clean-up, material transported to B2960, and site restoration.Ton40$ - 0$ - 0
Service Order for loading soil from B2960 (Est. 8 Hrs 2X per year) and vehicle wash facility (Est. 8 hrs once per year) into other contractor solid waste containers.Each4$ - 0$ - 0
1015Service Order Excavate Stream Sediment TrapsEach16$ - 0$ - 0
1016RFP Service Orders - Fixed Plug NumberJob1$ 200,000.00$ 200,000.00
1017Materials (Cost Reimbursable) - Fixed Plug NumberJob1$ 25,000.00$ 25,000.00
TOTAL OPTION YEAR 1 PERIOD$ 225,000.00
CLINDescriptionUnitQuantityUnit PriceTotal
2001Project Management (Mar 1, 2028 - Feb 28, 2029)Month12$ - 0$ - 0
2002Equipment and Operating Materials (Mar 01, 2028 - Feb 28, 2029)Month12$ - 0$ - 0
2003Paved Road, Lots, Runway/ Taxiway (Apr 1, 2028 - Oct 31, 2028)Month7$ - 0$ - 0
2004Unpaved Roads and Surfaces (Apr 1, 2028 - Oct 31, 2028)Month7$ - 0$ - 0
2005Trails (Apr 1, 2028 - Oct 31, 2028)Month7$ - 0$ - 0
2006Snow and Ice Removal (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Priority Roads, Sidewalks, and Parking Lots (Nov. 1, 2028 - Mar. 31, 2029)Month5$ - 0$ - 0
Service Order RoadMiles50$ - 0$ - 0
Service Order Parking LotMiles50$ - 0$ - 0
Service Order SidewalksLinear Foot2,000$ - 0$ - 0
Service Order Railroad Switch w/Out HeaterEach24$ - 0$ - 0
2007APRIL Operations (Snow and Ice Removal or Mowing Areas Apr 1, 2028-Apr 30, 2028)Month1$ - 0$ - 0
2008Grounds Maintenance Grass Cutting (May 1, 2028 - Oct. 31, 2028) (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Mowing Areas A, A1, B, C, D, and E (May 1, 2028 - Oct. 31, 2028)Month6$ - 0$ - 0
Service Order for Additional Grass Cutting/ Mowing Services by Commercial Riding MowerAcre50$ - 0$ - 0
Service Order for additional Grass Cutting/ Mowing/ Brushing (up to 3") Services by Agricultural Class MowerAcre200$ - 0$ - 0
Service Order Weed TrimmingHour120$ - 0$ - 0
2009Service Order Turf Repair and MaintenanceSquare Yard2,000$ - 0$ - 0
2010Tree/ Shrub Maintenance (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Hazardous Tree Survey (Annual Requirement)Job1$ - 0$ - 0
Service Order Tree Removal 0-18" DBHEach20$ - 0$ - 0
Service Order Tree Removal 19-24" DBHEach15$ - 0$ - 0
Service Order Tree Removal 25" and Greater DBHEach10$ - 0$ - 0
Service Order Stump Removal 0-20"Each5$ - 0$ - 0
Service Order Stump Removal 21-36"Each5$ - 0$ - 0
Service Order Stump Removal 37" or GreaterEach5$ - 0$ - 0
Service Order PruningEach50$ - 0$ - 0
Service Order Tree and Shrub PlantingEach10$ - 0$ - 0
Service Order Tree CagingEach25$ - 0$ - 0
2011Fire Break Maintenance (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Service Order Fire Break Disking (Annual Requirement)Job1$ - 0$ - 0
Service Order Fire Break Maintenance - RFP Service OrdersJob1$ - 0$ - 0
2012Service Order Barrier PlacementEach40$ - 0$ - 0
2013Service Order Maintain Material SitesEach10$ - 0$ - 0
2014Hazardous Material Spill Cleanup and Disposal (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Service Order for Spill clean-up, material transported to B2960, and site restoration.Ton40$ - 0$ - 0
Service Order for loading soil from B2960 (Est. 8 Hrs 2X per year) and vehicle wash facility (Est. 8 hrs once per year) into other contractor solid waste containers.Each4$ - 0$ - 0
2015Service Order Excavate Stream Sediment TrapsEach16$ - 0$ - 0
2016RFP Service Orders - Fixed Plug NumberJob1$ 200,000.00$ 200,000.00
2017Materials (Cost Reimbursable) - Fixed Plug NumberJob1$ 25,000.00$ 25,000.00
TOTAL OPTION YEAR 2 PERIOD$ 225,000.00
CLINDescriptionUnitQuantityUnit PriceTotal
3001Project Management (Mar 1, 2029 - Feb 28, 2030)Month12$ - 0$ - 0
3002Equipment and Operating Materials (Mar 01, 2029 - Feb 28, 2030)Month12$ - 0$ - 0
3003Paved Road, Lots, Runway/ Taxiway (Apr 1, 2029 - Oct 31, 2029)Month7$ - 0$ - 0
3004Unpaved Roads and Surfaces (Apr 1, 2029 - Oct 31, 2029)Month7$ - 0$ - 0
3005Trails (Apr 1, 2029 - Oct 31, 2029)Month7$ - 0$ - 0
3006Snow and Ice Removal (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Priority Roads, Sidewalks, and Parking Lots (Nov. 1, 2029 - Mar. 31, 2030)Month5$ - 0$ - 0
Service Order RoadMiles50$ - 0$ - 0
Service Order Parking LotMiles50$ - 0$ - 0
Service Order SidewalksLinear Foot2,000$ - 0$ - 0
Service Order Railroad Switch w/Out HeaterEach24$ - 0$ - 0
3007APRIL Operations (Snow and Ice Removal or Mowing Areas Apr 1, 2029-Apr 30, 2030)Month1$ - 0$ - 0
3008Grounds Maintenance Grass Cutting (May 1, 2029 - Oct. 31, 2029) (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Mowing Areas A, A1, B, C, D, and E (May 1, 2029 - Oct. 31, 2029)Month6$ - 0$ - 0
Service Order for Additional Grass Cutting/ Mowing Services by Commercial Riding MowerAcre50$ - 0$ - 0
Service Order for additional Grass Cutting/ Mowing/ Brushing (up to 3") Services by Agricultural Class MowerAcre200$ - 0$ - 0
Service Order Weed TrimmingHour120$ - 0$ - 0
3009Service Order Turf Repair and MaintenanceSquare Yard2,000$ - 0$ - 0
3010Tree/ Shrub Maintenance (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Hazardous Tree Survey (Annual Requirement)Job1$ - 0$ - 0
Service Order Tree Removal 0-18" DBHEach20$ - 0$ - 0
Service Order Tree Removal 19-24" DBHEach15$ - 0$ - 0
Service Order Tree Removal 25" and Greater DBHEach10$ - 0$ - 0
Service Order Stump Removal 0-20"Each5$ - 0$ - 0
Service Order Stump Removal 21-36"Each5$ - 0$ - 0
Service Order Stump Removal 37" or GreaterEach5$ - 0$ - 0
Service Order PruningEach50$ - 0$ - 0
Service Order Tree and Shrub PlantingEach10$ - 0$ - 0
Service Order Tree CagingEach25$ - 0$ - 0
3011Fire Break Maintenance (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Service Order Fire Break Disking (Annual Requirement)Job1$ - 0$ - 0
Service Order Fire Break Maintenance - RFP Service OrdersJob1$ - 0$ - 0
3012Service Order Barrier PlacementEach40$ - 0$ - 0
3013Service Order Maintain Material SitesEach10$ - 0$ - 0
3014Hazardous Material Spill Cleanup and Disposal (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Service Order for Spill clean-up, material transported to B2960, and site restoration.Ton40$ - 0$ - 0
Service Order for loading soil from B2960 (Est. 8 Hrs 2X per year) and vehicle wash facility (Est. 8 hrs once per year) into other contractor solid waste containers.Each4$ - 0$ - 0
3015Service Order Excavate Stream Sediment TrapsEach16$ - 0$ - 0
3016RFP Service Orders - Fixed Plug NumberJob1$ 200,000.00$ 200,000.00
3017Materials (Cost Reimbursable) - Fixed Plug NumberJob1$ 25,000.00$ 25,000.00
TOTAL OPTION YEAR 3 PERIOD$ 225,000.00
CLINDescriptionUnitQuantityUnit PriceTotal
4001Project Management (Mar 1, 2030 - Feb 28, 2031)Month12$ - 0$ - 0
4002Equipment and Operating Materials (Mar 01, 2030 - Feb 28, 2031)Month12$ - 0$ - 0
4003Paved Road, Lots, Runway/ Taxiway (Apr 1, 2030 - Oct 31, 2030)Month7$ - 0$ - 0
4004Unpaved Roads and Surfaces (Apr 1, 2030 - Oct 31, 2030)Month7$ - 0$ - 0
4005Trails (Apr 1, 2030 - Oct 31, 2030)Month7$ - 0$ - 0
4006Snow and Ice Removal (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Priority Roads, Sidewalks, and Parking Lots (Nov. 1, 2030 - Mar. 31, 2031)Month5$ - 0$ - 0
Service Order RoadMiles50$ - 0$ - 0
Service Order Parking LotMiles50$ - 0$ - 0
Service Order SidewalksLinear Foot2,000$ - 0$ - 0
Service Order Railroad Switch w/Out HeaterEach24$ - 0$ - 0
4007APRIL Operations (Snow and Ice Removal or Mowing Areas Apr 1, 2026-Apr 30, 2026)Month1$ - 0$ - 0
4008Grounds Maintenance Grass Cutting (May 1, 2030 - Oct. 31, 2030) (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Mowing Areas A, A1, B, C, D, and E (May 1, 2030 - Oct. 31, 2030)Month6$ - 0$ - 0
Service Order for Additional Grass Cutting/ Mowing Services by Commercial Riding MowerAcre50$ - 0$ - 0
Service Order for additional Grass Cutting/ Mowing/ Brushing (up to 3") Services by Agricultural Class MowerAcre200$ - 0$ - 0
Service Order Weed TrimmingHour120$ - 0$ - 0
4009Service Order Turf Repair and MaintenanceSquare Yard2,000$ - 0$ - 0
4010Tree/ Shrub Maintenance (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Hazardous Tree Survey (Annual Requirement)Job1$ - 0$ - 0
Service Order Tree Removal 0-18" DBHEach20$ - 0$ - 0
Service Order Tree Removal 19-24" DBHEach15$ - 0$ - 0
Service Order Tree Removal 25" and Greater DBHEach10$ - 0$ - 0
Service Order Stump Removal 0-20"Each5$ - 0$ - 0
Service Order Stump Removal 21-36"Each5$ - 0$ - 0
Service Order Stump Removal 37" or GreaterEach5$ - 0$ - 0
Service Order PruningEach50$ - 0$ - 0
Service Order Tree and Shrub PlantingEach10$ - 0$ - 0
Service Order Tree CagingEach25$ - 0$ - 0
4011Fire Break Maintenance (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Service Order Fire Break Disking (Annual Requirement)Job1$ - 0$ - 0
Service Order Fire Break Maintenance - RFP Service OrdersJob1$ - 0$ - 0
4012Service Order Barrier PlacementEach40$ - 0$ - 0
4013Service Order Maintain Material SitesEach10$ - 0$ - 0
4014Hazardous Material Spill Cleanup and Disposal (Roll-Up CLIN, SO's issued from Item Pricing Below)Job1$ - 0$ - 0
Service Order for Spill clean-up, material transported to B2960, and site restoration.Ton40$ - 0$ - 0
Service Order for loading soil from B2960 (Est. 8 Hrs 2X per year) and vehicle wash facility (Est. 8 hrs once per year) into other contractor solid waste containers.Each4$ - 0$ - 0
4015Service Order Excavate Stream Sediment TrapsEach16$ - 0$ - 0
4016RFP Service Orders - Fixed Plug NumberJob1$ 200,000.00$ 200,000.00
4017Materials (Cost Reimbursable) - Fixed Plug NumberJob1$ 25,000.00$ 25,000.00
TOTAL OPTION YEAR 4 PERIOD$ 225,000.00
Contract Value (Base plus four options)$ 1,145,000.00These three lines calculate automatically.
Six Month Option to Extend$ 112,500.00
Total Contract Value (Base, Plus 4, with 6 Month Option$ 1,257,500.00
CUI

Base Period Labor Burden Cost Data

Directions:ITEMS HIGHLIGHTED IN PINK ARE ITEMS THE VENDOR MUST FILL IN!
Itemize your projected costs in each Contract Line Item Number (CLIN) area.
Calculate cost times the number of estimated quantities required.FORMULA'S SHOW IN GREEN IN EACH COLUMN ARE REPRESENTATIVE OF THE FORUMLA(S) EMBEDDED IN THAT COLUMN.
The positions are to be listed as one job classification per line within each CLIN listed below. If you need to add additional job classifications, insert another line in the appropriate CLIN below. Do not combine personnel or hours. One line is one job classification.
DO NOT change any of the formulas embedded within these spreadsheets. If formulas must be changed please provide a detailed explanation as to why the formula was changed.THE DOLLAR VALUES , OTHER NUMBERS AND INFORMATION GIVEN IN THE SPREADSHEET BELOW ARE SHOWN FOR SAMPLE PURPOSES ONLY! THE FORMULAS USED ARE NOT SAMPLES AND CANNOT BE CHANGED.
Transfer cost data to the appropriate section of the price schedule.

A. Identify CLIN Number B. Identify PWS Paragraph Number(s) C. Identify Paragraph Title D. Identify PRS Number(s) E. Identify job classification in accordance with SCA. F. Identify Organizational Chart Position Number G. Identify Occupation Code in accordance with SCA and CBA. H. Identify Workload indicator I. Identify Schedule Workload J. Identify Type (SCA, Exempt, or CBA) K. Identify Total Hourly Wage L. Identify time per task in standard man hours. M. Calculate total man hours using the formula provided. N. Calculate FTE's using the formula provided. O. Calculate total hours using the formula provided. P. Calculate total base wages or material using the formula provided. Q. Calculate FICA using the formula provided. R. Calculate SUI using the formula provided. Vendor will need to fill in cells R12 and R13 S. Calculate FUI using the formula provided. Vendor will need to fill in cells S12 and S13 T. Calculate WC using the formula provided. Vendor will need to fill in cell T13 U. Calculate GL/UMB using the formula provided. Vendor will need to fill in cell U13 V. Identify the appropriate dollar amount for health & welfare. Fill in the dollar amount in cells V12 or V13 W. Calculate total health and welfare using the formula provided. X. Calculate Direct Labor before G&A using the formula provided. Y. Identify overhead rate. Vendor is to provide a description of what is included in the overhead rate. Fill in Y13 Z Calculate G&A using the formula provided. Vendor will need to fill in cell Y13 - not referencing DCAA Audit for G&A rates should be submitted with pricing piece of package AA. Calculate the total estimate cost using the formula provided. AB. Calculate profit using the formula provided. Vendor will need to fill in cell AB13 AC. Calculate total CLIN cost using the formula provided.

dollar amountdollar amountExempt
percentagepercentagedollar amountdollar amountSCA CBApercentagepercentagepercentage
CLINPWS Para #Paragraph TitlePRS #Job ClassificationOrg Chart Position NumberOccupation Code (SCA & CBA)Workload IndicatorSchedule Work LoadTypeTotal Hourly WageTime Per Task in Man Hours (Standard)Total Man HoursFTE'sTotal HoursTotal Base WagesFICASUTA per FTEFUTA per FTEWCGeneral Liability/ UmbrellaHealth & WelfareHEALTH & WELFARE TOTALDIRECT LABOR (Before G&A)OverheadG&ATotal Estimated CostProfitTOTAL CLIN COST
I15*L15ROUND(M15/1880,3)N15*2087O15*K15ROUND(IF(P15<110100,P15*0.062,110100*0.062),2)+(ROUND((P15*0.0145),2))R$12*R$13*N15S$12*S$13*N15T$13*P15/100P15/1000*U$13V12 or V13V15*O15ROUND(SUM(P15:U15,W15),2)ROUND(Y$13*X15,2)ROUND(Z$13*X15,2)ROUND(SUM(X15:Z15),2)ROUND(AB$13*AA15,2)ROUND(SUM(AA15:AB15),2)
0001 Project Management
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0001 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0002 Equipment and Operating Materials
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0002 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0003 Paved Road, Lots, Runway/Taxiway
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0003 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0004 Unpaved Roads and Surfaces
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0004 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0005 Trails
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0005 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0006 Snow and Ice Removal
Priority Roads, Sidewalks, and Parking Lots
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Road
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Parking Lot
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Sidewalks
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Railroad Switch w/Out Heater
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

0006 TOTAL 0.00 0.00 0.00 0.00 0.00 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! 0.00 0.00 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!

0007 April Operations (Snow and Ice Removal or Mowing Areas)
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0007 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0008 Grounds Maintnance Grass Cutting
Mowing Areas A, A1, B, C, D, and E
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order for Additional Grass Cutting/ Mowing Services by Commercial Riding Mower
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order for additional Grass Cutting/ Mowing/ Brushing (up to 3") Services by Agricultural Class Mower
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Weed Trimming
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

0008 TOTAL 0.00 0.00 0.00 0.00 0.00 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! 0.00 0.00 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!

0009 Service Order Turf Repair and Maintenance
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0009 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0010 Tree/Shrub Maintenance
Hazardous Tree Survey (Annual Requirement)
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Tree Removal 0-18" DBH
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Tree Removal 19-24" DBH
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Tree Removal 25" and Greater DBH
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Stump Removal 0-20"
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Stump Removal 21-36"
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Stump Removal 37" or Greater
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Pruning
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Tree and Shrub Planting
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Tree Caging
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

0010 TOTAL 0.00 0.00 0.00 0.00 0.00 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! 0.00 0.00 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!

0011 Fire Break Maintenance
Service Order Fire Break Disking (Annual Requirement)
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order Fire Break Maintenance - RFP Service Orders
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

0011 TOTAL 0.00 0.00 0.00 0.00 0.00 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! 0.00 0.00 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!

0012 Service Order Barrier Placement
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0012 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0013 Service Order Maintain Material Sites
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0013 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0014 Hazardous Material Spill Cleanup and Disposal)
Service Order for Spill Clen-up, material transported to B2960, and site restoration
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Service Order for loading soil from B2960 (Est. 8 HRS 2X per year) and vehicle was facility (Est. 4 hrs once per year) into other contractor sold waste containers.
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

0014 TOTAL 0.00 0.00 0.00 0.00 0.00 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! 0.00 0.00 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!

0015 Service Order Excavate Stream Sediment Traps
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0015 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0016 RFP Servicew Orders - Fixed Plug Number
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0016 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0017 Materials (Cost Reimbursable) - Fixed Plug Number
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0017 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0018 Phase In Period
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0018 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

Option Year 1 Labor Burden Cost Data

Directions:ITEMS HIGHLIGHTED IN PINK ARE ITEMS THE VENDOR MUST FILL IN!
Itemize your projected costs in each Contract Line Item Number (CLIN) area.
Calculate cost times the number of estimated quantities required.FORMULA'S SHOW IN GREEN IN EACH COLUMN ARE REPRESENTATIVE OF THE FORUMLA(S) EMBEDDED IN THAT COLUMN.
The positions are to be listed as one job classification per line within each CLIN listed below. If you need to add additional job classifications, insert another line in the appropriate CLIN below. Do not combine personnel or hours. One line is one job classification.
DO NOT change any of the formulas embedded within these spreadsheets. If formulas must be changed please provide a detailed explanation as to why the formula was changed.THE DOLLAR VALUES , OTHER NUMBERS AND INFORMATION GIVEN IN THE SPREADSHEET BELOW ARE SHOWN FOR SAMPLE PURPOSES ONLY! THE FORMULAS USED ARE NOT SAMPLES AND CANNOT BE CHANGED.
Transfer cost data to the appropriate section of the price schedule.

A. Identify CLIN Number B. Identify PWS Paragraph Number(s) C. Identify Paragraph Title D. Identify PRS Number(s) E. Identify job classification in accordance with SCA. F. Identify Organizational Chart Position Number G. Identify Occupation Code in accordance with SCA and CBA. H. Identify Workload indicator I. Identify Schedule Workload J. Identify Type (SCA, Exempt, or CBA) K. Identify Total Hourly Wage L. Identify time per task in standard man hours. M. Calculate total man hours using the formula provided. N. Calculate FTE's using the formula provided. O. Calculate total hours using the formula provided. P. Calculate total base wages or material using the formula provided. Q. Calculate FICA using the formula provided. R. Calculate SUI using the formula provided. Vendor will need to fill in cells R12 and R13 S. Calculate FUI using the formula provided. Vendor will need to fill in cells S12 and S13 T. Calculate WC using the formula provided. Vendor will need to fill in cell T13 U. Calculate GL/UMB using the formula provided. Vendor will need to fill in cell U13 V. Identify the appropriate dollar amount for health & welfare. Fill in the dollar amount in cells V12 or V13 W. Calculate total health and welfare using the formula provided. X. Calculate Direct Labor before G&A using the formula provided. Y. Identify overhead rate. Vendor is to provide a description of what is included in the overhead rate. Fill in Y13 Z Calculate G&A using the formula provided. Vendor will need to fill in cell Y13 - not referencing DCAA Audit for G&A rates should be submitted with pricing piece of package AA. Calculate the total estimate cost using the formula provided. AB. Calculate profit using the formula provided. Vendor will need to fill in cell AB13 AC. Calculate total CLIN cost using the formula provided.

dollar amountdollar amountExempt
percentagepercentagedollar amountdollar amountSCA CBApercentagepercentagepercentage
CLINPWS Para #Paragraph TitlePRS #Job ClassificationOrg Chart Position NumberOccupation Code (SCA & CBA)Workload IndicatorSchedule Work LoadTypeTotal Hourly WageTime Per Task in Man Hours (Standard)Total Man HoursFTE'sTotal HoursTotal Base WagesFICASUTA per FTEFUTA per FTEWCGeneral Liability/ UmbrellaHealth & WelfareHEALTH & WELFARE TOTALDIRECT LABOR (Before G&A)OverheadG&ATotal Estimated CostProfitTOTAL CLIN COST
I15*L15ROUND(M15/1880,3)N15*2087O15*K15ROUND(IF(P15<110100,P15*0.062,110100*0.062),2)+(ROUND((P15*0.0145),2))R$12*R$13*N15S$12*S$13*N15T$13*P15/100P15/1000*U$13V11 or V12V15*O15ROUND(SUM(P15:U15,W15),2)ROUND(Y$13*X15,2)ROUND(Z$13*X15,2)ROUND(SUM(X15:Z15),2)ROUND(AB$13*AA15,2)ROUND(SUM(AA15:AB15),2)
1001 Project Management
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
1001 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
1002 Equipment and Operating Materials
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
1002 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
1003 Paved Road, Lots, Runway/Taxiway
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
1003 TOTAL0.000.000.000.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
1004 Unpaved Roads and Surfaces
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0.000.0000.000$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .