Question $3-$ Show your workings.

Dynamic Sdn$.$ Bhd$.($DSB$)$ projected sales for the first six months of $2024$ are given below.

Jan. RM$250,000$ Aprill RM$400,000$

Feb. RM$300,000$ May RM$450,000$

Mar. RM$400,000$ June RM$400,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 RM$50,000/$month$.$ The company's cash balance as of

February $1,2024,$ will be RM$40,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 RM$25,000$ at the beginning of each month. Round all

answers to the nearest RM$100.$

REQUIRED: Set up a cash budget for DSB for the month of February until June $2024.$