Please create a chase and level policy aggregate plan, The forecasted values for the next 5 periods are 146.2,147.75,149.6667,146,144. The MAD tolerance is 10.

Level Policy
Period	1	2	3	4	5	Cost total
Beginning Inventory
Production
Demand
Workers Needed
Workers Available
Workers Hired
Workers Fired
End Inventory
Backlog
Undertime
Average Inventory

Chase Policy
	Week 1	Week 2	Week 3	Week 4	Week 5	Total Cost
Forecast	146.2	147.75	149.6667	146	144
Forecast in Units	147	148	150	146	144
Beginning Inventory
Production	147	148	150	146	144
Demand
Workers Needed
Workers Available
Workers Hired
Workers Fired
End Inventory
Backlog
Undertime
Regular Time

Develop a production plan for the next five weeks to meet the forecasted demand that minimizes the total production costs. You need to attempt (at a minimum) a level and chase production strategy for each product. Assume there are 480 manufacturing minutes in a day, 5 manufacturing days in a week and 52 working weeks in a year. Provide the total cost of your plan for the next five weeks and for each product type state the production quantity, the ending inventory, the number of units backordered, workers needed, and undertime in each week if applied. (Ending inventory and back orders must be zero at the period 25. Exceptions: level policies for product 3 and product 4 may have some ending inventory at the period 25 .) Also develop an MRP record for all the products and sub-products based on the given BOM to produce the forecasted demand. Refer to the tables in Appendix A. Then, create a MPS for the four sub-products based on those MRP records. With the MPS record of sub-products, perform a capacity plan to determine the number of machines you will need for your production plans and provide the total cost for the plan. Do not forget to subtract downtime from available hours. In considering downtime, each week is supposed to have non-stop 2400 minutes. Also, assume beginning inventory equals zero