Department Projections
Tip
Project a Sales Target for a Period You Specify
The Department Projections report allows you to use your sales data to
establish sales, cost of goods sold (COGS) and expense targets for a specified
date range, providing an easy way to monitor and
update your progress toward each as they are recorded into CDBWin. It also helps
you manage your managers because you can set benchmarks for sales, COGS and
expenses and view the progress toward those goals. You can see, for
example, whether those in charge of pricing have discounted retail to stimulate sales while compromising your
COGS or expense targets.
To use the Department Projections report:
- On the Reports menu, click Daily Book > Department > Projections.
- Select a Begin Process Date and End Process Date range. The report includes
the actual sales figures falling within this period.
- Select an End Projection Date that determines how far forward
projections are to be set (the default is the end of the current month).
- For example, if you select a
Begin Process Date of 1/1/06 and an End Process Date of 1/10/06,
and your
End Projection Date is 1/31/06, the CDB will project
(extrapolate) sales data out to the end of the 31-day month (sales/10 x 31).
This sales data is broken out into separate departments.
- Click OK when finished. The Department Projections window
appears:
- Work through the Projections Window as follows:
- (1) There are three views possible for the report: Sales
dollars, Gross Profit dollars or Expenses
only. Choose the view by selecting the appropriate option button.
- (2) MTD Proj — This is the sales projection automatically
calculated for the department based on the Process date range. In the example cited above,
the projection is 31 days.
- (3) Primary — These two columns give you a chance to enter specific
dollar goals for the time period projected—again, in our example, 31 days. The system then
automatically calculates how
many more sales dollars your business needs to meet your goal in the
department:
- Goal — Type in the sales dollar figure you wish to make for the projected
time period for the department.
- Need — Based on the projected amount and the Goal you entered the system
determines—within the time period—how much more you need to meet your sales goal.
For example, if your projections for Department “Milk” are $1777.86 as determined
by the system, and you type in $1800.00 in the Goal column, the system calculates
$22.14 as your Need,
that is, how much more milk you need to sell to meet your goal.
- Other — This pair of columns provide an opportunity to enter Goal
dollars to determine a second, alternative projection of Need.
- Click View or Print when you have finished making adjustments
to the window:
|
