Question

ABC Ltd is a wholesaler. The management has been extremely worried about the entity’s cash position over the last few years. In January, they sought your advice and asked you to prepare a cash budget for the forthcoming month of May. The business has provided the following information to assist in this task.

• Estimated total sales for the next six months to 30 June, 2019 are as follows:

	January	February	March	April	May	June
Total sales	$ 152,500	$ 171,250	$ 177,500	$ 185,000	$ 167,500	$ 157,500

• Total sales comprise 80% credit sales and 20% cash sales.
• Cash is received immediately on cash sales.
• Analysis of past records has shown that credit sales are collected over a three-month period, with 50% being collected in the month of sales, 30% in the next month and the remaining in the following month.
• Projected expenditure during January to June are as follows:

• Purchases of goods for resale are made on credit. The entity receives one month credit on these purchases. The expected purchases for March $71,000, April $80,000, May $54,000 and June $48,000.
• An inventory check at the end of last year, a total of $45,000 of inventory, valued at cost is considered obsolete. The ABC Ltd is currently negotiating the sale of this inventory for $9,500 and expects cash payment during May.
• ABC Ltd has agree to purchases new inventory-handling equipment. The cost of $105,200 is payable in two equal payments in April and May.
• The monthly depreciation of the new inventory handling equipment will be $2,000.
• Business expected to sell the old equipment for $5,000 in May.
• Rent will be $ 5,500 per month, paid monthly and one month in advance.
• Utility expenses will be $2,000 in May but the amount will be paid in June.
• Monthly wage expense will be $ 20,500 and paid at the end of each month.
• ABC Ltd currently negotiating a marketing campaign with an advertising agency. The cost will be $6,300 in May and $7,700 in June. Payment will be made in cash.
• It is estimated that the cash balance at 1^st May will be $16,000.

Required:

1. Prepare a schedule showing receipts from credit customers for the months of April, May and June.
2. Prepare a cash budget for May only.

Answer 1

Solution:

1. Cash receipts from credit customers for the month of April, May and June

Month	Credit Sales ($)	April	May	June
January	$152,500 x 80% = $122,000	0	0	0
February	$171,250 x 80% = $137,000	$137,000 x 20% = $27,400	0	0
March	$177,500 x 80% = $142,000	$142,000 x 30% = $42,600	$142,000 x 20% = $28,400	0
April	$185,000 x 80% = $148,000	$148,000 x 50% = $74,000	$148,000 x 30% = $44,400	$148,000 x 20% = $29,600
May	$167,500 x 80% = $134,000	0	$134,000 x 50% = $67,000	$134,000 x 30% = $40,200
June	$157,500 x 80% = $126,000	0	0	$126,000 x 50% = $63,000
Total Collection		$144,000	$139,800	$132,800

.

2. Cash Budget of ABC Ltd. for the month of May

	$	$
Anticipated Receipts:
Receipts from credit customers	139,800
Cash Sales (167,500 x 20%)	33,500
Cash receipt from sales of obsolete inventory	9,500
Sales of old equipment	5,000
A. Total Cash Receipts		187,800
Anticipated Payments:
Payment for inventory purchased in April	80,000
Payment for inventory-handling equipment	52,600
Rent	5,500
Wages	20,500
Advertising	6,300
B. Total Cash Payments		164,900
Excess (Deficit) receipts over payments (A-B)		22,900
Cash Balance at the beginning of month		16,000
Cash Balance at the end of month		38,900