An Introduction to Web Based Ordering & SOS (Store Order - - PowerPoint PPT Presentation

an introduction to web based ordering sos store order
SMART_READER_LITE
LIVE PREVIEW

An Introduction to Web Based Ordering & SOS (Store Order - - PowerPoint PPT Presentation

An Introduction to Web Based Ordering & SOS (Store Order Services) LCBO PSM Trade Symposium 2016 May 27, 2016 Chris Elliott Acting Director Retail Systems and Wholesale Agenda SOS & SOQs front & back Store Order SOQ Accuracy


slide-1
SLIDE 1

LCBO PSM Trade Symposium 2016

May 27, 2016 Chris Elliott

Acting Director Retail Systems and Wholesale

An Introduction to Web Based Ordering & SOS (Store Order Services)

slide-2
SLIDE 2

Agenda

SOS & SOQs – front & back SOQ Accuracy Promotions & Promo Separation MINs

Store Order Services

slide-3
SLIDE 3
  • Sets Replenishment

Policies (business rules) for all LCBO Retail stores

  • Creates a new SOQ

(Suggested Order Quantity) every day, for every store

  • Makes the SOQ’s available
  • ver the Intranet

Store Order Services

What SOS Does

slide-4
SLIDE 4
  • Forecast the replenishment of

the LCBO warehouses

  • Determine store transmission /

delivery schedules, or frequency of delivery

  • Tell stores what brands to list

(or delist)

  • Tell stores where to shelve

products

Store Order Services

What SOS Does NOT Do

slide-5
SLIDE 5
  • Frequency of delivery
  • Transmission lead time
  • Store holding capacity

(when necessary)

  • Whether a store is

building inventory; for long weekends or Christmas

SOQs – The Front End

What Store SOQs are Primarily Based On

slide-6
SLIDE 6

Each brand’s

  • Seasonality. This

is defined as weekly weighting. SOQs – The Front End

Store SOQs are also based on:

slide-7
SLIDE 7

Seasonality

slide-8
SLIDE 8

Seasonality

slide-9
SLIDE 9
  • A brand’s Weekly

Average Rate of Sale (ARS)

  • Weekly brand

performance update

  • Each brand’s

Contribution Code (CC) that range from A thru E

SOQs – The Back End

Store SOQs are Also Based On

slide-10
SLIDE 10
  • Store Specific
  • A ranking of products

within each Set

  • Based on 3 factors

SOQs – The Back End

CC Rankings A = 60% B = 20% C = 15% D = 4% E = 1% Contribution Codes are:

slide-11
SLIDE 11
  • Compares LW Sales vs

Forecast of 5 possibilities (3, 6, 12, 26, 52 weeks) – “Best Method” (closest match) is then utilized

SOQs – The Back End

  • Assigned as a result of

sales exceeding or falling short of previous week’s forecast

  • Flags cause the Safety

Stock to adjust ARS (Average Rate of Sale) is Blended: Brand Flags (Strong or Dying)

slide-12
SLIDE 12

SOQ Accuracy

slide-13
SLIDE 13
  • Store inventory must

always be managed

  • Inventory adjustments

completed as required

  • On Hand and On

Order quantities are captured nightly at store closing

SOQ Accuracy

In order to ensure SOQ Accuracy

slide-14
SLIDE 14

PROMOTIONS & PROMO SEPARATION

slide-15
SLIDE 15
  • SOS applies no uplift in

forecasting to Promo brands

  • Store Managers

continue to be responsible for ordering all of their store’s promotional needs

Promotions

slide-16
SLIDE 16
  • Store specific “Location

Maps” are populated for each promo period – for review & adjustment by store

  • Flags are used on

brands to separate the promotional uplift in sales

Promotions

To Identify Promo Brands

slide-17
SLIDE 17

MINs

slide-18
SLIDE 18
  • SKU MINs are used to

support a “Ready for Business” look

  • All MINs are initially set

to 4

  • MINs can be reduced

below 4

  • This will slow the rate of

replenishment (X.O. Cognacs, Texas Mickeys, etc.)

MINs

slide-19
SLIDE 19
  • Location MINs are used for
  • Multi-location brands such as:
  • Discretionary displays
  • Beer/cooler plinths
  • Refrigerated brands
  • Promo brands

Location MINs

slide-20
SLIDE 20

SUMMER TOP 200

slide-21
SLIDE 21

Summer Top 200

slide-22
SLIDE 22

Summer Top 200

slide-23
SLIDE 23

HOLIDAY TOP 200

slide-24
SLIDE 24
slide-25
SLIDE 25
slide-26
SLIDE 26
slide-27
SLIDE 27

Top Sparkling Wines

slide-28
SLIDE 28

Top VINTAGES Essentials

slide-29
SLIDE 29

Top TBS & Direct Beer

slide-30
SLIDE 30

Questions?

slide-31
SLIDE 31