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 Demand D $9 19 5 50 E $8 8 3 60 F $6 8 3 25 G $5 Le 10 30 Supply 50 40 75 165 165 a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.)

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 Demand D $9 19 5 50 E $8 8 3 60 F $6 8 3 25 G $5 Le 10 30 Supply 50 40 75 165 165 a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.)

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
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?
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
Please don't answer in handwritten..thanku
please justify your answer
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?
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
Sealy Ltd. is a newly established mattress factory that has calibrated its operations towards supplying high quality mattresses to the hotel trade as well as to the general public. The company intends to maximize it supply chains operations by ensuring that the three macro processes that manage the flow of information, product and funds required to generate, receive and fulfill a customer order is optimized in its operations. The company’s transportation network is also being designed but is being analyzed in terms of possible trade-offs that may have to be made in order to optimize the operation. Additionally, another far reaching decision that the company has to make is regarding the sourcing of raw material for their operations in particular whether to source in house or to outsource the supply chain function. As a new company in the 21st Century it is expected that information technology will play a pivotal role in the operations of the company Describe the functioning of the…
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 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.
Ancient history of logistics distribution regarding probability?