Question: table [ [ Year , Month,Sales ] , [ Year 1 , January, 1 0 3 ] , [ February , 1 0 3

\table[[Year,Month,Sales],[Year 1,January,103],[February,103],[March,115],[April,76],[May,85],[June,105],[July,84],[August,132],[September,99],[October,83],[November,94],[December,83],[Year 2,January,88],[February,73],[March,79],[April,84],[May,74],[June,77],[July,82],[August,72],[September,81],[October,110],[November,49],[December,106],[Year 3,January,84],[February,137],[March,93],[April,109],[May,119],[June,128],[July,79],[August,127],[September,125],[October,96]]
Calculate the mean and standard deviation for monthly Teddy Bear demand.
\table[[,96.95833333],[,],[,19.16589672],[,]]
The store owner has just learned about the base stock policy, and would like to develop an appropriate base stock level for teddy bears. They place an order with their supplier in Mexico every 2 months, and the delivery leadtime is 1 month. They want to select the base stock level so that there is no more than a .05 probabiity of a stockout.
What is the expected on-order inventory for teddy bears?
Calculate the mean of the p+L-month demand distribution.
Calculate the standard deviation of the P+L-month distribution.
Calculate the appropriate base stock level if KABS is to meet their stockout probability requirement.
For each of the following situations, how would your base stock level for teddy bears change?
a. Mean demand increases, standard deviation decreases
b. Mean demand increases, standard deviation increases
 \table[[Year,Month,Sales],[Year 1,January,103],[February,103],[March,115],[April,76],[May,85],[June,105],[July,84],[August,132],[September,99],[October,83],[November,94],[December,83],[Year 2,January,88],[February,73],[March,79],[April,84],[May,74],[June,77],[July,82],[August,72],[September,81],[October,110],[November,49],[December,106],[Year 3,January,84],[February,137],[March,93],[April,109],[May,119],[June,128],[July,79],[August,127],[September,125],[October,96]] Calculate the mean and standard deviation for

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!