Problem 12-9 Assume that you are the manager of a shop that assembles power tool
ID: 428800 • Letter: P
Question
Problem 12-9 Assume that you are the manager of a shop that assembles power tools. You have just received an order for 56 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws is Item Lead Time (weeks) On HandComponents A(2), B(1), C Saw 15 E(3), D(1) D(2), F(3) E (2), D(2) 10 5 65 20 10 30 Develop the material requirements plan for component E using lot-for-lot ordering. (Leave no cells blank - be certain to enter "O" wherever required.) Item: E(3) & E(2) LT 1 Beg Inv. 4 6 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order releaseExplanation / Answer
Solution-
Item: E(3) & E(2) LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
0
0
0
0
150
180
0
0
0
Scheduled receipts
0
0
0
0
0
0
0
0
0
Projected on hand
10
10
10
10
10
0
0
0
0
Net requirements
0
0
0
0
140
180
0
0
0
Planned order receipt
0
0
0
0
140
180
0
0
0
Planned order release
0
0
0
140
180
0
0
0
0
Item: E(3) & E(2) LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
0
0
0
0
150
180
0
0
0
Scheduled receipts
0
0
0
0
0
0
0
0
0
Projected on hand
10
10
10
10
10
0
0
0
0
Net requirements
0
0
0
0
140
180
0
0
0
Planned order receipt
0
0
0
0
140
180
0
0
0
Planned order release
0
0
0
140
180
0
0
0
0