Home > Excel Reports > Show Buying Report > Deals
Mango Show Buying Report - Deals Tab
The Deals tab scores convention Show Specials and Power Buy deals. Deals are ranked by a Score Category and Deal Score. Higher scoring deals have the most relevance, produce the least overstock, and have the best savings for your store. Suggested order quantities are calculated to maximize savings while minimizing overstock. Using this report allows you to quickly pick out your best deals and copy/paste the orders into Event Planner on Acenet.
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:
You can download Mango’s Show Buying Report in 2 ways:
OR
Steps to process this worksheet:
Column B - Order Qty: shows how much of a deal to order. Mango will suggest a ~25-week supply (~32-week for seasonal) so that your store should sell through before the next show. Obviously, you may want to adjust this suggestion up or down based on your store's budget and storage capacity. Column C - Deal (or Bulletin): shows the bulletin number associated with the deal.
Column F - SKU: lists the deal's associated SKU, and (Asst) if the deal is an assortment of SKUs (you can use the SKUs tab to drill further into the deal).
Column G - Discount: shows the deal's average savings as a percentage of regular cost. Column H - Max Weeks Supply Order Qty + QOH: - shows the maximum weeks supply at the suggested order quantity for your store. This column will show you how long the slowest-moving SKU in the deal will take to sell through in your store. Also includes current quantity-on-hand position. Column I - Weeks Supply Order Qty + QOH: this column shows the deal's average weeks supply at the suggested order quantity (column B). Column J - Number of SKUs: shows the number of SKUs included in the deal. Column K - % Carried in Store: shows the percentage of deal SKUs already carried by your store. Column L - 1 OM Cost: the deal's cost per 1 deal offer OM (deal order multiple). Column M - 1 OM Savings: the deal's dollar savings per 1 deal offer OM. Column N - Order Qty Cost: the deal's total cost for the suggested order qty (column B).
Column O - Order Qty Savings: the deal's dollar savings for the suggested order qty (column B). Column P - 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 Q - Score Category: deals are grouped into categories to help you order more intelligently (see top of this page for more detail). Column R - Number of Ship Dates: indicates if the deal has multiple shipping dates to accommodate your store's season or to stagger inventory throughout the year.
Column S - 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 T - Bulletin Dating: the deal's anticipated statement due date.
Column U - Drop Ship: Y = a Drop Ship deal.
Column V - Dept: shows the department the majority of the SKUs within the deal are based.
Column W - Event Type: shows Ace's convention event category for the deal.
Column X - Savings Per Cubic Ft.: the deal's dollar savings per cubic foot of inventory space ordered.
Column Y - Order Qty Cubic Ft.: the deal's cubic feet at suggested Order Qty.