Question

Technopak Limited supplies components for smartphones. REQUIRED Use the information provided below to: 5.1 Prepare debtors collection schedule for April and May 2019. 5.2 Prepare cash budget for April and May 2019. Note: Where applicable, round off all amounts to the nearest to the nearest Rand (14) INFORMATION The following figures are available: Sales Purchases Sales Commission Wages January 96000 100000 400 800 Actual 2019 February 120000 50000 600 800 March 60000 160000 1200 800 Estimated 2019 April May 160000 200000 84000 60000 800 400 ? • 40% of all sales are for cash • 25% of all purchases are cash Collections for credit sales are as follows: 20% is collected in the month of the sale and 2% discount is granted on these collections. 60% is collected in the month following of sale. • 15% is collected in the second month following the month of sale • The remaining 5% is written off as bad debts 1. Technopak Limited will make an investment of R50 000 in fixed deposit on 1 April 2019. Interest of R18 000 per month is expected to be received from 30 April 2019. 2. Creditors are paid 2 months after the date of invoice. 3. Rent expense amounts R4 500 per month and is payable on the first day of each month. 4. Wages will be increased by 10% in April 2019 and will increase by a further 5% in May 2019. 5. A new machine is expected to be purchased for R12 000 cash in May 2019. 6. Commission is paid on sales personnel in the month following the month in which it was earned. 7. On 31 March 2019, Technopak Limited had a bank overdraft of R28 000.

Answer 1

	Debtor Collection Schedule
	Pariculars			Januray	February	March	April	May
	Sales			$ 96,000.00	$ 120,000.00	$ 60,000.00	$ 160,000.00	$ 200,000.00
a)	Cash Sales		(40%')	$ 38,400.00	$   48,000.00	$ 24,000.00	$   64,000.00	$   80,000.00
	Credit Sales		Balance	$ 57,600.00	$   72,000.00	$ 36,000.00	$   96,000.00	$ 120,000.00
	Collection for the month of:
	January			$ 11,289.60	$   34,560.00	$    8,640.00
	February				$   14,112.00	$ 43,200.00	$   10,800.00
	March					$    7,056.00	$   21,600.00	$     5,400.00
	April						$   18,816.00	$   57,600.00
	May							$   23,520.00
b)	Collections from debtors			$ 11,289.60	$   48,672.00	$ 58,896.00	$   51,216.00	$   86,520.00
(a+b)	Total collection			$ 49,689.60	$   96,672.00	$ 82,896.00	$ 115,216.00	$ 166,520.00

	Cash Budget
	Particulars				April	May
	Beginning Balance				$ (28,000.00)	$    (1,364.00)
Add:	Collections				$ 115,216.00	$ 166,520.00
	Interest on Investment				$   18,000.00	$   18,000.00
	Total cash available				$ 105,216.00	$ 183,156.00
Less:	Disbursements
	Investment made				$   50,000.00	$                 -
	Payment to creditors				$   50,000.00	$ 160,000.00
	Rent Expense				$     4,500.00	$     4,500.00
	Wages				$        880.00	$        924.00
	Machine purchase				$                 -	$   12,000.00
	Commission on sale				$     1,200.00	$        800.00
	Total Disbursements				$ 106,580.00	$ 178,224.00
	Ending Balance				$    (1,364.00)	$     4,932.00

is this correct?