1. The drug distribution company LOS PAISAS wants to build a new warehouse in Carretera a Masaya area in which they intend to store the following products: equipment and products for babies. With these products, they plan to serve a total of 10,000 pharmacies in Managua. Equipments Baby products Demand (quantity pharmacies served) 2,000 8,000 Cost per product $1,000.00 $30.00 To achieve balanced use of products, baby product must be equal to 60% of authorized product units. Additionally, the number of units requested in medical equipment must be at least 20% of the total authorized. There are a total of 10,000 pharmacies. The optimal plan needs to be determined to maximize the amount of products they must have to meet demand and maximize profits. Can you please explain it Step-by-step and typed? Thank you in advance!
1. The drug distribution company LOS PAISAS wants to build a new warehouse in Carretera a Masaya area in which they intend to store the following products: equipment and products for babies. With these products, they plan to serve a total of 10,000 pharmacies in Managua. Equipments Baby products Demand (quantity pharmacies served) 2,000 8,000 Cost per product $1,000.00 $30.00 To achieve balanced use of products, baby product must be equal to 60% of authorized product units. Additionally, the number of units requested in medical equipment must be at least 20% of the total authorized. There are a total of 10,000 pharmacies. The optimal plan needs to be determined to maximize the amount of products they must have to meet demand and maximize profits. Can you please explain it Step-by-step and typed? Thank you in advance!
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...
Related questions
Question

Transcribed Image Text:1. The drug distribution company LOS PAISAS wants to build a new
warehouse in Carretera a Masaya area in which they intend to store the
following products: equipment and products for babies. With these products,
they plan to serve a total of 10,000 pharmacies in Managua.
Equipments
Baby products
Demand (quantity pharmacies served) 2,000
8,000
Cost per product
$1,000.00
$30.00
To achieve balanced use of products, baby product must be equal to 60% of
authorized product units. Additionally, the number of units requested in
medical equipment must be at least 20% of the total authorized. There are a
total of 10,000 pharmacies. The optimal plan needs to be determined to
maximize the amount of products they must have to meet demand and
maximize profits.
Can you please explain it Step-by-step and typed? Thank you in advance!
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 3 images

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
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
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


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.