1 08 marks HASF & Company Ltd. has given the following particulars. You are required to prepare a cash budget for the three months ending 31stDecember, 2019 (Oct, Nov Dec) Months Sales Materials Wages Overheads Rs. Rs. Rs. Rs. August 20,000 10,200 3,800 1,900 September 21,000 10,000 3,800 2,100 October 23,000 9,800 4,000 2,300 November 25,000 10,000 4,200 2,400 December 30,000 10,800 4,500 2,500 10% sales are on cash basis, 50% of the credit sales are collected next month and the balance in the following next month: Creditors Materials after 2 months Wages 40% in the same month & 60% in next month Overheads in same month and in next month Cash balance on 1st October, 2019 is expected to be Rs. 8,000. A machinery will be installed in August, 2019 at a cost of Rs. 100,000. The monthly installment of Rs. 5,000 is payable from October onwards. Dividend on preference share capital of Rs. 3,000 will be paid on 1st December, 2019. Advance to be received for sale of vehicle Rs. 20,000 in December. Income-tax (advance) to be paid in December Rs. 5,000. Minimum Balance required Rs. 20,000

Find out:

Credit Sales October

Cash sales October

Total cash received from sales in October

Cash disbursement for material in November

Cash disbursement for labour in December

Cash disbursement for FOH in November

Total cash disbursement in December

Cash balance at the end of November