Homework: Material Requirements Planning Score: 0 of 10 pts Problem 14.22 40f 4
ID: 344536 • Letter: H
Question
Homework: Material Requirements Planning Score: 0 of 10 pts Problem 14.22 40f 4 (0 complete) Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table Period Gross requirements 30 1 2 3 45678 9 10 11 12 40 40 60 30 10 70 60 Holding cost $2.50/unitweek; setup cost- $200, lead time - 1 week; beginning inventory 40 Develop a lot-for-lot solution (enter your responses as whole numbers) Period Gross requirements 1 2 3 4 5 6789 10 11 12 30 40 40 60 30 10 7060 1401-10 On-hand at beginning of period 10 On-hand at end of period Order receipt Order release o 30 0 40 6 30 0 10 70 30 60 40 60 30 70 60Explanation / Answer
Please find below the filled up table with relevant values including missing values
Period
1
2
3
4
5
6
7
8
9
10
11
12
Gross requirement
30
40
40
60
30
10
70
60
On hand at beginning of period : 40
40
10
10
0
0
0
0
0
0
0
0
On hand at end of period
10
10
0
0
0
0
0
0
0
0
0
0
Order receipt
0
0
30
0
40
60
30
0
10
70
0
60
Order release
0
30
0
40
60
30
0
10
70
0
60
Following formula have been used :
On hand at beginning of period t = On hand at end of period t-1
On hand at end of period t = On hand at beginning of period t – Gross requirement of period t ( Provided On hand at beginning of period t > Gross requirement of period t)
On hand at end of period t = 0 ( Provided on hand at beginning of period t < = Gross requirement of period t )
Order receipt for period t = 0 ( provided on hand at beginning of period t >= Gross requirement of period t )
Order receipt for period t = Gross requirement for period t – On hand at beginning of period t ( provided on hand at beginning of period t < Gross requirement of period t)
Period
1
2
3
4
5
6
7
8
9
10
11
12
Gross requirement
30
40
40
60
30
10
70
60
On hand at beginning of period : 40
40
10
10
0
0
0
0
0
0
0
0
On hand at end of period
10
10
0
0
0
0
0
0
0
0
0
0
Order receipt
0
0
30
0
40
60
30
0
10
70
0
60
Order release
0
30
0
40
60
30
0
10
70
0
60
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.