Description
notes:only mrp, without capacity plan. if you work it out , please send me as an excel form. All the questions are in the pdf that is uploaded.By the way，if you need help,I will resend an example to you in order to deal with it asap.
Unformatted Attachment Preview
FACULTAD DE ADMINISTRACIÓN Y
DIRECCIÓN DE EMPRESAS. UPV
MRP PROBLEM
CORDA S.A. manufactures two product types, A and B. These products are made up of six
different parts, as illustrated in Figure 1 in the list:
A
B
2x
1x
1x
2x
C
D
E
F
3x
1x
3x
2x
G
H
G
D
Figure 1. Bill of materials for products A and B
The data of the safety stock (SS), lead time (LT), launched lot size (LOT), on hand
inventories (OHI), scheduled receipts (SR), week when scheduled receipts are received
(WSR), work centre where the operation is carried out (TC), setup time (TP), unit execution
time (TE), and the percentage of faults in each operation are as follows:
Item
A
Item
B
Item
C
SS
LT
Lot
OHI
SR
WSR
15
1
10
60
30
2
Operation
CT
TP (Hours)
TE (Hours)
Faults
1
3
1,6
0,35
0%
SS
LT
Lot
OHI
SR
WSR
30
1
8
130
30
1
Operation
CT
TP (Hours)
TE (Hours)
Faults
2
6
1,45
0,25
5%
SS
LT
Lot
OHI
SR
WSR
15
2
12
30
—
Operation
CT
TP (Hours)
TE (Hours)
Faults
3
4
0,75
0,15
2,4 %
4
3
0,65
0,3
3,5 %
FACULTAD DE ADMINISTRACIÓN Y
DIRECCIÓN DE EMPRESAS. UPV
Item
D
Item
E
Item
F
Item
G
Item
H
SS
LT
Lot
OHI
SR
WSR
-2
1
—-
Operation
CT
TP (Hours)
TE (Hours)
Faults
5
5
1,02
0,14
1,2 %
6
6
1,04
0,91
0,18 %
SS
LT
Lot
OHI
SR
WSR
10
2
5
10
—
Operation
CT
TP (Hours)
TE (Hours)
Faults
7
5
0,6
0,1
1,9 %
8
1
0,55
0,2
2,9 %
SS
LT
Lot
OHI
SR
WSR
40
1
1
-50
1
Operation
CT
TP (Hours)
TE (Hours)
Faults
9
6
1,1
0,1
2%
10
7
3
0,16
1%
SS
LT
Lot
OHI
SR
WSR
-3
1
330
90
3
Operation
CT
TP (Hours)
TE (Hours)
Faults
11
1
1,2
0,15
1,5 %
12
6
0,8
0,25
3%
SS
LT
Lot
OHI
SR
WSR
-1
1
—-
Operation
CT
TP (Hours)
TE (Hours)
Faults
13
4
1,1
0,1
1,05 %
Based on the sale forecasts made by the Sales Manager, a Master Production Plan has been
established in which the gross requirements are:
Period
1
2
3
4
5
6
7
8
A (units)
50
52
48
B (units)
60
59
61
80
And item G has further requirements of 50 spare parts in week 4.
–
Consider the MRP (WITH FAULTS) for the next 8 weeks. Make the comments you
consider necessary.
FACULTAD DE ADMINISTRACIÓN Y
DIRECCIÓN DE EMPRESAS. UPV
–
Calculate whether there will be sufficient capacity at work centre 1 over all periods of the
planning horizon. If not, can the problem be solved? How? (Specify a concrete way to
solve it)
Purchase answer to see full
attachment
