Preparing a Production Budget Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales: January 41,000 February 38,000 March 50,000 April 51,000 Patrick's policy is to have 15% of next month's sales in ending inventory. On January 1, it is expected that there will be 4,600 drums of solvent on hand Required: Prepare a production budget for the first quarter of the year. Show the number of drums that should be produced each month as well as for the quarter in total. If required, round your answers to the nearest whole unit Patrick Inc. Production Budget For the Coming Quarter January February March 1st Quarter Total Sales 41.000 38,000 50,000 129,000 Desired ending inventory 5,700 7,500 7,650 20,850 x Total needs 46,700 45,500 57,650 149,850 x Less: Beginning inventory 4,600 5,700 7,500 17,800 x Units to be produced 42,100 39,800 50,150 132,050