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 malntaln requlred levels of vehicle avallability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below. From\To A D. | $14 Supply 65 $14 $13 $6 | 10 10 40 8 | 10 12 16 150 Demand 60 80 45 70 255\255 a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank, whenever zero (0) Is requlred.) F From/To Candidate solution D E G Supply A 65 65 35 5 40 60 45 45 150 Total Shipped 60 80 45 70 255 Cost D E F B Total Costs 24

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 malntaln requlred levels of vehicle avallability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below. From\To A D. | $14 Supply 65 $14 $13 $6 | 10 10 40 8 | 10 12 16 150 Demand 60 80 45 70 255\255 a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank, whenever zero (0) Is requlred.) F From/To Candidate solution D E G Supply A 65 65 35 5 40 60 45 45 150 Total Shipped 60 80 45 70 255 Cost D E F B Total Costs 24

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

Rent’R Cars is a multisite car rental company in Huntsville/Madison area. 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 at the renting facility. The supply and demand for economy cars, cost of moving vehicles between sites per vehicle are shown below. From / To D E F G Supply A $9 $8 $6 $5 50 B 9 8 8 0 40 C 5 3 3 10 75 Demand 50 60 25 30 a.)Draw a diagram by showing supply points, demand points, and connecting arcs. b.)Define variables, write the objective function and constraints. c.)Prepare an initial Excel worksheet, check your formulas, and save it. d.)Complete solver parameters, copy it, and save as a file.
Your regular trucking company that you use to move LTL freight from Winnipeg to Duluth, Minnesota, 1s suddenly on strike. You call other trucking companies but cannot get space What could you have done to avoid this situation? 1. Regularly use more than one carrier to create a bank of possible carriers to handle your business 2. Always book space with your truckers in advance 3. Use a pool car operator and hope they have next-day service to Duluth 4. Nothing can be done
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 $
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 70 | $16 $15 $14 $6 8 13 35 14 9. 15 12 100 Demand 55 60 50 40 205\205 a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.) From/To Candidate solution Supply Total shipped Cost A $ [ Total costs
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 oveilebility. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, ore shown below. From\To Supply |$14 |$14 |$13 $6 65 | 1e | 1e 40 18 16 150 Derand 68 se 45 70 255\255 a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank, whenever zero (0) Is required.) From/To D E G supply Candidate solution A Total Shipped Cost D E G Total Costs
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?
. A company has a central supply facility and a distribution center located 400miles away. The central supply product cost is $75, TL transportation rates fromcentral supply to the DC are $60 per unit, and handling costs at the DC are $4 perunit. Calculate the market boundary location and the landed cost at the marketboundary. LTL rates are $2 per unit per mile.
A company is considering four modes of transportationfor its shipments. It plans to ship 32 pallets weighing500 pounds each from Salt Lake City, Utah to Reno,Nevada at a distance of 518 miles. What is the best way tomake these shipments given the following information?
There are four basic resources available, also known as production factors, which can be used by a busines such as Afri-Fast to deliver goods and services. Identify the four (4) factors or production, give a theoretical description of each, and provide a suitable practical example of how each an be used ina logistics service organisation such as Afri-Fast.
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…
Operations Management Define ITS and explain FOUR (4) benefits of ITS to transportation industry particularly to your country. Use appropriate examples to support your answer.
Using the information about customer vehicle traffic to and from a proposed new sports stadium (not built yet), find the best location for the stadium that minimizes total distance travelled using the center-of-gravity method. Zip Code Location Options 2 3 4 Coordinates of Location X 2 9 12 13 y 4 5 6 12 Vehicles per Stadium Event 4,300 4,700 1,100 2,000 Use the center-of-gravity method to determine an ideal location for a service center. Round your answers to two decimal places. Cx: Cy: