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)
(months) Cost per 1,000 sq. feet leased
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.
The solution provides a detailed and step-by-step explanation (incl. Excel program) for the problem.