Question

2Thel Manageamoem of Ankit lad decided so preare csbget for May and June 2018. Following information was extracted from the books of Ankit Ltd. Budgeted Actual June May April Feb Mar Sales: Cash 250 600 290 500 35 700 300 000 320 000 600 000 580 000 585 800 Credit 410 500 500 500 710 000 690 000 685 700 700 800 Purchases 595 400 Salaries and wages 65 800 65 800 Sundry Expenses 18700 19400 25 400 20 500 21 500 65 800 65 800 65 800 Additional Information: Cash in respect of credit sales is collected as follows: a) 50% within 30 days 30% within 60 days 15% within 90 days 5% within-(uncollectible) The following discounts are allowed on sales: b) 10% on cash sales 5% on credit sales if accounts are settled within 30 days. All salaries, wages and expenses are paid in cash c) d) e) Sundry expenses include depreciation of $3 000 per month. Sixty percent (60%) of all purchases are on credit and are paid during the month that follows the month of transaction. On 30 June a dividend of $5 000 was declared. 1) g) The cash in the bank on 30 April 2018 was $15 500. Prepare a cash budget for the period I May to 30th June 2018. (7 Marks)

Answer 1

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
Schedule of Cash Receipt
	Credit Sale	%	Discount	May	June
Credit Sale:
February Sale	$ 410,500			$ 61,575
March Sale	$ 500,500	30% and 15%		$150,150	$ 75,075
April Sale	$ 585,800	50% and 30%	5%	$278,255	$175,740
May Sale	$ 580,000	50%	5%		$275,500
June Sale	$ 600,000
Cash Sale			10%	$270,000	$288,000
Total Cash Collection				$759,980	$814,315
Schedule of payment for purchase
				May	June
Credit Purchases:
April Purchase	$ 420,480			$420,480
May Purchase	$ 414,000				$414,000
June Purchase	$ 426,000
Cash Purchase		40%		$276,000	$284,000
Cash Payment for purchases				$696,480	$698,000
Cash Budget:
				May	June
Beginning Balance				$ 15,500	$   -4,300
Add: Cash Collection				$759,980	$814,315
Total Cash Available				$775,480	$810,015
Payment for:
Purchases				$696,480	$698,000
Salary and wages				$ 65,800	$ 65,800
Sundry Expense (Excluding Dep)				$ 17,500	$ 18,500
Total Cash Payment				$779,780	$782,300
Ending Balance				$   -4,300	$ 27,715