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

Objectives of strategic management, Problem What are important objectiv...

Problem What are important objectives of strategic management and the causes for failure t of strategic management Objectives To keep pace with the changing business e

Operations research, state phases of operations research and and their impo...

state phases of operations research and and their importance in solving problems

Precentile - measure of central tendency , Normal 0 false fal...

Normal 0 false false false EN-IN X-NONE X-NONE

Method of concurrent deviations, Method of Concurrent Deviations The  ...

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

Word problems based on formulation of linear programming, Word problems bas...

Word problems based on formulation of linear programming problems. 2.   A manufacturer produces nuts and bolts for industrial machinery. It takes 1 hour of work on machine 1 an

Linear regression, regression line drawn as y=c + 1075x, when x was 2, and ...

regression line drawn as y=c + 1075x, when x was 2, and y was 239, given that y intercept was 11. calculate the residual

Assumption of f- test- hypothesis testing, Assumption of F- Test The  ...

Assumption of F- Test The  theoretical assumption on which  F test  is based are: 1.The populations for  each sample must  be normally  distributed  with  identical  mean

Linear programming, A paper mill produces two grades of paper viz., X and Y...

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

Pay-off matrix , In a rectangular game, pay-off matrix of player A is as fo...

In a rectangular game, pay-off matrix of player A is as follows: Player B B1 B2 Player A A1 A2 i) Solve the game. ii) Write down the pay-off matrix of B and th

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