Difference between revisions of "Stock Forecasting"
m (info added) |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
===In This Section=== | ===In This Section=== | ||
This section will cover how to view stock forecasting reports.<br /> | This section will cover how to view stock forecasting reports.<br /> | ||
| − | + | This Stock Forecasting is based on, the <u>last 12 months sales</u>, and excludes items which are <u>packs</u> or <u>service</u> items.<br /> | |
== Searching == | == Searching == | ||
'''Show Top X Sellers'''<br /> | '''Show Top X Sellers'''<br /> | ||
| − | Here you can select the number of | + | Here you can select the number of bestsellers you would like to view, by typing in the relevant number into the search box. Eg. type 10 for the top 10 best selling SKU's.<br /> |
'''Filter By Product Group'''<br /> | '''Filter By Product Group'''<br /> | ||
| − | If you would like to filter your best selling SKU's by a particular product group, you can select the appropriate product group from the drop-down menu. Select ''All Groups'' if you do <u>not</u> want to filter by a particular product group.<br /> | + | If you would like to filter your best selling SKU's by a particular product group, you can select the appropriate product group from the drop-down menu. Select '''All Groups''' if you do <u>not</u> want to filter by a particular product group.<br /> |
'''Search'''<br /> | '''Search'''<br /> | ||
If you would like to search by a specific SKU, type the SKU (whole or partial) into the search bar.<br /> | If you would like to search by a specific SKU, type the SKU (whole or partial) into the search bar.<br /> | ||
| − | + | Note that specified SKU will be filtered by the number of best sellers and product group filter that has already been selected. | |
Press the [[File:Filter-report.PNG|alt=Filter report Button|link=|Filter report]] button to apply the filters and view relevant results. | Press the [[File:Filter-report.PNG|alt=Filter report Button|link=|Filter report]] button to apply the filters and view relevant results. | ||
| Line 20: | Line 20: | ||
== Results == | == Results == | ||
The previously selected filters have been applied to your results.<br /> | The previously selected filters have been applied to your results.<br /> | ||
| − | Results given can be sorted by ''SKU'', ''Name'' of stock file, ''Current Stock'' level, ''12 Month Sold'' number, ''Average Monthly'' sold value, ''Average Weekly'' sold value, ''Weeks Left of Own Stock'' forecast, ''Weeks Left of Suppliers Stock'' forecast, ''Weeks Left in Total'' forecast, ''Average Weekly Cost'', ''Average Weekly Revenue'', Average Weekly Profit'', and ''Last Sold'' date. | + | Results given can be sorted by '''SKU''', '''Name''' of the stock file, '''Current Stock''' level, '''12 Month Sold''' number, '''Average Monthly''' sold value, '''Average Weekly''' sold value, '''Weeks Left of Own Stock''' forecast, '''Weeks Left of Suppliers Stock''' forecast, '''Weeks Left in Total''' forecast, '''Average Weekly Cost''', '''Average Weekly Revenue''', '''Average Weekly Profit''', and '''Last Sold''' date. |
Latest revision as of 13:24, 8 November 2021
Stock Forecasting
In This Section
This section will cover how to view stock forecasting reports.
This Stock Forecasting is based on, the last 12 months sales, and excludes items which are packs or service items.
Searching
Show Top X Sellers
Here you can select the number of bestsellers you would like to view, by typing in the relevant number into the search box. Eg. type 10 for the top 10 best selling SKU's.
Filter By Product Group
If you would like to filter your best selling SKU's by a particular product group, you can select the appropriate product group from the drop-down menu. Select All Groups if you do not want to filter by a particular product group.
Search
If you would like to search by a specific SKU, type the SKU (whole or partial) into the search bar.
Note that specified SKU will be filtered by the number of best sellers and product group filter that has already been selected.
Press the 
button to apply the filters and view relevant results.
Results
The previously selected filters have been applied to your results.
Results given can be sorted by SKU, Name of the stock file, Current Stock level, 12 Month Sold number, Average Monthly sold value, Average Weekly sold value, Weeks Left of Own Stock forecast, Weeks Left of Suppliers Stock forecast, Weeks Left in Total forecast, Average Weekly Cost, Average Weekly Revenue, Average Weekly Profit, and Last Sold date.
