Problem:
The treasurer of John Loyde Company plans for the company to have a cash balance of $91,000 on March 1. Sales during March are estimated at $900,000. February sales amounted to $600,000, and January sales amounted to $500,000. Cash payments for March have been budgeted at $580,000. Cash collections have been estimated as follows:
-Sixty percent of the sales for the month to be collected during the month.
-Thirty percent of the sales for the preceding month to be collected during the month.
-Eight percent of the sales for the second preceding month to be collected during the
month.
The treasurer plans to accelerate collections by allowing a 2 percent discount for prompt payment. With the discount policy, she expects to collect 70 percent of the current sales and will permit the discount reduction on these collections. Sales of the preceding month will be collected to the extent of 15 percent with no discount allowed, and 10 percent of the sales of the second preceding month will be collected with no discount allowed. This pattern of collection can be expected in subsequent months. During the transitional month of March, collections may run somewhat higher. However, the treasurer prefers to estimate collections on the basis of the new pattern so that the estimates will be somewhat conservative.
1. Estimate cash collections for March and the cash balance at March 31 under the present policy and under the discount policy.
2. Is the discount policy desirable?
| |
Under the present policy
|
Under the discount policy
|
|
Balance, March 1
|
$ 91,000
|
$ 91,000
|
|
Collections:
|
|
|
|
From March sales
|
540,000 ($900,000 X 60%:
|
617,400""
|
|
From Feb. sales
|
180,000 ($600,000 X 30%;
|
90,000 ($600,000 X 15%)
|
|
From Jan. sales
|
40,000 ($500,000X 8%)
|
50,000 ($500,000 X 10%)
|
|
Total cash available
|
$85 1,000
|
$848,400
|
|
Less: Disbursements
|
580,000
|
580,000
|
|
Balance, March 31
|
$271,000
|
$268,400
|
*$900,000 X 70% X 98% $617,400
2.No, &cause under the discount policy, the March 31 cash balance will be smaller.
The following information pertains to merchandise purchased by Westwood Plumbing Company for July, August, September, and October. During the month, 60 percent of the merchandise to be sold during the following month is purchased. The balance of the merchandise is purchased during the month. Gross margin averages 20 percent of sales.
| |
Purchases
|
| |
For the following
|
For the current month
|
|
July
|
$ 87,000
|
$ 92,000
|
|
August
|
96,000
|
100,000
|
|
September
|
120,000
|
89,000
|
|
October
|
110,000
|
92,000
|
Estimate the sales revenue for August, September, and October.