Description
Decision support, excel Please see questions that are attached and please show work. Thank you for your help
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
hey buddy, please find attached the solution to your assignment.
Running Head: DECISION SUPPORT ASSIGNMENT
Decision Support Assignment
Name
Instructor
Course
Date
1
DECISION SUPPORT ASSIGNMENT
2
Problem 1
Average time a ticket buyer must wait:
λ = 10⁄hour
μ = 12⁄hour
Wq = λ⁄μ(μ − λ) = 10⁄12(12 − 10) = 0.417 hours = 25 minutes
𝐖𝐪 = 𝟐𝟓 𝐦𝐢𝐧𝐮𝐭𝐞𝐬
The portion of time the ticket seller is busy:
p = λ⁄μ = 12 = 0.833hours = 50 minutes.
10
𝐩 = 𝟓𝟎 𝐦𝐢𝐧𝐮𝐭𝐞𝐬
Problem 2
Average number of parts waiting to be worked on:
λ = mean number of part arrivals per hour = 60⁄7.5 = 8 parts per hour.
μ = mean service rate = 10 parts⁄hour
L = λ⁄(μ − λ) = (10−8) = 4 parts
8
𝐋 = 𝟒 𝐩𝐚𝐫𝐭𝐬
The percentage of time the operator is working:
DECISION SUPPORT ASSIGNMENT
3
p = λ⁄μ = 10 = 0.8 = 80%
8
𝐩 = 𝟖𝟎%
The percentage of time the machine is idle:
I = 1 − p = 1 − 0.8 = 0.2 = 20%
𝐈 = 𝟐𝟎%
Problem 3
λ = 4 airplanes per hour
μ = 60⁄12 = 5 per hour
a) Lq = λ2 ⁄μ(μ − λ) = 42 ⁄5(5 − 4) = 3.2
𝐋𝐪 = 𝟑. 𝟐
b) Wq = λ⁄μ(μ − λ) = 4⁄5(5 − 4) = 0.8 hours = 48 minutes
𝐖𝐪 = 𝟒𝟖 𝐦𝐢𝐧𝐮𝐭𝐞𝐬
1
...