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

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

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.