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
Scenario: You work as a junior employee in the marketing department of a medium-sized Hong Kong organisation. One of your major tasks is your involvement in your organization's


Problem based on graphical solution of a given LPP when feasible region is bounded. 1.    Solve the following linear programming graphically; Maximize and minimize z = 60x+

Drury's Principles: The basic principle, which still governs the selection of reading material for a library, was enunciated by Drury  in 1930. It states: "To provide the righ

Six Operators are to be assigned to five jobs with the cost of assignment in Rs. given in the matrix below. Determine the optimal assignment. Which operator will have no assignment

Purpose: The purpose of this study is to explore the effect of professional development on teachers' Lesson Planning, Class Management, Teaching Methods, Cooperation and Teac

Seven Step to a Successful Presentation There  are seven  basic  step which  need to  kept  in mind at the  time of  making  a presentation. How  successful one  is at eh end

In your role as a Consultant to a renowned organisation or institution, you have been asked to design and submit a research proposal to examine the future sustainability of its bus

explian completelly the operation reserch

Important of Probability The  various practical applications  of the  theory  of probability are: a.The fundamental  laws of statistic viz   the law  of statistical regular