Project Details
WM Insource Snow Removal RFP 2023
RFP
Lessons Learned
Won
Green
90%
06-22-2023
10-26-2023
Project Log Items
 
Date
Type of Note
Type of Service
Due Date
Status
Note
Resolution
 
07-10-2023 General Note     Open Jason T Final Meeting: 

Seasonal Looks: 

Look at Salem IN Provider 30,000 last year 20k pricing 

Saint Charles MO 40K last year and 21K this year 

St. Peters MO modest drop (overrode by RFP Team to match Incumbent) 

Greenville NC small drop from 6,100 to 5,200 

Go through Per Event and check level 1 last year provider pricing vs this year and calling out any outliers 

Preferred Location: 

Possibly making per event states no 

24 Hour Service: 

Call Matt Alley to double check 

Re-Look at TN any near Big Metro should be a yes (talk to Matt Alley) 

Look at discount: based on percent of region 

Addendum: look at region and discount, needs to be primarily seasonal 

Potential put a large # of sites and large discounts 		 
07-06-2023 General Note     Open For Bryan's Walmart West sites - Per our conversation, I would like for all of my per event pricing to remain the same as last year except for one store.

 Walmart: E Walnut St Thayer 837 

I would like 837 to be submitted at your recommended pricing. Thank you!

Seasonal numbers I would like priced....
996 $30,350.63
6390 $29,691.43
1601 $44,908

 		  
07-06-2023 General Note     Open Walmart Thursday Touchbase Notes

-    Sent Tim list of field who has not signed off on for SOW
-    Waiting for answer on bidding entire state that is warmer weather, going to ask Walmart for advice. Bruce recommends going in “at close to 100% margin” if we are going to bid those in case it snows
-    Mike is still on fence for TX and LA, waiting for answer from Walmart
-    Was wondering where margin column was, highlighted top row of them
-    Kyle going to go store by store for margin and make his own edits
-    Team leads meeting together to finalize margins
-    Bryan said he is going up 5-10% on keeping the same on most incumbents, will send us over them soon

  
07-06-2023 General Note     Open Mitch: 

Per Event: 

Equipment: Skidsteer 

Hourly Rate: 115 

Bulk Salt 175 

Hand Labor: 40 

Hand Labor Efficiency: 1500 

Sidewalk De-Icer: 30 

Sidewalk De-Icer Efficiency: 2000 

Push Level #1: 1.5 

Salt: Sodium Chloride 
One time Mechanical Sweep: 200 

New Martinsville: 26 K  

IN and KY Locations use PPSI 15yr snow 

AL Sites: 

Equipment: Skidsteer 

Hourly Rate: 115 

Bulk Salt: 175 

Hand Labor: 40 

Bryan: 

Equipment: Loader 

Efficiency: 90,000 

Equipment Hourly Rate: 150 

Bulk Salt: 175 

Hand labor efficiency: 1500 

Salt: Sodium Chloride 

Sweep: 200 

Any Incumbents: Take price up 10% 

Millersberg/New Philly: 30 year data 

Rest of the sites: 15 year 

Kent: 68 

5410: 60,000 

Mansfield: 60,000 

Streetsboro: 80,000 

Ryan: 

Equipment: Loader 

Equipment Efficiency: 90,000 

Hourly Rate: 150 

Bulk Salt: 175 

Hand Labor: 40 

Labor Efficiency: 2000 

Push Ratio: .0026 

Anywhere we are incumbent: Up 5% 

Ashtabula: 105,000 

Chardon: 82,000 

Macedonia: 40,000 

Madison: 90,000 

Middlefield: 80,000 

Cleveland Hights: 80,000 

Karen:  

Match all of Bryan Nevet for frequencies 

Add all incumbents not in WV do 15% 

WV incumbents add 12.5% 

For all other sites use Column BZ 

Coshocton: 58,000 

3581: 29,000 

5% on incumbent sites for central 

Becky: 

Match Drew on Frequencies 

2426: 40,0000 

1990: 20,000 

Increase Seasonal: 10% from incumbent 

AL: 

Equipment: Skid 

Equipment Rate: 115 

Bulk Salt: 175 

Hand Labor 40 

Efficiency: 1500 

Sidewalk De-Icer: 35 

Efficiency: 2000 

Drew: 

Match to AL for frequencies 

Celina: 42,000 

Franklin: 30,000 

3206: 30,000 

Xenia add 10% to incumbent price 

Alex: 

Match frequencies to Ryan Carrol 

Salt: Sodium Chloride 

Sweep: 200 		 
07-05-2023 General Note     Open Bryan wanted to use current pricing for Tehachapi CA since we had success there. Upload those into customer totals.

* Andy Krumm and John Alves have been making their own edits inside the V3 model.		  
07-05-2023 General Note     Open Dan Schafer: 

Apple Valley, Barstow, Crescent City, Eureka take a second look could get snow 

Jackson and Sonora bid the rest of CA do not bid 

2 sites Sodium Chloride 		 
07-03-2023 General Note     Open RAM: 

Bryan Futscher: 

Minnesota: 

Equipment: Loader 

Bulk Salt: 375 

Hand Labor: 45 

Sidewalk De-Icer: 45 

Salt Type: Rock Salt 

One time sweep: 1500 

Seasonal Minimum: 50,000 

ND, SD, WI: 

Equipment: Loader 

Equipment Price: 400 

Bulk Salt: 425 

Bag De-Ice: 45 

Seasonal Minimum:50,000 

Salt: Rock Salt 

One time Sweep: 1500 

Daniel: 

NM 
Equipment Rate: 300 

Bulk Salt: 325 

Hand Labor: 75 

De-Icer Rate: 75 

Seasonal Minimum: 10,000 

Ruidoso Downs: 25,000 

Per Event Minimum: 2000 

Type of Salt: Rock Salt 

Ruidoso Downs: 1500 

TX:  

Anything over 5 inches 

Equipment: Truck 

Equipment Rate: 225 

Hand Labor: 55 

Sidewalk De-Icer: 55 

Seasonal Minimum: 10,000 

Per Event Minimum: 1500 

Sodium Chloride 

One Time Sweep: 750 

Under 5 in: 
 
Equipment Rate: 300 

Bulk Salt: 425 

Hand Labor: 75 

Sidewalk De-Icer: 75 

Seasonal Minimum: 7500 

Per Event Min: 1500 

Salt: Sodium Chloride 

No Mechanical Sweep 

John Alves: 

Equipment: Loader 

Hourly Rate: 375 

Bulk Salt: 350 

De-Icer: 50 

Seasonal Minimum: 38,500 

Sodium Chloride 

Mechanical Sweep: 1500 

All other States: 

Equpment: Loader 

Equipment Hourly: 350 

Bulk Salt: 375 

Hand Labor: 65 

Sidewalk De-Icer Per Bag: 50 

Seasonal Minimum: 50,000 

Steve Martin: 

NM: 

Match Daniel Rates 

Mechanical Sweep: 500 

CA: 
 
All 0 snowfalls are no bids in CA 
Eureka, Crescent City no snow 

Equipment: Skidsteer 

Equipment Rate: 300 

Bulk Salt: 400 

Hand Labor: 75 

Bag De-Icer: 75 

Seasonal Min:7500 

Per Event: 2000 

Sodium Chloride 

Susanville Sweep: 1500 

Eric Black: 
Seasonal 

Equipment: Loader 

Equipment Price: 325 

Bulk Salt: 350 

Hand labor: 55 

Bag Salt: 50 

Sodium Chloride 

Sweep: 1500 

Per Event: 

Above 10 in 

Equipment Rate: 200 

Bulk Salt: 425 

Hand Labor: 65 

Sidewalk De-Icer: 55 

Seasonal Min: 7500 

Per Event: 1500 

Sodium Chloride 

Mechanical Sweep 1500 

Less than 10 in: 

Equipment Rate: 225 

Bulk Salt: 425 

Hand Labor: 65 

Sidewalk De-Icer: 55 

Seasonal Minimums: 7500 

Per Event Min: 1750 

No Sweep 

Grant Woods: 

Per Event:  

Elko: Skidsteer 

Hourly Rate: 300 

Bulk Salt: 425 

Hand Labor: 65 

Sidewalk De-Icer: 55 

Seasonal Min: 25000 

Per Event: 3750 

Seasonal: 

SD: 

Loader 

Hourly Rate: 425 

Bulk Salt Per Ton: 425 

Hand Labor: 55 

Sidewalk De-Icer: 55 

Seasonal Minimum: 50,000 

Salt: Sodium Chloride 

Sweep:  

ID: 

Equipment: Skidsteer 

Equipment Rate: 325 

Bulk Salt: 400 

Hand Labor: 55 

Salt: Brine 

Mechanical Sweep: 1500 

Seasonal Min: 40,000 

Jammes: 

Not bidding any sites but Elizabeth City 

Equipment: Truck 

Equipment Rate: 250 

Bulk Salt: 350 

Hand Labor: 65 

Sidewalk Deicer: 55 

Sodium Chloride 

No One time sweep 

Steve H.: 

CT,ME,NY- mirror all of Jon Alves pricing 

WV: 

Equipment: Loaders 

Hourly Rate: 375 

Bulk Salt: 350 

Hand Labor: 55 

Sidewalk De-Icer: 55 

Seasonal Min: 45,000 

Sodium Chloride 

Sweep Price: 1500 

Per Event: Skidsteer 

Rate: 275 

Bulk Salt: 350 

Hand Labor: 55 

Sidewalk De-Icer: 45 

Seasonal Minimum: 30,000 

Per event: 1500 

Sodium Chloride 

Sweep: 1500 		 
07-03-2023 General Note     Open Jim: 

Add 10,000 sq ft to total parking lot sqft for garden Center in Erie PA 

Downs add 7,000 

Per Events:  

Equipment: Skidsteer 

DC: 175 

Maryland: 175 

Delaware: 150 

Bulk Salt: anything below 190 make 190 

Maryland, DC, and Delaware up the push ratios to .0028 and sidewalk ratios .02 

Salt Used: Sodium Chloride 

Seasonal Snow:  

Equipment: SKidsteers 

Hourly Rate: 160 

Bulk Salt: Everywhere except NJ/NY: 180 

NJ/NY: 200 

Hand Labor: 50 

Anything at a 0: go to 45 

Salt: Sodium Chloride 

No Lot sweep cost for any of Jim’s territory 		 
06-30-2023 General Note     Open Matt Alley: 
Seasonal:
All Sites: Skidsteer
Equipment Rate: 185
Bulk Salt in VA: 300
West Jefferson: Calcium Chloride
VA: Rock Salt
One Time Lot sweep: 200
Bluefield: 75000
Per Event:
SC, GA, MS, LA, AL
Bulk Salt: all sites 300
Seasonal Minimum: 3500
Seasonal Per Event Minimum: 3* lot per push minimum
Ice: Calcium Chloride
Sweep: 200
Neoga says in MS look at it after
NC,TN,OK,AK
Equipment Rate: 135
Seasonal Min: 3500
NC: 7000
Per Event Min: 4* hourly
Calcium Chloride
Sweep: 200
VA
Equipment Skidsteer
Hourly Rate: 175
Bulk Salt: 300
Seasonal Min: 7000
Per Event Min: 4* hourly rate
Salt: Rock Salt
Sweep: 200
NC and VA under 5 inches: 5000
NC and VA over 5 inches: 7000		  
06-29-2023 General Note     Open Ashley: 
Bidding heavy incase there is snow we are covered because we will have to mobilize units. Going high incase we are given it so we can make sure we are covered.
May have to look at potential setting a service limit for the state, of TX and worst case scenario is to reject if we are given a massive amount of sites

Minimum Push: 3500
De-Ice: 3000
Sidewalk Per Push: 2250
Sidewalk De-Ice: 1500
Per event min: 9000
Seasonal Minimum: 15,000
Sodium Chloride
Sweep Minimum: 0
  
06-29-2023 General Note     Open Andy Krumm:
Equipment for all 3 states: Skidsteer
Sodium Chloride
One time sweep cost: 125 across the board.
MI: 
Bulk Salt: 190
Traverse City, Sault Ste. Marie: Use Flat Ratio 
Will be reviewing with DM and getting back price wise
  
06-29-2023 General Note     Open Steven Fry

Per Event:
Equipment: Skidsteer 
Equipment Rate: 125
Bulk Salt: 180
# of Pushes Levels: 1.5, 2.5, 3.5, 4.5
Seasonal Minimum 20,000 for all sites
Sodium Chloride
Sweep: 0 write it into contract
Seasonal:
Everything above 400,000
Equipment: Loader
Equipment Rate: 180
Bulk Salt: 180
Sodium Chloride
Everything else
Equipment: Skidsteer
Rate: 125
Bulk Salt: 180
Sodium Chloride
Seasonal Minimum: 16500		  
06-28-2023 General Note     Open Troy: 
AZ
Frequencies: 
Hand Labor: 50
Lot Push Min: 150
Sidewalk Per Push Minimum: 75
Seasonal Minimums:
Cottonwood: (Average snowfall 67) 73000
Prescott Valley: (Average snowfall 67) 73000
Show Low: 28000
Taylor: 25000
Per Event Minimum: 1100
Proposed Melt Product: Sodium Chloride
One Time Sweep: 400
Seasonal AZ Sites: 
Equipment: 110
Seasonal Sites in AZ: Flat Ratio
AZ
Low Snow Sites:
Low Snow Number: 
Lot Minimum: 5000
Salt 2500
Sidewalk: 1000
Sidewalk De-Ice: 250
Sodium Chloride
Sweep: 400
Seasonal Min: 100000 
CO/UT:
Seasonal Sites: Flat Ratio
350 one-time sweep
Magnesium Chloride: CO
Sodium Chloride: UT
Outside CO States:
Ration Changes
Almosa: .0032
Carbon City: .0027
Craig: .0036
Delta: .0038
Evergreen: .0032
Fort Morgan: .0028
Firsco: .0036
Glenwood Springs: .0036
Gunnison: .0036
La Junta: .0038
Lamar: .0038
Montrose: .0029
Monumnet: .0032
Pagosa Springs: .0036
Rife: .0029
Salida: .0029
Steamboat Springs: .0038
Trinidad: .004
Woodland Park: .0036
Per Event CO/UT:
Equipment Rate:
Cortez: 125
Hurrican/Pleasant Grove: 130
St. George:110
Washington:125
Bulk Salt: 275
Hand Labor: 65
Using Walmart number on St.George 3220 and Washington 1439
Use Flat Ratio for Seasonal Price
IL: 
Per Event: 
Equipment Rate: 110
Salt 175
Hand Labor 50
Bag 45
Using Walmart Specs for Quincy IL 1454
Sodium Chloride
Mechanical: 375
Flat Ratio for Seasonal Price
IL Seasonal: 
For all non spec’d sites, pull in Walmart Numbers
Average on Sidewalks for non spec’d sites
Canton 1713: Flat Rate
Glen Carbon 256: Flat Rate
Pittsfield 480: Flat Rate
MO:
Per Event: 
Equipment: Skidsteer
Rate: 150
Salt 175
Sodium Chloride
Sweep: 300
Use Flat Ratio
Seasonal: 
Sodium Chloride
Sweep: 300
NV:
Equipment Rate: 135
Slat: 325
Sodium Chloride
Sweep: 500
Change Rate to .003 then use Flat Rate for Seasonal
Low Snow Number: 
Lot Minimum: 5000
Salt 2500
Sidewalk: 1000
Sidewalk De-Ice: 250
Sodium Chloride
Sweep: 500
Seasonal Min: 100000		  
Postmortems
 
Date Modified
Question
Answer
Action to What We Learned
 
No Postmortem records found
Show fields from Show fields from Show fields from a related table
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:
Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.