Calculate the MPS for the attached file and please explain and show formulas on excel.  Lot Size 60 Quantity on hand 35 Lead Time 1 Week Week 1 2 3 4 5 6 7 8 Forecast 20 18 31 28 26 27 33 35 Customer Order Booked 15 17 9 14 9 0 7 0

Bookshelf Online: Operations Management - Mozilla Firefox myFranklin Norton THIS PAGE IS SAFE 3 ||| A Q G H Bookshelf Online: Oper X https://online.vitalsource.com/#/books/9780133872538/cfi/6/5101/4/2/6/2/2@0:97.5 8 468 1. Complete the MPS record in Figure 11.29 for a single item. Item: A Quantity on Hand: Forecast Customer orders (booked) Projected on-hand inventory MPS quantity Type here to search 35 1 20 15 Turnitin Operations Management 0 2 18 17 3 28 9 e X B What is Trend Projection X 28 14 Week 4 5 6 7 23 9 Order Policy: 60 units Lead Time: 1 week n 30 33 7 wa X 8 38 9 Daily News You Need to X C Q Search 05 E 2 zazzle.com/co/cart X 8 Application | Apply No X V @ O Aa NORT X + E F X 8:57 PM 9/12/2017 17