There are two parts to this assignment worth $10$ points each $(20$ points total$)$:Part $1$Based on the aggregate planning problem we solved in class $($ see tutorial below$)$ Create an plan for this problem that is a lower total cost than $$12,100.$ A copy of this solution can be found in the file$-$folder in a document titled "bicycle aggregate plan" as well as attached to this assignment. Limitations include:Whatever you choose as your Regular production must remain the same for the entire planning horizon.Costs associate with the options are listed at the bottom of the file.You start with $0$ inventory, however, can have a balance of inventory at the end of the $12$ month planning horizon.Overtime can NOT exceed $25\%$ of your Regular production time for any given period.Launch External ToolPart $2$Complete the MPS schedule $($MPS Assignment.doc$)$ including Projected Available, ATP, ATP cumulative, and MPS given the provided lot or batch size, current on$-$hand, and safety stock minimum.Attach your solutions. Supporting Materialsbicycle aggregate plan.docxMPS Assignment.doc