Question: Please answer Q3, show excel with formulas if needed. SHIPMENT ROUTE PLANNING Bill Binder's business nearly went under when Colorado almost passed the bottle bill.


Please answer Q3, show excel with formulas if needed.
SHIPMENT ROUTE PLANNING Bill Binder's business nearly went under when Colorado almost passed the bottle bill. Binder's Beverage produced soft drinks for many of the large grocery stores in the area. After the bottle bill failed, Binder's Beverage flourished. In a few short years, the company had a major plant in Denver and a warehouse in east Denver. The problem was getting the finished product to the warehouse. Although Bill was not good with distances, he was good with times. Denver is a big city with numerous roads that can be taken from the plant to the warehouse. Exit 135 Exit 136 Exit 137 1-70 High Street West Street North Street Columbine Street Rose Street South Avenue Plant 6th Avenue Warehouse 10 Figure: Road Map for Binder's Beverage The road network and travel times are described below. The soft drink plant is located at the corner of North Street and Columbine Street (Node 1). High Street also intersects North Street and Columbine Street at the plant. Twenty minutes due north of the plant on North Street is 1-70, the major east-west highway in Denver. North Street intersects 1-70 at Exit 135. It takes 5 minutes driving east on 1-70 to reach Exit 136. This exit connects 1-70 with High Street and 6th Avenue. Ten minutes east on 1-70 is Exit 137. This exit connects 1-70 with Rose Street and South Avenue. From the plant, it takes 20 minutes on High Street, which goes in a northeast direction, to reach West Street. It takes another 20 minutes on High Street to reach 1-70 and Exit 136. It takes 30 minutes on Columbine Street to reach West Street from the plant. Columbine Street travels east and slightly north. West Street travels east and west. From High Street, it takes 15 minutes to get to 6th Avenue on West Street. Columbine Street also comes into this intersection. From this intersection, it takes an additional 20 minutes on West Street to get to Rose Street, and it takes another 15 minutes to get to South Avenue. From Exit 136 on 6th Avenue, it takes 5 minutes to get to West Street. Sixth Avenue continues to Rose Street, requiring 25 minutes. Sixth Avenue then goes directly to the warehouse From Rose Street, it takes 40 minutes to get to the warehouse on 6th Avenue. At Exit 137, Rose Street travels southwest. It takes 20 minutes to intersect with West Street, and it takes another 20 minutes to get to 6th Avenue. From Exit 137, South Street goes due south. It takes 10 minutes to get to West Street and another 15 minutes to get to the warehouse." Answer the following questions: Q1: How quickly (in minutes) can Bill get his trucks from his plant to the warehouse? What is the route? Q2: There is a long-awaited Highway 1-70 construction project that is expected to make traffic go really slow between Exit 136 and 137 after March 1* (a) How would the shipment route change if Bill is to avoid these highway exits? (b) What will be the shortest time to get trucks from his plant to the warehouse after March 19? Q3: Once roadworks on 1-70 began on March 1st, many drivers started bypassing the congested highway by using the West Street detour between Exit 136 and 137. The detour traffic increased road congestion between the intersection of West St. and 6th Ave. (Node 5), and the intersection of West St. and Rose St. (Node 7) leading to long delays between these intersections. How does this new situation change Bill's shipping routeStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
