Inventory Scw Retail Statistics

Action: RETLSIZE

ProfitSystem® accumulates sales statistics for each inventory item owned. Companies have a choice to utilize size, color & width for inventory items. ProfitSystem® will maintain sales statistics at that level very well.

There are two choices for seeing the sales statics for a inventory style. The first is the Statistics Tab and the second is the SCW Statistics button.

The SCW Statistics button will display the retail sales totals by the inventory size, color, width (SCW) breakdown created by the shop.

Hint: There is a SCW description called OTHER. OTHER is a system defined SCW. Each inventory style contained within the system will have a SCW called OTHER and it cannot carry a quantity on hand. OTHER cannot be deleted or edited.

The OTHER SCW is a used by the system to hold sales information about the style it is assigned to. An option within ProfitSystem is the ability for a operator to sell any size or color or width of a entered inventory style, even if that size or color o r width is not found under the inventory style. Basically the operator is allowed to enter ANY size, color or width for the style when that option is set within General Setup. This is called an non-validated entry.

All retail sales statistics are accumulated under the SCW OTHER in the instance that the Housekeeping->General Set-up->System Store/Set-up Option Tab in Tickets Section ‘Allow sale of item not in inventory (checked = YES) and the operator sells an item on a Ticket with a Size or Color or Width that is not in the inventory file for that style.

The form displays all the sizes, colors & widths entered for the selected style

The information currently displayed is for the highlighted SCW.

Show Stats & pricing? … When unchecked the form does NOT display the MTD, YTD and Life sales totals. This option exists to speed the display of the other information on the form when skipping from one SCW to another. The MTD, YTD and Life totals are dynamically calculated from the ticket data and can take a few moments to complete for each SCW.

Size, Color, Width...The size, color, and width of the item. You should enter at least one size, even for items that are not sized. You can use FA (for fit all) or NA (not applicable.)

A size, color, or width code can only contain letters, numbers, and $, %, *, -, +, /. It cannot contain “, ‘,[ or ].

Qty on hand...The quantity you currently have on hand. This quantity is maintained automatically. It is the total of the QOH for every Receive History entry for this size/color/width. If you need to manually change the QOH, change the QOH via the Receive History form.

Qty on stock orders...This will show your total quantity for this style, size, color, and width that is outstanding on stock purchase orders.

Reorder cost...This is wholesale cost to reorder a new item. This amount is calculated automatically, based on the reorder cost for the style plus any costs for extra charges that apply to this size.

Last received...The date you last received this item, either via a stock PO or by changing the quantity on hand directly. You cannot change this date directly. However, if you update the last receive date on the Receive History form, and that date is later than the date here, the date last received on the Retail Sizes and Retail Inventory will be updated.

Retail price 1 & 2...Retail is the base retail selling price of this size. It is the same as the markdown price from the style.

Mkdn Retail Price 1 & 2...If there are any promotional prices, or extra charges that apply to this size, the resulting new selling price will be displayed in the Markdown Retail Price 1 & 2 fields. You can double click on this field to show how ProfitSystem® is computing the markdown price.

Gross Margin 1 & 2...ProfitSystem® tracks the gross margin of an inventory size. This number is automatically calculated for you.

MTD Sold...Every time the ProfitSystem® program is started, it checks the current date. If ProfitSystem® sees that a new month has started, it will ask the user to reset the MTD totals. If you choose to reset them, ProfitSystem® will reset the following MTD (Month to Date) figures to zero, like a trip odometer on your car. In order for ProfitSystem® to track these figures accurately, the MTD totals must be reset to zero at the beginning of each month.

MTD Sold is the total number of times the SCW has been sold since the last time the MTD counter had been reset to zero. ProfitSystem® records this information automatically.

Sold 1 & Sold 2 totals for MTD, YTD and Life are the total times sold for Price 1 & Price 2 respectively.

MTD revenue...This is the amount of total revenue this size has generated since that last time the MTD counter had been reset to zero.

MTD cost of sales...This is the total cost of sales for this size since that last time the MTD counter had been reset to zero. ProfitSystem® records this information automatically.

MTD gross margin...MTD Gross Margin % is similar to the gross margin percentage shown on page 1 of the inventory, except that the number shown here is a month to date total. Again, it shows the total since last time the MTD counter had been reset to zero. ProfitSystem® records this information automatically.

YTD Sold...These figures are identical to the month to date fields, except these figures are accumulated on a year to date basis. When the program is first started on January 1st, the system will prompt the user if she/he wishes to reset the YTD numbers in addition to the MTD numbers.

YTD revenue, sales, gross margin...These figures are identical to the month to date fields, except these figures are accumulated on a year to date basis.

Total Sold...These figures are identical to the month to date fields and year to date fields, except these figures are accumulated on a lifetime basis, i.e. since the day they were entered into ProfitSystem®. These figures cannot be reset to zero. ProfitSystem® records this information automatically.

Total revenue, cost of sales, gross margin...These figures are identical to the month to date fields, except these figures are accumulated on a year to date basis.

Print button...Allows you to print Tag(s) for the selected SCW inventory item. When you click it, you see a list of the tags that are set up to print for Retail Size (InvDetail) will display, and you can select one to print. If you only have one designed, it will print that one automatically.