Assignment
1. Bower is an outdoor clothing accessories chain that produces a line of hats for $10 from its Asian supplier, BowerSports. Unfortunately at the time of order placement, demand is uncertain. Bower forecasts that its demand is normally distributed with a mean of 2,100 and standard deviation of 1,200. The hats are sold for $22. Unsold hats have little salvage value: Bower simply donates them to charity.
a) What order quantity, Q, maximizes Bower's expected profit?
For the remaining questions assume the order quantity Q = 3,000 (Not what you calculated in part a)
b) What are the expected lost sales?
c) What are the expected sales?
d) What is the expected left over inventory?
e) What is its expected profit?
f) What is the expected fill rate
g) What is its stock-out probability?
2. Dan McClure's bookstore must decide how many copies of a book, Power and Self-Destruction, to order. The book's retail price is $20 and the wholesale price is $12. The salvage value is $8. Dan believes the demand can be represented by a normal distribution with a mean of 200 and a standard deviation of 80.
a) Dan prides himself on good customer service. His motto is "Dan has what you want to read". Using the NV model, what quantityshould he order for a 95 percent expected fill rate?
b) How many booksshould Dan order if instead he wants to achieve a 95 percent in-stock probability?
c) Dan decides to develop his own forecast of book sales. He collected data on recent books he felt matched the characteristics of Power and Self-Destruction. Using these data to construct an empirical distribution function, what would be the optimal order quantity, Q? (Assume Dan's initial forecast is 200 books.)
|
Book
|
Actual Demand
|
Forecast
|
A/F Ratio
|
|
Book
|
Actual Demand
|
Forecast
|
A/F Ratio
|
|
1
|
27
|
100
|
0.27
|
|
9
|
88
|
100
|
0.88
|
|
2
|
209
|
170
|
1.23
|
|
10
|
57
|
70
|
0.81
|
|
3
|
83
|
160
|
0.52
|
|
11
|
188
|
140
|
1.34
|
|
4
|
77
|
100
|
0.77
|
|
12
|
157
|
130
|
1.21
|
|
5
|
205
|
150
|
1.37
|
|
13
|
65
|
110
|
0.59
|
|
6
|
228
|
190
|
1.20
|
|
14
|
135
|
170
|
0.79
|
|
7
|
12
|
60
|
0.20
|
|
15
|
155
|
160
|
0.97
|
|
8
|
88
|
60
|
1.47
|
|
16
|
82
|
90
|
0.91
|
This data is also available for download as an Excel spreadsheet.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.