Old MathJax webview

please help me by using the excel the Wagner whithin .Thanks

this is a full question.Please help me the Wagner whithin by excel.Thanks

I aan Problem 2: (6.10/224 Silver et.al. (1998) Book) Consider a company facing a demand pattern and costs as follows: Month Sequential Requirements number (units) January 1 20 February 2 40 March 3 110 April 4 120 May 60 June 6 30 July 7 20 August 8 30 September 9 80 October 10 120 November 11 130 December 12 40 Total 800 Given: Fixed ordering cost A = $25.00, carrying cost r (per month) = $0.05 (Carrying costs are very high in this industry) and unit variable cost v= $4.00. Using a "three-month decision rule, the replenishment schedule and associated costs are as follows: a) Repeat using the Wagner-Whitin algorithm. 2 9 130 Problem 2: (6.10/224 Silver et.al. (1998) Book) Consider a company facing a demand patter and costs as follows: Month Sequential Requirements mumber January (units) 1 20 February 40 March 3 110 April 4 120 May 5 60 June 6 30 July 7 20 August 8 30 September 80 October 10 120 November 11 December 12 Total 800 Given: Fixed ordering cost A = $25.00, carrying cost r (per month) = $0.05 (Carrying costs are very high in this industry) and unit variable cost v = -$4.00. Using a "three-month decision rule, the replenishment schedule and associated costs are as fobws: Month 1 2 3 4 5 6 7 8 10 11 12 Total Starting 0 150 110 0 90 30 0 110 80 0 170 40 inventory Replenishment 170 0 0 210 130 0 0 290 0 800 Requirements 40 110 120 60 30 20 30 80 120 130 40 800 Ending inventory 150 110 0 90 30 0 110 80 0 170 40 0 780 Total replenishment costs: $110.00 Total carrying costs: $156.00 I Total replenishment + carrying: $256.00 40 9 0 0 0 20 so LIN SI I aan Problem 2: (6.10/224 Silver et.al. (1998) Book) Consider a company facing a demand pattern and costs as follows: Month Sequential Requirements number (units) January 1 20 February 2 40 March 3 110 April 4 120 May 60 June 6 30 July 7 20 August 8 30 September 9 80 October 10 120 November 11 130 December 12 40 Total 800 Given: Fixed ordering cost A = $25.00, carrying cost r (per month) = $0.05 (Carrying costs are very high in this industry) and unit variable cost v= $4.00. Using a "three-month decision rule, the replenishment schedule and associated costs are as follows: a) Repeat using the Wagner-Whitin algorithm. 2 9 130 Problem 2: (6.10/224 Silver et.al. (1998) Book) Consider a company facing a demand patter and costs as follows: Month Sequential Requirements mumber January (units) 1 20 February 40 March 3 110 April 4 120 May 5 60 June 6 30 July 7 20 August 8 30 September 80 October 10 120 November 11 December 12 Total 800 Given: Fixed ordering cost A = $25.00, carrying cost r (per month) = $0.05 (Carrying costs are very high in this industry) and unit variable cost v = -$4.00. Using a "three-month decision rule, the replenishment schedule and associated costs are as fobws: Month 1 2 3 4 5 6 7 8 10 11 12 Total Starting 0 150 110 0 90 30 0 110 80 0 170 40 inventory Replenishment 170 0 0 210 130 0 0 290 0 800 Requirements 40 110 120 60 30 20 30 80 120 130 40 800 Ending inventory 150 110 0 90 30 0 110 80 0 170 40 0 780 Total replenishment costs: $110.00 Total carrying costs: $156.00 I Total replenishment + carrying: $256.00 40 9 0 0 0 20 so LIN SI