To create a computer (their final product, named product A), company BashimoX needs to combine many different parts to create A.

Parts needed to combine and make the products:

D = 2 units of B + 2 units of C

B = 1 unit of E + 2 units of F

C = 1 unit of F

E = 3 units of F

A = 3 units of B + 2 units of D + 2 units of E

Inventory on hand:

A = 0

B = 30

C = 40

D = 10

E = 25

F = 0

Production lead time:

A, E and F = 1 week

C and D = 2 weeks

B = 3 weeks

Lot-for-lot production = item C

Lot sizes:

A = multiple of 25

B = multiple of 25

D = multiple of 50

E = multiple of 50

F = multiple of 125

There is an order of 20 units of product A to be delivered in week 15

1) In excel, make the full MRP schedule for the order of product A above to determine the planned order release of all the parts. Will the company be able to make the order?

2) In excel, make the full MRP schedule for the order but without any on hand inventory and scheduled receipt for all items. Will the company be able to make the order?

3) In excel, make the MRP schedule for item F when the company can only use one machine and make 125 units of itemF each week. Can the company make the order? Show the changed MRP schedule for item F and any other items impacted by the change.