3.4-9. Web Mercantile sells many household products through an on-line catalog. The company needs substantial warehouse space for storing its goods. Plans now are being made for leasing ware- house storage space over the next 5 months. Just how much space will be required in each of these months is known. However, since these space requirements are quite different, it may be most eco- nomical to lease only the amount needed each month on a month- by-month basis. On the other hand, the additional cost for leasing space for additional months is much less than for the first month, so it may be less expensive to lease the maximum amount needed for the entire 5 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. The space requirement and the leasing costs for the various leasing periods are as follows: Required Month Space (Sq. Ft.) Leasing Period Cost per Sq. Ft. (Months) Leased $ 65 $100 30,000 20,000 40,000 10,000 50,000 1 1 3 $135 4 4 $160 5 $190 The objective is to minimize the total leasing cost for meeting the space requirements. (a) Formulate a linear programming model for this problem. c (b) Solve this model by the simplex method.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
Excel Solver please
3.4-9. Web Mercantile sells many household products through an
on-line catalog. The company needs substantial warehouse space
for storing its goods. Plans now are being made for leasing ware-
house storage space over the next 5 months. Just how much space
will be required in each of these months is known. However, since
these space requirements are quite different, it may be most eco-
nomical to lease only the amount needed each month on a month-
by-month basis. On the other hand, the additional cost for leasing
space for additional months is much less than for the first month,
so it may be less expensive to lease the maximum amount needed
for the entire 5 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.
The space requirement and the leasing costs for the various
leasing periods are as follows:
Required
Month Space (Sq. Ft.)
Leasing Period Cost per Sq. Ft.
(Months)
Leased
$ 65
30,000
20,000
40,000
10,000
50,000
1
1
2
$100
3
3
$135
4
4
$160
$190
The objective is to minimize the total leasing cost for meeting the
space requirements.
(a) Formulate a linear programming model for this problem.
c (b) Solve this model by the simplex method.
3.4-10. Larry Edison is the director of the Computer Center for
Transcribed Image Text:3.4-9. Web Mercantile sells many household products through an on-line catalog. The company needs substantial warehouse space for storing its goods. Plans now are being made for leasing ware- house storage space over the next 5 months. Just how much space will be required in each of these months is known. However, since these space requirements are quite different, it may be most eco- nomical to lease only the amount needed each month on a month- by-month basis. On the other hand, the additional cost for leasing space for additional months is much less than for the first month, so it may be less expensive to lease the maximum amount needed for the entire 5 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. The space requirement and the leasing costs for the various leasing periods are as follows: Required Month Space (Sq. Ft.) Leasing Period Cost per Sq. Ft. (Months) Leased $ 65 30,000 20,000 40,000 10,000 50,000 1 1 2 $100 3 3 $135 4 4 $160 $190 The objective is to minimize the total leasing cost for meeting the space requirements. (a) Formulate a linear programming model for this problem. c (b) Solve this model by the simplex method. 3.4-10. Larry Edison is the director of the Computer Center for
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 6 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.