PSCS Leadership
VP, Pricing and Supply Chain Strategy
Who is David Smith?
Source of truth for offsite_id
What is offsite_ids_master?
KR#1 has us focused on optimizing our buys from this rental car company
What is Hertz?
CPS Offsite
Who is Beth Cranston?
Of all offsite buys (B&M + online auctions + direct) in 2022 so far, what percent are B&M, rounded to the nearest 10%?
What is 90%? (92k / 105k = 87%)
AVP, CPS Buying
Who is John Arseneau?
Daily view of a car's journey
vehicle_history_tbl
KR#4 is primarily tasks Andrew with creating this numeric version of the CMB data pipeline
What is v3.0?
CPS Front Lot
Who is Jim Page?
The number of online auctions CarMax purchased cars from last month.
What is five? (Smart, Openlane, OVE, BMW Direct Nissan RPM)
Director, Ops Strategy & Production Planning
Who is Darrell Patton?
Data mart table containing vehicle info like make_code, model_code, and mileage
What is dm_nemesis.offsite_prepreview_cars?
Objective #3 says we will "Make Models More" this
What is maintainable?
Production Planning
Who is Eric Costello?
The last month we exceeded 10k offsite* buys,
(*B&M, online, and direct)
November, 2022
Director, Supply Chain Strategy (Merch & Logistics)
Who is Michael Isani?
Dispatch Report table containing stock_num level transfer assignments
What is xfer_dr_plan?
We currently have this many KRs colored green
What is 6?
Merch Strat
Who is Sheri Evarts?
The state we bought the most cars in at B&M auctions last month
What is Texas? (1836, next closest is CA with 936)
Senior Manager, Merch Strat
Who is Ian Mills?
Table apparently giving the rollout date for CMB going live in the OBW, with phase3_rollout ranging from 2012 to 2019.
What is obw_cmb_rollout?
Success on KR#6 will require adding this column to multiple tables.
What is fuel_type?
Operations Strategy
Who is Aaron Persily?
One of the top three B&M auctions in terms of last month's buys
What is Manheim Nashville, Manheim Dallas, or Manheim Texas Hobby?