How the shift alters the optimal total cost

Assignment Help Computer Engineering
Reference no: EM132171819

Using microsoft excel and the solver ad in and solver sensitivity report solve the following question:

Cox Cable Company needs to lease warehouse storage space for five months at the start of the year. It knows how much space will be required in each month. However, since these space requirements are quite different, it may be economical to lease only the amount needed each month on a month-by-month basis.

On the other hand, the monthly cost for leasing space for additional months is much less than for the first month, so it may be desirable to lease the maximum amount needed for the entire five months.

Another option is the intermediate approach of changing the total amount of space leased (by adding a new lease and/or having an old lease expire) at least once but not every month. Two or more leases for different terms can begin at the same time.

The space requirements (in square feet) and the leasing costs (in dollars per thousand square feet) are given in the tables below.

Month

Space requirements

Lease length

Lease cost

Jan

15,000

1 month

$280

Feb

10,000

2

450

Mar

20,000

3

600

April

5000

4

730

May

25,000

5

820

The task is to find a leasing schedule that provides the necessary amounts of space at the minimum cost.

A.) Determine the optimal leasing schedule and the optimal total cost.

B.) Consider what happens when the cost of a 5-month lease (currently $820) changes. Construct a graph showing how the optimal total cost varies with the cost of a 5-month lease, over the range from $800 to $1000.

C.) Consider instead what happens when the timing of space requirements shifts. In particular, suppose that March requirements drop and April requirements rise by the same amount. Construct a table to show, for shift amounts up to 15,000 square feet, how the shift alters the optimal total cost.

Reference no: EM132171819

Questions Cloud

What will the price of this stock be 8 years from now : The required return on this stock is 11 percent. What will the price of this stock be 8 years from now?
Compute mean of the sampling distribution : Compute mean of the sampling distribution and standard deviations for each n in the outer loop and print them out one row, (e.g. print(c(mean,std)).
Write a program to accept a user input as a number : Write a program to accept a user input as a number and perform one of the options selected from the following menu.
What steps would should someone recommend : What steps would should someone recommend? Can someone site source so I may get a little added help understanding this?
How the shift alters the optimal total cost : Construct a table to show, for shift amounts up to 15,000 square feet, how the shift alters the optimal total cost.
Cost of common stock : Divided Walls Construction (DWC) has determined that the yield to maturity (YTM) on new bonds is 5 percent, and its cost of common stock is 11 percent
Write a function that returns a list with all the prime : Write a function that returns a list with all the prime numbers from 1 to 1000. The program should have a loop that calls the is_prime function.
A program that count both capitalized and lower case : Write a function named countArticles() that count both capitalized and lower case instances of articles.
Create a program that shows prospective customers : An online bank wants you to create a program that shows prospective customers how their deposits will grow.

Reviews

Write a Review

Computer Engineering Questions & Answers

  Describe the four steps in the lead generation process

Why do you think B2B marketers consider producing an acceptable quantity of high quality sales leads one of their most important challenges?

  Define how a databses management system

describe how a databses management system (DBMS) and data mining can help a motor vehicle maintenance center improve its services, and what tables would be needed in such a database. Also what additional way can the DBMS and data mining be used to..

  Activity diagram and a use case diagram

AREI real estate agents utilize its information in order to search AREI’s database and the different listing service for houses which meet their needs.

  How it governance will improve effectiveness of it division

Assess how IT governance will improve the effectiveness of the IT Division to attain regulatory compliance. Develop a broad vision, an architecture.

  Communication diagram and sequence diagram

Why you would generate a communication diagram in place of a sequence diagram? Describe what the arrow which points to an object in the communication diagram implies.

  Was the leadership team afraid of change

Select an organization or industry that is facing significant change - Why were the leaders of your chosen company or industry unable to adapt to the changing

  Analyze improvements over the last two years to technology

Analyze the improvements over the last two years to your communication technology topic, and suggest an improvement based on its current usage.

  What is the salary range for chosen career goal position

What is the career goal (or position) you want to pursue and why? What is the salary range for your chosen Career Goal position?

  You have been recently hired to help with purchasing

you have been recently hired to assist with purchasing computer forensics tools and resources for a major corporation.

  Discuss the concept of image

Discuss the concept of "image." How does image affect one's interpretation of an organization? How does it affect how one approaches organizational issues?

  Discuss changing management concern would impact the it

analyze whether or not changing your management concern would impact the IT that you chose

  Examine a visual development environment in your facility

Examine a visual development environment in your facility. Is the environment based on control integration? Data integration?

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