QUESTION 2 Goodguy manufactures dog beds. In March 2019, the manager decided the business needed to have the security of a short-term loan of $50,000 starting in May 2019 as its cash balance had been reduced because of recent equipment purchases. The bank would charge interest at the equivalent of 4 percent per annum on the loan and require the business to repay interest and principal on 31 May 2019. To consider the loan application, the bank requested the provision of a number of budgets for May including the Cash Budget. The following information is available: Budgeted sales are 120,000 units per month for April, June and July, and 80,000 units for May of 2019. The selling price is $52 per unit. Finished Goods inventory on April 1 for 26,000 units was $780,000. The company follows a policy requiring ending finished goods inventory each month to be 20% of next month's sales. There is no WIP. The inventory of raw materials on April 1 was 15,600kg (@$30/kg). The ending inventory is required to be 30% of next month's production requirements. Selling & administrative expenses are expected to be $85,000 plus 10% of sales (this includes depreciation of $16,500). The manufacturing costs budget (based on a practical capacity of 150,000 units per month) follows: Materials (0.25 kg per bed, @ $30 per kg). $1,125,000 Direct Labour (10 minutes per bed @ $30 per hour)....... 750,000 Variable Overhead (allocated @$10 per DLH)... 250,000 Fixed Overhead 180,000 Total $2,305,000 Budgeted Fixed manufacturing overhead includes $48,000 of depreciation. REQUIRED: a. Prepare the following budgets for April and May 2019: (10 marks) (1) Production Budget (ii) Materials Purchases Budget in dollars b. You have been provided with the following additional information: All sales are made on credit and customers pay 50% in the month of sale; 50 % in the month following. Assume that materials are paid 40% in the month purchased and 60% in the following month. Labour and relevant overhead costs are paid in the month the liability is incurred. Selling and administration expenses are paid each month as incurred. The opening cash balance at 1st May (before the loan drawdown) was $5500. Assume the short-term loan has been secured, prepare the Cash Budget for the month of May, 2019. (6 marks) c. The CEO of Goodguy Ltd., a decentralised company with 4 major divisions (all profit centres), is concerned that the preparation of static budgets by the CEO has resulted in the company's budgets being less effective and not helpful for decision making in a constantly changing operating environment. What is the issue that the CEO is facing? How can this issue be addressed? Discuss the issue briefly and provide at least one recommendation to address the issue. (4 marks) QUESTION 2 Goodguy manufactures dog beds. In March 2019, the manager decided the business needed to have the security of a short-term loan of $50,000 starting in May 2019 as its cash balance had been reduced because of recent equipment purchases. The bank would charge interest at the equivalent of 4 percent per annum on the loan and require the business to repay interest and principal on 31 May 2019. To consider the loan application, the bank requested the provision of a number of budgets for May including the Cash Budget. The following information is available: Budgeted sales are 120,000 units per month for April, June and July, and 80,000 units for May of 2019. The selling price is $52 per unit. Finished Goods inventory on April 1 for 26,000 units was $780,000. The company follows a policy requiring ending finished goods inventory each month to be 20% of next month's sales. There is no WIP. The inventory of raw materials on April 1 was 15,600kg (@$30/kg). The ending inventory is required to be 30% of next month's production requirements. Selling & administrative expenses are expected to be $85,000 plus 10% of sales (this includes depreciation of $16,500). The manufacturing costs budget (based on a practical capacity of 150,000 units per month) follows: Materials (0.25 kg per bed, @ $30 per kg). $1,125,000 Direct Labour (10 minutes per bed @ $30 per hour)....... 750,000 Variable Overhead (allocated @$10 per DLH)... 250,000 Fixed Overhead 180,000 Total $2,305,000 Budgeted Fixed manufacturing overhead includes $48,000 of depreciation. REQUIRED: a. Prepare the following budgets for April and May 2019: (10 marks) (1) Production Budget (ii) Materials Purchases Budget in dollars b. You have been provided with the following additional information: All sales are made on credit and customers pay 50% in the month of sale; 50 % in the month following. Assume that materials are paid 40% in the month purchased and 60% in the following month. Labour and relevant overhead costs are paid in the month the liability is incurred. Selling and administration expenses are paid each month as incurred. The opening cash balance at 1st May (before the loan drawdown) was $5500. Assume the short-term loan has been secured, prepare the Cash Budget for the month of May, 2019. (6 marks) c. The CEO of Goodguy Ltd., a decentralised company with 4 major divisions (all profit centres), is concerned that the preparation of static budgets by the CEO has resulted in the company's budgets being less effective and not helpful for decision making in a constantly changing operating environment. What is the issue that the CEO is facing? How can this issue be addressed? Discuss the issue briefly and provide at least one recommendation to address the issue. (4 marks)
