Solve the following 10-period deterministic inventory model. Assume an initial inventory of 50 units.

This problem is purposely designed too big for hand computations, primarily to encourage the use of file excelWagnerWhitin.xls instead. The goal is to facilitate an understanding the big picture of the model without the burden of dealing with voluminous computations.

Period i 1 2 3 4 5 6 7 8 9 10 Demand D; (units) 150 100 20 40 70 90 130 180 140 50 Unit production cost ($) 6 6 446 + +26 8 4 4 Unit holding cost ($) 1 1 2 1 2 31421 Setup cost ($) 100 100 100 200 200 200 300 300 300 300