(Answered) CASE #1 Attached Files: Updated map.docx (735.016 KB) Routing

Description

CASE #1   




Attached Files:

  •  Updated map.docx(735.016 KB)
  •  Routing Case.mp4(33.823 MB)
  •  Routing Case Answer format.xls(44.5 KB)
  •  Routng Case.pdf(1.961 MB)

Here is the first case.   You need to develop 3 truck routes to pick up material for an automotive OEM.  

You will find.

1. The Case

2. An new map file

3. An answer sheet in Excel - This is all I need turned in.

4. A video talking you through it. 



INBOUND TRANSPORTATION PROBLEM

Round Trip

Minimize distance

Meet daily demand Options Additional Rules

1. Suppliers can not stack on other suppliers

2. Route to 80 - 85 cube 53' trailer 98" wide 110" high

45,000 capacity

Trailer sq. ft of floor 53 X 8 =

424

1.25 minutes per mile

30 min. per stop

(Reality - Plan 1 hour) #1 By weight

#2 By physical cube

#3 By Floor position PART 1

Step 1. Calc. Number of containers per day, weight per day, floor positions for each part Stop

A8 City

State

Bowling Green OH Std Pack Length Width

Height

28

70

39 Yellow = Calculations - Copy Down

Gross

Dailey

Pallets per

Weight Demand Stack

day

45

480

275

2

9.8

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0! Pallets per

Floor

day Round Max Weight Floor

Positions

UP

per day

Positions Round UP

10.0

4800

5.0

5.0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Containers Step 2 Calculate floor Cube based on sq. ft. of trailer and sq. ft. of container

Calc. Number of containers per day, weight per day, floor positions for each part Stop

A8

0

0

0

0

0

0

0

0

0

0

0

0 City

State

Bowling Green OH

0

0

0

0

0

0

0

0

0

0

0

0 0

0

0

0

0

0

0

0

0

0

0

0 Length Width

Height

Length in Feet

70

39

45

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0 5.8

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0 Width in

Feet

3.3

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0 Sq.

footage of

footprint

19.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0 Sq. ft

required

based

on # of

footprint

s

94.8

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0! % 0f Trailer

based on

Pallets per

Floor

available

day Round Max Weight Positions

Cube

UP

per day

Round Up

22%

10.0

4800

5.0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0! 0

0

0 0

0

0 0

0

0 0

0

0 0

0

0 0

0

0 0.0

0.0

0.0 0.0

0.0

0.0 0.0

0.0

0.0 #DIV/0!

#DIV/0!

#DIV/0! #DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0! = 3 trailers #DIV/0!

#DIV/0!

#DIV/0! #DIV/0!

#DIV/0!

#DIV/0! The correct answer is between 200% an 300% PART 2

Sort Stops by distance and build routes - Use mileage charts (Load in computer routing model and save the headache)

Truck starts at Detroit location and first pick up should be farthest away. Have the driver work his way back.

Pick up all the stops Route

RT.1

Stop 1

Stop 2

Stop 3 RT. 2

Stop 1

Stop 2

Stop 3 RT. 3

Stop 1

Stop 2

Stop 3 City/Stop

Detroit State

MI % 0f

Trailer

based

on

available

Cube Pallets

per day

Round

UP Max

Weight

per day Floor Positions Window

Window Minutes

Miles

6:00

30.0

0.0

0.0

0.0

0.0 Detroit MI Detroit MI 0% 0 Miles

0 Drive Time (min)

Total Minutes Time 0

0

30.0 0.5 Hours

0

0

0

0

0

0 Detroit MI Detroit MI 0% 0 Miles

Drive Time (min)

Total Minutes Time 0

0

0.0 0.0 Hours

0.0

0.0

0.0

0.0

0.0

0.0 Detroit MI 0% Miles

Drive Time (min)

Total Minutes Time 0

0

0.0 0.0 Hours Hint - Go North, Go South, Go West PART 3

You may have noticed that a few of the suppliers are very small. Convert 2 suppliers to two days per week.

Hopefully you have an Ohio Route, pick up the small suppliers 2 days per week, the big ones remain daily at the same time.

It needs to make sense so the driver does not sit for long periods of time.

Hint: The Daily's must be the same time all 5 days of the week, so the others should be first or last.

Question: what does the route look like and how does this save money?

ROUTE FOR MONDAY, WEDNESDAY, Route City/Stop

Detroit State

MI Detroit MI % 0f

Trailer

based

on

available

Cube Pallets

per day

Round

UP Max

Weight

per day Floor Positions Miles

Total Time Window

Window Minutes 0

0 Miles 0.0 Hours ROUTE FOR TUESDAY AND THURSDAY Route City/Stop

Detroit State

MI Detroit MI % 0f

Trailer

based

on

available

Cube Pallets

per day

Round

UP Max

Weight

per day Floor Positions Miles

Total Time Window

Window Minutes 0

0 Miles 0.0 Hours ROUTE FOR FRIDAY (WITHOUT EITHER 2 DAY PER WEEK SUPPLIER) Route City/Stop

Detroit State

MI Detroit MI % 0f

Trailer

based

on

available

Cube Pallets

per day

Round

UP Max

Weight

per day Floor Positions Miles

Total Time Window

Window Minutes 0

0 Miles 0.0 Hours

Question

CASE #1 Attached Files: Updated map.docx (735.016 KB) Routing

  • Written in: 30-Nov--0001
  • Paper ID: 763490254
Price: $24
 
SSL Certificate website security