02. SNOW REMOVAL COST MATRIX.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
TROOP C - LEWIS RUN STATION - SNOW REMOVAL
Solicitation number
6100064442
Issued by
Mercer County, Lewistown Borough, Pennsylvania

About this file

This document is a Cost Matrix spreadsheet for a snow removal contract (IFB # 6100064442) for the Lewis Run Station, Troop C, likely involving a state or local government transportation or public works department. The contract covers snow removal and deicing services with estimated quantities including 60 hours of snow removal/plowing per visit, 30 hours of sidewalk snow removal per visit, 60 tons of granular deicing material, 50 bags of deicing material, and 50 tons of deicing material application. The contract term includes an initial contract year plus four optional renewal years, allowing for potential five-year service coverage.

The cost matrix is structured to allow vendors to quote pricing for each contract year, with yellow cells designated for vendor input. Each contract year maintains consistent estimated quantities across snow removal, plowing, sidewalk clearing, and deicing material services. The spreadsheet is designed to automatically calculate total costs when unit prices are entered, providing a standardized format for bid submissions. The document includes instructions for completing the cost submittal, emphasizing the need to account for all tasks, deliverables, and requirements outlined in the associated Statement of Work, with provisions for vendors to add lines if necessary to comprehensively represent their proposed services.

View the file

Other files

On GovTribe

Work with this file

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

Text version

Instructions WCOA Judges' Conference - June 2019 COST SUBMITTAL INSTRUCTIONS

1The Cost Submittal must be completed in its entirety by completing all boxes.
2Enter vendor name, SAP number, contract number, name of person quoting, and provide contact information.
3Cost Submittal to account for all tasks, deliverables, and requirements outlined and presented in the Statement of Work including the justification/budget narrative.
4Add lines as necessary to include additional components per your quote/bid.
5Enter costs into sections per month. The spreadsheet will populate dollar signs and decimals, and will tabulate the total of the columns.

Cost Matrix

IFB # 6100064442

TROOP C - LEWIS RUN STATION

SNOW REMOVAL

Vendor Name:
SAP Number
Name of Person Quoting:
Contact Email:
Contact Phone #:
Offeror to complete in yellow cells only
Contract Year 1Optional Renewal Year 2
DescriptionQuantity (Estimated)UnitEachTotal CostDescriptionQuantity (Estimated)UnitEachTotal Cost
Snow Removal/Plowing (per visit)60Hour$0.00Snow Removal/Plowing (per visit)60Hour$0.00
Snow Removal/Sidewalks (per visit)30Hour$0.00Snow Removal/Sidewalks (per visit)30Hour$0.00
Granular Deicing Material60Ton$0.00Granular Deicing Material60Ton$0.00
Deicing Material50Bag$0.00Deicing Material50Bag$0.00
Application of Deicing Material50Ton$0.00Application of Deicing Material50Ton$0.00
TOTAL$0.00TOTAL$0.00
Optional Renewal Year 3Optional Renewal Year 4
DescriptionQuantity (Estimated)UnitEachTotal CostDescriptionQuantity (Estimated)UnitEachTotal Cost
Snow Removal/Plowing (per visit)60Hour$0.00Snow Removal/Plowing (per visit)60Hour$0.00
Snow Removal/Sidewalks (per visit)30Hour$0.00Snow Removal/Sidewalks (per visit)30Hour$0.00
Granular Deicing Material60Ton$0.00Granular Deicing Material60Ton$0.00
Deicing Material50Bag$0.00Deicing Material50Bag$0.00
Application of Deicing Material50Ton$0.00Application of Deicing Material50Ton$0.00
TOTAL$0.00TOTAL$0.00
Optional Renewal Year 5
DescriptionQuantity (Estimated)UnitEachTotal Cost
Snow Removal/Plowing (per visit)60Hour$0.00
Snow Removal/Sidewalks (per visit)30Hour$0.00
Granular Deicing Material60Ton$0.00
Deicing Material50Bag$0.00
Application of Deicing Material50Ton$0.00
TOTAL$0.00
TOTAL$0.00

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