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...
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...
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...
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...
In this exercise, you will analyze the supply-demand equilibrium of a city under some special simplifying...
In this exercise, you will analyze the supply-demand equilibrium of a city under some special simplifying assumptions about land use. The assumptions are: (i) all dwellings must contain exactly 1,500 square feet of floor space, regardless of location, and (ii) apartment complexes must contain exactly 15,000 square feet of floor space per square block of land area. These land-use restrictions, which are imposed by a zoning authority, mean that dwelling sizes and building heights do not vary with distance to...
Entries and Schedules for Unfinished Jobs and Completed Jobs Mellow Company uses a job order cost...
Entries and Schedules for Unfinished Jobs and Completed Jobs Mellow Company uses a job order cost system. The following data summarize the operations related to production for April, the first month of operations: Materials purchased on account, $3,170. Materials requisitioned and factory labor used: Job No. Materials Factory Labor 101 $3,030 $3,160 102 3,700 4,270 103 2,450 2,090 104 8,300 7,840 105 5,270 5,970 106 3,850 3,790 For general factory use 1,030 4,680 Factory overhead costs incurred on account, $5,790....
ABC corporation has existing property and equipment that is not in use. The company is considering...
ABC corporation has existing property and equipment that is not in use. The company is considering the use of this property and equipment. One option is to use the property and equipment to produce a new product. Estimates for demand of this product are 30,000 units annually for the first 5 years and 20,000 units annually for the following 6 years. Beyond that, the product is considered to be obsolete and production will cease. Price and variable costs would be...
Question 1. (Total: 25 marks) You want to buy a car valued at $48,000. You wi...
Question 1. (Total: 25 marks) You want to buy a car valued at $48,000. You wi ll make an upfront down -payment of $5,000 on the car , and borrow the rest of the money from your bank. Your bank will give you a 5- year loan at 2.5% APR compounded semi -annually . You plan to make biweek ly payments (i.e., one payment every two weeks) on the loan . The bank requires that you make the first payment...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT