3. Solve the following Linear Programing Model using Excel Solver The Ministry of Human Settlements is planning to construct housing units on an 8000-sq. meter plot. The plan is to build two types of units: the "Pugad ng Lambingan" type and the "“Kandungan ng Pagsinta" type. The total funding for the project is P12.3 M (loan from the World Bank). Site development and building costs have been estimated at P75,000 per Lambingan unit and P95,000 per Pagsinta unit. It has also been estimated that about 25 Lambingan units can be built on each 1000 sq.-meter plot but only 15 Pagsinta units can be built on an area of the same size. Architectural and environmental considerations limit the total number of units (both types combined) to at most 155 units. However, the loan agreement itself carries the provision that at least 30 Lambingan and at least 20 Pagsinta units must be built. Finally, social considerations require that at least 20 Lambingan units must be constructed for each seven Pagsinta. It is expected that each Lambingan unit will house approximately 7 people while each Pagsinta unit will house about 5 people. If the objective is for the entire project to house as many people as possible subject to all the previously stated conditions, how many units of each type must be built? Formulate this problem as a linear programming model.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
100%
3. Solve the following Linear Programing Model using Excel Solver
The Ministry of Human Settlements is planning to construct housing units on an
8000-sq. meter plot. The plan is to build two types of units: the "“Pugad ng
Lambingan" type and the "Kandungan ng Pagsinta" type. The total funding
for the project is P12.3 M (loan from the World Bank). Site development
and building costs have been estimated at P75,000 per Lambingan unit and
P95,000 per Pagsinta unit. It has also been estimated that about 25
Lambingan units can be built on each 1000 sq.-meter plot but only 15
Pagsinta units can be built on an area of the same size. Architectural and
environmental considerations limit the total number of units (both types
combined) to at most 155 units. However, the loan agreement itself carries
the provision that at least 30 Lambingan and at least 20 Pagsinta units
must be built. Finally, social considerations require that at least 20
Lambingan units must be constructed for each seven Pagsinta. It is expected
that each Lambingan unit will house approximately 7 people while each
Pagsinta unit will house about 5 people. If the objective is for the entire project
to house as many people as possible subject to all the previously stated
conditions, how many units of each type must be built? Formulate this problem
as a linear programming model.
Transcribed Image Text:3. Solve the following Linear Programing Model using Excel Solver The Ministry of Human Settlements is planning to construct housing units on an 8000-sq. meter plot. The plan is to build two types of units: the "“Pugad ng Lambingan" type and the "Kandungan ng Pagsinta" type. The total funding for the project is P12.3 M (loan from the World Bank). Site development and building costs have been estimated at P75,000 per Lambingan unit and P95,000 per Pagsinta unit. It has also been estimated that about 25 Lambingan units can be built on each 1000 sq.-meter plot but only 15 Pagsinta units can be built on an area of the same size. Architectural and environmental considerations limit the total number of units (both types combined) to at most 155 units. However, the loan agreement itself carries the provision that at least 30 Lambingan and at least 20 Pagsinta units must be built. Finally, social considerations require that at least 20 Lambingan units must be constructed for each seven Pagsinta. It is expected that each Lambingan unit will house approximately 7 people while each Pagsinta unit will house about 5 people. If the objective is for the entire project to house as many people as possible subject to all the previously stated conditions, how many units of each type must be built? Formulate this problem as a linear programming model.
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman