Q2/M2:

Solve Using Excel

2 incorrect as a production planning engineer, pls solve the two parts of the below question: Mark 0.00 out of 9.00 Gestion partl tot size-30 Units peric forecast 2020 20 comed anders 19 20 21 21 inventorys 15 units n light of the of the above data would you pis develop 2 Master Production Schedule for different safety stock (zero) and (10) respectively. SAFETY W1 W2 W3 WA SAFETY W2 ws WA STOCK-10 W 40 41 50 51 51 MDS 39 quantities X MDS 49 quantities X X X X X X Part II if you consider the Time Fence concepts for the safety stock zero fill the below table to show the quantities for the Master Production Schedule Demand Time Fence Planning Time Fence lot size 30 wa w forecas 20 20 commited ordered 21 21 Inventory in holds $ 20 19 20 20 W2 W3 W4 SAFETY STOCK=10w). units Inventory 38.66666667 On Hold 46.33333333 43.66666667 45.22222222 X X X X 2 incorrect as a production planning engineer, pls solve the two parts of the below question: Mark 0.00 out of 9.00 Gestion partl tot size-30 Units peric forecast 2020 20 comed anders 19 20 21 21 inventorys 15 units n light of the of the above data would you pis develop 2 Master Production Schedule for different safety stock (zero) and (10) respectively. SAFETY W1 W2 W3 WA SAFETY W2 ws WA STOCK-10 W 40 41 50 51 51 MDS 39 quantities X MDS 49 quantities X X X X X X Part II if you consider the Time Fence concepts for the safety stock zero fill the below table to show the quantities for the Master Production Schedule Demand Time Fence Planning Time Fence lot size 30 wa w forecas 20 20 commited ordered 21 21 Inventory in holds $ 20 19 20 20 W2 W3 W4 SAFETY STOCK=10w). units Inventory 38.66666667 On Hold 46.33333333 43.66666667 45.22222222 X X X X