Please only show how to do for PRODUCT #4

Plannin Develop a production plan for the next five weeks to meet the forecasted demand that minimizes the total production costs. You need to attempt 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 a 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 down time from available hours. In considering downtime, each week is supposed to have non-stop 2400 minutes long. Also, assume beginning inventory equals zero Plannin Develop a production plan for the next five weeks to meet the forecasted demand that minimizes the total production costs. You need to attempt 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 a 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 down time from available hours. In considering downtime, each week is supposed to have non-stop 2400 minutes long. Also, assume beginning inventory equals zero