Home > Excel Reports > Show Buying Report > SKUs
Mango Show Buying Report - SKUs Tab This tab shows Show Specials and Power Buy deals at the SKU level. It is sorted by Score Category then Deal Score.
Mango's Show Buying Report scores across the two major convention event types: Power Buys and Show Specials. All Power Buys are scored in your workbook; only Show Specials scoring 1 and above are included. Score Category column defined: Easy Button - Your 50 top-scoring easy-to-order deals: Your store carries at least 95% of the SKUs. Store Closeout = N for at least 95% of the SKUs. There is only one ship date. SKUs do not have a special order nor spike sales signature. Deal cost, savings per cubic foot, and total cubic feet conditions are met. Review - Great deals for your store, but need your review: Multiple ship dates. Mango tries to pick the best date for your store, but you might want to spread the deal out or pick a different date. High cost, exceeding $3,000. Under $2.13 savings per cubic foot. These are great deals, but your store might not have room. Deals where you do not carry every SKU, or some SKUs in the deal are Store Closeout = Y. Fill Shelf - Small deal quantities that should fit on your hook without causing back stock: SKUs with Shelf Capacity (Loc3) - fills your shelf up to a 40-week supply without going overcapacity. SKUs without Capacity (Loc3) - Small cube deals should not create back stock. Opportunity - these SKUs sell well in peer stores, but you do not (or have stopped) carrying the SKUs. Low Score - these deals will likely create too much overstock based on your store's sales history and offer OM. Unscored - these deals are not carried by your store, and not enough stores in your peer group carry the deal to determine a score.
Mango's Show Buying Report scores across the two major convention event types: Power Buys and Show Specials. All Power Buys are scored in your workbook; only Show Specials scoring 1 and above are included.
Score Category column defined:
Column A - Deal Score: this column is derived from Weeks Supply (column I & H), % Carried in Store (column K), and Order Qty Savings (column O). Higher numbers indicate deals with the fastest turns, carried in your store, and with the biggest dollar savings. -99,999 indicate new SKUs/Deals that do not have enough sales history in your store (and in your peer group) to score.
Column B - Score Category: deals are grouped into categories to help you order more intelligently (see top of this page for more detail).
Column C- Deal: shows the bulletin number associated with the deal.
Column G - Store QOH + QOO + FOQ: shows your store's quantity-on-hand (including Quantity-On-Order and Qty. on Future Order) as of the last Mango report date (last month-end). Column H - Offer OM: shows the number of units ships with the deal. Column I - Sugg Order Qty: show the quantity Mango is suggesting to order
Column J - Order Qty + QOH: column G + column I
Column K - Shelf Capacity: shows your store's floor shelf capacity if using Mango's Back Stock system (location 3). More info here. Column L - Store TTM Sales Units: shows your store's twelve trailing months (TTM) sales units, including promotional sales. Column M - Weeks Supply: shows the number of weeks supply the deal will bring in at the suggested order quantity, (also takes into account your store QOH). Column N - Offer Cost: shows the deal's discounted cost. Column O - Discount: shows the offer discount from regular cost. Column P - Future Cost: shows the SKU's regular or future cost. Column Q - Peer Sales Units: shows the number of units peer stores sell the SKU annually. This column is adjusted for your store's size within the peer group and is an indicator of how many units your store is likely to sell annually. Column R - % Peers Selling: shows the percentage of stores in your peer group selling the SKU. Peer groups are typically between 20 and 60 stores.
Column S - Offer Description: shows the deal's description.
Column T - Drop Ship: Y = Drop Ship Deal.
Column U - Ship Date: the deal's ship date for the bulletin (deal) listed. Note: Mango will try and select the most relevant ship date for your store if there are multiple shipping date options. But you should review!
Column V - Bulletin Dating: the deal's anticipated statement due date.
Column W - Store Closeout: shows if the SKU in your store is set to Store Closeout Y/N.
Column X - Allocation Qty: limit set by Ace for the number of units your store can order. If blank then it's unlimited.
Column Y - Event Type: shows Ace's convention event category for the deal.