Purchase Analysis
Action: RP_PURCH
The powerful Inventory Retail Purchase Analysis report is designed to help management make inventory merchandising decisions. The user will input the report's creation criteria to focus the output on specific areas for analysis.
Criteria
Sold between...Date range that the items were booked on sales tickets.
Limit to Vendor...Blank for all vendors or enter a specific vendor code.
Limit to category... Blank for all categories or enter a specific category code.
Grouping Options
Controls the sort order and report sub totals.
Price point...Groups on user defined price points
Price point and vendor... Groups by Vendor & user defined price points within vendor
Category & vendor... Groups by Category & vendor within category
Category & price point... Groups by Category & user defined price points within category
Price Point Options
Any grouping options selected above will provide the user access to the Price Point Options box. Here is where the price point breakdown will be defined. The user must input the starting price point in the Minimum field. Say $0. The Maximum field is where the grouping will end, say $500. The Price break every indicates the price point range, say $100. The example takes the input and displays it back. For this scenario the Example would be: $100 - $200, 200.01 - $300, $300.01 - $400, $400.01-$500
Minimum...starting price point.
Maximum...maximum price point
Price break every...group at what increments
Example...display - applying the information entered
Limit to store(s)...Available in the optional multistore software limiting the totals to specific store(s) within the chain.
Report Columns
#In Stock... Total on hand
% stock... # in Stock / Total Stock
Cost... Total on hand * Average Unit Cost
% Cost... Cost / Grand Total Cost (Cost of all reported items)
# Sold... Units sold (stock or ordered)
% Sold... Units sold / Grand Total units (Units of all reported items)
% Variance... % Stock / % Sold
# Stock Sold... Units sold from stock
% Stock Sold... Units stock Sold / Grand Total stock units sold (Stock Units sold of all reported items)
# Ordered Sold... Units sold that were ordered
% Ordered Sold... Units ordered sold / Grand Total ordered sold (Ordered Units sold of all reported items)
Net Sales... Net sales (gross price - discounts)
Markdown... Discounts to achieve net sales figure
Turns... Sales / Cost
Cost of Sales... Net cost of sales
Gross Margin... Cost of Sales/ Net Sales