QUESTION 6 NEELIPO Bhd forecasts unit sales for the next few months are as follows: Month January 2021 February March April May June July August Unit Sales 1,000 1,300 1,600 1,700 1,900 1,100 900 900 a) Selling price per unit is RM200. 40% of each month's sales are in cash and the remaining balance are on credit. The cash sales and 20% of credit sales are collected in the month of sales, 65% in the month following sales, and 15% in the second month following sales. b) Cash dividend of RM6,000 will be received in June c) Raw materials cost equal 40% of sales, and they are purchased on credit one month in advance of sales. 30% of purchases are paid in the month of purchase an the remaining 70% are paid in the following month d) Direct wages costs are RM5 per unit and are paid in the month incurred. e) Quarterly tax payments of RM8,000 are each due in March and June. Fixed monthly expenses consist of rent of RM20,000, selling expenses of RM 2,000 plus RM1.50 per units sold and depreciation of RM 12,000 g) The firm has an ending balance of RM22,000 in March and wishes to maintain a monthly minimum cash balance of RM10,000 Prepare cash budget for NEELIPO Bhd for the second quarter of 2021