need help please

Name Production and Materials Budgets April REQUIRED: Calculate the number of products that must be produced in February and the amount of materials required to be purchased in February using the following data. Projected Sales: January 30,000 units February 45,000 units March 40,000 units 17,000 units Desired ending inventory of completed units is 20% of the following month's production Each product requires 4 feet of material. The desired ending inventory of material is 30% of the next month's production need. a Number of units to be produced in February January February March April Item Sales Ending Inventory Total Needed Beginning Inventory Total Units to be Produced March April b) Feet of material to be purchased in February Item January February Total Units to be Produced Material per Unit Total Material Needed for Production Ending Inventory Total Need Beginning Inventory Total Material Needed