Sell Through Report

Action: RP_SELLTHRU

Overview

This report is a tool to determine adequate inventory in-stock levels based upon a season's selling requirements and to determine how well a inventory item is performing. It is ideal for inventory that is sold out-of-stock, as in, many ready to wear, mother's and prom retail operations.

The report groups by category &, may sub group by Style or Size or Color (depending on choice in selection criteria). Each line of the report represents a specific style, size, color (SCW).

Columns

Style Code, Size, Color... Specific SCW that is being analyzed on this line of the report.

QOH Start... The QOH as of the season's start date, (first date of season runs date range in the criteria).

Recv Adjust... Totals from beginning season until the Sell Through as of date in selection criteria, counts units received in range

Sold... Totals from beginning season until the Sell Through as of date in selection criteria, calculates units sold in range

Order... On stock order as of todays date (current system date)

QOH End... (QOH Start + qty RECD) - qty SOLD. This is the ending quantity on hand for the range

Sell Thru... As of the entered Sales thru date, Sales calculations stop on this date.. Sold / (QOH start + Recv)

Week left... (QOH start + Recv - Qty Sold) / ((Qty sold / ((sell thru date - season start date) / 7))) . A calculation to indicate how many weeks of inventory are available based upon the season's sales history to date.

(QOH start + Recv - Qty Sold) / ((Qty sold / (sell thru date - season start date) * 7)

Avg Unit Cost... Is the Average unit cost for the SCW found within inventory on the SCW form.

Avg Cost of Sales... Cost / Qty Sold. Total costs are not found within the report. This calculation is a summation of cost of sales for the sold qty.

Sales... Is the total net sales dollar value that occurred from the report's season start to the sales through date for this SCW.

% of Total Sales... This is the % of sales for this item, computed as a % of the total sales for this category. Sales for ths SCW / Total Category sales.

Margin... Sales - (Avg Cost Sales * qty Sold) / (Avg Cost Sales * qty Sold) printed as a percentage.

Inv. Turns... Qty SOLD / (QOH Start + QOH End) / 2.

Criteria

Season runs from (date range)... The date range, Start date and end date of the season being analyzed.

Sell-through as of... Todays date or prior. Does not make sense to compute sales on a future date since those sales have not happened yet. This date should not exceed the last date of the season.

Group by (Style or Size or Color)... The primary grouping is always by category. This field allows for a sub-grouping and may be either by style, size or color.

Limit to vendor... Limit report to a specific vendor. Leave blank for all vendors.

Limit to category... Limit report to a specific category. Leave blank for all categories..

Limit to sub-category... Limit report to a specific sub-category. Leave blank for all sub-categories.

Limit to Stores... Available with multi-store option. Limit report to a specific store. Leave blank for all stores.