Question: Question 3 - Show your workings. Dynamic Sdn. Bhd. (DSB) projected sales for the first six months of 2024 are given below. Jan. RM250,000 April

Question 3 - Show your workings. Dynamic Sdn. Bhd. (DSB) projected sales for the first six months of 2024 are given below. Jan. RM250,000 April RM400,000 Feb. RM300,000 May RM450,000 Mar. RM400,000 June RM400,000 DSB anticipated there will be 40% of sales collected in the month of the sale, 50% are collected in the month following the sale, and 10% are written off as uncollectible. Cost of goods sold is 70% of sales. Purchases are made the month prior to the sales and are paid during the month the purchases are made (i.e. goods sold in March are bought and paid for in February). Total other cash expenses are RM50,000/month. The company's cash balance as of February 1, 2024, will be RM40,000. Excess cash will be used to retire short-term borrowing (if any). DSB has no short-term borrowing as of February 28, 2024. Assume that the interest rate on short-term borrowing is 1%per month. The company must have a minimum cash balance of RM25,000 at the beginning of each month. Round all answers to the nearest RM100. REQUIRED: Set up a cash budget for DSB for the month of February until June 2024. (25 Marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
