communication partner
SALES REPORT
An estimate of future sales, often broken down into both units and currency. It is used to create company sales goals.
|
|
|
|
|
|
|
|
|
|
|
|
PROJECTED SALES BUDGET |
|
||||||
|
|
|
|
|
|
|
|
|
|
|
|
Selling price per unit |
$8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ACTUAL SALES |
January |
February |
March |
|
|
|
|
|
|
Actual sales - units |
20.000 |
24.000 |
28.000 |
|
|
|
|
|
|
Actual sales - dollars |
$160.000 |
$192.000 |
$224.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
RECEIPTS PATTERN |
1st month |
2nd month |
3rd month |
|
|
|
|
|
|
Accounts receivable collections |
25% |
50% |
25% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PROJECTED SALES |
April |
May |
June |
July |
August |
September |
|
|
|
Projected sales - units |
35.000 |
45.000 |
60.000 |
40.000 |
36.000 |
32.000 |
|
|
|
Projected sales - dollars |
$280.000 |
$360.000 |
$480.000 |
$320.000 |
$288.000 |
$256.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
QUARTER 2 - 2013 |
|
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|
(a) Sales budget: |
April |
May |
June |
Quarter |
|
|
|
|
|
Budgeted sales in units |
35.000 |
45.000 |
60.000 |
140.000 |
|
|
|
|
|
Budgeted selling price |
$8 |
$8 |
$8 |
|
|
|
|
|
|
Budgeted sales in dollars |
$280.000 |
$360.000 |
$480.000 |
$1.120.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(b) Budgeted cash collections: |
April |
May |
June |
Quarter |
|
|
|
|
|
February sales |
$48.000 |
|
|
$48.000 |
|
|
|
|
|
March sales |
112.000 |
$56.000 |
|
168.000 |
|
|
|
|
|
April sales |
70.000 |
140.000 |
$70.000 |
280.000 |
|
|
|
|
|
May sales |
|
90.000 |
180.000 |
270.000 |
|
|
|
|
|
June sales |
|
|
120.000 |
120.000 |
|
|
|
|
|
Total cash collections |
$230.000 |
$286.000 |
$370.000 |
$886.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
