Reference no: EM132597538

The following information is budgeted for Adella Sdn Bhd (ASB) for second quarter next year:

                                               April                         May                  June

Sales                             RM110,000            RM130,000   RM180,000

Purchase of materials         RM85,000               RM92,000   RM105,000

Rental expenses                   RM15,000               RM15,000   RM15,000

Fixed overhead                     RM60,000                RM60,000  RM60,000

Variable overhead                    RM25,000             RM15,000    RM15,000

Proceeds-sales of securities       RM250,000           RM150,000  RM300,000

Additional information:

a) All sales at ASB are on credit. ASB expects that 40% are collected in the month of sales, 58% in the month following the sale, and the remaining 2% are uncollectible.

b) ASB purchase all materials on credit; 80% of purchases are paid for in the month of purchase, the remaining 20% are paid for in the following month. The purchase of materials for the month of March is RM90,000.

c) Fixed overhead include depreciation of RM10,000.

d) Variable overhead and rental expenses are paid within the month they are incurred.

e) The company received 10% dividend from investment of RM600,000 in June.

f) An equipment costing RM65,000 will be purchased in May. Payment of the equipment will be in 4 equal payments starting June.

g) Three (3) administration staff will be employed, and each staff will be paid RM2,000 per month. Payment will be in the month in which they are incurred.

h) In April, the company is planning to purchase a motor van at a cost of RM50,000 which has an estimated useful life of 10 years. Depreciation charge per annum will be RM5,000. Only 30% of the motor van cost will be paid in the month of purchase, while the balance will be paid equally over the next two months.

i) Opening cash balance in April is RM161,000.

The company wishes to maintain a minimum cash balance of RM300,000 at the end of each month. The company borrows money from the bank at 12% interest if necessary, to maintain the minimum cash balance. Assume that borrowed money in this case is for one months.

Required:

Question a) Prepare Schedule of Collections for the month of April, May and June.

Question b) Prepare schedule for payment of materials for April, May and June.

Question c) Prepare cash budget for the months of April, May and June