The following budget estimates are available for Ashton Ltd., manufacturer of a single product: Actual and projected sales: Cash Credit R R January (actual) 70 800 283 200 February (actual) 72 000 288 000 March (actual) 71 400 285 600 April (budget) 68 400 273 600 May (budget) 70 800 283 200 June (budget) 72 000 288 000 Debtors on average settle their accounts as follows: 50% pay during the month following the month of sale, and are allowed a discount of 5%, 47% pay during the second month following the month of sale, and 3% prove uncollectable. Required production is as follows: Month Units March 17 900 April 17 400 May 17 850 The inventory policy of the company is to maintain closing stock of raw material at 80% of the following month's production requirements. The company uses 5 kg of raw material at a cost of R1,50 per kg, to manufacture one unit. Raw material stock at March 01, equals 72 000 kg. Sixty percent of all raw material purchases are paid within the month of purchase, and the other forty percent are paid during the month following the month of purchase. Total material purchases for February amounted to R122 440. Wages are R4 per unit, and factory overhead R3 per unit. Factory overhead include a monthly depreciation charge of R8 000. Fixed selling and administrative expenses amount to R45 000 per month, including a depreciation charge of R3 000. Monthly variable selling and administrative expenses equal 5% of total sales for the month. Wages, factory overhead, and selling and administrative expenses are all paid during the month incurred. Computers with a book value of R12 000 will be sold for cash during March, at a loss of R2 000. New computers will be acquired at a cost of R100 000 and would be paid for in five equal monthly installments commencing in March. The bank balance at March 01 amounted to R18 750. Required: Draw up a cash budget for the months of March and April. (h) Calculate collections from debtors for April (i) Calculate total receipts for April (j) Calculate creditors payments for April
- The following budget estimates are available for Ashton Ltd., manufacturer of a single product:
Actual and projected sales:
|
|
|
|
|
|
Cash |
Credit |
|
|
|
|
|
|
R |
R |
|
January (actual) |
|
|
|
70 800 |
283 200 |
|
|
February (actual) |
|
|
|
72 000 |
288 000 |
|
|
March (actual) |
|
|
|
71 400 |
285 600 |
|
|
April (budget) |
|
|
|
68 400 |
273 600 |
|
|
May (budget) |
|
|
|
70 800 |
283 200 |
|
|
June (budget) |
|
|
|
72 000 |
288 000 |
Debtors on average settle their accounts as follows:
- 50% pay during the month following the month of sale, and are allowed a discount of 5%,
- 47% pay during the second month following the month of sale, and
- 3% prove uncollectable.
Required production is as follows:
|
Month |
Units |
|
March |
17 900 |
|
April |
17 400 |
|
May |
17 850 |
The inventory policy of the company is to maintain closing stock of raw material at 80% of the following month's production requirements. The company uses 5 kg of raw material at a cost of R1,50 per kg, to manufacture one unit. Raw material stock at March 01, equals 72 000 kg. Sixty percent of all raw material purchases are paid within the month of purchase, and the other forty percent are paid during the month following the month of purchase. Total material purchases for February amounted to R122 440.
Wages are R4 per unit, and factory overhead R3 per unit. Factory overhead include a monthly
Computers with a book value of R12 000 will be sold for cash during March, at a loss of R2 000. New computers will be acquired at a cost of R100 000 and would be paid for in five equal monthly installments commencing in March.
The bank balance at March 01 amounted to R18 750.
Required:
Draw up a
(h) Calculate collections from debtors for April
(i) Calculate total receipts for April
(j) Calculate creditors payments for April
Step by step
Solved in 4 steps with 7 images
