National Cranberry Cooperative, 1996 case.

How best do I approach this question below by encorporating the capacities of each step of the process flow as well as the analyis of deliveries on the 23rd of September 1995?

Currently what is (are) the major reason(s) for trucks waiting and excessive overtime? Explain.

Below is the summary of the key points I made from the Case as well as the table showing the delivery times and weights of the cranberries. I am keen on showing the build up of inventory during the day as the deliveries come through and how these affect the current capacity of the dumpers which is 3,000bbls/ hour for 40 trucks with an average capacity of 75bbls per hour. At what pint do the ttrucks start waiting?

Average unloading time is 7.5minutes/truck per dumper. There are 5 dumpers available, so per hour its on average the average trucks is 40 per hour. Each truck has a capacity of 75bbls making the total capacity for receiving 3000 bbls/hour

Holding bins are as follows:

bins 1-16 for dry berries only with capacity 250bbls each

bins 25,26,27 for wet berries only with capacity 400bbls each

bins 17-24 could be used for either wet or dry

Destoning of Dry berries- 3 units with capacity 1500bbls/ hour each

Dechaffing of dry berries - 1 unit with capacity 1500bbls/hour

Dechaffing of wet berries 2 units with capacity 1500 bbls/hour each

Drying wet berries - 3 dryers with total capacity 200 bbls/ hour each

all the berries then go to the Seperator as the last step of the process. The seperator has 3 lines with total capacity 400 bbls/hour each

Deliveries observed on the 23rd of September 1995 are as shown in the table below.

Exhibit 1 Log of Total Deliveries on September 23, 1995
Actual Time	Color	Wet/Dry	Weight
6:51 AM	3	D	33,940.00
6:53 AM	3	D	9,980.00
6:56 AM	3	D	10,020.00
7:08 AM	1	D	12,200.00
7:19 AM	3	D	8,980.00
7:25 AM	3	D	7,520.00
7:26 AM	3	D	4,140.00
7:28 AM	3	D	11,720.00
7:31 AM	2	D	6,520.00
7:36 AM	3	D	1,480.00
7:39 AM	3	W	12,660.00
7:40 AM	3	D	31,640.00
7:42 AM	3	W	11,920.00
7:43 AM	3	D	2,060.00
7:48 AM	3	D	6,020.00
7:51 AM	3	W	12,640.00
7:52 AM	3	D	3,940.00
7:57 AM	3	D	6,060.00
8:00 AM	3	D	4,660.00
8:02 AM	3	D	1,880.00
8:05 AM	3	D	7,260.00
8:15 AM	3	D	4,960.00
8:18 AM	2	D	3,160.00
8:19 AM	2	D	3,320.00
8:20 AM	3	D	17,820.00
8:28 AM	3	D	3,360.00
8:31 AM	3	D	10,420.00
8:32 AM	2	D	5,780.00
8:33 AM	3	W	5,500.00
8:35 AM	3	D	8,880.00
8:39 AM	3	D	17,880.00
8:42 AM	3	D	1,580.00
8:44 AM	3	D	6,440.00
8:47 AM	3	W	7,860.00
8:48 AM	3	W	33,720.00
8:53 AM	2	W	11,340.00
8:54 AM	2	D	6,480.00
8:55 AM	3	D	5,280.00
8:58 AM	3	D	11,640.00
9:03 AM	2	W	11,180.00
9:11 AM	3	D	2,900.00
9:20 AM	3	D	3,580.00
9:25 PM	3	D	8,400.00
9:27 PM	3	D	3,920.00
9:30 PM	3	D	1,200.00
9:32 PM	3	D	3,480.00
9:37 PM	3	D	3,580.00
9:40 PM	3	W	8,440.00
9:41 PM	3	D	8,500.00
9:44 PM	2	D	7,560.00
9:46 PM	3	D	4,540.00
9:47 PM	3	D	9,040.00
9:48 PM	2	D	3,360.00
9:51 PM	3	D	2,820.00
9:54 PM	3	W	13,500.00
9:57 PM	3	W	11,560.00
9:59 PM	3	D	19,340.00
10:01 PM	3	D	20,340.00
10:04 PM	3	D	9,600.00
10:09 PM	3	W	13,020.00
10:25 AM	2	D	2,620.00
10:30 AM	2	W	11,460.00
10:33 AM	3	D	3,600.00
10:34 AM	2	W	7,280.00
10:36 AM	3	W	9,240.00
10:38 AM	3	W	12,700.00
10:40 AM	3	W	28,780.00
10:45 AM	2	D	18,000.00
10:48 AM	3	D	8,240.00
10:50 AM	3	W	13,820.00
10:51 AM	2	W	11,280.00
10:55 AM	3	D	1,280.00
11:00 AM	3	D	500.00
11:03 AM	2	D	29,560.00
11:04 AM	2	D	9,720.00
11:05 AM	3	W	8,000.00
11:06 AM	3	W	24,640.00
11:11 AM	3	D	1,880.00
11:13 AM	2	W	12,760.00
11:14 AM	3	D	9,980.00
11:17 AM	3	W	12,980.00
11:18 AM	2	D	7,860.00
11:21 AM	3	W	11,480.00
11:24 AM	3	D	12,680.00
11:38 AM	2	D	5,640.00
1:00 PM	3	D	2,220.00
1:10 PM	2	W	11,500.00
1:11 PM	3	W	9,460.00
1:13 PM	3	W	12,660.00
1:29 PM	2	W	5,620.00
1:31 PM	2	D	2,540.00
1:37 PM	3	D	11,760.00
1:38 PM	2	D	7,720.00
1:43 PM	2	W	7,080.00
1:45 PM	2	W	20,400.00
1:58 PM	3	D	12,200.00
2:01 PM	2	D	7,420.00
2:02 PM	2	W	3,140.00
2:03 PM	3	D	13,740.00
2:05 PM	3	D	2,840.00
2:06 PM	3	D	15,240.00
2:08 PM	2	D	11,540.00
2:10 PM	3	W	31,460.00
2:15 PM	3	W	9,300.00
2:22 PM	3	D	4,580.00
2:34 PM	3	W	11,280.00
2:36 PM	2	W	12,720.00
2:37 PM	2	D	14,140.00
2:38 PM	3	D	26,700.00
2:39 PM	3	W	11,820.00
2:42 PM	3	D	12,800.00
2:48 PM	2	D	7,980.00
2:56 PM	3	D	8,900.00
2:58 PM	3	D	11,420.00
3:01 PM	3	W	7,160.00
3:05 PM	3	D	17,680.00
3:16 PM	3	D	8,780.00
3:22 PM	3	D	3,660.00
3:24 PM	3	W	14,840.00
3:37 PM	3	W	9,160.00
3:42 PM	3	W	15,960.00
3:45 PM	3	D	1,280.00
3:47 PM	3	D	10,300.00
3:49 PM	2	W	11,540.00
3:54 PM	3	W	12,580.00
3:57 PM	3	D	11,040.00
3:59 PM	3	D	7,740.00
4:01 PM	3	W	12,500.00
4:02 PM	3	D	7,000.00
4:08 PM	3	D	7,340.00
4:09 PM	3	D	4,260.00
4:15 PM	3	D	1,660.00
4:17 PM	3	D	4,980.00
4:20 PM	3	W	12,640.00
4:22 PM	3	D	6,420.00
4:24 PM	3	D	11,200.00
4:36 PM	3	D	11,920.00
4:40 PM	3	W	12,320.00
4:45 PM	3	W	8,860.00
4:48 PM	2	W	7,140.00
5:10 PM	3	D	7,180.00
5:11 PM	2	D	11,220.00
5:12 PM	2	D	6,840.00
5:22 PM	3	D	9,600.00
5:40 PM	3	D	11,100.00
5:43 PM	3	W	11,080.00
5:46 PM	1	W	11,020.00
5:47 PM	1	W	11,240.00
6:00 PM	3	D	35,060.00
6:01 PM	3	W	31,580.00
6:06 PM	3	D	7,420.00
6:11 PM	3	D	4,500.00
6:14 PM	2	D	5,700.00
6:18 PM	3	D	4,640.00
6:23 PM	2	D	2,420.00
6:29 PM	3	D	9,440.00
6:31 PM	2	D	11,620.00
6:32 PM	3	D	8,360.00
6:34 PM	3	D	10,500.00
6:35 PM	3	D	3,240.00
6:40 PM	3	W	10,280.00
6:41 PM	3	D	8,140.00
6:42 PM	2	W	2,440.00
6:45 PM	3	D	13,720.00
6:53 PM	3	W	43,180.00
7:01 PM	3	W	13,420.00
7:06 PM	3	D	7,400.00
7:16 PM	3	D	7,260.00
7:17 PM	3	D	6,240.00
7:19 PM	2	W	13,120.00
7:22 PM	3	D	8,340.00
7:24 PM	3	D	6,160.00
7:30 PM	3	D	9,020.00
7:30 PM	3	D	9,020.00
7:30 PM	3	W	9,240.00
7:30 PM	2	D	7,660.00
7:30 PM	3	D	3,960.00
7:30 PM	3	D	4,100.00
7:30 PM	2	W	11,860.00
7:30 PM	3	D	11,460.00
7:30 PM	2	W	11,240.00
7:30 PM	3	D	1,980.00
7:30 PM	3	D	10,480.00
7:30 PM	2	D	11,600.00