- use excel to answer questions 1 and 2.

- formula, the calculation processes and solutions should be given. in addition to conclusions of your findings must be provided and justified.

- for this assignment you may refer to Chapter 13 "Determining the Optimal Level of Product Availability" Sunil Chopra and Peter Meindl, Supply Chain Management: Strategy, Planning, and Operation, Pearson, 2010.

1. Question 1.

Green Thumb, a manufacturer of lawn care equipment, has introduced a new product. Each unit costs $150 to manufacture, and the introductory price is to be $200. At this price, the anticipated demand is normally distributed, with a mean of = 100 and a standard deviation of = 40. Any unsold units at the end of the season are unlikely to be valuable and will be disposed of in a fire sale for $50 each. It costs $20 to hold a unit in inventory for the entire season.

a) How many units should Green Thumb manufacture for sale?

b) What is the expected profit from this policy?

c) On average, how many customers does Green Thumb expect to turn away because of stocking out?

2. Question 2.

The general manager of Green Thumb decides to conduct extensive market research for its new product. At the end of the market research, the manager estimates demand to be normally distributed, with a mean of = 100 and a standard deviation of = 15.

(use cost and price information from Question 1)

d) How should Green Thumb alter its production plan in Question 1 as a result of the market research?

e) How much increase in profit is it likely to observe?

f) How does the improved forecast affect the demand lost by Green Thumb because of understocking?