Determine the weekly demand and lead time, Operation Research

Assignment Help:

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?


Related Discussions:- Determine the weekly demand and lead time

Cost, Six Operators are to be assigned to five jobs with the cost of assign...

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

Trade literature - classification of documents, Trade Literature: Trad...

Trade Literature: Trade literature consists of documents that give information on the processes and materials involved in the manufacture of a product, various types of produc

Process, process of operation research

process of operation research

Usage in the context of library and information services, Usage in the Cont...

Usage in the Context of Library and Information Services: In library and information science, there is, however, no need for making such distinction between data and informati

Linear programming problem, A paper mill produces two grades of paper viz.,...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

Tied ranks equal or repeated rank, Tied Ranks Equal or Repeated Rank W...

Tied Ranks Equal or Repeated Rank When  two or more  items  have equal values  it is  difficult  to give ranks  to them. In  that case  the items are given  the average of the

Considerations for oral reporting, Considerations for Oral Reporting S...

Considerations for Oral Reporting Sometimes  the researcher has been asked to  make an oral presentation of his  research findings he should  bear in mind a few major  conside

North west corner rule, North West Corner Rule for Initial Solution: Now ...

North West Corner Rule for Initial Solution: Now by applying North West corner rule we can initial solution. According to this rule without regard to cost consideration the

Compute the joining, The Best Corporation is considering making either mino...

The Best Corporation is considering making either minor or major repairs to a malfunctioning production process.  When the process is malfunctioning, the percentage of defective it

Problem, A paper mill produces two grades of paper viz., X and Y. Because o...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd