**Rent'R Cars Transportation Problem Example**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. However, this policy requires the company 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.### Cost TableThis table lists the cost of moving cars from one location to another.| From/To | D | E | F | G | Supply ||---------|-----|-----|-----|-----|--------|| A | 514 | 514 | 513 | 66 | 65 || B | 5 | 1 | 5 | 1 | 40 || C | 8 | 10 | 12 | 16 | 150 |- **Demand**: 60 (for D), 80 (for E), 45 (for F), and 70 (for G), totaling 255.- **Supply**: Total supply is also 255.### Task**a.** Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank, whenever zero (0) is required.)### Candidate Solution TableThis table is intended for inputting the candidate solution to determine car distribution.| From/To | D | E | F | G | Supply ||---------|---|---|---|---|--------|| A | | | | | 65 || B | | | | | 40 || C | | | | | 150 || Total Shipped | 0 | 0 | 0 | 0 | |### Cost Calculation TableThis table calculates total costs based on the candidate solution.| Cost | D | E | F | G | Total Costs ||-----------|---|---|---|---|-------------|| A | | | | | || B | | | | | || C | | | | | || Total Costs | | |

Answered: Rent'R Cars is a multisite car rental…

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

A highway contractor needs to locate a single supply point to provide road building materials to three projects. The volume and the map coordinates for the three projects are shown below. Find the ideal location (coordinates) of the supply poiunt using Center of Gravity Method.
4.- A building materials company with production facilities in Reno, Spokane and Tacoma ships boxes to three distribution centers with costs per box as shown in the table. Get the cost of transportation by northwest corner method. From Center 1 Reno $3 Spokane $4 Tacoma $3 Demand 30 Center 2 $3 $2 $2 30 Center 2 $2 $3 $3 35 Capacity 25 40 30
Lancelot’s Barbecue makes its sauce using an old family recipe. Due to overwhelming response on its Instagram account in January 2020, it decides to sell directly to the public and is considering four locations. Two months later, the world shuts down due to the Covid-19 pandemic and Lancelot’s fails to produce a single bottle of its sauce. Which location would have been ideal for making no sauce? Cost Data Abilene Beaumont Conroe Dalhart Fixed costs $180,000 $220,000 $235,000 $265,000 Direct material cost per unit $10.50 $10.00 $10.00 $9.25 Direct labor cost per unit $3.90 $4.00 $2.75 $3.45 Overhead per unit $1.10 $1.00 $1.50 $1.20 Transportation cost per unit $1.10 $0.80 $1.25 $0.90 a. Dalhart b. Beaumont c. Conroe d. Abilene
OCEAN: Mike plans to transport 30 pallets containing 53 cartons and an additional pallet containing 40 cartons from Montreal to Shanghai. Each pallet (including the 1 additional pallet) weighs 800kgs and measures 121cm x 90cm x 100cm. The rate is $92 w/m. Determine the Freight cost ($). 3106 2000 32.67 25.5 Others
1) Explain how Zara uses e-Supply chain management to obtain a competitive advantage
13. Food trucks have become a $2 billion industry, serving creative, and often healthy, food options in places where traditional food options might be limited. For example, a food truck might stop at a local college campus during lunch time. The truck might stop later at an underprivileged district in the afternoon, and then to a local club scene in the evening. Which of the following are advantages food trucks have over traditional restaurants in terms of land and capital costs? Food trucks can easily establish a brand name, helping cement a loyal customer base. The physical capital needed to set up a food truck is less than that of a restaurant. Food trucks require little, if any, land, provided they have the proper permits to operate in a public street. Food trucks can seek out demand instead of having to expend resources drawing customers to a fixed location.
Write an essay titled "Here, There, and Everywhere" on the construction and hardware supply company FOUR ACES.
Answer using the excel screenshot format to do the question.
6.- Comfort Zone Furniture has plants in Boston, Dallas and Seattle, which ship their production to four demand centers, with the transportation costs indicated in the following table. Using the northwest corner method and stepping stone find the optimal solution. Boston Dallas Seattle Demand 1 $3 $6 $1 20 2 $5 $8 $9 60 3 $7 $5 $7 30 4 $4 $2 $3 40 Capacity 50 50 50 150
Sycamore Plastics (SP) is a manufacturer of polyethylene plastic pellets used es a row material by manufacturers of plastic goods around the United States SP currently operates four manufacturing centers in Philadelphia, PA; Atlanta, GA; St. Louis, MO; and Salt Lake City, UT. The plants have different capacities and production costs as indicated in the table below. МАXIMUM CAPАCITY PROD. COST (x 180, 800 LBS.) (PER 1,200 LBs.) $328.00 $278.00 $388.00 $253.00 PLANT Philadelphia Atlanta St. Louis Salt Lake City 7.9 9.1 12.1 10.4 SP currently has six contract customers located in New York City: Birmingham, AL; Terre Haute, IN; Dallas, TX; Spokane, WA; and San Diego, CA. Transportstion costs between the plants and verious customers, es well os contracted demand from esch customer, are shown in the table below. TRANSPORT COSTS PER 1,02e LBS. TERRE HAUTE FROM/TO NYC BIRMINGHAM DALLAS SPOKANE SAN DIEGO Philadelphia $ 46 $ 53 $ 57 $ 63 $ 74 $ 83 Atlanta 56 43 59 76 se St. Louis 58 61 51 55 61…
A firm’s cost of goods sold last year was $3,410,000, and the firm operates 52 weeks per year. It carries seven items in inventory: three raw materials, two work-in-process items, and two finished goods. The following table contains last year’s average inventory level for each item, along with its value. a. What is the average aggregate inventory value? b. How many weeks of supply does the firm maintain? c. What was the inventory turnover last year?
please use excel

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

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

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS