Question

Given the following data, develop MRP tables and indicate the Planned order releases for all items....

Given the following data, develop MRP tables and indicate the Planned order releases for all items.

A is an MPS item. A needs 2 C's and 3 F’s. F needs 3 C’s. (I eliminated scheduled receipts since the problem did not have scheduled receipts.)

Period

6

7

8

GR-A

400

0

300

On hand inventory for all items is 200 and lead time for A is 1 period, and LT for all other items is 2 periods. Use lot-for-lot for A and a lot size of 500 or multiples of 500 for C and F.

Draw the Bill of Materials                                                           Fill up the Low level code Table

Item

Low level code

A

C

F

A

1

2

3

4

5

6

7

8

GR

EI

NR

PO Receipt

PO Release

C

1

2

3

4

5

6

7

8

GR

EI

NR

PO Receipt

PO Release

F

1

2

3

4

5

6

7

8

GR

EI

NR

PO Receipt

PO Release

Given the following data, develop MRP tables and indicate the Planned order releases for all items.

A is an MPS item. A needs 4 C's, 2 F’s and 5 G’s. F needs 4 C’s and G needs 2 C’s. (I eliminated scheduled receipts since the problem did not have scheduled receipts.)

Period

6

7

8

GR-A

0

100

900

On hand inventory for all items is 300 and lead time for A is 1 period, and LT for all other items is 2 periods. Use lot-for-lot for A and a lot size of 500 or multiples of 500 for C, F and G.

Draw the Bill of Material                  Fill up the Low level code Table

Item

Low level code

A

C

F

G

A

1

2

3

4

5

6

7

8

GR

EI

NR

PO Receipt

PO Release

C

1

2

3

4

5

6

7

8

GR

EI

NR

PO Receipt

PO Release

F

1

2

3

4

5

6

7

8

GR

EI

NR

PO Receipt

PO Release

G

1

2

3

4

5

6

7

8

GR

EI

NR

PO Receipt

PO Release

Homework Answers

Answer #1

1)

BOM/Product Structure Tree:

Low Level Code Table:

Item Low Level Code
A 0
C 2
F 1

2) Product Structure Tree is following

Low Level Code Table is following

Item Low Level Code
A 0
C 2
F 1
G 1

MRP Schedule is following

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Given the following data, develop MRP tables and indicate the Planned order releases for all items....
Given the following data, develop MRP tables and indicate the Planned order releases for all items. A is an MPS item. A needs 4 C's, 2 F’s and 5 G’s. F needs 4 C’s and G needs 2 C’s. (I eliminated scheduled receipts since the problem did not have scheduled receipts.) Period 6 7 8 GR-A 0 100 900 On hand inventory for all items is 300 and lead time for A is 1 period, and LT for all other...
Given the following data, develop MRP tables and indicate the Planned order releases for all items....
Given the following data, develop MRP tables and indicate the Planned order releases for all items. A is an MPS item. A needs 2 C's and 3 F’s. F needs 3 C’s. (I eliminated scheduled receipts since the problem did not have scheduled receipts.) Period 6 7 8 GR-A 400 0 300 On hand inventory for all items is 200 and lead time for A is 1 period, and LT for all other items is 2 periods. Use lot-for-lot for...
Given the following data, develop MRP tables and indicate the Planned order releases for all items....
Given the following data, develop MRP tables and indicate the Planned order releases for all items. A is an MPS item. A needs 4 C's, 2 F’s and 5 G’s. F needs 4 C’s and G needs 2 C’s. (I eliminated scheduled receipts since the problem did not have scheduled receipts.) Period 6 7 8 GR-A 0 100 900 On hand inventory for all items is 300 and lead time for A is 1 period, and LT for all other...
Solve the MRP Item                         LLC    Leadtime      Lot Sizing Rule
Solve the MRP Item                         LLC    Leadtime      Lot Sizing Rule Skate 1 1 Lot for Lot Lace 1 1 FOQ = 500 Box 1 2 FOQ = 500 Board 1 2 Lot for Lot Wheel Assembly 2 1 FOQ = 800 Body 2 2 Lot for Lot Axle 2 1 Lot for Lot Hardware 2 3 FOQ = 1500 BOM                                                                         Draw Product Structures Here Boxed Skates       Skates (2)             Body             Axle (2)             Hardware             Wheel Assembly (2)       Laces (2)       Box Skateboard       Board       Wheel Assembly (4)       Axle (2)...
Solve the MRP Item                         LLC    Leadtime      Lot Sizing Rule
Solve the MRP Item                         LLC    Leadtime      Lot Sizing Rule Skate 1 1 Lot for Lot Lace 1 1 FOQ = 500 Box 1 2 FOQ = 500 Board 1 2 Lot for Lot Wheel Assembly 2 1 FOQ = 800 Body 2 2 Lot for Lot Axle 2 1 Lot for Lot Hardware 2 3 FOQ = 1500 BOM                                                                         Draw Product Structures Here Boxed Skates       Skates (2)             Body             Axle (2)             Hardware             Wheel Assembly (2)       Laces (2)       Box Skateboard       Board       Wheel Assembly (4)       Axle (2)...
Problem 12:9 Assume that you are the manager of a shop that assembles power tools. You...
Problem 12:9 Assume that you are the manager of a shop that assembles power tools. You have just received an order for 57 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws is Item Lead Time (weeks) On Hand Components Saw 2 15 A(2), B(1), C(4) A 1 10 E(3), D(1) B 2 5 D(2), F(3) C 2 65 E(2), D(2) D 1 20 E 1 10 F 2 30   ...
MRP IN MANUFACTURING 1. Each E subassembly is made up of 6 G parts, 20 H...
MRP IN MANUFACTURING 1. Each E subassembly is made up of 6 G parts, 20 H parts, and ONE J part. Draw the product structure tree diagram. Using the product structure tree diagram and the information provided below, Completeth e following MRP Report Transaction processing for PART E and PART G ONLY if the following information is provided: ( Do not order more quantity of any resources that are needed to maintain the production) E subassembly G part H part...
Product Y is made from one component P, three components Q, and one 2 components R.  P...
Product Y is made from one component P, three components Q, and one 2 components R.  P is made from two parts S, Q is made from one S, and R is made from two part S and three part T.  Other data includes: Part                 Lead time             Lot size                   On hand                 Scheduled receipts         Safety Stock Y                         1                                 lot-for-lot               30                                              none                                          5 P                        2                                   40                              15                                              none                                          none Q                        2                                 100                               8                                               none                                          8 R                        3                                 120                             30                                              none                                          none S                         2                                 500                             20                                              500, week 1                          20 T                         2                                 600                           370                                             none                                          50 a.    Draw the BOM for product Y. b. Complete the MRP explosion for product Y.  Identify any problems, and discuss possible solutions Master Production Schedule Finished...
Problem L You work for a landscaping company. You need four poles and 2 cubic yards...
Problem L You work for a landscaping company. You need four poles and 2 cubic yards of mulch for every tree that is planted. Calculate the Material Requirements Plan below. The beginning inventory for each item has been given. Week Beg. Inv. 1 2 3 4 5 6 7 8 Quantity 72 65 30 64 Tree Lead Time = 1 wk Lot for Lot Gross Requirements Scheduled Receipts Projected On-Hand 2 Net Requirements Planned Order Receipts Planned Order Releases Poles...
Calculate the cost of operating under the different MRP lot sizing techniques: Lot-for-Lot (L4L) Economic Order...
Calculate the cost of operating under the different MRP lot sizing techniques: Lot-for-Lot (L4L) Economic Order Quantity (EOQ) Least Total Cost (LTC) Least Unit Cost (LUC) Compare your results and state which method is the most cost efficient in this situation. Consider the following MRP lot sizing problem: Cost per item $50 Order/setup cost $75 Inventory carrying cost per item per week $1 Weekly net requirements: 1 2 3 4 5 6 7 8 75 90 100 90 80 95...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT