Determine the weekly demand and lead time, Operation Research

Family Application specialises in selling major appliances for use in kitchen remodelling.  One of its more popular items is the SubZero refrigerator.  Over the past 40 weeks, the store has collected data regarding the weekly demand for this refrigerator.  On the basis of these data, the following demand distribution has been estimated:

The store's policy is to reorder up to 15 refrigerators whenever the inventory on hand

Weekly Demand                     Probability

0                                              0.25

1                                              0.15

2                                              0.15

3                                              0.25

4                                              0.1

5                                              0.1

reaches five or fewer at the end of a week. The holding cost for each refrigerator is $2 per week, and the cost of reordering is $50. If a customer wants a SubZero refrigerator and Family is out of stock, the customer will go elsewhere and the sale is lost. The company estimates that it suffers a goodwill cost of $40 for each lost sale.

Current inventory is seven refrigerators. Lead time for delivery can be described by the following distribution:

Lead Time                   Probability

1 week                         0.3

2 weeks                       0.5

3 weeks                       0.2

(a)  Conduct a 10-week simulation of Family's inventory situation regarding the SubZero refrigerator to determine the total cost for this period. Use random number generator of Microsoft Excel to determine the weekly demand and to determine the lead time.  

(b)  SubZero is  offering Family a new policy of automatically delivering five refrigerators every two weeks. Conduct a 10-week simulation of Family's inventory situation under this plan and determine the total cost for the 10-week period.

(c)  On the basis of your answers to part (a) and (b), what would you recommend to Family management regarding the supplier's offer?

Posted Date: 2/28/2013 2:57:21 AM | Location : United States







Related Discussions:- Determine the weekly demand and lead time, Assignment Help, Ask Question on Determine the weekly demand and lead time, Get Answer, Expert's Help, Determine the weekly demand and lead time Discussions

Write discussion on Determine the weekly demand and lead time
Your posts are moderated
Related Questions
Classification of documents by information Characteristics: The schemes of classification advocated by Hanson and Grogan are mainly based on the information characteristics of

a)Draw a network for the project. b)Determine the critical path. Activity Duration Activity Duration 1-2 15 5-10 22 1-3 13 6-9 33 1-4 1

STANDARA DEVIATION Standard  deviation  is the  square  root of the  arithmetic  average of  squares of all  the deviations from the  mean. In short  it may  be defined  as th

Uses  of Mean  Deviation Mean  Deviation  is rarely being used as a measure of dispersion. But  due to  easy  and  simplicity  in calculation. It  is rather  useful  in busin

Solve by simplex method Maximize Z = 5x 1 + 3x 2 Subject to 3x 1 + 5x 2 ≤ 15 5x 1 + 2x 2 ≤ 10 &         x 1 ≥ 0, x 2  ≥ 0 [Ans. Max Z = 235/19

how does it work

Method of Concurrent Deviations The  coefficient  of concurrent  deviation or coefficient  of correlation  b the concurrent deviation  methods  is given  by the formula. R

we have three reservoirs with daily supplies of15, 20 and 25 litres of fresh water respectively. on each day we must supply four cities A B C D whose demands are 8 10 12 and 15 res

six operators are to be assigned to the 5 jobs with the cost of assignments

Method of calculation of Mode Calculation  of Mode  Individual  series: For determining  mode count the  number of times the  various  values  repeat  themselves and the  va