Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

A computer virus has destroyed some of the numbers in a Wagner-Whitin computatio

ID: 443130 • Letter: A

Question

A computer virus has destroyed some of the numbers in a Wagner-Whitin computation table that you were working on. The only information that remains is shown in the table below. i. (*16 points) Complete the following Wagner-Whitin solution table by filling all cells that are required to determine the optimal production plan over the five-month planning horizon. Note that per unit variable production or purchase cost are constant over time and may be ignored. The fixed order (setup) cost, A, and the monthly inventory holding cost rate, h, data are the same in each month. All missing information (e.g., cost & demand data) may be inferred from the visible entries in the table. [Write table cost entries in terms of A and h.]

Planning Period, t (months)

1

2

3

4

5

Demand à

50

D2 =________

75

50

D5 =________

jt = 1

A = _______

ß A + h ´ D2 = 320

770

2

400

3

910

4

5

Zt*

A

320

770

jt*

1

1

1

1

1

Q*t = Optimal Quantity

Planning Period, t (months)

1

2

3

4

5

Demand à

50

D2 =________

75

50

D5 =________

jt = 1

A = _______

ß A + h ´ D2 = 320

770

2

400

3

910

4

5

Zt*

A

320

770

jt*

1

1

1

1

1

Q*t = Optimal Quantity

Explanation / Answer

_______________________________________________________________________

   0          80            0           0             590

   

770 - 770  =0

400 -  320   = 80

910 - 320 =  590  

Demand =   2 *Demand

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote