Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updated WOS definitions

...

Recommended Order - The computer generated integer units recommended. This value is exact, not rounded by minimum order quantity multiple.

Blended WOS - Store / Market blended weeks of supply - (Store WOS + Market WOS) / 2; can be helpful when evaluating slow/fast stores vs cohorts.

...

Sales History? - Whether or not sales history exists for this store/item. Useful when determing determining rate of sale from prior year data.

...

Store WOS - Calculated weeks of supply at this store based on sales weights chosen. (User-selected weekly sales rate X WOS target in order template.)

Deviation Safe WOS - Calculated weeks of supply at this store including potential for unit sales variances (helpful for volatile/non-steady selling items).

Market WOS - Market/Patch Weeks of Supply for this item.Total store inventory / Market POS Avg over X weeks (Need to define X weeks)

Store Attributes - Placeholder to display any user custom store attributes. Store attributes set in User Ordering Preferences.

...

Effective Inventory - Calculated inventory including on hand, on order, and suggested units. Changes as order quantities are changed.

Effective WOS - Calculated Week of Supply including on hand, on order, and suggested unitsUser Preferences Effective Inventory parameter / calculated one-week sales rate. Changes as order quantities are changed.

...

Net Rain Days - Number of forecasted rainy days over/under the number of days in the next 7 days last year.

Lowes WOS - Shows the Lowe's WOS calculation based on last week's sales.Current unit inventory / Last week's unit sales. This is at whatever level the report is built (store, market, category, region, etc).


Detailed Description of WOS Calculations

Lowe’s WOS - Current unit inventory / Last week’s unit sales (This is at whatever level the report is built - store, market, category, etc. Note this is also a very volatile metric, and is often misleading during the beginning and ending of each season as sales change.)

Store WOS is calculated using 2 factors:

  • The weekly sales rate you set in your User Preferences

  • The WOS target you set in each order template.


User Preference Weekly Sales Rate in units is the combination of these 2 parameters:

Image Added

This creates a weekly sales rate for a single week (per store/item). This is then multiplied by the WOS setting you choose in your order template.

Image Added

Market WOS is the value of the store inventory in units for all the stores in a market divided by the average POS for the market over X weeks (Ross getting X; need to know if this is adjustable or fixed.)

Blended WOS is the value of Store WOS + Market WOS / 2; (Rarely used except in special situations, which we should specify. Also, is the Store WOS the value of the inventory of all the stores in the market / the inventory of all these same stores?)

Effective WOS is the value of  your User Preferences Effective Inventory setting / the calculated one weekly sales rate (see first box above).

Image Added

In using the WOS metrics we recommend the following order of importance in evaluating your inventory:

  • Effective WOS

  • Market WOS

  • Store WOS

  • Blended WOS

...