Project Details
Target Plumbing RFP
RFP
Completed
Won
Green
100%
04-18-2023
05-31-2024
Target has given us the opportunity to bid on plumbing for 1900 stores and DCs across the country. Opportunity has a request for regular hourly rates, emergency rates, and trip charges.
Project Log Items
 
Date
Type of Note
Type of Service
Due Date
Status
Note
Resolution
 
05-15-2023 General Note     Open Final Adjustments:
-confirmed drop in CA Trip even if COMP (unified drop for whole state)
-reduce pa trip $10
-reduce ga, md, tn trips $5
Eureka CA double everything just like round one ($80, $210, $140)		  
05-15-2023 General Note     Open Round two notes:
- drop trip $5 for both DC and Stores 
CA stores coming down $10 on trip & down $5 regular hour rate
OH Stores coming down $10 on trip - hourly staying same

all other rates will stay the same 
  
05-12-2023 General Note     Open R1 results came in, R2 is due Monday.

Talked to Dalton and Max, they are likely going to stay put on everything since we've been awarded about 240 sites and the cap is 300. Only really going to focus on OH and CA. Want to meet monday at 9.		  
04-21-2023 General Note     Open -Dc Rates 1.25X's state rates from stores Bid 
-DC window for work 2am - 6 am - will submit OT rates for any work performed
-Reviewed with team and based off Nat averages, comps, & referenced active walmart plumbing to compare rates
-Used previous award hourly rates for any stores we were listed as Primary or Back-up
-charged much higher for 3 areas - IA, CO, & Eureka CA due to extreme difficulties in locating providers 
-Submitted 04/21/2023 a week early for coaching 
-trip charge $70 for stores / $75 for Dc's 		 
04-20-2023 General Note     Open DC's- $75 across the board on trip charge
Leave DC pricing a little higher than stores
Eureka, CA- don't bid on this site- DECISION		  
04-20-2023 Meeting     Open     - Due Date: 4/28
    - Submit first round by the EOW
    - 3 year contract
    - Have already awarded 47 sites from the RFP
    - Capped at 300 sites
    - Retain sites we already have
        ? Have 222 sites currently plus the 47 we have already been awarded
        ? Dalton sending over incumbent sites and pre RFP sites we have been awarded
    - Do DC's count towards the cap? QUESTION (56 DC locations)
    - Do not want to win IOWA- Bid high
    - RISK: maintenance window 2-6AM will fall in overtime rates Wed/Sat- DCs
        ? Will majority of work occur during these hours? QUESTION
    - Trip charge: $55-70
    - Can bill on multiple trips- one trip charge per WO, can explain an additional trip
    - 15% on material and equipment
    - RFP Team ACTION ITEMS
        ? Pull comparable with current target rate sheets
            § Kohls, Walgreens
        ? Pull in national average
        ? Target wo's
Set meeting for Thursday 4/20		  
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.