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
Problem: A policy maker is considering several policy options that lead to different utility levels of different individuals a) Which Policy is would be optimal according t

Question A The basic characteristic feature of Operations Research is that it employs mathematical representations or models to analyse problems. Explain the methodology of Operat

#what is the similarity and differences between transportation and linear programing models?

mile-high microbrewery makes a light beer and a dark beer. mile-high has a limited supply of barley, limited bottling capacity, and a limited market for light beer. profits are $0.

A paper mill products two grade of paper viz., X & Y. Because of raw material restriction, it cannot produce more than 400 tons of grade X paper & 300 tons of grade Y paper in a we

Problem 1 (Problem 23, page 507) At a machine tool plant, five jobs must be completed each day. The time it takes to do each job depends on the machine used to do the job. If a mac

Model building is the essence of the operations research approaches?

Form of t- Distribution 1. The students  t - distribution  like the  normal  distribution has bell shaped frequency  curve which is symmetrical. The only  parameter which  det

Solve the following Linear Programming Problem using Simplex method. Maximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 = 4 X1 - X2 = 2 X1, X2 = 0