Due to the many potential metrics an order-writer may utilize when customizing orders, the options can seem a bit overwhelming. Below is a sample order output and the columns returned can be described by the glossary listing below. Any of these columns can be hidden or ordered by utilizing the preferences options - to read more click User Ordering Preferences.
For customers who order for Lowe's, we have recently added a Lowe's WOS metric that you can use to manage your inventory levels when Lowe's gives specific directions for maintaining WOS levels. (Purple-highlighted column.)
Store# - The store number.
Market - The market/patch of the store.
SKU/Item - The item.
Description - The item description.
Category - The item category.
On Hand - Remaining units on hand for the item/store.
On Order - Shipment data based units on order.
EDI On Order - Lowe's EDI on order value from daily 852.
Order Units - Computer suggested order based on minimum order multiple.
Cost Total - Total cost dollars ordered for this item at this store.
Retail Total - Total retail dollars ordered for this item at this store.
Min. Order Qty. - Minimum order quantity multiple.
Max. Order Qty. - Optional. If set, no order can contain more than this many units (subject to optional category superpack rounding rules)
Max Packtype Order Qty. - Optional, if set in the packtype - no order can contain more than this many units, (subject to optional category superpack rounding rules)
Packs in Container - Number of minimum order multiples in a super pack (rack) for this pack type.
Cost - Current program item cost.
Status - Indicates whether item is primary or secondary in market.
Retail - Program regular retail price.
Mkt. Avg. This Yr. - Avg. number of units sold in current year across the market.
Mkt Avg. Last Yr. - Avg. number of units sold in prior year across the market.
8wk Avg. - Avg. number of units sold in preceding weeks.
4wk Avg. - Avg. number of units sold in preceding weeks.
2wk Avg. - Avg. number of units sold in preceding weeks.
Sold Last Week - Number of unis sold in the preceding full fiscal week.
Next 2wk. Avg. LY - Avg rate of sale in coming weeks based on prior year history.
Max. Wk. Sold - Highest number of units sold during the preceding 8 week period. Indicator of max potential.
Min. Wk. Sold - Lowest number of units sold during the preceding 8 week period.
Mkt. Volatility Units - How many units the store sales rate differs across all stores in the market/patch over the past 4 weeks. Good indicator of lumpy sales item.
Str. Volatility Units - How many units the sales rate differs at this store over the past 4 weeks.
Inv. Shortage - Indicates whether the computer encountered an availability shortage at the warehouse when ordering and may have reduced ordered amount as a result.
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 - can be helpful when evaluating slow/fast stores vs cohorts.
Store Rank - Store sales volume based rank across all stores in the template, based on all items being ordered in the template.
WTD Sold - Number of units sold since the beginning of retailer fiscal week.
Units Sold Next 4 Wks. - Store specific total units sold next X weeks based on prior year history, if available.
Mkt. Avg. Store Sold Next 4 Weeks - Market/Patch store average units sold next X weeks based on prior year history.
Min. Up Inventory -
Blanket Qty -
Net Hardiness Str vs. Item - Difference between the item USDA hardiness value and the store's value - indicates potential for frost driven loss if store is higher than item.
Ad Event? - Number of days (up to 35) until promotion begins. If number is negative, promotion is active, values is number of days left until promotion ends.
Margin Erosion? - Indicates the amount of short term margin erosion vs the regular MC% in the past week.
Regular MC% - Regular margin contribution % of the item. Indicated desired margin at program inception.
Item Rank - The rank of this item at this store compared to all other stores evaluated in the template.
Sales Trend Slope - Slope of sales, positive indicates increasing sales, negative indicates slowing.
Regression Est. - Polynomial regression estimate of sales based on actual weekly sales units.
Sales History? - Whether or not sales history exists for this store/item. Useful when determing rate of sale from prior year data.
Weighted Avg. Sold - Calculated Avg. units sold based on weights chosen.
Store WOS - Calculated weeks of supply at this store based on sales weights chosen.
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.
Store Attributes - Placeholder to display any user custom store attributes. Store attributes set in User Ordering Preferences.
Fiscal LY Unit Total - Units sold at the store during the entire previous fiscal year.
FYTD Units - Units sold at the store during the current fiscal year to date.
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 units. Changes as order quantities are changed.
Presence Qty - Presence/Presentation quantity set by user, if not zero. Used for ordering to non-zero minimum regardless of demand profile. Use for shelf space filling.
Prior Units - optionally populate this column with a prior batch order units of the chosen template.
WTD MC% - Avg. Week-to-date margin%. Compare to Regular MC% for promo margin erosion.
FYTD MC% - Avg. Fiscal Year-to-date margin%.
FLY MC% - Fiscal last year margin%.
FLY Unit Sell% - Fiscal last year unit sell thru %.
FLY Cost Sell% - Fiscal last year cost sell thru %.
FYTD Unit Sell% - Fiscal year-to-date unit sell thru %.
FYTD Cost Sell% - Fiscal year-to-date cost sell thru %.
Pending Un-Extracted Orders - Order units on finalized batches which haven't been extracted yet.
Rain Days CY - Number of forecasted rainy days next 7 days current year
Rain Days PY - Number of forecasted rainy days next 7 days last year.
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.