Question: (b) Kent Sdn Bhd needs to come up with a cash budget to make sure that there is sufficient cash within the company to achieve

 (b) Kent Sdn Bhd needs to come up with a cash

budget to make sure that there is sufficient cash within the company

(b) Kent Sdn Bhd needs to come up with a cash budget to make sure that there is sufficient cash within the company to achieve the operations in the company. Following are the information gathered from Kent Sdn Bhd: 1) The sales figures for the month are January RM 300,000, February RM 400,000 and March RM 550,000. 2) From the sales figure, only 10 percent of the customers agreed to pay immediately. Of the remaining customers, 60 percent agreed to pay one month after sales and the balance of 40 percent agreed to pay 2 months after-sales. 3) Based on the industry experience, it is known that credit sales customers of 2 percent tend not to pay due to various reasons. These are referred to as bad debts. Kent Sdn Bhd had decided to reduce the budgeted cash inflow by this percentage only with the customers who are paying 2 months after-sales. The company incurs labour cost to 20 percent, material cost to 25 percent and overhead cost to 15 percent. All this cost percentage is based on sales value for each month. 4) 5) Labour costs are being paid on weekly basis and one week in arrears. Assuming both January and February have 4 weeks while March has 5 weeks. 6) Material cost and overhead cost are paid in the month they are incurred. 7) Included in the overhead cost is RM 10,000 monthly charge for depreciation. Required: Prepare a cash budget for January, February and March. The opening balance of January bank balance was RM 150,000. (21 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!