Exercise MRP 1 and solutions PDF

Preview

Summary

Ejercicio grupo EUS...

Description

Exercise MRP I and its solution Product X, which takes 102 minutes to be produced, and which has the manufacturing structure in the form of the product structure that is presented in the below figure, where the number of units of each component or subset is indicated to obtain a unit of the upper set. Take into account that for the aforementioned components we apply the master production program and the data of the inventory registry file that are provided in charts 1 and 2, respectively. It is needed to elaborate the MRP by using the below template and taking into consideration the following restrictions: - the lot to lot sizing technique for elements X, A and B - the technique of the constant period (2 periods) for element C. - the technique of the minimum total cost for element D - the Silver-Meal technique for element E. The cost of possession is € 5 per unit and period and the emission cost is € 900 per order.

Chart 1: Master Production Schedule and External Demand for component A MPS X A

1

2

3

4

5 30

40

Chart 2: Inventory Records File Item

Ss

Ts

Av.

X A B C D E

0 20 5 30 30 0

1 2 1 1 2 2

0 40 0 50 60 0

Sched. Rec. 10 at t=4 20 at t=6 ----10 at t=7 ---

6 50

7 20

8 40

D - Minimum Total Cost Cp per lot(i) = (Cp unit * NN(i) * #weeks at warehouse(i)) + Cp per lot(i-1) Periods

NN

Q

#weeks at warehouse

4 4&5 6 6 6&7

30 150 60 60 110

30 180 240 60 170

0 1 2 0 1

Cp per lot 0 750 1350 0 550

Ce per lot 900 900 900 900 900

E – Silver Meal Cp per lot(i) = (Cp unit * NN(i) * #weeks at warehouse(i)) + Cp per lot(i-1) Periods

NN

Q

# of periods

#weeks at warehouse

4 4&5 4&5&6 4&5&6&7 7

20 50 20 40 40

20 70 90 130 40

1 2 3 4 1

0 1 2 3 0

Cp per lot 0 250 450 1050 0

Ce per lot 900 900 900 900 900

Total Cost per lot=Cp+Ce 900 1150 1350 1950 900

Total Cost/#of periods 900 575 450 487,50 900

SOLUTION...