Project Details
Target Electrical Services & Ext Lighting
RFP
Lessons Learned
Won
11-13-2023
02-26-2024
Project Log Items
 
Date
Type of Note
Type of Service
Due Date
Status
Note
Resolution
 
03-05-2024 General Note     Open Keel came down and let us know we picked up an additional 343 sites as secondary, will send us a site list.  
02-08-2024 General Note     Open Round 3 Bid Notes:
Apprentice rates are going to be going to 50 across the board
Texas everywhere where we were 90 in previous round drop to 75, 110 to 90 and 137 to 110
Fl everywhere but panhandle dropping 15% 
CA dropping Sacramento from 117 to 99.50, southern ca from 120 to 110, the rest of 125 to 106
WA dropping from 130 to 120
PA – we are dropping all locations by 10. 100 to 90, 105s to 95, 115 to 109.50, 
NC going from 100 to 90
GA anywhere where we are 100 go to 90 and where we are 110 go to 100
AZ: anywhere 105 to 95.50 and 115 to 105
TN: anywhere where we are 100 go to 90, any place we are 110 go to 100
VA we are going to keep the same pricing		  
01-30-2024 Pricing Strategy     Open we are going to be offering two bundles to try and entice Target to award more locations. Both bundles are going to be based on sites that we bid on. [JAN-30-24 Torian Pauley] Bundle 1: TX, FL, CA, WA need 125 sites from these 3 states to get 7%, 
Bundle 2: at least 225 sites from OK, PA, NC, GA, AZ, TN, VA, WA for 5%
01-26-2024 General Note     Open Feedback is that we are high across the board
Leaving helper rates the same
All trips are going to be adjusted to $80 for stores and DC
District 110 in Milwaukee we are going to be going from $191 to 150
DC area Distribution Centers we are taking from $156 to $140
Distro centers in Chicago we are going from $156 to $135
Region 296 we are dropping to $120
Indianapolis we are going to drop from $120 to $115
Metro markets in Texas are adjusted to $90, Austin, San Antonio, DFW, Houston
FL stores and DC we are going to drop pricing to $100
NC/SC come down to $100 from $110
Cleveland (170 and 174) going from $115 to $100
Pittsburgh (430 or 415) we will be going from $115 to $105
Philly (421,422,453,462) dropping from $115 to $105
Phoenix (374, 379, 377, 375) dropping from $115 to $105
Atlanta (336,334,335,346) dropping from $110 to $100
Nashville (333, 369) going from $110 to $100		  
11-29-2023 General Note     Open Submitted R1 today, team did not want to do any bundle for Round 1  
11-15-2023 General Note     Open - Currently, not doing great. Margin is only around 20%
- Primary or secondary at probably 120 locations
- Just need hourly rates and trip
- Model is all built out, want to start with a 1.25x the hourly rate for DCs
- count store hierarchy offices as a store, count office warehouse as a DC with pricing		  
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.