What is the minimum number of additional units

Assignment Help Operation Management

Reference no: EM131858638

Question: Consider a perishable product whose daily demand can range from a low of 31 to a high of 50. Demand is uniformly distributed over this range, so that sales of the product are equally likely to be anywhere from 31 to 50. Unsold units at the end of the day must be discarded.

a) The retailer selling the product wishes to maintain an 85% service level (i.e., probability of fulfilling demand should be at least 0.85). How many units should the retailer order each day?

b) What is the minimum number of additional units that the retailer should order each day if the desired service level is increased to 95%?

c) If the service level is 85%, what is the average numbers of units that are unsold each day?

d) If the retailer sells each unit for $10, what is the average daily revenue if the service level is 85%?

e) The retailer purchases each unit at a cost of $7. If the retailer is interested in maximizing expected profit, what is the optimal order quantity?

f) If the retailer were able to lower the unit purchase cost by 10%, what would be the corresponding percentage increase in profit?

g) The retailer sells a second products with similar price and purchase cost, but whose demand is uniformly distributed over the range of 36 to 45 (i.e., the mean of the two products are the same but their variances are different). If $10 is the selling price and $7 is the purchase cost, which product is more profitable (has a higher expected profit)? Compare the optimal order quantities for the two products.

h) Using Excel, generate the following plots for the two products discussed in g):

i) Expected profit versus order quantity (i.e., vary Q from 31 to 50 and plot the corresponding expected cost) for both products on the same figure,

ii) Expected revenue versus order quantity (i.e., vary Q from 31 to 50 and plot the corresponding expected cost) for both products on the same figure,

iii) Optimal order quantity versus the purchase cost (i.e., vary the purchase costs from 0 to 10 and plot the corresponding optimal order quantity).

Discuss the results observed.

Reference no: EM131858638

Questions Cloud

What are some likely future crimes : What are some likely future crimes, and how will future criminal activity differ from criminal activity today?

Draw the mirror images of the three cases for insertion : Draw the mirror images of the three cases for insertion into a Red-Black tree and explain how each situation is resolved.

Role of social media in emergency management : How critical is the role of social media in emergency management? Should Public Information Officers

Explain the meaning of a continuum of force : Explain the meaning of a continuum of force? How much force can be used by an officer when executing an arrest

What is the minimum number of additional units : What is the minimum number of additional units that the retailer should order each day if the desired service level is increased to 95%?

Share your results from the victim vs creator assessment : compare the victim, creator and growth mindsets, using your own words and examples. How are they similar, and how do they differ?

Recent terrorist attack in the new york city subway : Would you classify the recent terrorist attack in the New York City subway? Did the terrorist accomplish any objectives?

Write a program that implements radix sort on an array : Write a program that implements radix sort on an array of int values. You will need to make 10 passes, because an int can store numbers up to 2,147,483,648.

How effective were your choices in reducing prostitution : What solutions did you implement to reduce the prostitution problems in Central City? How effective were your choices in reducing prostitution

User Account

All Pages