Question

Question 4 Agapanthus Berhad projected sales and purchases for the month of October to December 2018 as below: Sales (RM 17,000 22,000 18,000 14,000 2018 Purchases (RM 12,000 14,000 13,000 14,000 tember October November December Wages of RM1,500 are paid in the month that they are incurred. Overhead expenses of RM1,200 are due each month and these are paid one month in arrears. On 1 November 2018, the company plan to buy a second-hand van for RM8,000 Sales are all on credit and the company policy is to allow a 30 days credit period. Half of the purchases are on credit and the length of credit period allowed is a month. The other half of the purchases are for immediate settlement. The balance at the bank as at 1 October 2018 is RM15,000 Required Produce a cash budget for the 3-month period ending 31 December 2018. (10 Marks)

Answer 1

Agapanthus Berhad
Cash Budget
For the 3-Month Ended Dec 31, 2018
			(Figure in RM)
	October	November	December
Beginning Balance	15,000	17,500	15,300
Add: Cash Collection	17,000	22,000	18,000
Total cash available	32,000	39,500	33,300
Less: Cash disbursements
Purchase	13,000	13,500	13,500
Wages	1,500	1,500	1,500
Overhead Expenses		1,200	1,200
Van purchase	-	8,000	-
Total cash disbursements	14,500	24,200	16,200
Ending cash balance	17,500	15,300	17,100
Working
Purchases Payment
	October	November	December
September	6,000
October	7,000	7,000
November		6,500	6,500
December			7,000
Total	13,000	13,500	13,500