A local pharmacy orders 15 copies of a monthly magazine, Ask an Expert

Management Studies

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.

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M91890206

Have any Question?Write your Review or question?

Related Questions in Operation Management

Its pretty clear that if you can get a kardashian sister to

It's pretty clear that if you can get a Kardashian sister to advertise your product, you're pretty much guaranteed a sales increase. Imagine that Lerner started developing a fashion line outside of her Urban Decay busine ...

Please read the two 2 below discussions and write a

Please read the two (2) below discussions and write a response. Must be a minimum of 6 lines per discussion. Please include a reference in your response using APA format and cite the reference in the text. Discussion #1: ...

1 mark achin sells 3600 electric motors each year the cost

1. Mark Achin sells 3,600 electric motors each year. The cost of these is $200 each, and demand is constant throughout the year. The cost of placing an order is $40, while the holding cost is $20 per unit per year. There ...

1 according to the material presented in this class among

1. According to the material presented in this class, among the most important and essential functions of business leaders are: [Select all that apply] developing and executing a plan to drive the company’s competitors o ...

1 choose any 3 ebusiness tools used by amazon for

1. Choose any 3 Ebusiness tools used by AMAZON for connecting and communicating and discuss how it is being used and how it adds value to the Company? communicating internally 2. What are the key tenets of teamwork and c ...

1 if you were the ceo of toys r us - explain what caused

1. If you were the CEO of Toys R Us: - Explain what caused Toys R Us to fail. - What would your strategy and approach be to turn the Company around? Explain. - What would you have done to change the Company’s fate, so th ...

Feasibility analyses and business plans please respond to

Feasibility Analyses and Business Plans Please respond to the following: Develop an idea for a new business and conduct a feasibility analysis. Please be as creative as you like in the development of your idea (but as ca ...

Social networking sites are fast becoming corporate

Social networking sites are fast becoming corporate resources. Consider how Facebook may be used by an organization. Can you think of different ways in which organizations such as Coca-Cola, KFC, or Bank of America can u ...

Answer the following question 1- what makes jamie oliver

Answer the following Question : 1- What makes Jamie oliver management approach effective ? 2- Which area of his management approach is the most important in his management approach? 3- To what extent do professor Ariely' ...

1 describe each of the dimensions of organizational

1. Describe each of the dimensions of organizational structure. How are they important? 2. Select an organization. Consider your experience as a customer, how would you describe the organizational strategy? Does it alig ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert