Develop a spreadsheet model for problem

Assignment Help Business Economics
Reference no: EM133082630

The Axis car rental company allows its customers to pick up a rental car at one location and return it to any of its locations. Currently, two locations (1 and 2) have 16 and 18 surplus cars, respectively, and four locations (3, 4, 5, and 6) each need 10 cars. The costs of getting the surplus cars from locations 1 and 2 to the other locations are summarized in the following table.

 

Cost of Transportation between Locations

 

 

Location 3

Location 4

Location 5

Location 6

Location 1

$54

$17

$23

$30

Location 2

$24

$18

$19

$31

Because 34 surplus cars are available at locations 1 and 2, and 40 cars are needed at locations 3, 4, 5, and 6, some locations will not receive as many cars as they need. However, management wants to make sure that all the surplus cars are sent where they are needed, and that each location needing cars receives at least five. Develop a spreadsheet model for this problem and solve it using Solver.

How many cars are to be shipped from Location 2 to Location 4?

Reference no: EM133082630

Questions Cloud

Average growth rate for all occupations : In 2015, the average growth rate for all occupations was about 7 percent. Why is it important that all the occupations listed above have growth rates over 12 pe
Estimated price elasticity of demand : Assume the volume of patients at the profit-maximizing price is 24,600. The merged firm's estimated price elasticity of demand is
Discuss the importance of well-developed compensation plan : Discuss the importance of a well-developed compensation plan in attracting and retaining good employees and how to keep those plans from "working too well."
Investigate forecasting at different levels of business : Investigate forecasting at different levels of business and challenges - How many units for each product should be purchased from the vendors? With what lead
Develop a spreadsheet model for problem : Because 34 surplus cars are available at locations 1 and 2, and 40 cars are needed at locations 3, 4, 5, and 6, some locations will not receive as many cars as
How does it affects our economic status and to our life : How does it affects our Economic status and to our life?
Demonstrate that a form of the gravity model : We have an imaginary system with planets, Alderaan, Bespin, Coruscant, Dagobah, and Endor, with shares of system spending given by 12%, 24%, 55%, 3%, and 6%, re
Impact on which of the industry threats : Imagine the state of Utah passed a law that stipulated only a specific number of special food cart permits would be awarded. Permits could be traded or sold, bu
What is the future of globalization : In your own understanding, what is the future of Globalization? Explain and support your answer.

Reviews

Write a Review

Business Economics Questions & Answers

  Worlds largest economies and policymakers

The economys business cycles are not well synchronized with any of the world's largest economies and policymakers.

  How many security lights will be purchased

What is the socially efficient quantity of lights? How many security lights will be purchased if each store buys its own lights?

  How demand for services would go up or down

Think of the impact of various consumers and suppliers. Think how demand for services would go up or down.

  What is the data scale for each of these three variables

A poll solicits a large number of college undergraduates for information on the following variables: the name of their cell phone provider

  Rate of return for buying the annual permit

The annual parking permit costs $100 due August 15th, and the semester permits are $65 due August 15th and January 15th.

  Interest elastic the investment demand function

The more interest elastic (the flatter) the investment demand function, the stronger will be the “crowding out” effect associated with a pure fiscal policy measure.

  Salesman learned the price elasticity of demand

How many percent will increase in the total sales (revenue) if he cuts the price by 10%? Show your calculation process

  What annual rate of return must the endowment fund earn

If the interest from the endowment is to fund 100 students each year in the amount of $10,000 each

  Maximizing profit or minimizing the costs

Companies (Producers) usually strive for maximizing profit or minimizing the costs, often at a very high cost in overall economy.

  What is the cross-price elasticity of demand

If Starbucks raises its price by 6 percent and McDonald’s experiences a 0.6 percent increase in demand for its coffee, what is the cross-price elasticity of demand?

  What are the total current liabilities

If a company's accounts payable is $42,041, retained earnings are $412,474, long-term debt is $391,227 and your accrued expenses are $5,966, what are the total current liabilities?

  Suppose that the aggregate expenditure curve

Suppose that the aggregate expenditure curve can be expressed algebraically as AE=3,000 - 2,000r where AE is aggregate expenditures and r is the real interest rate expressed as decimal. You check the website of the Congressional Budget office and lea..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd