Instructions

Compile$/$consolidate the data for analysis

I suggest pivot tables or sumif function

Vlookup can combine data from multiple tables

Assumptions

Answer the following questions

Which product is at risk of obsolescence?

Which products are at risk of stocking out?

No new batches of these products have been started; thus in

order to determine when a new batch will reach the

customer, we have to add the lead times for each process

All batches in each inventory stage have just progressed to

that stage.

Is there a product that is likely to stock out?

The distributor tells your supply planner that they have too

much Albumin $25\%50$ML TAIWAN $20$MM and she should

stop making it$.$ Is this the right decision? Why$/$Why not?