Project Details
Walmart Exterior 2023
RFP
Completed
Won
Green
100%
12-07-2022
12-23-2022
Project Log Items
 
Date
Type of Note
Type of Service
Due Date
Status
Note
Resolution
 
03-24-2023 Decision     Open Landscaping pricing has been revised by the field, and it will be used to resubmit to Walmart. Major spec and frequency Changes  
03-24-2023 Decision     Open Per Request of Bryan Baldini reduce all cost per sweep for Travis Hardeman area by $2  
03-24-2023 Decision     Open per request of Bryan Baldini reducing cost in Steve Martins area by 2% to the Customer  
03-24-2023 Decision     Open Pricing reduction received from field Member Samantha Geary for MO Pricing reduction on cost per sweep anywhere from $2-$5 dollars  
03-24-2023 Decision     Open Cost per sweep reduced $2 for all stores under Steven Fry's region  
03-23-2023 Decision     Open Updates for FL locations:
-    We will go to $30 for Lawrence Roscini
-    Go to $35 for Michael Behler, Nadia Benraiss, and Keith Merrell.
-    Adjust to $33 for Austin Ureste and Paul Breedlove
-    And everything under Michael Jammes will be $47.50 (including the one that seems to show Jason Fontana)
  
03-23-2023 Decision     Open Matt Alley approved to go to $37.50 as a labor rate in VA and NC.  
Jim Rubino (formerly John G) approved $50 as a labor rate in MA and RI.
Don Proud approved to go to $30 in Orlando, $35 in South FL, and $33 for all other sites.
John G has approved:
-    $47.50 in CT
-    $55 in PA
-    $65 in GA
-    $50 in ME
-    $55 in NC
-    $50 in NH
-    $57.50 in TN
-    $52.50 in VA
-    $55 in VT
-    $47.50 in FL
-    NY – I adjusted on the sheet already as I was working with John to understand the numbers.  We went from $75 to 70 and $65 to $55 in his area.
  
12-23-2022 Meeting       Strategy meeting- 4

Discounts 
2%- 500 sites
3%- 750 sites
5%- 1000 sites 		 
12-23-2022 Meeting       Strategy Meeting- 3

LAND

Reactive services- updated- nothing below 50 or above 150
Tree removals reduced to 600
Tree down reduced to 375
Shrub pruning- kyle flat rated his sites- $50
- $25 below 14'
- Above 14' flat rate- kyle $75- rest of team aligned
Shrub removal
- $30 flat rate
Margin alignment- 30% margin across the board

High tree trimming over 14'
- ASSUMPTION- will not use for GOLD- if they do, just to create camera visibility or code requirements
- west/ central locations- $200
- East/ kyle $100

- west- margin direction- ACTION

Pressure wash- updated
caps for mulch- updated

LOT SWEEP
- 1 and 2 times per month pricing
- Neighborhood 300 1x 500 2x- Same for tier 1 stores
- Supercenters 400 1x 600 2x
- D sites 50% above base price- will cost a premium to get someone to complete the job- torian Add margin points
- WI 150 for lot sweep to the provider
- DCs 600 minimum 

Mulch- Add 10% to gold to distinguish between gold and silver scope pricing- DECISION		  
12-22-2022 Meeting       Strategy Meeting- 2

Sweeping costs- DCs
- Range $500 per million sq ft- $1200- Kyle
- 750-1250
- lower end down south, higher up north- DECISION
- SWEEPS PER MONTH
ACTION: NAT team to go through Michael Jammes area and adjust costing- kyle going adjust numbers

West and Central Locations- LAND
ACTION: List of changes to be made per A, B, C, D's- need margins 
A's 22 B 26, C 30, D 34- Kyle's Margins- across the board on all scopes
ACTION: Tim and Bryan will have margins over to Torian tonight

Power Washing
Pricing all over the board 
2500 ceiling on sidewalks- Eric and team 
Risk: What if they don't give us both services?
Neighborhood market rate: 1750
Supercenter rate: 2500
ACTION: Walmart team to make geographic adjustments
CALLOUT: Spec process needs to be changed and updated to reflect more precise specs
CALLOUT: Northwest OH and PA- Amish country- horse manure removal will raise pricing 

All formulas are written on bid sheet and ready to be uploaded once pricing is finalized
  
12-22-2022 Meeting       Strategy Meeting- 1

LANDSCAPING

High tree trimming over 14'
- Ryan- standard number to apply across the board/ account for a lift/ Increase percentage from silver to gold
- Add 10% to get to the GOLD pricing and keep tree trimming out of it
- 40 trimming under 14' capped unless it is already below for $40
- over 14' raise base to $150
ACTION- Torian send out revised document on this

Pruning Frequencies
- Kyle changed his frequencies in his area
- 6 in extreme south- complete some pruning each visit to make it look like they are keeping up with the property
- general south- 4
- 2 prunings in north
ACTION- walmart team sending out prune frequencies per state in chat or email

Mulch
- some areas seemed low- FL and AL
- Kyle bumped up rates around $70 in FL
- Concerns in some locations- mainly panhandle for pine straw- over $100 to provider
- Each location should not be lower than $60 to the customer

Tree Removal/ Tree Down
- 150- 4000 range from RMs
- Avg tree down in AZ around $550
- Kyle- down tree 350, tree removal 500

Pressure Washing
- FL pricing for docks and truck wells 2X a year- 2000 per service is high
ACTION- eric, chris, and team- analysis on geographical range for pricing
Graffiti, Animal droppings, compactor
- standardize pricing to square foot- walmart team to review- ACTION

Lot Sweep
- Kyle- not in agreeance with formulas- typically goes store by store and makes manual adjustments- no big outliers
- not including any porter time with this
- slightly increased price per sweep
- Lot conditions very important to INSOURCE
-ACTION Need direction on sweeps for DCs/ provider DC rate

Brush Hog
- 40- 175 hourly rate- re group at 3PM		  
12-21-2022 Meeting       Eric Black
6500 tree trimming above 14'
pressure washing- JOHN G- thinks it should be priced per square foot
  
12-21-2022 Risk       Tree removal all inclusive- establish caveats around size.  
12-21-2022 Risk       Remediation on sites. How are we going to negotiate?  
12-21-2022 Risk       Gold scope- tree trimming over 14'
  
12-21-2022 Risk       Irrigation start up and shut downs on DC properties  
12-21-2022 Risk       Native mowing on sites out west- Steve martin location in NM
  
12-20-2022 Meeting       Jim Rubino
start up 250 (retail stores)
shut down 350
monitoring 70
DC- 2000 start up 4000 shut down, monitoring 500
  
12-20-2022 Meeting       Michael Jammes
no start up or shut down in panhandle of FL- normally only shut down if a cold weather system comes through
150 a palm tree- remediation cost?- Ryan site by site reviewed based on site conditions
Panama city beach, FL will be an at Risk site
Risk- Tree Removal- 4000, tree down- 2800- 100 per shrub
Georgia
Risk- some of these locations in the middle of nowhere- will drive price up
no start up or shut down
tree trimming above 14' 170 per tree- same in NC
1100 organic bin- CALLOUT		  
12-19-2022 Meeting       Ashley T.
- No monitoring or irrigation
- no spring and fall clean up 
CALLOUT- 9000 to provider a month UPS DC location- LAND

SWEEPING
- minimums for supercenters and normal stores 90
- DC- 500 minimum cost per sweep 		 
12-19-2022 Meeting       Bruce
-4 ferts in AL
- irrigation, start-up, monitoring, shut down- prices confirmed
- trimming above 14' $1000
Bruce getting ADHOC stuff back to Torian- ACTION
  
12-19-2022 Meeting       Matt Alley
monitoring- 75 across the board
start- up- 175, 225 shut down
Turf ferts- 3
tree trimming about 14' for gold scope- need lift- $1000 Gold Tier 
Grovetown, GA- missing specs- Walmart neighborhood market- ACTION		  
12-19-2022 Meeting       Dan Shafer
SWEEP
- 50 per sweep- 85-90 minimum for both		  
12-19-2022 Meeting       Don Proud
- Concern is LJ who is on vacation
- Palm rate - $45
- minimums gold scope
- Kyle going to dive into sheet in FL and reach out to Don
- pruning number does not include palms in FL
LOT SWEEPS
- Has a sweeper charging walmart directly 65-100 per sweep
- dont go over 1 portering hour when combined with sweep- will outprice yourself- Kyle- CALLOUT
PRESSURE WASH
garden center- 1200-2000
loading docks- 500-1000
compactor- 200-250?
Exterior Windows- Kyle Reaching out to Ryan Curtis- Have we done this exercise? CALLOUT
- working copy take off hourly rate- per unit price for shrub
- SEND DON REACTIVE OOS ITEMS TO PRICE SEPERATELEY - ACTION 
- Kyle getting additional pricing for sweep porter- ACTION

  
12-14-2022 Meeting       KICK OFF CALL
    - How to tackle DC's?
        ? Site recon bid not back until 12/21- 25 locations?
        ? Spec a handful and get an average?
            § Will be able to walk the site post award
                ? Final price able to be negotiated
    - ACTION: Torian sending out working copy by 12/13- live link for field include inputs- include RM's as well
    - Stores are not dictated by gold, silver, or bronze on bid sheet
    - Could walmart drop from Gold to silver or bronze?
        ? Could be a possibility 
        ? How will this affect payments? Currently structured at 12 monthly payments.
        ? Question from Jason- post to coupa along with other questions
        ? RISK: check in with store for each service event- nearly impossible
    - Specs (DC's)
        ? Less remote sites get specs first
        ? Can site recon send over 10 at a time
        ? RFP team complete priority sites to send to site recon
            § ACTION: Clint getting with site recon for specs 
            § ACTION: create priority DC list to send to site recon
    - Field team sending over list of questions
ACTION: RFP Team to submit questions on coupa		  
12-12-2022 SOW Pressure Washing     Power Washing Services
- Store customer entrances
- store sidewalks (2x's annually) front, side perimeter
- Garden center (2x annually)
- ACC front access area (2x annually)
- Compactor/ Organic Bin areas (2x's annually)
- Loading docks/ truck wells (2x's annually)
- exterior windows (select- approved stores only) HOW DO WE KNOW WHAT STORES TO BID?
- parking garage- (select- approved stores only) HOW DO WE KNOW WHAT STORES TO BID?

OUT OF SCOPE (All reactive requests- per square foot pricing only)
- Graffiti
- Animal Droppings
- compactor leak or post repair pad wash
- Awnings/ canopy
- Exterior windows on second level
- pharmacy drive-thru
- OGP- on-line grocery pick-up
- Cart storage- inside vestibule enclosure
  
12-09-2022 SOW Land     Landscaping Standard SOW- Stores 
- Turf- mow, edge, trim
- Native- 3 times a year to height no less than 4"
- Weeds- addressed weekly-landscape, islands, planters, parking lot, gutters?, sidewalks
- trash removal
- straightening adjustment of plants/ trees that lean or sag- pruning
- pest control- inspect plant material- spray once identified

OUT OF SCOPE Service Expectations
- Mulch, Rock Install
- Shrub pruning (above below 14')- prune annually by auto generated work order
- Tree pruning- same as shrubs
- Sod replacement
- Tree removal
- Tree down- (inclusive of stump removal, labor, materials, equipment, disposal fees)
- Tree replacement-  like for like
- shrub removal
- shrub replacement- like for like
- Brush Hog- large lot acreage		  
12-09-2022 SOW Lot     Lot and Portering SOW
- lot sweep/ handpick trash/ rubbish
- parking lots
- sidewalks/walkways
- truck wells
- landscape areas, turf, native beds, mulch beds, planting beds

 Mechanical and or Vacuum and or Regenerative Air
Sweeping / Portering (Hand Pick of Trash / Rubbish)
- performed between 11PM and 6AM

PRICNG STRUCTURES FOR LOT SWEEP
1-7 per week
1-2 sweeps per month
Upon request		  
12-08-2022 SOW Land     Landscape SOW (TIERED)
- Turf/ Grass- maintain 2-4 inches for 365 days per year. Includes Native (weed free?)
- Weeds- weed free for 365 days- zero tolerance based on tier level
- Mulch/ Rock- replenish as needed/ refreshed at minimum once per year between march and May. 
Gold and silver tiers replenish as needed throughout the year. 
Bronze requires reactive WO and approved proposal
- Tree/ Shrub Trimming
maintain 365 days per year. 
Gold tier- to be trimmed as needed regardless of height.
Silver- requires reactive and approved proposal for anything 14 feet and above. Anything below 14 feet is trimmed as needed.
Bronze- reactive WO and approved proposal
- Tree/ Shrub replacement
- Irrigation
Test irrigation monthly by cycling and inspecting each zone for proper settings
Gold tier: make all repairs necessary to ensure proper functionality
Silver/ Bronze: ensure water leaks are isolated and report and repairs needed
- Offseason Service
maintain clean landscaping while in the offseason- cut grass as needed. Keep free of trash, leaves, branches and weeds
RETENTION PONDS, OPEN WATER BASINS, WETLAND AREAS OUT OF SCOPE
*WARRANTY- One year warranty on all new plants from date of planting
*Expectations to check in with store with each service event		  
11-09-2022 Meeting      
Customer asked us to bid the sow with the assumption that remediation is not needed
We bid Sam’s with too many scope assumptions included
Sams most likely reverted to the old SoW instead of TCO
Sams said KBS was terminated from exterior trades in CA and UT – Dan hasn’t heard of the provider.
Sams haven’t said much about Alf		  
11-09-2022 Pricing Strategy       Be more aggressive on store remodel sites because additional revenue on interior  
Postmortems
 
Date Modified
Question
Answer
Action to What We Learned
 
05-05-2023 11:55 AM   The value of the relationship with the procurement director was critical in getting this award. We would not have gotten the award without Ross giving us some leeway. We need to make sure we are having no less than quarterly meetings with Ross and his team to maintain that relationship. Owned by Tim and SE. 

  
05-05-2023 11:55 AM  
Walmart prioritizes self-performers and we need to have a plan to overcome those preferences. 		 
05-05-2023 11:55 AM   The volume of trades that they awarded correlated directly with the volume-based discount that we offered. An award of 1,000 trades, we would give 5% and they gave slightly over that number. Next time let's be more aggressive on the ask.   
05-05-2023 11:55 AM   Walmart is giving a lot of feedback on weed control which was not included in the SoW. We need to include it in pricing because they are still expecting weed control. In general SoW was written vaguely so be careful on those traps.   
05-05-2023 11:55 AM   Relative to land, the more limited SoW we can sign, the more beneficial to DMG, due to the door being opened to ad hoc business. Mow/Blow/and Go is preferred for DMG then up selling non-routine work.   
05-05-2023 11:55 AM   Pressure washing – try to nail down what is spec’d/costed from field. Prioritize more next time because it bit us this time. INCLUDE MINIMUMS.   
05-05-2023 11:55 AM   Walmart's field team has a vote on this. Important for Team Leads and AMs to maintain these relationships as it will help us be awarded more business in the future.   
05-05-2023 11:55 AM   Alf and Mercer had the largest awards for land. DMG was the biggest winner for lot and pressure washing. They are self-performers. Alf doesn’t self-perform in half of their markets but they have Walmart convinced that they do.   
05-05-2023 11:55 AM   It was obvious that our specs were wrong, which resulted in pricing being out of line. Next steps are to use the new tool to verify all Walmart specs before the release of future RFPs. Also collaborating to create baseline pricing for all trades in advance of RFP releasing. 
  
05-05-2023 11:55 AM   Clear ownership of action items with clear deadlines needed on future RFPs  
05-09-2023 10:10 AM   win reasons: 
Relationships with the Director of Procurement that gave us additional opportunities to improve our pricing
Relationships with the trade team who helped to influence the decision
Strong relationships with the field team who insisted on have DMG within their territory
  
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.