Table 1: Article Class HW \#4 Summer 12023 Operations and SCM 3123 Sections 601 and 602 Transportation Homework Assignment due: Monday, 6/12/2023, 11:50 pm Truck Rate Determination You are the shipping manager for Marin Bikes, a bicycle manufacturer based in Petaluma, CA. You ship bikes and bike-related products from Petaluma to your primary distribution warehouse in Denver, CO. Use Tables 1 and 2 to answer questions 1 - 5. All shipments are from the manufacturing site in Petaluma to the warehouse in Denver. NOTE: remember you are working in hundred weight (cwt), so watch where your decimal point belongs. HINT: remember bump/phantom weight! 1. Determine the lowest cost possible to ship 4,700lbs. of the Wolf Ridge bike. 2. Determine the lowest cost possible to ship 7,100 lbs. of the Presidio bike. 3. Determine the lowest cost possible to ship 41,000lbs. of the Presidio bike system. 4. Determine the lowest cost possible to ship 28,000 lbs. of the Standard shock system. 5. Determine the lowest cost possible to ship 800lbs. of the Deluxe shock system. 1 Table 2: Specific Rates for Shipments from Petaluma, CA. to Denver, CO. Freight Consolidation Question 6a: Rocky Mountain Freight Company has four (4) separate LTL shipments that need to be moved from Salt Lake City, UT. to four different customers in Columbus, OH. Using the information below, determine the cost of both scenarios. Which scenario yields the lowest cost? Scenario 1: Send four trucks from Salt Lake to Columbus, each with one load, to their respective customers. Scenario 2: Consolidate shipments at a Salt Lake warehouse, send all four loads on one truck, and drop off the loads at their respective customers in Columbus until all shipments have been delivered. Weight of each shipment: 8,000lbs. Cost per truck from Salt Lake City to Columbus: $2,400 (includes drop-off fee) Cost to consolidate shipments at the Salt Lake City warehouse: $14.00 per hundred-weight Cost per drop-off load in Columbus (only if one truck is used to drop off all shipments): $600 Question 6b: Rocky Mountain Freight Company has just found out that one of the customers cancelled their order. Using the same cost information from Question 6a, determine the new cost of both scenarios and again, which of the two scenarios yields the lowest cost