Prepare an MRP

Inventory/MRP

1. Dee and Carol are owners of a company supplying tin cans to countries at war. This war tin company has had a history of lack of control, particularly in the production-inventory area. Both Dee and Carol expect to sell 900 cases of tin cans over the next year (300 days), but they are uncertain as to how they should procure and inventory the cans.

Dee prefers to order the cans from an outside supplier where he can obtain them at $50.00 a case to be delivered within 2 days of an order. He estimates ordering cost at $20.00/order. Annual carrying charges include 15% interest charge along with insurance and taxes that amount to $2.50 per unit of average inventory (these are two separate costs).

Carol prefers to produce the cans internally. She claims that the company has the capacity to produce 6 cases a day. The setup cost (ordering) and carrying costs remain the same as if the cans were purchased outside.
What would be the inventory policy if Dee’s scheme is followed?
What would be the inventory policy if Carol’s scheme is followed?
Which would you recommend and why?

Suppose Dee finds a dealer that will give him a 2% discount if he orders more than 900 cases at a time. Would your recommendation change? Explain.
Suppose that Carol wants to investigate the possibility of backordering cases of cans. She estimates that the stockout cost would be only $.50 per case per year. What is Carol’s optimal inventory policy in this case?

What is your final suggestion to Dee and Carol concerning the inventory policy that they should adopt? Why?

Find the optimal order quantity and optimal cost for each of the models described above. Also illustrate each of the inventory policies with the appropriate diagram.

2. A product has the following bill of materials:

The Final Product requires 2 units of sub-assembly B and 2 units of sub-assembly C. Sub-assembly B requires 3 units of part H and one unit of raw material F. Sub-assembly C requires one unit of sub-assembly D, 3 units of part E and one unit of raw material F. Sub-assembly D requires 2 units of part E and 3 units of raw material G.
You also have the following information:

Receipts:

On Time to Scheduled To be received

Item Hand Produce Quantity in week:__

A 500 1 1000 1

B 1000 1 1000 2

C 1000 1

D 300 1

E 500 1

F 2000 3

G 400 2 6000 1

H 2500 2 4000 2

Prepare an MRP schedule for all of the components in the product to cover an 8-week planning horizon. You will first have to draw a Bill of Materials. Estimated demand for the final product is 3000 units in Week 7 and 4500 units in Week 8.