Question 1

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 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?