Royal Seafood delivers fresh fin and shellfish to specialty grocery stores in the state of Oregon. The company packs a delivery truck in Corvallis and then drives in one single route to its 5 customers spread throughout the state. The distances in miles between all locations may be found in the Table 1. E Click the icon to view Table 1. a. Propose an efficient route by using the Nearest Neighbor heuristic with Corvallis as the starting city. What is the total distance traveled? The route is V and the total distance is miles. (Enter your response as a whole number.) b. Use the Nearest Neighbor heuristic to calculate five routes, each starting from one of Royal Seafood's customer's location. What is the best route for Royal Seafood? (Enter your responses as whole numbers.) Starting location Route Total distance in miles A AEDBCFA 1,111 В D E The shortest route is V having the total distance of miles. Note that using the same sequence of cities we can start the route at any one of them and travel the same total distance. (Enter your response as a whole number.)

Royal Seafood delivers fresh fin and shellfish to specialty grocery stores in the state of Oregon. The company packs a delivery truck in Corvallis and then drives in one single route to its 5 customers spread throughout the state. The distances in miles between all locations may be found in the Table 1. E Click the icon to view Table 1. a. Propose an efficient route by using the Nearest Neighbor heuristic with Corvallis as the starting city. What is the total distance traveled? The route is V and the total distance is miles. (Enter your response as a whole number.) b. Use the Nearest Neighbor heuristic to calculate five routes, each starting from one of Royal Seafood's customer's location. What is the best route for Royal Seafood? (Enter your responses as whole numbers.) Starting location Route Total distance in miles A AEDBCFA 1,111 В D E The shortest route is V having the total distance of miles. Note that using the same sequence of cities we can start the route at any one of them and travel the same total distance. (Enter your response as a whole number.)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

On a daily basis, the Vampire Van is dispatched from Maplewood Hospital to pickup blood and platelet donations made at its local donation centers. The distances in miles between all locations may be found in Table.a. The Vampire Van travels from Maplewood Hospital (A) to (B) to (C) to (D) to (E) and then returns to the hospital (A). What is the total number of miles that the van must travel using this route?b. Using Maplewood Hospital as the beginning location, create a route using the NN heuristic. What is the total number of miles that the van must travel using this route?c. Using Valley Hills (E) as the beginning location, create a route using the NN heuristic. What is the total number of miles that the van must travel using this route?
Determine the suitable location of a distribution centre with the below data, minimizing the transportation dollars spent on managing inbound and outbound shipments. Plot the location of the Vendors, Customers and the location of the new DC in a chart Vendor V1 V2 V3 V4 Customer C1 C2 C3 C4 Rate $ per Ton Mile $ $ $ $ 4.75 3.75 3.15 4.75 Rate $ per Ton Mile $ $ $ $ 3.50 3.75 4.25 5.00 Volume in Tons 1000 1000 1600 1400 Volume in Tons 760 640 800 500 Vendor Location Coordinates (miles) Horizontal 525 600 412.5 300 Vertical 300 750 750 630 Customer Location Coordinates(miles) Vertical 450 900 1050 975 Horizontal 900 900 825 1050
Suppose that you are an engineer tasked with finding a new location for your distribution center (let's say you work as an industrial engineer at a cosmetics company). You have a good idea of who your customers are and how many tons of cosmetics you must ship per week. Using your company headquarters as the origin, you plot out the following table: Customer x-location (miles) y-location (miles) Quantity (tons/week) JC Penney 10 280 3 BB&B 70 180 7 Target 80 160 4 Bath&Body Works 170 20 5 Walmart…
The following table gives the map coordinates and the shipping loads for a set of cities that we wish to connect through a central hub. Using the Center of Gravity method, near which map coordinates should the hub be located? STORE LOCATION CONTAINERS SHIPPED PER MONTH X Y Chicago 2,000 50 120 Pittsburgh 1,000 110 100 New York 3,000 160 130 Atlanta 2,000 120 40
7. Pizza Hut Ibri is an tourism. (True /False) example of direct service provider in
Contrast the location of a food distributor and a supermar-ket. (The distributor sends truckloads of food, meat, produce, etc., to the supermarket.) Show the relevant considerations(factors) they share; show those where they differ.
Rent'R Cars is a multisite car rental company in the city. It is trying out a new "return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below. From To A B C 8 Demand 65 60 D $11 10 13 From/To Candidate solution A B с Total Shipped Cost A B E $5 4 с Total Costs F $9 8 12 75 Find the solution that minimizes moving costs using Microsoft Excel. Note: Leave no cells blank, whenever zero (0) is required. D $7 13 D 12 80 0 0 65 65 Supply 95 75 110 280 280 0 0 845 Answer is complete but not entirely correct. E F G 15 X 0 X 0 15 75 X 0X 0 0 X 75 X 45 120 F 80 0 > Answer is complete but not entirely correct. E G 0 X 600 X 540 0 80 560 0 Supply 0 95 75 110 280 2,620
7. Novelis at Oswego NY supplies rolled aluminum sheets to Ford Motor's Kansas City plant to make F150 truck. The transportation manager of Novelis needs to choose from rail, waterway, and truck. The following information are gathered to make the transportation mode decision: Transportation Mode Transit Time, Days Rate $/cwt Shipment Size, cwt Rail 15 $2.50 12,000 Waterway 20 $0.80 200,000 4 $12.50 4,000 Truck The annual transportation volume is 2.5 million cwt. The value of aluminum is $500 per cwt. Inventory carrying cost for both companies is 20% per year. Please calculate the total logistics costs (transportation, inventory at Novelis, inventory at Ford, inventory in transit), and decide which transportation mode should be selected. (20 points)
Rent'R Cars is a multisite car rental company in the city. It is trying out a new “return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below. From\To Supply 50 E F G A $9 $8 $6 $5 B 9. 8 40 C 3 3 10 75 Demand 50 60 25 30 165\165 a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank - be certain to enter "O" wherever required.) From/To Candidate solution E F Supply A В C Total shipped Cost A C Total costs $
a. A farmers' cooperative association plans to build a new sugar mill in Georgetown. The primary objective of the mill is to provide the farmers with a place to take their crop for processing that will reduce their transportation costs. The members of the co-op believe that the center-of-gravity method is appropriate for this objective. While there are over 200 sugar cane farms in the region, they are tightly clustered around six villages. Using the data below, use the center-of-gravity method to calculate the coordinates of the best location for this mill. All mileage references use Browns Town as (0,0). Village Barney Valley Blue Pasture Congo Valley Bower Rabacca Salem Miles East of Miles North of Sugar Cane Browns Town Browns Town 90 140 20 50 100 10 10 60 70 20 80 120 tonnage 240,000 320,000 450,000 120,000 60,000 140,000
Maya ltd. wants to use the Centre of Gravity location technique to determine where to setup its distribution centre. What is the main objective of using this technique? What information will be needed in order to use this technique? Setup a numerical example that can be used to demonstrate to the owner of the company how the technique can be used Use the numerical example set up above to demonstrate how the centre of gravity location technique is used.
Linear Programming & Transportation Model - scenario/case (simple example) that can be analyzed by using linear-programming/transportation model specifically in identifying the decision variables, constraints and objective function (goals). - Supply and chain operations specifically