QUESTIONS Doll, a Division of Relk Ltd., manufactures shall 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 3 per cent per annum on 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. $15 per unit. The selling price is Finished Goods inventory on April 1 for 20,000 units was $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 (520/kg). The ending Inventory is required to be 201 of next month's production requirements. Selling & administrative expenses are 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 @ 924 per hour) 240,000 Variable Overhead (allocated 083 per DLR) 30,000 Fixed Overhead (allocated per unit) 100,000 Total $870,000 Budgeted Pixed manufacturing overhead excludes $48,000 of depreciation REQUIRED: a) Prepare the following budgets for April and May 2019: (10 marks) (1) Production Budget (11) Materials Purchases Budget in dollars b) You have been provided with the following additional information The remaining 101 18 All sales are nade on credit and customers pay 50$ in the month of sale 408 in the month following: 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 marka) ht Uudes $40,000 of depreciation. REQUIRED: al Prepare the following budgets for April and May 2019: (10 marks) (il Production Budget (41) 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 sales 400 in the month following. The remaining 101 18 uncollectable. Assume that materials are paid 50% in the month purchased and 50in the following month. Labour and relevant overhead coats 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 prorit 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 statie budgets are not meeting the cost benefit test? What two alternatives to statie budgets can you suggest? (4 marks)