Overview

The Deal Calculator in Supplier Purchase Planning is a tool designed to help you make informed buying decisions and maximize supplier deals.  

This tool estimates how long your inventory will last based on historical sales data and calculates the Gross Margin Return on Investment (GMROI).  This is a key metric that shows how much profit your business can generate for every dollar invested in inventory.

Settings

• Cases to buy:  This is the number of cases needed to receive the deal
• Accelerator:  The estimated percentage of sales growth.  Leaving this value at zero will calculate the values based on the average past sales. 
• Number of rows selected:  The number of rows selected in the SPP report.  You can select multiple rows by holding control and clicking on the row.
• Est weeks to sell out (ave):  The average number of weeks it will take to sell the product based on past sales data.
• Date of sell out:  An estimate on the day the inventory will be depleted based on past sales data.
• Est. GMROI (Regular price):  The GMROI based on the regular price of the product.
• Est. GMROI (Sale price):  The GMROI based on the sale price of the product.
• Apply deal buy:  Calculates the QTO value for the selected product(s)
• Clear:  This will clear the data in the Deal Calculator form
• Details:  This opens a new tab with a breakdown of purchasing data, including current on hand, inventory in pending POs, and more.

Procedure

1. Log into the back office
2. Navigate to -> Tools -> Supplier Purchase Planning
3. Create a new supplier purchase plan
4. Select the location(s)
5. Select the supplier(s)
6. (Optional) Add additional filters to narrow your list for the items available in a supplier's deal group
7. Select the product(s). If selecting multiple products, you'll want to hold the control button on your keyboard, and click on the line you wish to add to the deal calculator.
8. Enter the number of cases to buy for the related deal for the selected product(s)
9. (Optional) Enter an accelerator percent
10. Click the Apply deal buy button