Purchase Solution

A company needs to lease warehouse storage space

Not what you're looking for?

Ask Custom Question

A company needs to lease warehouse storage space for five months at the start of the year. The space requirements (in square feet) and the leasing costs of each type of lease are given in the two tables below:
Month Required Space (sq. feet)
Jan 15,000
Feb 10,000
Mar 20,000
Apr 5,000
May 25,000

Lease Term
(months) Cost per 1,000 sq. feet leased
1 $280
2 $450
3 $600
4 $730
5 $820

Leases for different terms can begin at the same time. In addition, a lease should not be entered into if its term extends past May.
(a) Create and solve a linear programming model for determining the leasing schedule that provides the required amounts of space at minimum cost.
(b) What would the impact of a 1,000 square foot increase in the space required for each of the months from January to May?

------------------------------
See attached for full problem description.

Attachments
Purchase this Solution

Solution Summary

The solution provides a detailed and step-by-step explanation (incl. Excel program) for the problem.

Purchase this Solution


Free BrainMass Quizzes
Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.