Adjusting
and Updating takes about :15-:30 minutes and is done
once per
year in January & again in July if desired.
The purpose is to update your buying
plan with Actual Past Performance standards,
then
“adjust” past results to reflect your standards
and objectives.
=================================================================
After Dec EOM is entered:
Annual Shop Setup – 2008: Enter your
current (2008) Retail Sales and Rounds Budgets.
(for other than golf shops, ignore the "rounds"
instructions)
A.
Automatic Buttons:
(IF YOU HAVE EOM DATA FOR EVERY MONTH OF 2007-
OTHERWISE
SKIP TO B. ANNUAL SUB CATEGORY SETUP):
1. "Auto-Set
Monthly Sales": "Use Last Year's PLANS"
is your best option. Remember how we
"smoothed" your deliveries by adjusting these
percentages? That same Plan is probably
still valid, unless you have a reason for changing it.
2. "Auto-Set
Monthly Rounds": Clicking on this will
automatically set the % of annual rounds for each month
to the %s realized last year. If corporate
rounds budgets are available, you may prefer to use
those percentages.
3. "Use Past
Performance":
Click on the “Use Past Performance” button
Select the “Use Last Year” option
Select “OK”
(Wait - the calculations may take 60+ seconds)
You will be taken to the:
B. Annual Sub Category Setup:
If
you had a full years history and used the Automatic Buttons:
The results will be
imported automatically. Follow the step by step
instructions.
If you did
not have a full year history and did not use the automatic buttons:
Use the same plan you had for 2007 - which should have
already been copied to 2008.
Adjust as follows:
1. "% of Sales": Unless you have a reason, leave the
Actual % of
Sales that OTBW calculated from Last Year to constitute
the Plan for This Year.
2. "Turns": The Past
Performance button enters the
Planned Turns you used
Last Year. Check each Sub Category and make adjustments
at your discretion.
3. “Order Plan %” should be 100% less the % of Special
Orders that was calculated, IF you entered Special
Orders all of last year. Change as
required to reflect 100% less your anticipated % of
Special Orders.
4. "COS%" will = your Actual COS% Last
Year. This should be improving each year as your
inventory is reduced to optimum levels and fewer and
fewer markdowns are required. Check each Sub Category and adjust
if
you want different (better) standards than your actual
COS% from Last Year.
5.
"Average Inventory" in the right column
should be checked with every entry you make in the other
columns, to pass the "common sense" check.
This is an average from Jan 1 to Dec 31 and includes
both peak and off seasons.
6. "Copy To
Next Year" before exiting the setup. This will
insure that Y2009 is established with the same standards
on your seamless o-t-b Report.
Call Tim at
928 636-2105 if you would like us to walk you through
this procedure, or if you have questions after having
done it yourself. Attach your backup file to
an email prior to calling.
