Question

Download HW 14 (Excel download) and perform the necessary calculations. Then enter selected values below. What is the POHI value for Period 1? What is the POHI value for Period 6? What is the POHI value for Period 8?

Data is in excel table. Picture provided.

Answer 1

Answer 1: POHI of period 1= 121

Answer 2: POHI of period 6= 112

Answer 3: POHI of period 8= 122

Answer 4: MPS period 2: 35

Answer 5: MPS period 4: 35

Answer 6: MPS period 6: 35

Answer 7: ATP period 1: 121

Answer 8: ATP period 5: 5

Answer 9: ATP period 7: 35

Explained in image attached.

Period 4 6 Gross requirements GR 30 35 38 41 40 40 40 20 Customer orders CO 39 25 16 100 23 0 0 safety stock SS 105 igenning inventory- 120 inventory on hand IOH Projected inventory POHI 121 121 118 112 112 107 122 20 121 121 118 112 112 107 Net requirements NR 124 19 28 93 28 18 Planned order receipts (PR)/ Master production schedule MPS 140 35 35 35 105 35 35 35 available to promise ATP 121 10 19 24 12 35 35 steps IOH+PR-GR or PR-NRCO will be taken instead of GR whem CO>GRIOH- PIOH of last week projected inventory- NR- GR+ SS-IOH or O if negative more than or equal to NR in PR- multiples of lot size PR of preceeding week MPS- sum of CO until next POR- ATP: uction