Business Use of a Spreadsheet by Cici’s Furniture

$19.95

Add to cart
Essay #: 072939
Total text length is 15,680 characters (approximately 10.8 pages).

Excerpts from the Paper

The beginning:
Business Use of a Spreadsheet by Cici’s Furniture
Executive Summary
One of the classic challenges of any service-oriented business is how to best align supply of servers (for example, waiters, cashiers, etc.) with customer demand for service. This challenge is often referred to as queuing analysis. This description of a model focuses on the business use of a spreadsheet by Cici’s Furniture, a wholesale furniture store with a single location in Syracuse, New York, for queuing analysis. Cici’s Furniture faced the following business challenges with regards to queuing analysis: (a) Understanding the balk rate, (b) understanding the distribution of customer arrivals, (c) understanding the distribution of furniture delivery arrivals, and (d)...
The end:
.....2:00
45
11:05
11:48
4
60
1:00
45
12:05
12:48
5
60
2:00
45
1:05
1:48
6
60
3:00
45
2:05
2:48
7
60
4:00
45
3:05
3:48
8
60
5:00
45
4:05
4:48
9
60
6:00
45
5:05
5:88
10
60
7:00
45
6:05
6:48
Appendix C: Excerpts from Showroom Service Spreadsheet
Cust.
Interarrival
Arrival
Service
Server #1
Wait
Total
#
Time
Time
Time
Start
End
Time
Time
(min)
(hr:min)
(min)
(hr:min)
(hr:min)
(hr:min)
(hr:min)
start
9:00
1
3
9:03
9
9:03
9:12
0:00
0:09
2
1
9:04
9
9:12
9:21
0:08
0:17
3
10
9:14
6
9:21
9:27
0:07
0:13
4
3
9:17
6
9:27
9:33
0:10
0:16
5
1
9:18
9
9:33
9:42
0:15
0:24
6
10
9:28
3
9:42
9:45
0:14
0:17
7
5
9:33
6
9:45
9:51
0:12
0:18
8
10
9:43
6
9:51
9:57
0:08
0:14
9
5
9:48
6
9:57
10:03
0:09
0:15
10
1
9:49
3
10:03
10:06
0:14
0:17
11
1
9:50
3
10:06
10:09
0:16
0:19