02. SNOW REMOVAL COST MATRIX.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
TROOP B -PITTSBURGH STATION SNOW REMOVAL
Solicitation number
6100064323
Issued by
Allegheny County, Pennsylvania

About this file

This is a Cost Matrix Excel spreadsheet for a snow removal contract (IFB # 6100064323) for the Pennsylvania State Police Troop B - Pittsburgh Station. The document outlines a five-year contract with potential optional renewal years, covering snow removal services including plowing, sidewalk clearing, and deicing material application. The contract includes estimated quantities for snow removal/plowing (60 hours per visit), sidewalk snow removal (30 hours per visit), granular deicing material (60 tons), deicing material (50 bags), and deicing material application (50 tons) for each contract and renewal year.

The cost matrix is designed for vendors to complete pricing information in yellow cells, with placeholders for vendor name, SAP number, contact information, and unit pricing for each service. The spreadsheet allows for comprehensive cost submission across multiple contract years, enabling precise tracking of proposed costs for snow removal and related services. The document provides a structured format for vendors to quote prices for each service type, with the ability to calculate total costs across different contract periods, though in this example, all total cost fields are currently set to $0.00.

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 # 6100064323

TROOP B - PITTSBURGH 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 .