A company needs to lease warehouse storage space
Not what you're looking for?
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.
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.