A local pharmacy orders 15 copies of a monthly magazine


A local pharmacy orders 15 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies. Historical records suggest that the probability distribution of demand is Poisson with a mean of 10. The pharmacy purchases the magazines for $2.25 and sells them for $5.00. Any magazines leftover at the end of the month are donated to hospitals and other health care facilities. Model this newsvendor problem in Excel. Test your model to show the corresponding profit when demand for the month is 5, 10, 15 or 20 magazines.

Request for Solution File

Ask an Expert for Answer!!
Operation Management: A local pharmacy orders 15 copies of a monthly magazine
Reference No:- TGS01376639

Expected delivery within 24 Hours