A toy manufacturing company has collected 10 periods of data for two of its toys
ID: 1220109 • Letter: A
Question
A toy manufacturing company has collected 10 periods of data for two of its toys, X and Y. Using the two data sets as gross requirements data, construct MRP time-phased records. Using Excel spreadsheet, create four time-phased records, two for each data set. For one case, use a lot size of 220 units, and for the other use an order quantity equal to the total net requirements for the next two periods. In all four records, start with a beginning inventory of 220 units and compute the average inventory level held over the 10 periods. What do the results mean?
Explanation / Answer
Demand
Current
1
2
3
4
5
6
7
8
9
10
X (Gross requirement)
141
126
119
135
122
127
121
128
126
131
scheduled receipt
220
257
249
257
Projected inventory balance
220
299
173
311
176
54
176
55
129
3
1596
Net requirement
Planned order
Planned received
Y (Gross requirement)
147
163
160
102
80
90
86
99
97
159
scheduled receipt
220
182
176
196
157
Projected inventory balance
220
293
130
152
50
146
56
166
67
127
1407
Net requirement
Planned order
Planned received
In this problem as we do not have any planned order and planned received we calculate the time phase on the basis of gross requirement. When gross requirement more than the inventory available we rescheduled the receipt as per the question.
Therefore the average inventory requirement is:
In product X (1596/10=159.6)
In product Y (1407/10=140.7)
Demand
Current
1
2
3
4
5
6
7
8
9
10
X (Gross requirement)
141
126
119
135
122
127
121
128
126
131
scheduled receipt
220
257
249
257
Projected inventory balance
220
299
173
311
176
54
176
55
129
3
1596
Net requirement
Planned order
Planned received
Y (Gross requirement)
147
163
160
102
80
90
86
99
97
159
scheduled receipt
220
182
176
196
157
Projected inventory balance
220
293
130
152
50
146
56
166
67
127
1407
Net requirement
Planned order
Planned received
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.