QUESTION 8 3 per annum on * was Doll, a Division of Relk Ltd., manufactures small jewellery boxes. In March 2019 the manager decided the business needed to have the security of a three-month loan of $100,000 starting on 1 May 2019 as its cash balance had been diminished because of recent equipment purchases. The bank would charge interest at the equivalent of cent per the loan and require the business to repay interest monthly commencing on 31 May 2019. The principal is paid at the end of the three-month term. 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 100,000 units per month for April, June and July, and 95,000 units for May of 2019. The selling price is $15 per unit. Finished Goods inventory on April 1 for 20,000 units $240,000. The company follows a policy requiring ending finished goods inventory each month to be 30% of next month's sales. There is no WIP. * The inventory of raw materials on April 1 was 11,400kg (@$20/kg). The ending inventory is required to be 20% of next month's production requirements. Selling administrative expenses expected to be $65,000 plus 10% of sales (this includes depreciation of $10,500). * The manufacturing costs budget (based on a practical capacity of 100,000 units per month) follows: Materials (0.25 kg per box, $20 per kg) $500,000 Direct Labour (6 minutes per box @ $24 per hour) 240,000 Variable Overhead (allocated @ $3 per DLH) 30,000 Fixed Overhead (allocated per unit) 100,000 Total $ 870,000 * Budgeted Fixed manufacturing overhead excludes $48,000 of depreciation. * & are REQUIRED: a) Prepare the following budgets for April and May 2019: (10 marks) (i) 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; 40% in the month following. The remaining 10% is uncollectable. Assume that materials are paid 50% in the month purchased and 50% 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 1 May (before the loan drawdown) was $2,000. Assume the short-term loan has been secured, prepare the Cash Budget for the month of May, 2019. (13 marks) c) The CEO of Relk Ltd., a decentralised company with 4 major divisions (all profit centres), is concerned that the use of static budgets is outdated. He believes the budgets are costly to produce and provide little benefit to the organization. What are some of the reasons the CEO might think static budgets are not meeting the cost benefit test? What two alternatives to static budgets can you suggest? (4 marks)
