Question 3: Consider a product with the following MPS record: 1 30 35 2 25 13 3 40 32 4 15 5 30 23 6 25 7 7 43 8 22 Weeks Forecast Orders Available MPS ATP 60 60 60 60 Initial inventory is 20 units. a) Complete the Available and ATP rows of the MPS record. Assume that we are using discrete logic that we use in class. b) The following orders are received during week 1 (one by one, starting with the order in the first row) Order 1 2 3 Quantity 30 50 10 25 Due Date Week 2 Week 3 Week 5 Week 6 Decide whether you will accept or reject these orders as you receive them. If you need to reject an order on the date it is requested, state when it can be satisfied. Assuming that the customer accepts your suggestion, revise the MPS record based on these new orders. Orders are satisfied with first come first served rule and partial delivery is accepted