Collections and Payments
Not what you're looking for?
All sales of Dunn's Building Supplies (DBS) are made on credit. Sales are billed twice monthly on the tenth of the month for the last half of the prior month's sales and on the twentieth of the month for the first half of the current month's sales. The terms of all sales are 2/10, net 30. Based on past experience, the collection experience of accounts receivable is as follows:
Within the discount period 80%
On the 30th day 18%
Uncollectible 2%
The sales value of shipments for May 2005 was $750,000. The forecast sales for the next four months are
June $800,000
July 900,000
August 900,000
September 600,000
DBS's average markup on its products is 20% o the sales price.
DBS purchases merchandise for resale to meet the current month's sales demand and to maintain a desired monthly ending inventory of 25% of the next month's cost of goods sold. All purchases are on credit with terms of net 30. DBS pays for one half of a month's purchases in the month of purchase and the other half in the month following the purchase.
All sales and puchases occur unifomly throughout the month.
1. How much cash can DBS plan to collect from account receivable collections during July 2005?
2. How much can DBS plan to collect in September from sales made in August 2005?
3. Compute the budgeted dollar value of DBS inventory on August 31, 2005.
4. How much merchandise should DBS plan to purchase during June 2005?
5.How much should DBS budget in August 2005 for the payment for merchandise purchased?
Purchase this Solution
Solution Summary
The solution explains the calculation of the amount of cash collection based on receivables and the amount of payments to be made based on purchases.
Solution Preview
1. How much cash can DBS plan to collect from account receivable collections during July 2005?
Accounts receivable collections in July will be made up of:
Sales from June 1-15, billed June 20, but not paid within 10 days
$800,000 X 1/2 X 0.18= $ 72,000 - these will half the month sales and 18% of them are collected in 30 days
Plus
Sales from June 16-30, billed July 10, paid within 10 days
$800,000 X 1/2 X 0.80 X 0.98 =313,600 - these are collected in 10 days there will be a 2% cash discount
Plus
Sales from July 1-15, billed July 20, paid within 10 days
$900,000 X 1/2 X 0.80 X 0.98 = ...
Purchase this Solution
Free BrainMass Quizzes
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Operations Management
This quiz tests a student's knowledge about Operations Management
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.