A toy manufacturing company has collected 10 periods of data for two of its toys
ID: 463188 • 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 Quentin' 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
Period
Order
1
2
3
4
5
6
7
8
9
10
X
141
126
119
135
122
127
121
128
126
131
Y
147
163
160
102
80
90
86
99
97
159
A time phased MRP record for X
Period
1
2
3
4
5
6
7
8
9
10
Average Invetory Level
Demand
141
126
119
135
122
127
121
128
126
131
Available
79
173
54
139
17
110
209
81
175
44
108.1
MPS
220
220
220
220
220
On hand
220
MPS quantity
220
A time phased MRP record for Y
Period
1
2
3
4
5
6
7
8
9
10
Average Invetory Level
Demand
147
163
160
102
80
90
86
99
97
159
Available
73
130
190
88
8
138
52
173
76
137
106.5
MPS
220
220
220
220
220
On hand
220
MPS quantity
220
A time phased MRP record for X
Period
1
2
3
4
5
6
7
8
9
10
Average Invetory Level
Demand
141
126
119
135
122
127
121
128
126
131
Available
79
119
0
122
0
121
0
126
0
0
56.7
MPS
166
257
248
254
131
On hand
220
MPS quantity
net requirement for next two period
A time phased MRP record for Y
Period
1
2
3
4
5
6
7
8
9
10
Average Invetory Level
Demand
147
163
160
102
80
90
86
99
97
159
Available
73
160
0
80
0
86
0
97
0
0
49.6
MPS
250
182
176
196
159
On hand
220
MPS quantity
net requirement for next two period
Period
Order
1
2
3
4
5
6
7
8
9
10
X
141
126
119
135
122
127
121
128
126
131
Y
147
163
160
102
80
90
86
99
97
159
A time phased MRP record for X
Period
1
2
3
4
5
6
7
8
9
10
Average Invetory Level
Demand
141
126
119
135
122
127
121
128
126
131
Available
79
173
54
139
17
110
209
81
175
44
108.1
MPS
220
220
220
220
220
On hand
220
MPS quantity
220
A time phased MRP record for Y
Period
1
2
3
4
5
6
7
8
9
10
Average Invetory Level
Demand
147
163
160
102
80
90
86
99
97
159
Available
73
130
190
88
8
138
52
173
76
137
106.5
MPS
220
220
220
220
220
On hand
220
MPS quantity
220
A time phased MRP record for X
Period
1
2
3
4
5
6
7
8
9
10
Average Invetory Level
Demand
141
126
119
135
122
127
121
128
126
131
Available
79
119
0
122
0
121
0
126
0
0
56.7
MPS
166
257
248
254
131
On hand
220
MPS quantity
net requirement for next two period
A time phased MRP record for Y
Period
1
2
3
4
5
6
7
8
9
10
Average Invetory Level
Demand
147
163
160
102
80
90
86
99
97
159
Available
73
160
0
80
0
86
0
97
0
0
49.6
MPS
250
182
176
196
159
On hand
220
MPS quantity
net requirement for next two period
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.