Problem no.4 (12%): (a) formulate the following 10-period deterministic dynamic inventory model (i.e., Wagner-Whitin) and solve using MS EXCEL Solver (or any other software of your choice). Assume an initial inventory of 50 units. Demand Di (units) Unit production cost ($) Unit holding cost ($) Setup cost ($) Period i 100 1 2 1 1 2 100 Ovau AWN 150 100 20 40 70 90 230 6 6 4 4 6 8 4 4 2 6 3 yl2jl421 100 200 200 200 300 300 300 300 180 8 9 10 140 50 ON (b) solve the above problem using the Silver-Meal approach. Problem no.4 (12%): (a) formulate the following 10-period deterministic dynamic inventory model (i.e., Wagner-Whitin) and solve using MS EXCEL Solver (or any other software of your choice). Assume an initial inventory of 50 units. Demand Di (units) Unit production cost ($) Unit holding cost ($) Setup cost ($) Period i 100 1 2 1 1 2 100 Ovau AWN 150 100 20 40 70 90 230 6 6 4 4 6 8 4 4 2 6 3 yl2jl421 100 200 200 200 300 300 300 300 180 8 9 10 140 50 ON (b) solve the above problem using the Silver-Meal approach