Question 1 From the following information prepare a monthly cash budget for the three months ending 31st Dec.2020 Sales Materials Wages Production Admin. Selling, etc Month (RM) (RM) (RM) (RM) (RM)...


Question 1<br>From the following information prepare a monthly cash budget for the three months ending<br>31st Dec.2020<br>Sales<br>Materials<br>Wages<br>Production<br>Admin. Selling, etc<br>Month<br>(RM)<br>(RM)<br>(RM)<br>(RM)<br>(RM)<br>June<br>6,000<br>3,600<br>1,300<br>450<br>320<br>July<br>6,500<br>4,000<br>1,500<br>450<br>320<br>Aug.<br>7,000<br>4,800<br>1,500<br>500<br>350<br>Sep.<br>7,500<br>4,500<br>1,500<br>600<br>350<br>Oct.<br>8,000<br>4,600<br>1,600<br>600<br>400<br>Nov.<br>8,500<br>5,000<br>1,800<br>700<br>400<br>Dec.<br>9,000<br>5,200<br>2,000<br>700<br>450<br>Credit terms<br>Sales<br>3 months to debtors. 10% of sales are on cash. On an average, 50% of credit<br>sales are paid on the due dates while the other 50% are paid in the month following<br>Creditors for material โ€“ 2 months.<br>Lag in payment<br>Wages. 1/4 month, overheads<br>1/2 month.<br>Other information<br>Plant and Machinery to be installed in Aug. at a cost of RM30,000. It will be paid for by<br>monthly installments of RM1,000 each from 1st Oct.;<br>Preference share dividend @ 6% on RM100,000 are to be paid on 1st Dec.<br>Calls on 500 equity shares @ RM2 per share expected on 1st November;<br>Dividends from investments amounting to RM500 are expected on 31st Dec.;<br>Income tax (advance) to be paid in December RM 1,000<br>Cash and Bank Balance on 1st Oct. expected RM3,000.<br>Required:<br>Prepare cash budget for 3 months period ending 31st December 2020 in detail with<br>appropriate workings.<br>

Extracted text: Question 1 From the following information prepare a monthly cash budget for the three months ending 31st Dec.2020 Sales Materials Wages Production Admin. Selling, etc Month (RM) (RM) (RM) (RM) (RM) June 6,000 3,600 1,300 450 320 July 6,500 4,000 1,500 450 320 Aug. 7,000 4,800 1,500 500 350 Sep. 7,500 4,500 1,500 600 350 Oct. 8,000 4,600 1,600 600 400 Nov. 8,500 5,000 1,800 700 400 Dec. 9,000 5,200 2,000 700 450 Credit terms Sales 3 months to debtors. 10% of sales are on cash. On an average, 50% of credit sales are paid on the due dates while the other 50% are paid in the month following Creditors for material โ€“ 2 months. Lag in payment Wages. 1/4 month, overheads 1/2 month. Other information Plant and Machinery to be installed in Aug. at a cost of RM30,000. It will be paid for by monthly installments of RM1,000 each from 1st Oct.; Preference share dividend @ 6% on RM100,000 are to be paid on 1st Dec. Calls on 500 equity shares @ RM2 per share expected on 1st November; Dividends from investments amounting to RM500 are expected on 31st Dec.; Income tax (advance) to be paid in December RM 1,000 Cash and Bank Balance on 1st Oct. expected RM3,000. Required: Prepare cash budget for 3 months period ending 31st December 2020 in detail with appropriate workings.

Jun 03, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here