Demand for the magazine varies

Assignment Help Operation Management

Reference no: EM131133769

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 pharmary 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.

please post excel and show formulas too please.

Reference no: EM131133769

Questions Cloud

Huge opportunity for an entire retail segment : The poor economic trend actually became a huge opportunity for an entire retail segment. Select one of the five environmental forces (social, economic, technological, competitive, and regulatory), discuss an actual trend that fits into that particula..

Brief history of the religion : Select a religion (other than your own) : 1) A brief history of the religion, 2) The religion’s major beliefs and practices that could impact the workplace such as holy days, dress, diet, and attitudes about women, racial minorities and gays, etc., a..

State null and alternative hypotheses : Bank manager Justin Goodson has a developed a new customer complaint system to reduce the time customers spend waiting for teller services during peak hour. Waiting time used to be an average of 10 minutes. State null and alternative hypotheses. Iden..

What are possible creative alternate actions : What are the possible consequences of specific and alternative actions (responses)? What are the relevant obligations from your analysis of the dilemma? What community standards of integrity provide you with guidance? What are possible creative alter..

Demand for the magazine varies : 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 pharmary purchases the mag..

In the clean air act as amended : In the Clean Air Act as amended, Congress allowed California, which has serious problems with air quality, to adopt its own standards for emissions from cars and trucks, subject to the approval of the Environmental Protection Agency (EPA) according t..

Make shareholder commitment : How does Gap INC make shareholder commitment? Strives to manage the company for the benefit of all stakeholders. Initiates and engages in genuine dialogue with stakeholders.

Search engines in global business : After reading the case study "Search Engines in Global Business" (pages 212-213) assess the catering search engines to local cultures. Within today's changing global business, what do you see happening in the next five years regarding search engines'..

Specific violations according to the nuremberg code : Did Milgram's Study violate the rights of his research subjects? What were the specific violations according to The Nuremberg Code, The Belmont Report, and/or 45 CFR 46? How could the study be conducted (research question, informed consent, nature of..

User Account

All Pages