0% found this document useful (0 votes)
14 views16 pages

Warehouse Task Utilization Analysis

The document outlines various exercises related to warehouse and service operations, including calculations for worker utilization, queue models, and service rates. It provides specific scenarios for tasks such as picking, loading, and customer service, with detailed metrics on process times, demand, and worker requirements. Additionally, it includes analysis of queue types and average waiting times for both warehouse operations and customer service scenarios.

Uploaded by

Elisa Cascales
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
14 views16 pages

Warehouse Task Utilization Analysis

The document outlines various exercises related to warehouse and service operations, including calculations for worker utilization, queue models, and service rates. It provides specific scenarios for tasks such as picking, loading, and customer service, with detailed metrics on process times, demand, and worker requirements. Additionally, it includes analysis of queue types and average waiting times for both warehouse operations and customer service scenarios.

Uploaded by

Elisa Cascales
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Exercise 1

The workers in a warehouse are in charge of the following tasks:


1) Supply pallets with products to the picking area. The process time is 150s per pallet and they have to move 15 pallets
2) Pick items ordered by the customers. They have to pick 280 items / h and the process time is 22 seconds per item.
3) Move pallets of finished products to the loading area. They have to move 18 pallets / hour and they take on average
4) Load trucks. They have to load on average 5 trucks per shift and they take 20 min per truck. A standard shift lasts 8 ho
Please answer the following questions:
a) Determine the number of workers needed in the warehouse assuming that the maximum utilization rate is 85%.
b) Estimate their utilization rate.
c) The warehouse has one dock for unloading incoming trucks. The arrival rate is 6 trucks / shift. The unload process time
M/M/1 queue model, what is the average number of trucks waiting? What's their average waiting time?

1 shift = 8 hours

Task Process time (s) S (Units/h) Demand (Units / h) D/S


Supply pallets to picking area 150 24 15 0.625
Picking 22 163.6363636 280 1.711111111
Move pallets to loading 100 36 18 0.5
Load trucks 1200 3 0.625 0.208333333
TOTAL 3.044444444

MAX Utilization 85%


N (Number of workers) 4

𝜆 (Arrival rate trucks/shift)


𝜆 (Arrival rate trucks/h)
6
0.75

𝜇 (Service rate trucks/h)


Process time (min) 30
2.0000
Utilization rate 37.50%
Lq 0.2250
Wq (min) 18.0
d they have to move 15 pallets/h.
time is 22 seconds per item.
our and they take on average 100s per pallet.
ruck. A standard shift lasts 8 hours.

m utilization rate is 85%.

shift. The unload process time is 30 min. Assuming a


waiting time?

U
15.6%
42.8%
12.5%
5.2%
76.1%
Exercise 2
A store receives on average 50 customers / hour. There are 3 cashiers and the average service time is 2.52 min per customer.
i) What is the type of queue using Kendall's notation? What is the servers utilization rate?
ii) Estimate the average queue length and the average waiting time in minutes.
To handle customer returns, there is another single independent server that takes on average 5 min per customer. There are o
wish to return items.
iii) What is the type of queue using Kendall's notation? What is the servers utilization rate?
iv) Estimate the average queue length and the average waiting time in minutes.

i) and ii)
Customers arrival rate 50 cust per hour
N
Service time 2.52 min 0.3
Service rate 23.80952381 cust per hour 0.129
1
Number of servers (N) 3 1 2
Queue type (Kendall not) M/M/3 0.059
2
Utiliization rate 70.0% 0 2
Average queue length 1.149 0.030
3
Average waiting time (Min) 1.3788 min 0 1
0.016
4
iii) and iv) 0 1
Returns arrival rate 9 cust per hour 0.009
5
Service time 5 min 0 0
Service rate 12 cust per hour
Number of servers (N) 1
Queue type (Kendall not) M/M/1
Utiliization rate 75.0%
Average queue length 2.25
Average waiting time (min) 15 min
me is 2.52 min per customer. The customers wait on a single line.

min per customer. There are on average 9 customers / hour that

Utilization U
0.4 0.5 0.70 0.75 0.80 0.85 0.90 0.95
0.267 0.500 1,633 2,250 3,200 4,817 8,100 18,050
2 4 3 5 7 11 9 15 12 19 17 27 27 42 57 88
0.152 0.333 1,345 1,929 2,844 4,426 7,674 17,587
1 3 2 5 6 11 8 14 11 19 16 26 26 42 56 88
0.094 0.237 1,149 1,703 2,589 4,139 7,354 17,233
1 2 2 4 6 10 8 14 11 18 16 26 26 41 56 87
0.060 0.174 1,000 1,528 2,386 3,906 7,090 16,937
0 2 1 4 6 10 8 13 11 18 16 26 26 41 56 87
0.040 0.130 0.882 1,385 2,216 3,709 6,862 16,678
0 1 1 3 5 10 7 13 10 17 15 25 25 41 55 87
0.98
48,020
147 226
47,535
146 226
47,160
146 226
46,844
146 225
46,566
145 225
Exercise 3
Customers arrive at Michael’s Clothing Shop at a rate of 12 per hour, distributed in a Poisson fashion. Michael’s service times
a) Find the percentage of time that Michael is busy.
b) Find the average number of customers waiting.
c) Find the average number of customers in the shop.
d) Find the average time (in minutes) a customer waits until it is his or her turn.
e) Find the average time (in minutes) a customer spends in the shop.
f) If now the demand increases to 24 cust / h, how many servers are needed to have a maximum utilization rate of 85%? How
long do they spend in the shop?

𝜆 (Arrival rate cust/h) 12

𝜇 (Service rate cust/h)


TBA (min) 5
15
p (Process time, min) 4
N (Number of servers) 1
Queue type (Kendall's notation) M/M/1

a)
Utilization (U) 80%

b)
Average number of customers waiting in the queue (Lq) 3.20

c)
Average number of customers in the shop (Ls) 4

d)
Average time a customer waits in the queue (Wq) 16 min

e)
Average time a customer spends in the shop (Ws) 20 min

f)

𝜆 (Arrival rate cust/h) 24

𝜇 (Service rate cust/h)


TBA (min) 2.5
15
p (Process time, min) 4
Max Utilization 85%
N (Number of servers) 2

Utilization (U) 80%


Average number of customers waiting in the queue (Lq) 2.844
Average number of customers in the shop (Ls) 4.444
Average time a customer waits in the queue (Wq) 7.11 min
Average time a customer spends in the shop (Ws) 11.11 min
ashion. Michael’s service times follow an exponential distribution, with an average of 4 min per customer.

m utilization rate of 85%? How long do customers have to wait in the line with these new conditions? How
mer.

How
Problem 4
The pickers in a distribution center are in charge of the following tasks:
- Picking online orders. It takes 5 min to pick an average of 20 items.
- Picking store orders. It takes 8 min to pick an average of 40 items.
- Sorting and packing online orders. Takes 7 min to sort 20 items.
- Packing store orders. Takes 3 min to pack 40 items.
a) The current demand is 1200 units / shift for online orders and 3000 units / shift for store orders. If there are 4 workers, wha
b) If the demand changes to 2000 units / shift for online orders and 2200 units / shift of store orders. How many workers are
c) If there are 3 pickers only working with the online orders, what is the maximum number of units / shift that they can handl

1 shift = 8 hours

Online orders / shift 1200


Store orders / shift 3000

Number of pickers 4

a)

Task Process time (min) Number of items


Picking online orders 5 20
Picking store orders 8 40
Sorting and packing online orders 7 20
Packing store orders 3 40

b)

Online orders / shift 2000


Store orders / shift 2200

Number of pickers 5

Task Process time (s/item) S (Units/h)


Picking online orders 15 240.0
Picking store orders 12 300.0
Sorting and packing online orders 21 171.4
Packing store orders 4.5 800.0

c)
Number of pickers 3
Utilization rate 85%

Task Process time (s/item) S (Units/h)


Picking online orders 15 240.0
Sorting and packing online orders 21 171.4
TOTAL

Demand (units / h) 255


Demand (units / shift) 2040
r store orders. If there are 4 workers, what is their current utilization rate?
of store orders. How many workers are needed to have a maximum utilization rate of 85%?
umber of units / shift that they can handle if their utilization rate is 85%?

Online orders / hour 150


Store orders / hour 375

Process time (s/item) S (Units/h) Demand (Units / h) D/S U


15 240.0 150 0.625 15.6%
12 300.0 375 1.25 31.3%
21 171.4 150 0.875 21.9%
4.5 800.0 375 0.46875 11.7%
TOTAL 3.21875 80.5%

Online orders / hour 250


Store orders / hour 275

Demand (Units / h) D/S U


250 1.04166666667 20.8%
275 0.91666666667 18.3%
250 1.45833333333 29.2%
275 0.34375 6.9%
TOTAL 3.76041666667 75.2%
1/S
0.0042
0.0058
0.0100
Mean queue length , 95% and 99% percentiles of the queue length M/M/N

Utilization U
N
0.3 0.4 0.5 0.70 0.75 0.80 0.85
0.129 0.267 0.500 1,633 2,250 3,200 4,817
1
1 2 2 4 3 5 7 11 9 15 12 19 17 27
0.059 0.152 0.333 1,345 1,929 2,844 4,426
2
0 2 1 3 2 5 6 11 8 14 11 19 16 26
0.030 0.094 0.237 1,149 1,703 2,589 4,139
3
0 1 1 2 2 4 6 10 8 14 11 18 16 26
0.016 0.060 0.174 1,000 1,528 2,386 3,906
4
0 1 0 2 1 4 6 10 8 13 11 18 16 26
0.009 0.040 0.130 0.882 1,385 2,216 3,709
5
0 0 0 1 1 3 5 10 7 13 10 17 15 25
0.005 0.027 0.099 0.784 1,265 2,071 3,536
6
0 0 0 1 0 3 5 9 7 13 10 17 15 25
0.003 0.018 0.076 0.702 1,161 1,944 3,383
7
0 0 0 1 0 2 5 9 7 12 10 17 15 25
0.002 0.012 0.059 0.631 1,071 1,831 3,245
8
0 0 0 0 0 2 4 9 6 12 9 17 15 24
0.001 0.008 0.046 0.571 0.991 1,729 3,118
9
0 0 0 0 0 2 4 8 6 12 9 16 14 24
0.000 0.006 0.036 0.517 0.920 1,637 3,003
10
0 0 0 0 0 1 4 8 6 11 9 16 14 24
0.000 0.004 0.028 0.471 0.856 1,553 2,895
11
0 0 0 0 0 1 3 8 6 11 9 16 14 24
0.000 0.003 0.022 0.429 0.798 1,475 2,796
12
0 0 0 0 0 1 3 8 5 11 8 16 14 23
0.000 0.002 0.018 0.392 0.746 1,404 2,702
13
0 0 0 0 0 0 3 7 5 11 8 15 13 23
0.000 0.001 0.014 0.359 0.698 1,338 2,615
14
0 0 0 0 0 0 3 7 5 10 8 15 13 23
0.000 0.001 0.011 0.329 0.654 1,277 2,533
15
0 0 0 0 0 0 2 7 5 10 8 15 13 23
0.90 0.95 0.98
8,100 18,050 48,020
27 42 57 88 147 226
7,674 17,587 47,535
26 42 56 88 146 226
7,354 17,233 47,160
26 41 56 87 146 226
7,090 16,937 46,844
26 41 56 87 146 225
6,862 16,678 46,566
25 41 55 87 145 225
6,661 16,446 46,314
25 40 55 86 145 225
6,480 16,235 46,084
25 40 55 86 145 224
6,314 16,039 45,870
25 40 55 86 145 224
6,161 15,857 45,669
24 40 54 86 144 224
6,019 15,686 45,480
24 39 54 86 144 224
5,886 15,525 45,300
24 39 54 85 144 224
5,760 15,371 45,129
24 39 54 85 144 223
5,642 15,226 44,965
24 39 54 85 144 223
5,530 15,086 44,808
23 39 53 85 143 223
5,424 14,952 44,656
23 38 53 85 143 223

Common questions

Powered by AI

The main challenge in meeting demand is ensuring that the process time for each task aligns with the number of workers and their shift capacity. For instance, if task times are high compared to demand, such as loading trucks which take 20 minutes per truck, workers may not be able to meet high demand even with a full shift of 8 hours. Efficient resource allocation depends on balancing these factors to avoid bottle-necking and exceeding maximum utilization rates .

An increase in demand from 12 to 24 customers per hour necessitates increasing the number of servers to maintain an 85% utilization rate, moving from typically 1-2 servers to potentially more. This change aims to prevent an overburdened system, ensuring waiting times remain manageable. As demand doubles, service rates must adjust to handle increased customer throughput without compromising customer service levels, necessitating additional staffing or efficiency improvements .

The assumption of an 85% maximum utilization rate acts as a benchmark for resource allocation, preventing overuse of staff and ensuring sufficient buffer for unpredictable demand surges. It informs decision-making by ensuring that workers are neither underutilized nor overstressed, fostering consistent task management and optimal workflow outcomes, thereby minimizing the risk of bottlenecks in logistics operations .

Customer arrival distribution following a Poisson model significantly impacts both queue lengths and waiting times. It suggests that arrivals are independent and occur at a constant average rate, which aids in predicting peak times, informing necessary adjustments in staffing levels to mitigate increased queue lengths. In retail, where varying demand is expected, correctly anticipating these distributions is crucial for minimizing customer wait times and ensuring efficient service .

To handle the increased demand of 2000 online and 2200 store orders per shift, staffing levels need to be carefully managed to prevent exceeding the 85% utilization rate. Given the tasks and their respective process times, the workforce must be adequately sized to process the combined demand without delay, likely requiring an increase to five or more workers to manage the throughput without overutilizing the current staff beyond acceptable limits .

Standard M/M/1 models, which typically assume single-server systems with exponential service times and Poisson arrivals, may not fully capture the complexity of warehouse operations involving multiple tasks and resource interdependencies. These models can oversimplify real-world phenomena by assuming independence among arrivals and departures, potentially leading to suboptimal resourcing decisions due to limitations in handling varied task details with nuances like simultaneous pallet movements and concurrent truck loadings .

The M/M/1 queuing model applied at the docking station, where the arrival rate is 6 trucks per shift, emphasizes a single server handling arrivals. The effectiveness of this model lies in its ability to calculate average wait times (18 minutes) and queue lengths (0.225 trucks), which help in aligning service rates with truck arrivals. However, the limited single server may lead to significant wait times under high peak arrival rates, reducing service efficacy .

Kendall's notation assists by providing a standardized way to denote the characteristics of a queue system. It defines the type of arrival process (M for Markovian/Poisson), service time distribution, and the number of service channels. For example, M/M/3 indicates a queue with Poisson arrivals, exponential service times, and three servers. Its primary purpose is to simplify the analysis of complex queue systems and to standardize comparisons across different operational settings .

The maximum utilization rate for workers in a warehouse is 85%. This rate is determined by dividing the total demand of tasks by the available supply capacity of the workers, ensuring that employees are not overburdened beyond their maximum productive capacity. Specifically, utilization is calculated by dividing the time utilized by the workers on tasks (sum of process times) by the total available work time in a shift .

Increasing the number of servers within a queuing system generally decreases utilization per server but also reduces customer waiting times. This trade-off improves customer experience by enabling faster service completion, reducing overall queue length, and spreading the workload more evenly across available servers. However, this requires careful balance to avoid underutilization and unnecessary resource expenditure .

You might also like