Apricot Berhad had projected its sales for the first half of 2023 to be as follows:...

Transcribed Image Text:

Apricot Berhad had projected its sales for the first half of 2023 to be as follows: Month Month RM 100,000 RM 360,000 January April February 120,000 May 480,000 March 200,000 June 480,000 Cost of goods sold is 40% of sales. Purchases are made and paid for 1 month prior to the sale. 40% of sales are collected in the month of the sale, 40% are collected in the month following the sale, and the remaining 20% in the second month following the sale. Total other cash expenses are RM20,000 per month. Apricot Berhad is planning to buy a machine worth RM10,000 cash in May 2023. The company's cash balance as of 31 March 2023 is projected to be RM40,000, and the company wants to maintain a minimum cash balance of RM10,000. Excess cash will be used to retire short-term borrowing (if any exists). The company has no short-term borrowing as of 31 March 2023. Assume that the interest rate Prepare a monthly cash budget for the second quarter of 2023. Apricot Berhad had projected its sales for the first half of 2023 to be as follows: Month Month RM 100,000 RM 360,000 January April February 120,000 May 480,000 March 200,000 June 480,000 Cost of goods sold is 40% of sales. Purchases are made and paid for 1 month prior to the sale. 40% of sales are collected in the month of the sale, 40% are collected in the month following the sale, and the remaining 20% in the second month following the sale. Total other cash expenses are RM20,000 per month. Apricot Berhad is planning to buy a machine worth RM10,000 cash in May 2023. The company's cash balance as of 31 March 2023 is projected to be RM40,000, and the company wants to maintain a minimum cash balance of RM10,000. Excess cash will be used to retire short-term borrowing (if any exists). The company has no short-term borrowing as of 31 March 2023. Assume that the interest rate Prepare a monthly cash budget for the second quarter of 2023.