Need help doing an aggregated production plan in excel

Develop Aggregate Production Plan, Master Schedule, and Materials Requirement Plans for electric fans based off the sales forecast. Be sure to include the following: The determination of inventory requirements of the electric fans component parts and finished goodsThe selection of an appropriate inventory system (fixed order quantity, two bin method, etc.) to meet inventory requirements