Stock Replenishment

Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).

Part of: Stock Reports

The report details stock holding for a specified supplier detailing full stock status and purchasing trends over the last six months cumulating in an average sales value which will aid in purchase demand planning.

Column definitions

The coloured backgrounds indicate whether sales over the analysed timeframe were profitable using the specified Target % as the mark for a green background – yellow is 50% of the target or higher and red below this figure.

The red weeks cover indicates that the lead time for new goods exceeds the number of weeks cover and therefore there is the potential that zero stocking levels will be reached before replenishment goods arrive.

Selection Criteria

Run time choices, user selectable.

• Include

  • Re-orderable Only / Exclude Re-orderable / All stock

• Restricted Stock Holding Location(s)

• Show Individual Stock IDs

  • Yes / No

• Sales Grouping

  • Monthly / 3 Month groups

• Supplier(s)

• Range(s)

• Target Percentage

Print Sequence

As indicated by blue numbered squares in the report example.

1 Stock Holding Location

2 Supplier / Vendor

3 SKU

4 Option Choice

Report Totals

As indicated by yellow numbered squares in the report example.

• There are none.

Printed Fields

Fields printed on the report.

• Supplier / Vendor

• SKU

• Range / Collection

• Model Number / Supplier Stock Reference

• Product Description & Options

• Stock Status (when showing Stock ID) - blue text - shaded background

• Stock ID (if selected) - blue text - shaded background

• Sales Order Number (when showing Stock ID) - blue text - shaded background

• Rolls indicator

• Current Stock

• Imperfect Stock level

• Not Saleable Stock

• Sold Stock level

• Saleable Stock value

• Quantity On Demand

• Units On Order

• Overall Saleable Stock Balance

• Re-Orderable Indicator

• Lead Time (in days)

• Sales by month

• Average monthly sales

• Weeks Cover

Attachments (1)

image-20230821-152906.png
124 KB