Nova Wood Manufacturing company sales in December 2018 were $60,000 and they are expected to rise...

Transcribed Image Text:

Nova Wood Manufacturing company sales in December 2018 were $60,000 and they are expected to rise by $4,000 per month for the next 5 months. Of sales, 80 per cent are collected during the month of sale and the rest two months after sales. The cost of sales is 60 per cent of sales and, the company plans to keep an inventory at the end of each month equal to forty per cent of the anticipated sales for the next month's sales. Suppliers are paid one month after purchases are made. Monthly wages amount to $3,000, rent and heating $800 and depreciation $600. A machine is to be bought in February for $4,000 paid in cash. The purchase of the machine means that the monthly change for depreciation will increase by $40. The inventory held at January 1st is $12,450. Required: 1. Calculate the estimated cash collection from sales for February and March.(8) marks) 2. Calculate the purchases for February and March. (12 marks) 3. Assuming that the cash balance at 31/01/2019 is $8,000; prepare a cash budget for the two months ending March 31, 2019.( 18 marks) 4. Discuss whether the company will be able to repay a loan of $45,000 at the end of March.(2 marks) Nova Wood Manufacturing company sales in December 2018 were $60,000 and they are expected to rise by $4,000 per month for the next 5 months. Of sales, 80 per cent are collected during the month of sale and the rest two months after sales. The cost of sales is 60 per cent of sales and, the company plans to keep an inventory at the end of each month equal to forty per cent of the anticipated sales for the next month's sales. Suppliers are paid one month after purchases are made. Monthly wages amount to $3,000, rent and heating $800 and depreciation $600. A machine is to be bought in February for $4,000 paid in cash. The purchase of the machine means that the monthly change for depreciation will increase by $40. The inventory held at January 1st is $12,450. Required: 1. Calculate the estimated cash collection from sales for February and March.(8) marks) 2. Calculate the purchases for February and March. (12 marks) 3. Assuming that the cash balance at 31/01/2019 is $8,000; prepare a cash budget for the two months ending March 31, 2019.( 18 marks) 4. Discuss whether the company will be able to repay a loan of $45,000 at the end of March.(2 marks)