Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Suppose an Excel spreadsheet model has been partially created as shown below. A 1 2 3 4 5 6 7 8 9 10 11 12 A From 0 0.2 0.5 0.9 B To 0.2 0.5 0.9 1 C Lead Time Probability Lead Time (in days) 1 2 3 4 0.2 0.3 0.4 0.1 D What formula should be used to generate a lead time (in days) from this distribution? =VLOOKUP(RAND(),A6:D9,3) =VLOOKUP(RAND(),A6:D9,4) =VLOOKUP(A6:A9,A6:D9,3) =VLOOKUP(A6:A9,A6:D9,4) E

Suppose an Excel spreadsheet model has been partially created as shown below. A 1 2 3 4 5 6 7 8 9 10 11 12 A From 0 0.2 0.5 0.9 B To 0.2 0.5 0.9 1 C Lead Time Probability Lead Time (in days) 1 2 3 4 0.2 0.3 0.4 0.1 D What formula should be used to generate a lead time (in days) from this distribution? =VLOOKUP(RAND(),A6:D9,3) =VLOOKUP(RAND(),A6:D9,4) =VLOOKUP(A6:A9,A6:D9,3) =VLOOKUP(A6:A9,A6:D9,4) E

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter4: Linear Programming Models
Section: Chapter Questions
Problem 52P
See similar textbooks
icon
Related questions
Question
Suppose an Excel spreadsheet model has been partially created as shown below. 1 2 3 4 5 6 7 8 9 10 11 12 A From 0 0.2 0.5 0.9 B To 0.2 0.5 0.9 1 C Lead Time Probability Lead Time (in days) 1 2 3 4 0.2 0.3 0.4 0.1 D What formula should be used to generate a lead time (in days) from this distribution? =VLOOKUP(RAND(),A6:D9,3) =VLOOKUP(RAND(),A6:D9,4) =VLOOKUP(A6:A9,A6:D9,3) =VLOOKUP(A6:A9,A6:D9,4) E
Transcribed Image Text:Suppose an Excel spreadsheet model has been partially created as shown below. 1 2 3 4 5 6 7 8 9 10 11 12 A From 0 0.2 0.5 0.9 B To 0.2 0.5 0.9 1 C Lead Time Probability Lead Time (in days) 1 2 3 4 0.2 0.3 0.4 0.1 D What formula should be used to generate a lead time (in days) from this distribution? =VLOOKUP(RAND(),A6:D9,3) =VLOOKUP(RAND(),A6:D9,4) =VLOOKUP(A6:A9,A6:D9,3) =VLOOKUP(A6:A9,A6:D9,4) E
Suppose an Excel spreadsheet model has been partially created as shown below. A 1 2 3 4 5 6 7 8 9 10 11 12 A From 0 0.2 0.5 0.9 B To 0.2 0.5 0.9 1 C Lead Time Probability Lead Time (in days) 1 2 3 4 0.2 0.3 0.4 0.1 D What formula should be used to generate a lead time (in days) from this distribution? =VLOOKUP(RAND(),A6:D9,3) =VLOOKUP(RAND(),A6:D9,4) =VLOOKUP(A6:A9,A6:D9,3) =VLOOKUP(A6:A9,A6:D9,4) E
Transcribed Image Text:Suppose an Excel spreadsheet model has been partially created as shown below. A 1 2 3 4 5 6 7 8 9 10 11 12 A From 0 0.2 0.5 0.9 B To 0.2 0.5 0.9 1 C Lead Time Probability Lead Time (in days) 1 2 3 4 0.2 0.3 0.4 0.1 D What formula should be used to generate a lead time (in days) from this distribution? =VLOOKUP(RAND(),A6:D9,3) =VLOOKUP(RAND(),A6:D9,4) =VLOOKUP(A6:A9,A6:D9,3) =VLOOKUP(A6:A9,A6:D9,4) E
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
SEE MORE TEXTBOOKS