Project Details
TransformCo Land RFP 2024
RFP
Lessons Learned
Won
10-26-2023
11-30-2023
Project Log Items
 
Date
Type of Note
Type of Service
Due Date
Status
Note
Resolution
 
11-09-2023 General Note     Open Final Review:
- good with the pricing as long as RMs are comfortable with following the scope
- going in at 25% margin for all non-incumbent sites
- anything under 20% margin, bump up to 25% with the non-incumbents
- no discounts or bulk packages will be offered for these sites		  
11-09-2023 General Note     Open Risks with this RFP

- since it was a 1.5 week turnaround, not much time to verify specs or pricing
- only about 1/3 of sites were verified by the field. On our VP call on 10/30, the field thought they should spec the sites and not pay for specs since it was only 2-4 per DM.
- with the field being in office this week, it made it difficult to verify pricing with each RM.
- had to make assumptions on when to stick with incumbent pricing and match fields rates/frequencies for RMs that we were not able to review sites and rates with		  
11-08-2023 General Note     Open Steve F:
- Steve was good with matching rates and frequencies from the Kohls Land bid. Said we wanted a flat 3% increase to all incumbent locations.

Dan S:
- kept incumbents all the same with the exception of Freedom, CA since it was 8% margin. Added 15% of the cost for that location
- CA $40 hourly, $70 mulch, 3 native, 3 pond, 0 turf ferts, $75 min
- $120 per service for Hemet, CA
- WA 32 mows, 75% for weed control, $75min 

Troy D:
- keep incumbents the same
- MO $45 hourly, $68 mulch, 75% weed control, $85 min
- KS $48 hourly, $68 mulch, 75% weed control, $95min		  
11-08-2023 General Note     Open Robert Y:
sent rates and frequencies from Kohls Land bid to him over teams, said he was good with them due to being in RM meetings in office today


Josh H:
sent rates and frequencies from Kohls Land bid over to him and Mitch on teams, Mitch said he was good with the rates. Mitch also wanted us to match pricing on the two incumbent sites since we had good margins.		  
11-08-2023 General Note     Open Per Alec, tax does need to be included in prce.  
11-07-2023 General Note     Open Andy entered his own provider pricing into the model.  
11-06-2023 General Note     Open Matt Alley -
Incumbent:
-    Match incumbent sites except for Asheville 4112 go up 9%
-      Add 12% to last years incumbent provider rate for Brunswick, GA

Non-Incumbent:
-    $500 a month on the Hamilton MT location
-    Minimum for the rest of the stores set at the average of all RAM sites
-      Average is about $420 a month
-      Adding $30 a month to Laredo TX site to cover 

  
11-06-2023 General Note     Open Ashley T –
-    Incumbent
o    Match current pricing that we have for the one incumbent
-    Non-Incumbent
o    No spring or fall cleanup pricing to be included
o    Hourly rates are good
o    Frequencies are good 
o    Drop turf ferts to 3
o    1 to 1 for weed control for all pricing
o    $125 for per visit minimum
  
11-06-2023 General Note     Open Ellis E.
Incumbents:
-    Incumbents we are going to match what we currently do for the customer
Non-Incumbent
-    Remove the native mow for 1155 
-    1 hour mow minimum for the sites
-    Patrick and Tate are going to verify the locations for the bales of Pine
-    Going for 37.50 to 42 for provider hourly rate
-    Mowing is going to be 1 to 1 
-    Minimum going from 75 to 100		  
11-06-2023 General Note     Open Jim R:
Incumbents
-    Incumbent sites match what we are currently doing on the provider side
Non – Incumbent
-    1 hour minimum for sites that have no mow hours
-    Hour rates are good
-    Turf ferts dropping down from 4 to 3 
-    Weed control 75% of mows
-    Per visit min is good at $75		  
11-06-2023 General Note     Open Don P
Mow Hour Adjustments
-    Minimum for landscaping is $100
-    We were incumbent on Merritt Island at one point
-    Adjusting location 1285 mow hours from 10 to 5 
-    Adjusting 1175 mow hours from 8 hours to 3.5 hours
-    1485 mow hours from 7 to 6
-    No spring or fall clean up for FL
Pruning:
-    1175 we are adjusting pruning from 40 to 20 hours 
General Notes:
-    Hourly rate set to $45
-    Mulch install for Orange Park change from 85 to 55
-    All natives to 12
-    Pond frequency for 24
-    Turf fertilizations going from 4 to 3
-    Palm pruning is out of scope 
-    Irrigation is out of scope
-    Weed control to 1 to 1 with mowing
-    Adjusting Merritt Island (location 1175) to $1300 a month to cover the same cost as last time we owned it		  
11-02-2023 General Note     Open Kickoff Call Call-Outs:

- most of these stores are closed
- Bruce wishes we would have gotten more time, going to try and get an extension to 11/10
- whether it is open or closed is based on site maps
- field will need to have sites verified by 11/3 since it is only 2-3 by DM
- field team reviews on 11/6 and 11/8
- mulch is not included in price and will be a separate WO, but we still want to get specs		  
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.