Question

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 | $ | ||||

Answer #1

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

Formulae:

SOLVER formulae:

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 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 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 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. 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 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 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. 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 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 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

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 3 minutes ago

asked 18 minutes ago

asked 21 minutes ago

asked 32 minutes ago

asked 47 minutes ago

asked 55 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago