Solved: There are two products being produced by a firm with the following bills of material

1. There are two products being produced by a firm with the following bills of material: P (2) Q3) S(2) Routing Information (all times in hours) Product/ Lot Size Work Operation Setup Run Time Setup Total hours Per Unit per partTime 03 83 02 1.22 004 404 029729 032 532 016 816 012 1.212 .905 Part Center 20 100 of 1 0.8 1.2 0.4 0.7 0.5 1.3 0.6 0.9.005 0.6 0.8 40 100 T00 200 70 300 1 of1 50 200 of 2 50 300 2 of 2 100 200 1 of 2 100 300 2 of 2 1 of 1 1 of 1 1.6 0.8 1.2 0.5 With this information, set up the capacity bills and determine the capacity needed per work center to run the following master schedule: Week Product C Product D 40 20 50 45 Week 1 Week 2 Week 3 Work Center C 100 300 Fill in the Work Center Load in the table above.
There are two products being produced by a firm with the following bills of material: Routing Information (all times in hours) With this information, set up the capacity bills and determine the capacity needed per work center to run the following master schedule: Fill in the Work Center Load in the table above.

Expert Answer

The MRP Schedule: (Assume the items will be produced in same week in which they are ordered)

Item: C
OH = 0
LT = 0
SS = 0
Q = 20

1

2

3

Gross Req.

50

40

45

Scheduled receipts

0

0

0

Projected-on-hand

10

10

5

Net Requirement

50

30

35

Planned order Receipts

60

40

40

Planned order releases

60

40

40

Time/unit on WC #100

0.83

0.83

0.83

Load on WC #100

49.8

33.2

33.2

Time/unit on WC #200

0

0

0

Load on WC #200

0

0

0

Time/unit on WC #300

0

0

0

Load on WC #300

0

0

0

Item: P (1 per item C)
OH = 0
LT = 0
SS = 0
Q = 100

1

2

3

Gross Req.

60

40

40

Scheduled receipts

0

0

0

Projected-on-hand

40

0

60

Net Requirement

60

0

40

Planned order Receipts

100

0

100

Planned order releases

100

0

100

Time/unit on WC #100

0

0

0

Load on WC #100

0

0

0

Time/unit on WC #200

0.404

0.404

0.404

Load on WC #200

40.4

0

40.4

Time/unit on WC #300

0

0

0

Load on WC #300

0

0

0

Item: Q (3 per item C)
OH = 0
LT = 0
SS = 0
Q = 70

1

2

3

Gross Req.

180

120

120

Scheduled receipts

0

0

0

Projected-on-hand

30

50

0

Net Requirement

180

90

70

Planned order Receipts

210

140

70

Planned order releases

210

140

70

Time/unit on WC #100

0

0

0

Load on WC #100

0

0

0

Time/unit on WC #200

0

0

0

Load on WC #200

0

0

0

Time/unit on WC #300

0.729

0.729

0.729

Load on WC #300

153.09

102.06

51.03

Total Load on WC #100

49.8

33.2

33.2

Total Load on WC #200

40.4

0

40.4

Total Load on WC #200

153.09

102.06

51.03

Item: D
OH = 0
LT = 0
SS = 0
Q = 40

1

2

3

Gross Req.

15

20

18

Scheduled receipts

0

0

0

Projected-on-hand

25

5

27

Net Requirement

15

0

13

Planned order Receipts

40

0

40

Planned order releases

40

0

40

Time/unit on WC #100

1.22

1.22

1.22

Load on WC #100

48.8

0

48.8

Time/unit on WC #200

0

0

0

Load on WC #200

0

0

0

Time/unit on WC #300

0

0

0

Load on WC #300

0

0

0

Item: P (2 per item D)
OH = 0
LT = 0
SS = 0
Q = 100

1

2

3

Gross Req.

80

0

80

Scheduled receipts

0

0

0

Projected-on-hand

20

20

40

Net Requirement

80

0

60

Planned order Receipts

100

0

100

Planned order releases

100

0

100

Time/unit on WC #100

0

0

0

Load on WC #100

0

0

0

Time/unit on WC #200

0.404

0.404

0.404

Load on WC #200

40.4

0

40.4

Time/unit on WC #300

0

0

0

Load on WC #300

0

0

0

Item: R (1 per item D)
OH = 0
LT = 0
SS = 0
Q = 50

1

2

3

Gross Req.

40

0

40

Scheduled receipts

0

0

0

Projected-on-hand

10

10

20

Net Requirement

40

0

30

Planned order Receipts

50

0

50

Planned order releases

50

0

50

Time/unit on WC #100

0

0

0

Load on WC #100

0

0

0

Time/unit on WC #200

0.532

0.532

0.532

Load on WC #200

26.6

0

26.6

Time/unit on WC #300

0.816

0.816

0.816

Load on WC #300

40.8

0

40.8

Item: S (2 per item R)
OH = 0
LT = 0
SS = 0
Q = 100

1

2

3

Gross Req.

100

0

100

Scheduled receipts

0

0

0

Projected-on-hand

0

0

0

Net Requirement

100

0

100

Planned order Receipts

100

0

100

Planned order releases

100

0

100

Time/unit on WC #100

0

0

0

Load on WC #100

0

0

0

Time/unit on WC #200

1.212

1.212

1.212

Load on WC #200

121.2

0

121.2

Time/unit on WC #300

0.905

0.905

0.905

Load on WC #300

90.5

0

90.5

Load on WC #100

48.8

0

48.8

Load on WC #200

188.2

0

188.2

Load on WC #300

131.3

0

131.3

Load on WC #100

48.8

0

48.8

Load on WC #200

188.2

0

188.2

Load on WC #300

131.3

0

131.3

Week 1

Week 2

Week 3

C

D

C

D

C

D

Total Load on WC #100

49.8

48.8

33.2

0

33.2

48.8

Total Load on WC #200

40.4

188.2

0

0

40.4

188.2

Total Load on WC #300

153.09

131.3

102.06

0

51.03

131.3

Still stressed from student homework?
Get quality assistance from academic writers!