Question

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

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 D E F G Supply
A

$7

$14

$15

$3

75
B

7

12

17

2

65
C

10

6

9

8

110
Demand 45 60 65 80 250\250


a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.)

From/To D E F G Supply
Candidate solution
A
B
C
Total shipped
Cost
A
B
C
Total costs $

Homework Answers

Answer #1

Problem was modelled in Excel and solutions were prepared using SOLVER (LP). Snapshots are shown below:

Formulae:

SOLVER formulae:

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Rent'R Cars is a multisite car rental company in the city. It is trying out a...
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 D E F G Supply A...
The Acme Car Company claims that no more than 8% of its new cars have a...
The Acme Car Company claims that no more than 8% of its new cars have a manufacturing defect. A quality control inspector randomly selects 300 new cars and finds that 33 have a defect. Should she reject the “8% or less” claim using 1PropZTest? Assume a significance level of 0.05. Select one: a. Yes, because the p-value is 0.016 b. Yes, because the p-value is 0.028 c. No, because the p-value is 0.16 d. No, because the p-value is 0.28...
An accountant for Abington Cubic Car Rental Company was recently asked to report the firm's costs...
An accountant for Abington Cubic Car Rental Company was recently asked to report the firm's costs of producing various levels of output. The accountant knows that the most recent estimate available of the firm's cost function is: C(Q) = 150,000 + 25Q + 8Q2 + 6Q3 Where costs are measured in thousands of dollars and output is measured in thousands of hours rented. a. What is the average fixed cost of producing 20 units of output? b. What is the...
Utopia Company operates a plant in Avalon with a monthly capacity of 35,000 units and a...
Utopia Company operates a plant in Avalon with a monthly capacity of 35,000 units and a plant in Bridgetown with a monthly capacity of 40,000 units. Product is shipped to regional distribution centers located in Riverdale, Seaside and Teatown. The long-range planning group at Utopia reevaluated their forecasts and determined that due to an anticipated increase in demand in the next 5 years, the company should consider increasing capacity by constructing a new plant in one or more of the...
1) The equations below can be used to analyze the apartment rental market of Detroit, Michigan....
1) The equations below can be used to analyze the apartment rental market of Detroit, Michigan. The city of Detroit has hired you as a consultant to compare two polices aimed at reducing the cost of housing. ?=????−.???? ?=???+.??? a) Calculate the equilibrium price and quantity for housing, show graphically. Be sure to include all supply and demand intercepts. Use a straight edge to draw the graph. b) Suppose that a $120 subsidy is given to each renter (consumer). Calculate...
Given demand curve for Silvana Chocolates Company ( SCC ) a. How many Bars could be...
Given demand curve for Silvana Chocolates Company ( SCC ) a. How many Bars could be sold for $100? b. At what price would SCC sales fall to zero? QD = 10,000 - 25P. c. What is the total revenue (TR) equation for SCC in terms of output, Q? What is the marginal revenue equation in terms of Q? d. What is the point-price elasticity of demand when P = $150 ? What is total revenue at this price? What...
There are three firms in the car production industry, where the production of cars gen- erates...
There are three firms in the car production industry, where the production of cars gen- erates pollution. All three firms have the same damage function: each additional unit of emissions damages society $15. However, all three firms have different abatement technologies. The marginal abatement cost is 5 + 0.2A for Volvo and 5 + 0.25A for Ford. Finally, the marginal abatement cost for Toyota is A − 5, where A is abatement. All three firms only care about maximizing profits...
A car dealership decided to add an annex to its sales office as a customer lounge....
A car dealership decided to add an annex to its sales office as a customer lounge. The project is divided into the activities listed in the following table. The immediate predecessor(s), times and costs, both normal and crashed, are given. To finish the project sooner, the dealership has to make time and cost tradeoffs. If the project needs to be finished in 25 weeks, you are required to formulate a linear programming model to decide about how much to crash...
Singapore gets a boost in the electric car making drive-Home appliances brand Dyson picks island city...
Singapore gets a boost in the electric car making drive-Home appliances brand Dyson picks island city as its location for new venture    Singapore: When James Dyson, the billionaire British inventor of the bagless vacuum cleaner, unveiled a plan to build an electric car plant in Singapore, it raised a few eyebrows. Not only does the land-starved city state have some of the highest average salaries in the world, but it has been nearly 40 years since Ford closed its...
Do heavier cars really use more gasoline? Suppose a car is chosen at random. Let x...
Do heavier cars really use more gasoline? Suppose a car is chosen at random. Let x be the weight of the car (in hundreds of pounds), and let y be the miles per gallon (mpg). x2544344723403452 y3017271329172114 Complete parts (a) through (e), given Σx = 299, Σy = 168, Σx2 = 11,915, Σy2 = 3854, Σxy = 5816, and r ≈ −0.943. (a) Draw a scatter diagram displaying the data. Selection Tool Line Ray Segment Circle Vertical Parabola Horizontal Parabola...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT