Excel worksheet W5Q1. Mistwood Pharmaceuticals produces 8 different types of drugs which must be refrigerated at all times. Due to the nature of their demand, Mistwood’s demand is very irregular so they must keep a large stockpile of the drugs in their warehouse. These drugs are typically stored in refrigeration units which are unique to each drug and the product must be rotated each day within each unit, so the drugs reach their maximum shelf life. Each of these refrigeration units have a weight and size (measured in ft2) which limit how much of each drug can be stored. At the moment, Mistwood’s warehouse has a size of 5,420 ft2 and can have a maximum weight of 52,160 lbs. Also, the current warehousing staffing can spend 250 hours/day rotating the drugs.
