5 Emphasis Heading 1 Normal Strong 10 11 12 13 14 15 Q.1 Noel Enterprises has budgeted sales in units for the next five months as follows: January 6,500 units February March April 5,500 units 7,200 units 4,500 units May Month: Sales - Units EI - Next Mth 3,600 units I Required Less: BI To be produced Past experience has shown that the ending inventory for each month must be equal to 10% of the next month's sales in units. The inventory on December 31 contained 450 units. The company needs to prepare a production budget for the first quarter of the year. a.. What should the opening inventory be in units for April? Fc Required Less: BI Emphasis v Heading 1 Normal Strong 10 11 12 13 14 15 To be produced Past experience has shown that the ending inventory for each month must be equal to 10% of the next month's sales in units. The inventory on December 31 contained 450 units. The company needs to prepare a production budget for the first quarter of the year. a.. What should the opening inventory be in units for April? b.. What is the total number of units to be produced in February? c. What is the desired ending inventory for February? For the quarter ending March 31? d. Provide the following for the first calendar quarter - A quarter is 3 months- Total sales Beginning inventory Ending inventory Total production [10 marks]