G10 G SECTION 4 - PROBLEM QUESTION - Total 26 marks A sales budget is given below for one of the products, the G400 which is manufactured by Hasta Brothers Ltd: 5 January 6 February 7 March April May 10 June 11 25,000 units 40,000 units 65 000 units 45.000 units 35,000 units 30,000 units 12 The inventory of finished goods at the end of each month must equal 20% of the next month's sales. However, on 13 December 31, the finished goods inventory totalled only 4,000 units. 15 Each unit of the product (G400) requires three kilograms of specialized material which costs $5.25 per ky. Since the availability of the material 16 is sometimes irregular, the company has a policy of maintaining a materials ending inventory at the end of each month equal to 17 30% of the next month's production needs. This requirement had been met on January 1 of the current year. 19 Required: 1. Prepare a Production budget showing the number of G400 units to be produced in each month for January February and March (12 marios) 18 20 21 28 24 January February March April 25 26 27 Krestructions SECTION 2 SECTION 3 SECTION 4 SECTION 5 SECTION New DELL