You have been appointed as a junior accountant at a manufacturing company that produces one product:...

Transcribed Image Text:

You have been appointed as a junior accountant at a manufacturing company that produces one product: Product X. The company's management has provided you with the following information for the next quarter (3 months): Sales and production information: Sales Forecast: 1,500 units in January, 1,800 units in February, 2,000 units in March, and 4000 units in April. Each unit sells for $60. Desired Ending Inventory: The company aims to maintain ending inventory of Product X equal to 20% of the following month's expected sales. Beginning Inventory: The beginning inventory of Product X for January is 500 units. All sales are on account and collected 20% in the month of sales, 30% in the month following the sale, and 45% in the second month following the sale. Required: a) Calculate the production volume for each of January, February, and March (6 marks) b) Calculate the total cash collected from sales in April. (4 marks) You have been appointed as a junior accountant at a manufacturing company that produces one product: Product X. The company's management has provided you with the following information for the next quarter (3 months): Sales and production information: Sales Forecast: 1,500 units in January, 1,800 units in February, 2,000 units in March, and 4000 units in April. Each unit sells for $60. Desired Ending Inventory: The company aims to maintain ending inventory of Product X equal to 20% of the following month's expected sales. Beginning Inventory: The beginning inventory of Product X for January is 500 units. All sales are on account and collected 20% in the month of sales, 30% in the month following the sale, and 45% in the second month following the sale. Required: a) Calculate the production volume for each of January, February, and March (6 marks) b) Calculate the total cash collected from sales in April. (4 marks)