Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. rent'r cars is a multisite car rental company in t

Rent'R Cars is a multisite car rental company in the city. It is trying out a...

Free

80.2K

Verified Solution

Question

Statistics

Rent'R Cars is a multisite car rental company in the city. It istrying out a new \"return the car to the location most convenientfor you\" policy to improve customer service. But this means thatthe company has to constantly move cars around the city to maintainrequired levels of vehicle availability. The supply and demand foreconomy cars, and the total cost of moving these vehicles betweensites, are shown below.

From\ToDEFGSupply
A

$15

$16

$14

$6

70
B

8

7

13

6

35
C

14

9

15

12

100
Demand55605040205\205


a. Find the solution that minimizes moving costsusing Microsoft Excel. (Leave no cells blank - be certainto enter \"0\" wherever required.)

From/ToDEFGSupply
Candidate solution
A
B
C
Total shipped
Cost
A
B
C
Total costs

Answer & Explanation Solved by verified expert
3.7 Ratings (373 Votes)

The Excel output is:

D E F G Supply
A 15 16 14 6 70
B 8 7 13 6 35
C 14 9 15 12 100
Demand 55 60 50 40 205
Total shipped
D E F G Supply
A 0 0 30 40 70 70
B 35 0 0 0 35 35
C 20 60 20 0 100 100
55 60 50 40 205
Demand 55 60 50 40
Cost 2060
Total costs
D E F G Supply
A 0 0 420 240 660
B 280 0 0 0 280
C 280 540 300 0 1120

(a)

D E F G Supply
A 0 0 30 40 70
B 35 0 0 0 35
C 20 60 20 0 100
Total shipped 55 60 50 40 205
D E F G Supply
A 0 0 420 240 660
B 280 0 0 0 280
C 280 540 300 0 1120
Total costs 560 540 720 240 2060
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

Answer True or False for the following: 1. Chi-square requires assumptions about the shape of the population...

Physics
1.2K views

A wood burning stove is box shaped with a height of 30.7”, width 26.25” and depth...

Accounting
1.2K views

Dana intends to invest $66,000 in either a treasury bond or a corporate bond. The Treasury...

Biology
1.2K views

Which of the following is translated in the cytoplasm and then imported into an organelle...

Geometry
1.2K views

Q 7 cm

Basic Math
1.2K views

Sadie needed to get her computer fixed. She took it to the repair store. The...

Calculus
1.2K views

K Fill in the blank with The boiling point of The boiling point

Accounting
1.2K views

Answer Question A Southampton Plc and Northampton Plc operate...

Accounting
1.2K views

FenderGlbson Company Company Fender Company Company Gibson Data from the current year-end balance sheets Assets...

Finance
1.2K views

QUESTION 2 4.51 po Swiss Bank, Inc. is an all-equity firm that currently has 25...

Accounting
1.2K views

Cavite Company acquired land and building by issuing 60,000, P100 par value, ordinary shares. On...

Accounting
1.2K views

Capitalization, no ALL CAPS). Answer 1: sender ip address hardware type target ip address target...