– SALES FORECASTING/OPEN TO BUY
To open SLFC, press <Alt M> (“Menu”) and follow the Menu path illustrated below, then press <Enter>, or simply enter <SLFC> in the “Enter Program Name” field and press <Enter>.
program forecasts sales and open to buy for the next three months.
Running this program will
produce a Sales Forecast report and a consolidated Open to Buy report for all
you uncheck the “Dept. Summary Only” option, the program will produce a
one-page Open to Buy report for each department, in addition to the
above-mentioned reports (26 pages total).
Sales Forecast Report
The concept of this report is for the system look at the last three months of sales and, based upon that, project the next three months of sales. This gives the bookstores an idea of where their sales are going to be over the next three months, as well as how much money they are going to have to spend based upon that projection.
By default, the Sales
Forecast report is based upon the previous three months’ increase or decrease
Example: If book sales in Jan, Feb & Mar of 2000 were 10% higher than Jan, Feb and Mar of 1999, the sales projection for Apr, May & Jun would be up 10% over Apr, May & Jun of 1999.
You may override the
default by changing the
“Fore” (forecast) department entries in SYS, Config. File, Cash
Using this feature you may project an increase or decrease, regardless of
the past three months’ sales.
Example: If sales for Apr, May & Jun of 1999 were unusually low, due to road construction in front of your store, a sales projection of 10% increase for Apr, May & Jun 2000 may not be an accurate projection.
to Buy Report
This report will
be built off the sales projection, upon which you can make spending projections.
You can then see how spending projections are coming along, based upon where
inventory dollars are currently.
Therefore, to have a true open to buy, you must have a sales projection,
a cost of goods projection, a beginning inventory, a month-to-date inventory
amount and an ending inventory.
You will then need to know how much you are over- inventoried or
under-inventoried as the month began.
order for this report to be accurate, there are two things that are required:
Budget figures must be
set up in SYS, Configurations 2037-2040.
Beginning and ending
inventory amounts on the Open to Buy report are based on the IVT
("Inventory Totals") report having been run the first of the month.
Therefore, you must run the IVT report the first of every month and on
the day the Open to Buy report is run.