To create a computer labelled "A", company BashimoX needs to combine many different parts to create A.

Parts needed to combine and make the products:

Parts B,C,D, E and F are used in creating the final product (A). To make part D it requires combining 2 parts labelled B and 2 parts labelled C. The different combinations to make the parts are listed below:

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 = 1 week

E = 1 week

F = 1 week

C = 2 weeks

D = 2 weeks

B = 3 weeks

Lot-for-lot production quantity = item C

Lot sizes for producing items:

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?