Product Performance and Purchase Recommendations Sample

This screen and its accompanying tabs appear when you double-click on a grid item in the Product Selection screen, a screen you access via the Product Performance and Purchase Recommendations routine. You use that screen to specify your report preferences and run-time options. You use this screen to view the results.

Header Area

The header portion of the screen displays information for the selected product, including Product code, Vendor Model Number, Vendor, Group, Category, Collection, Status, Style, Price Point, and Open to Buy Department.

General

The General tab displays information on the product selected, such as inventory turns, product status, and current costing information.

Suggested Retail - Gross Profit Percentages Based On

Selling Price - Gross Profit Percentages Based On

Sale Price - Gross Profit Percentages Based On

The inventory turnover ratio calculation includes the current months sales. If less than one year of history is available, the formula calculates based on the available history. Click here for detail on the formula used.

If the item has not been sold in the last twelve (12) months or, no inventory existed in stock during the last twelve (12) months, the Inventory Turns field displays zero (0).

Landed Add-On Approximations

Actual Sales

The Actual Sales tab provides a calculation of actual total inventory available, based on current net available, back-ordered sales, and incoming purchase orders for 13 weeks in the future.

The first column in this row shows the current net available calculated as:

NET AVAIL = QOH - RES - FLR - AI

The above equation translates literally as "net available equals the total quantity on hand less the number of items reserved to orders, less floor samples, and less As-Is items". Each subsequent week then shows the prior week's ending total net available as the new week's beginning net available.

Sales History

The Sales History tab provides information regarding monthly units sold, as well as GMROI, gross margins for a year and 4 months, and order counts for ASAP, CWC, As Is, and Layaways.

This is the gross margin return on investment/inventory, including the current months sales. If less than a years history is available, the formula will be calculated based on the available history. Click here for detail on how this is calculated.

If the item has not been sold in the last twelve (12) months or there was no inventory in stock during the last twelve (12) months, the GMROI displays zero (0).

Gross Margin

Sales Per Period

Inventory

The Inventory tab provides total quantities of the selected product for all locations, as well as a breakdown by location.

The first column in this row shows the current net available calculated as:

NET AVAIL = QOH - RES - FLR - AI

For each location, the grid displays the on-hand, net available, back-order, As-Is, and floor sample quantities of the selected product . Also displayed are the number of units on written sales for the current period and for the previous period, for each location. To access the Export to Excel and Export to HTML options, right-click a line in the grid.

Purchasing

The Purchasing tab shows open purchase orders by location with delivery dates, quantities, and cost. To access the Export to Excel and Export to HTML options, right-click a line in the grid.

The purchase order lead weeks displays for the selected product. When calculating purchase lead weeks, the system references the purchase lead days and the Exclude Weekends in Vendor Lead Days field in the Purchasing Control Settings.

If a check does not appear at the Exclude Weekends in Vendor Lead Days field, the lead weeks calculates as follows:

0 purchase lead days = 0 lead weeks
1-7 purchase lead days = 1 lead week
8-13 purchase lead days = 2 lead weeks

... and so on.

If a check appears at the Exclude Weekends in Vendor Lead Days field, the lead weeks calculates as follows:

0 purchase lead days = 0 lead weeks
1-5 purchase lead days = 1 lead week
6-10 purchase lead days = 2 lead weeks

... and so on.

The minimum stock weeks displays for the selected product. When calculating minimum stock weeks, the system checks the following fields for a lead days value, using the first one it finds:

Lead Days fields on the Advanced Vendor Group Exception Settings - Minimum Stock Days screen
Lead Days fields on the Advanced Vendor Category Exception Settings - Minimum Stock Days screen
Minimum Stock Days field in the Advanced Vendor Settings

Once the system finds a value, it calculates minimum stock weeks as follows:

0 minimum stock days = 0 lead weeks
1-7 minimum stock days = 1 lead week
8-13 minimum stock days = 2 lead weeks

... and so on.

The excess stock weeks displays for the selected product. When calculating excess stock weeks, the system checks the following fields for a lead days value, using the first one it finds:

Lead Days fields on the Advanced Vendor Group Exception Settings - Excess Stock Days screen
Lead Days fields on the Advanced Vendor Category Exception Settings - Excess Stock Days screen
Excess Stock Days field in the Advanced Vendor Settings

Once the system finds a value, it calculates minimum stock weeks as follows:

0 excess stock days = 0 lead weeks
1-7 excess stock days = 1 lead week
8-13 excess stock days = 2 lead weeks

... and so on.

The calculated number of net purchase orders for all warehouse/store locations displays using the following calculation:

Net PO = On PO - B/O (back-ordered) - LAYAWAY sales.

The grid displays the following information for open purchase orders for this product:

Location
P/O Number
On Hold - hold status
Date - date of entry, delivery, or acknowledgement
Date Type - identifies the Date Type displayed in the Date field. If "Entered" appears, this field indicates the PO does not have a delivery date and has not been acknowledged.
Open QTY (quantity)
Material Cost

For additional detail on a purchase order, or to edit the purchase order, you can double-click a line item in the grid to access the Enter a Purchase Order screen.

Forecast Sales

The Forecast Sales tab provides forecasted information for 13 weeks in the future, based on the sales rate. It also provides order warning and/or excess warning based on the options selected when running the Full Buyers Worksheet.

This field indicates the number of units calculated to be sold per week. The following calculation is used:

Sales Rate = (Total Units * Variance)/Number of Weeks

Total Units is the total number of units invoiced over the period specified during run-time. Variance is the Variance Percent specified during run-time. Number of weeks is either 13 weeks or the number of weeks the product has been in stock based on its first receipt date.

Based On Calculated Sales

The first column in this row shows the current net available calculated as:

NET AVAIL = QOH - RES - FLR - AI

Product Performance and Purchase Recommendations Sample

(Full Buyer's Worksheet)

Header Area

General

Suggested Retail - Gross Profit Percentages Based On

Selling Price - Gross Profit Percentages Based On

Sale Price - Gross Profit Percentages Based On

Landed Add-On Approximations

Actual Sales

Sales History

Gross Margin

Sales Per Period

Inventory

Purchasing

Forecast Sales

Based On Calculated Sales