Question: **Please show in excel including calculations** Dana Farber also uses continuous review system to manage the inventory level of Belinostat, another type of lymphoma treatment

**Please show in excel including calculations**
Dana Farber also uses continuous review system to manage the inventory level of Belinostat, another type of lymphoma treatment drug. The ordering cost for this drug is $250 per order, and the yearly holding cost is $150 per dose. The forecasted annual (52 weeks) demand for Belinostat at Dana Farber is 15,600 doses. Millennium Pharmaceuticals, the supplier for Belinostat, has been very reliable in delivery, and maintains a constant lead time of 3 weeks. Based on Dana Farber's inventory usage records from the past, the standard deviation of the demand for Belinostate during the entire 3- week lead time period is 55 doses. Dana Farber would like to maintain a 95% service level. Please help Dana Farber determine the optimal order quantity (EOQ) and Reorder point (ROP) for BelinostatStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
