2-30 A warehouse storage building company must determine how many storage sheds of each size-largeor small-to build in its new 8,000-square-foot facility to maximize rental income. Each large shed is150 square feet in size, requires $1 per week in advertising, and rents for $50 per week. Each smallshed is 50 square feet in size, requires $1 per week in advertising, and rents for $20 per week. Thecompany has a weekly advertising budget of $100 and estimates that it can rent no more than 40large sheds in any given week.

Linear programming is a mathematical method used to find the best possible outcome or solution from…

Answered: A warehouse storage building company…

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...

See similar textbooks

Similar questions

a) Suppose you walk into a large supermarket at 2 am with a friend. Your friend says, "I can't believe that these stores stay open all night. Only one out of fifteen checkout lines is open. There can't be more than ten shoppers in this store. It just doesn't make any sense for this store to be open all night." What conditions must be true for it to be to the advantage of the supermarket to stay open all night? b) Your friend has a large garden and grows fresh fruit and vegetables to be sold at a local "farmer's market." Last year your friend was the only worker in the garden, without any additional workers. However, this year your friend hired a worker and production more than doubled. He comments "Next summer, I think I'll hire another two workers (so total workers including myself would go up from 2 to 4) and my output should again more than double". Is it likely that he could hire more workers and always continue to reap greater than proportional increases in production? Why?
A diabetic patient needs at least 40 units of Vit. A, at least 30 units of Vit. C, and at least 40 units 30 units of Vit. E each day. Each brand X multivitamin capsule contains 4 units of Vit. A, 6 units of Vit. C, and 2 units of Vit. E; each brand Y capsule contains 5 units of Vit. A, 3 units of Vit.C, and 5 units of Vit. E. If each brand X capsule costs P6.00 and each brand Y capsule costs P9.00, how many capsules should the patient take each day to minimize the costs?
6. A company has a warehouse with the dimensions shown in the following diagram. How many pallets measuring 48"x40" can be stored three high if there is to be a 2" space between the pallets? 50' Aisle Aisle 4' 4' 4' 4'
A manufacturer that produces 100 different products is considering building a new warehouse because there is no room in raw material and product warehouses. Because although some products are more than in the warehouse, some demands that come due to the fact that the ban products are not enough in the warehouse are avoided. For this reason, it plans not to miss any demand by producing and storing enough of all its products, and of course it is considering building a new and larger warehouse to store more products. What can you suggest to this company, taking into account what is described in the course, describe your proposal in maximum detail with the concepts described in the course, as applicable activities.
(d) The company only has 4 workstations available. If it only operates its 4stations, how many weeks does it need to meet the production requirements?(e) The company has other contracts it needs to satisfy. Working on themugs more than 4 weeks means it will have to cancel another contract,incurring a penalty of $4,500. Each new workstation costs the company$2,500. What should the company do: cancel the contract or buy therequired workstations?
Maximize P = x + 4y subject to x + y ≤ 4 2x + y ≤ 5 x ≥ 0, y ≥ 0
Maximize P = x + 4y − 2z subject to 3x + y − z ≤ 40 2x + y − z ≤ 20 −x + y + z ≤ 40 x ≥ 0, y ≥ 0, z ≥ 0
d) A company can produce three products A, B and C. the products yield a contribution of Kshs.8, 5 and 10 respectively. The products use a machine which has 400 hours capacity. Each unit of the product uses 2, 3 and 1 hour respectively of the machines capacity. There are only 150 units available in the period of a special component which is used singly in product A and C. Only 200kgs of a special alloy is available in the period. The usage of special alloy is 2kgs per unit and 4kgs per unit respectively. There is an agreement with a trade association to produce no more than 50 units of product B in the period. Advise the company on the production plan that will maximize contribution.
#3 Mention some drawbacks of the Linear Model?
a.) in table 1, the transportation cost is?b.) in the evaluation of occupied cells in table 1, the value of W2 is?c.) in yhe evaluation of vacant/unoccupied cells in table 1, the highest negative index is?d.) in table 2, the tiles manufactured by PlantB will be supplied to distributor?e.) the transportation cost in table 2 is?f.) in the evaluation of occupied cells in table 2, the value of V2 is?g.) in the evaluation of occupied cells in table 2, the value of W3 is?h.) in the evaluation of unoccupied/vacant cells in table 2, the highest negative index is?i.) the optimal solution is found in table? **Note: find for the tables**
a.) in table 1, the transportation cost is? b.) in the evaluation of occupied cells in table 1, the value of W2 is? c.) in yhe evaluation of vacant/unoccupied cells in table 1, the highest negative index is? d.) in table 2, the tiles manufactured by PlantB will be supplied to distributor? e.) the transportation cost in table 2 is? f.) in the evaluation of occupied cells in table 2, the value of V2 is? g.) in the evaluation of occupied cells in table 2, the value of W3 is? h.) in the evaluation of unoccupied/vacant cells in table 2, the highest negative index is? i.) the optimal solution is found in table? **Note: find for the tables**

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS