CWD Electronics sells Televisions (TV), which it orders from the USA. Because of shipping and handling costs, each order must be for 5TVs. Because of the time it takes to receive an order, the company places an order every time the present stock drops to 5 TVs. It costs $50 to place an order. It costs the company $500 in lost sales when a customer asks for a TV and the warehouse is out of stock. It costs $100 to keep each TV stored in the warehouse. If a customer cannot purchase a TV when it is requested, the customer wi

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

CWD Electronics sells Televisions (TV), which it orders from the USA. Because of shipping and handling costs, each order must be for 5TVs. Because of the time it takes to receive an order, the company places an order every time the present stock drops to 5 TVs. It costs $50 to place an
order. It costs the company $500 in lost sales when a customer asks for a TV and the warehouse is out of stock. It costs $100 to keep each TV stored in the warehouse. If a customer cannot purchase a TV when it is requested, the customer will not wait until one comes in but will go to a competitor.
The following probability distribution for demand for TV has been and the time required to receive an order once it is placed (lead time) has the following probability distribution: (Attached)

The company has 3 TVs in stock. Orders are always received at the beginning of the week.
Note that a lead time of 2 weeks imply that an order placed in week one will arrive in week 4.

The time required to receive an order once it is placed (lead time) has the following probability 
distribution:

 

Time to Receive an Order (wk)    Probability
1                                                      .60 
2                                                      .20

3                                                      .20


Hint. No order is placed until the current order has arrived. Usage of all random numbers for lead time depend on stock arrivals in the model hence all numbers may not be used.

a) Construct the appropriate random number mappings for the random variables starting with .00. (lead & demand time)
b) Simulate CWD's ordering and sales policy for 20 weeks. 
c) Compute the average cost of the policy

demand .15 .84 .16 .12 55 .16 .84 .63 .33 57 .18
lead time .47 .74 .35 .56 .64
Use the following headings
21
Month OI URA IRN
55 .01 40
CAIRN POFEL
.26 23
.52
lead-
D D FEI SO order RN time
37 .70 56
IC
.99 .16
SOCOC TC
31
Transcribed Image Text:demand .15 .84 .16 .12 55 .16 .84 .63 .33 57 .18 lead time .47 .74 .35 .56 .64 Use the following headings 21 Month OI URA IRN 55 .01 40 CAIRN POFEL .26 23 .52 lead- D D FEI SO order RN time 37 .70 56 IC .99 .16 SOCOC TC 31
Demand per Week Probability
.05
.10
.20
.35
.20
.05
.05
0
1
2
3
4
5
6
Transcribed Image Text:Demand per Week Probability .05 .10 .20 .35 .20 .05 .05 0 1 2 3 4 5 6
Expert Solution
steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.