Donated to hospitals and other health care facilities

Assignment Help Operation Management

Reference no: EM131133686

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: EM131133686

Questions Cloud

Find the optimal solution using graphical procedure : Consider the following linear program: what are the extreme points of the feasable region. Find the optimal solution using graphical procedure

Global competition in the consumer products industry : Then identify which of the four strategies Avon and P&G are trying to implement. After identifying the strategies Avon and P&G are using please describe and explain how and why each is pursuing the organizational strategy it has selected to penetrate..

Compare and contrast the bottom-up budgeting process : Compare and contrast the bottom-up budgeting process with the top-down budgeting process. Make sure to discuss their advantages and disadvantages in regard to estimating project budgets and when it is appropriate to use each process.

How work should be distributed during the final week : The campaign headquarters of Debbie Smith, a candidate for the Board of Supervisors, has 100 volunteers. With one week to go in the election, there are three major strategies remaining: media advertising, door-to-door canvassing, and telephone campai..

Donated to hospitals and other health care facilities : 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..

Considered as imperative component of an organization : Why should strategic management be considered as an imperative component of an organization? Include personal experiences in which it was and experiences in which it wasn’t and comment on the outcome of each circumstance

Motivate companies to evaluate training programs : How might course design differ for baby boomers compared to GenXers? Which design would you prefer and why? What can be done to motivate companies to evaluate training programs?

Evaluate the business-level strategy of victory motorcycles : Victory Motorcycles" Please respond to the following: Evaluate the business-level strategy of Victory Motorcycles to determine whether you believe the strategy is appropriate to offset forces in the industry. Provide specific examples to support your..

What are your views on just war : What are your views on "Just War"? Just war theory-the doctrine that war may be morally permissible under certain conditions-is a morally sound doctrine. Do you agree or disagree. Link this statement with some aspect of current events on warfare.

User Account

All Pages