Case Study 3 Cantik Berhad makes a range of products all of which follow a similar production process and have the same cost structure. The products are made in batches that are started at the beginning of the month and are completed and taken into finished goods inventories at the end. There is no work in progress at the end of any month. The business is considering a change in its sales prices, volumes and credit terms. Current position Sales revenues are RM0.3 million a month and produce a contribution of 40 units per RM1 of sales revenue. Variable raw material costs account for 20 units per RM1 of sales revenue. Fixed costs are RM120,000 a month, of which RM30,000 is depreciation. Credit customers take one month to pay, trade payables for raw materials are paid one month after purchase and the other variable costs are paid during the month of production. At the end of each month, the business has sufficient raw material inventories to meet the following month's production and enough finished inventories to meet the following month's sales. Possible future position Production and sales volumes would be increased by 50 percent. To generate the increased demand, selling prices would be reduced by 10 percent and trade receivables would be allowed to pay two months after the sale. Since neither the usage nor the cost per product of raw materials and other variable costs would be affected by the proposed expansion, the contribution per RM1 of sales revenue would fall to 30 units. Apart from the increased trade receivables payment period, all working capital policies would remain the same as at present. If the adjustments to sales volume, price, and payment period are to occur, they will begin with sales made on December 1st of this year, but to meet the business's working capital policies there would be effects on cash flows before that time. The business's balance at bank at 1 October is expected to be RM70,000. Required: (a) Show Cantik Berhad cash budgets for each of the month of October, November, and December this year and January and February next year, on the assumption that the proposed expansion of sales goes ahead. Note: Ignore interest. (20 marks) (b) Discuss the effects of the expansion plans on the business's working capital levels and profitability. (20 marks) [Total: 100 marks] Case Study 3 Cantik Berhad makes a range of products all of which follow a similar production process and have the same cost structure. The products are made in batches that are started at the beginning of the month and are completed and taken into finished goods inventories at the end. There is no work in progress at the end of any month. The business is considering a change in its sales prices, volumes and credit terms. Current position Sales revenues are RM0.3 million a month and produce a contribution of 40 units per RM1 of sales revenue. Variable raw material costs account for 20 units per RM1 of sales revenue. Fixed costs are RM120,000 a month, of which RM30,000 is depreciation. Credit customers take one month to pay, trade payables for raw materials are paid one month after purchase and the other variable costs are paid during the month of production. At the end of each month, the business has sufficient raw material inventories to meet the following month's production and enough finished inventories to meet the following month's sales. Possible future position Production and sales volumes would be increased by 50 percent. To generate the increased demand, selling prices would be reduced by 10 percent and trade receivables would be allowed to pay two months after the sale. Since neither the usage nor the cost per product of raw materials and other variable costs would be affected by the proposed expansion, the contribution per RM1 of sales revenue would fall to 30 units. Apart from the increased trade receivables payment period, all working capital policies would remain the same as at present. If the adjustments to sales volume, price, and payment period are to occur, they will begin with sales made on December 1st of this year, but to meet the business's working capital policies there would be effects on cash flows before that time. The business's balance at bank at 1 October is expected to be RM70,000. Required: (a) Show Cantik Berhad cash budgets for each of the month of October, November, and December this year and January and February next year, on the assumption that the proposed expansion of sales goes ahead. Note: Ignore interest. (20 marks) (b) Discuss the effects of the expansion plans on the business's working capital levels and profitability. (20 marks) [Total: 100 marks]