complete all parts using excel

ne January 1, 2022, inventory of HD-240 is 2,000 units. Management desires an ending inventory cach quarter equal to 40% of the next quarter's sales, Sales in the first quarter of 2023 are expected to be 256 higher than sales in the same quarter in 2022 Instructions Prepare quarterly production budgets for each quarter and in total for 2022. Prepare a direct materia budget. 622.5 (LO 2), AP DeWitt Industries has adopted the following production budget for the first 4 months of 2022 Month Month January February Units 10,000 8,000 March April Units 5,000 4,000 Each unit requires 2 pounds of raw materials costing S3 per pound. On December 31, 2021, the ending raw materials inventory was 4,000 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month's production requirements