Οperational Research And linear Programming-The Houses Builder Problem












2














EXERCISE




A builder has purchased $21,000$ square meters of land on which it is planned to build two types of houses, X(detached) and Y(a combination of town-house units), within an overall budget of $2100000$ euros.



A type X house costs $35000$ euros to build and requires $600$ square meters of land. A type Y house cost $60000$ euros to build and requires $300$ square meters of land.



To comply with local planning regulations, not more than $40$ buildings may be constructed on this land, but there must be at least five of each type. From past experience, it is known that the profit per type X house is about $10000$ euros and per type Y house to be about $6000$ euros.Profit is to maximized




QUESTION




The problem must be formulated in the form of linear programming and has to be solved in EXCEL by SOLVER. Based on this output, you have to state what the optimal solution is.




ATTEMPT




  • Definition Of The Variables


X: Type X houses(Detached)



Y: Type Y houses(a combination of town-house units)




  • Objective Function


Maximize problem(Profit is to maximized)
$$textrm{Max profit} =10000X + 6000Y$$




  • Constraints


$X+Y leq 40$ (Not more than $40$ Buildings)



$600X+300Y leq 21000$(Square meters Constraint)



$35000X+60000Y leq 2100000$(Land requirements)



$X geq 5$ (At Least Five Of Each Type)



$Y geq 5$ (At Least Five Of Each Type)



So, when I get these constraints in my excel, Solver can't find a feasible solution and I don't know why. Is there any problem with my mathematical modelling? I believe that the constraints are obvious from the exercise!



This is my Formulation in Excel:
enter image description here



and this is the message when I use Solver to solve it and find MaxProf:
enter image description here



I would be really grateful if somebody can help me with this as it's important for the next questions of my project! Any thorough solution or explanation would be really helpful!



Thanks in advance!










share|cite|improve this question
























  • I'm voting to close this question as off-topic because the question is not math related. Better site maybe super user meta.stackexchange.com/questions/155487/…
    – mathcounterexamples.net
    Dec 26 at 13:03










  • I´ve done the same in excel. It gave me the same message. It seems that the program is not feasible. Have you tried to sketch the feasible solution space?
    – callculus
    Dec 26 at 13:17












  • Υeah, but why? Did you use the same mathematical modelling as me? It seems impossible to me that the program is not feasible, because it's only the first question in my project. All the other questions depend on this question! Strange ha?
    – Magic K. Mamba
    Dec 26 at 13:26










  • @callculus yeah and I didn't find any feasible solution!
    – Magic K. Mamba
    Dec 26 at 13:31










  • It is clear that the problem has no solution. With a minimum of 5 houses of each, you don’t have enough land.
    – mathcounterexamples.net
    Dec 26 at 13:48
















2














EXERCISE




A builder has purchased $21,000$ square meters of land on which it is planned to build two types of houses, X(detached) and Y(a combination of town-house units), within an overall budget of $2100000$ euros.



A type X house costs $35000$ euros to build and requires $600$ square meters of land. A type Y house cost $60000$ euros to build and requires $300$ square meters of land.



To comply with local planning regulations, not more than $40$ buildings may be constructed on this land, but there must be at least five of each type. From past experience, it is known that the profit per type X house is about $10000$ euros and per type Y house to be about $6000$ euros.Profit is to maximized




QUESTION




The problem must be formulated in the form of linear programming and has to be solved in EXCEL by SOLVER. Based on this output, you have to state what the optimal solution is.




ATTEMPT




  • Definition Of The Variables


X: Type X houses(Detached)



Y: Type Y houses(a combination of town-house units)




  • Objective Function


Maximize problem(Profit is to maximized)
$$textrm{Max profit} =10000X + 6000Y$$




  • Constraints


$X+Y leq 40$ (Not more than $40$ Buildings)



$600X+300Y leq 21000$(Square meters Constraint)



$35000X+60000Y leq 2100000$(Land requirements)



$X geq 5$ (At Least Five Of Each Type)



$Y geq 5$ (At Least Five Of Each Type)



So, when I get these constraints in my excel, Solver can't find a feasible solution and I don't know why. Is there any problem with my mathematical modelling? I believe that the constraints are obvious from the exercise!



This is my Formulation in Excel:
enter image description here



and this is the message when I use Solver to solve it and find MaxProf:
enter image description here



I would be really grateful if somebody can help me with this as it's important for the next questions of my project! Any thorough solution or explanation would be really helpful!



Thanks in advance!










share|cite|improve this question
























  • I'm voting to close this question as off-topic because the question is not math related. Better site maybe super user meta.stackexchange.com/questions/155487/…
    – mathcounterexamples.net
    Dec 26 at 13:03










  • I´ve done the same in excel. It gave me the same message. It seems that the program is not feasible. Have you tried to sketch the feasible solution space?
    – callculus
    Dec 26 at 13:17












  • Υeah, but why? Did you use the same mathematical modelling as me? It seems impossible to me that the program is not feasible, because it's only the first question in my project. All the other questions depend on this question! Strange ha?
    – Magic K. Mamba
    Dec 26 at 13:26










  • @callculus yeah and I didn't find any feasible solution!
    – Magic K. Mamba
    Dec 26 at 13:31










  • It is clear that the problem has no solution. With a minimum of 5 houses of each, you don’t have enough land.
    – mathcounterexamples.net
    Dec 26 at 13:48














2












2








2







EXERCISE




A builder has purchased $21,000$ square meters of land on which it is planned to build two types of houses, X(detached) and Y(a combination of town-house units), within an overall budget of $2100000$ euros.



A type X house costs $35000$ euros to build and requires $600$ square meters of land. A type Y house cost $60000$ euros to build and requires $300$ square meters of land.



To comply with local planning regulations, not more than $40$ buildings may be constructed on this land, but there must be at least five of each type. From past experience, it is known that the profit per type X house is about $10000$ euros and per type Y house to be about $6000$ euros.Profit is to maximized




QUESTION




The problem must be formulated in the form of linear programming and has to be solved in EXCEL by SOLVER. Based on this output, you have to state what the optimal solution is.




ATTEMPT




  • Definition Of The Variables


X: Type X houses(Detached)



Y: Type Y houses(a combination of town-house units)




  • Objective Function


Maximize problem(Profit is to maximized)
$$textrm{Max profit} =10000X + 6000Y$$




  • Constraints


$X+Y leq 40$ (Not more than $40$ Buildings)



$600X+300Y leq 21000$(Square meters Constraint)



$35000X+60000Y leq 2100000$(Land requirements)



$X geq 5$ (At Least Five Of Each Type)



$Y geq 5$ (At Least Five Of Each Type)



So, when I get these constraints in my excel, Solver can't find a feasible solution and I don't know why. Is there any problem with my mathematical modelling? I believe that the constraints are obvious from the exercise!



This is my Formulation in Excel:
enter image description here



and this is the message when I use Solver to solve it and find MaxProf:
enter image description here



I would be really grateful if somebody can help me with this as it's important for the next questions of my project! Any thorough solution or explanation would be really helpful!



Thanks in advance!










share|cite|improve this question















EXERCISE




A builder has purchased $21,000$ square meters of land on which it is planned to build two types of houses, X(detached) and Y(a combination of town-house units), within an overall budget of $2100000$ euros.



A type X house costs $35000$ euros to build and requires $600$ square meters of land. A type Y house cost $60000$ euros to build and requires $300$ square meters of land.



To comply with local planning regulations, not more than $40$ buildings may be constructed on this land, but there must be at least five of each type. From past experience, it is known that the profit per type X house is about $10000$ euros and per type Y house to be about $6000$ euros.Profit is to maximized




QUESTION




The problem must be formulated in the form of linear programming and has to be solved in EXCEL by SOLVER. Based on this output, you have to state what the optimal solution is.




ATTEMPT




  • Definition Of The Variables


X: Type X houses(Detached)



Y: Type Y houses(a combination of town-house units)




  • Objective Function


Maximize problem(Profit is to maximized)
$$textrm{Max profit} =10000X + 6000Y$$




  • Constraints


$X+Y leq 40$ (Not more than $40$ Buildings)



$600X+300Y leq 21000$(Square meters Constraint)



$35000X+60000Y leq 2100000$(Land requirements)



$X geq 5$ (At Least Five Of Each Type)



$Y geq 5$ (At Least Five Of Each Type)



So, when I get these constraints in my excel, Solver can't find a feasible solution and I don't know why. Is there any problem with my mathematical modelling? I believe that the constraints are obvious from the exercise!



This is my Formulation in Excel:
enter image description here



and this is the message when I use Solver to solve it and find MaxProf:
enter image description here



I would be really grateful if somebody can help me with this as it's important for the next questions of my project! Any thorough solution or explanation would be really helpful!



Thanks in advance!







optimization linear-programming mathematical-modeling






share|cite|improve this question















share|cite|improve this question













share|cite|improve this question




share|cite|improve this question








edited Dec 26 at 23:13









callculus

17.8k31427




17.8k31427










asked Dec 26 at 12:52









Magic K. Mamba

316113




316113












  • I'm voting to close this question as off-topic because the question is not math related. Better site maybe super user meta.stackexchange.com/questions/155487/…
    – mathcounterexamples.net
    Dec 26 at 13:03










  • I´ve done the same in excel. It gave me the same message. It seems that the program is not feasible. Have you tried to sketch the feasible solution space?
    – callculus
    Dec 26 at 13:17












  • Υeah, but why? Did you use the same mathematical modelling as me? It seems impossible to me that the program is not feasible, because it's only the first question in my project. All the other questions depend on this question! Strange ha?
    – Magic K. Mamba
    Dec 26 at 13:26










  • @callculus yeah and I didn't find any feasible solution!
    – Magic K. Mamba
    Dec 26 at 13:31










  • It is clear that the problem has no solution. With a minimum of 5 houses of each, you don’t have enough land.
    – mathcounterexamples.net
    Dec 26 at 13:48


















  • I'm voting to close this question as off-topic because the question is not math related. Better site maybe super user meta.stackexchange.com/questions/155487/…
    – mathcounterexamples.net
    Dec 26 at 13:03










  • I´ve done the same in excel. It gave me the same message. It seems that the program is not feasible. Have you tried to sketch the feasible solution space?
    – callculus
    Dec 26 at 13:17












  • Υeah, but why? Did you use the same mathematical modelling as me? It seems impossible to me that the program is not feasible, because it's only the first question in my project. All the other questions depend on this question! Strange ha?
    – Magic K. Mamba
    Dec 26 at 13:26










  • @callculus yeah and I didn't find any feasible solution!
    – Magic K. Mamba
    Dec 26 at 13:31










  • It is clear that the problem has no solution. With a minimum of 5 houses of each, you don’t have enough land.
    – mathcounterexamples.net
    Dec 26 at 13:48
















I'm voting to close this question as off-topic because the question is not math related. Better site maybe super user meta.stackexchange.com/questions/155487/…
– mathcounterexamples.net
Dec 26 at 13:03




I'm voting to close this question as off-topic because the question is not math related. Better site maybe super user meta.stackexchange.com/questions/155487/…
– mathcounterexamples.net
Dec 26 at 13:03












I´ve done the same in excel. It gave me the same message. It seems that the program is not feasible. Have you tried to sketch the feasible solution space?
– callculus
Dec 26 at 13:17






I´ve done the same in excel. It gave me the same message. It seems that the program is not feasible. Have you tried to sketch the feasible solution space?
– callculus
Dec 26 at 13:17














Υeah, but why? Did you use the same mathematical modelling as me? It seems impossible to me that the program is not feasible, because it's only the first question in my project. All the other questions depend on this question! Strange ha?
– Magic K. Mamba
Dec 26 at 13:26




Υeah, but why? Did you use the same mathematical modelling as me? It seems impossible to me that the program is not feasible, because it's only the first question in my project. All the other questions depend on this question! Strange ha?
– Magic K. Mamba
Dec 26 at 13:26












@callculus yeah and I didn't find any feasible solution!
– Magic K. Mamba
Dec 26 at 13:31




@callculus yeah and I didn't find any feasible solution!
– Magic K. Mamba
Dec 26 at 13:31












It is clear that the problem has no solution. With a minimum of 5 houses of each, you don’t have enough land.
– mathcounterexamples.net
Dec 26 at 13:48




It is clear that the problem has no solution. With a minimum of 5 houses of each, you don’t have enough land.
– mathcounterexamples.net
Dec 26 at 13:48










1 Answer
1






active

oldest

votes


















1














You have made a typo at the exercise. $text{It is "A builder has purchased 21,00}$ $color{red}{0}$ $text{square meters of land}$ $text{on which it is planned to build... "}$



But you have written it at your constraint: $600X+300Y leq 21,000 $ (Square meters Constraint)



If you use this constraint the problem is feasible. This is what I got by using the Excel solver:



enter image description here



Excel sheet with formulas



enter image description here



Input mask



enter image description here






share|cite|improve this answer



















  • 1




    This is after using Solver?I use Sumproduct function,not Sum!Is this wrong?And what is these $1050000$ and $600000$??From where did you get these?
    – Magic K. Mamba
    Dec 26 at 14:07










  • It is $30cdot 35000=1,050,000$ for instance. And similar for y: $10cdot 60,000=600,000$
    – callculus
    Dec 26 at 14:10












  • So,i made mistake with the variables.I use 1 and 1 but that's wrong because i have a constraint that tells me that i have $Y geq 5$ and $X geq 5$.Right?
    – Magic K. Mamba
    Dec 26 at 14:12










  • And why you use Sum function?
    – Magic K. Mamba
    Dec 26 at 14:14






  • 1




    No problem. We are here to help, especially on Christmas. Yeah, I´ve used the solver.
    – callculus
    Dec 26 at 14:25











Your Answer





StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
});
});
}, "mathjax-editing");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "69"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3052913%2f%25ce%259fperational-research-and-linear-programming-the-houses-builder-problem%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









1














You have made a typo at the exercise. $text{It is "A builder has purchased 21,00}$ $color{red}{0}$ $text{square meters of land}$ $text{on which it is planned to build... "}$



But you have written it at your constraint: $600X+300Y leq 21,000 $ (Square meters Constraint)



If you use this constraint the problem is feasible. This is what I got by using the Excel solver:



enter image description here



Excel sheet with formulas



enter image description here



Input mask



enter image description here






share|cite|improve this answer



















  • 1




    This is after using Solver?I use Sumproduct function,not Sum!Is this wrong?And what is these $1050000$ and $600000$??From where did you get these?
    – Magic K. Mamba
    Dec 26 at 14:07










  • It is $30cdot 35000=1,050,000$ for instance. And similar for y: $10cdot 60,000=600,000$
    – callculus
    Dec 26 at 14:10












  • So,i made mistake with the variables.I use 1 and 1 but that's wrong because i have a constraint that tells me that i have $Y geq 5$ and $X geq 5$.Right?
    – Magic K. Mamba
    Dec 26 at 14:12










  • And why you use Sum function?
    – Magic K. Mamba
    Dec 26 at 14:14






  • 1




    No problem. We are here to help, especially on Christmas. Yeah, I´ve used the solver.
    – callculus
    Dec 26 at 14:25
















1














You have made a typo at the exercise. $text{It is "A builder has purchased 21,00}$ $color{red}{0}$ $text{square meters of land}$ $text{on which it is planned to build... "}$



But you have written it at your constraint: $600X+300Y leq 21,000 $ (Square meters Constraint)



If you use this constraint the problem is feasible. This is what I got by using the Excel solver:



enter image description here



Excel sheet with formulas



enter image description here



Input mask



enter image description here






share|cite|improve this answer



















  • 1




    This is after using Solver?I use Sumproduct function,not Sum!Is this wrong?And what is these $1050000$ and $600000$??From where did you get these?
    – Magic K. Mamba
    Dec 26 at 14:07










  • It is $30cdot 35000=1,050,000$ for instance. And similar for y: $10cdot 60,000=600,000$
    – callculus
    Dec 26 at 14:10












  • So,i made mistake with the variables.I use 1 and 1 but that's wrong because i have a constraint that tells me that i have $Y geq 5$ and $X geq 5$.Right?
    – Magic K. Mamba
    Dec 26 at 14:12










  • And why you use Sum function?
    – Magic K. Mamba
    Dec 26 at 14:14






  • 1




    No problem. We are here to help, especially on Christmas. Yeah, I´ve used the solver.
    – callculus
    Dec 26 at 14:25














1












1








1






You have made a typo at the exercise. $text{It is "A builder has purchased 21,00}$ $color{red}{0}$ $text{square meters of land}$ $text{on which it is planned to build... "}$



But you have written it at your constraint: $600X+300Y leq 21,000 $ (Square meters Constraint)



If you use this constraint the problem is feasible. This is what I got by using the Excel solver:



enter image description here



Excel sheet with formulas



enter image description here



Input mask



enter image description here






share|cite|improve this answer














You have made a typo at the exercise. $text{It is "A builder has purchased 21,00}$ $color{red}{0}$ $text{square meters of land}$ $text{on which it is planned to build... "}$



But you have written it at your constraint: $600X+300Y leq 21,000 $ (Square meters Constraint)



If you use this constraint the problem is feasible. This is what I got by using the Excel solver:



enter image description here



Excel sheet with formulas



enter image description here



Input mask



enter image description here







share|cite|improve this answer














share|cite|improve this answer



share|cite|improve this answer








edited Dec 26 at 14:45

























answered Dec 26 at 14:02









callculus

17.8k31427




17.8k31427








  • 1




    This is after using Solver?I use Sumproduct function,not Sum!Is this wrong?And what is these $1050000$ and $600000$??From where did you get these?
    – Magic K. Mamba
    Dec 26 at 14:07










  • It is $30cdot 35000=1,050,000$ for instance. And similar for y: $10cdot 60,000=600,000$
    – callculus
    Dec 26 at 14:10












  • So,i made mistake with the variables.I use 1 and 1 but that's wrong because i have a constraint that tells me that i have $Y geq 5$ and $X geq 5$.Right?
    – Magic K. Mamba
    Dec 26 at 14:12










  • And why you use Sum function?
    – Magic K. Mamba
    Dec 26 at 14:14






  • 1




    No problem. We are here to help, especially on Christmas. Yeah, I´ve used the solver.
    – callculus
    Dec 26 at 14:25














  • 1




    This is after using Solver?I use Sumproduct function,not Sum!Is this wrong?And what is these $1050000$ and $600000$??From where did you get these?
    – Magic K. Mamba
    Dec 26 at 14:07










  • It is $30cdot 35000=1,050,000$ for instance. And similar for y: $10cdot 60,000=600,000$
    – callculus
    Dec 26 at 14:10












  • So,i made mistake with the variables.I use 1 and 1 but that's wrong because i have a constraint that tells me that i have $Y geq 5$ and $X geq 5$.Right?
    – Magic K. Mamba
    Dec 26 at 14:12










  • And why you use Sum function?
    – Magic K. Mamba
    Dec 26 at 14:14






  • 1




    No problem. We are here to help, especially on Christmas. Yeah, I´ve used the solver.
    – callculus
    Dec 26 at 14:25








1




1




This is after using Solver?I use Sumproduct function,not Sum!Is this wrong?And what is these $1050000$ and $600000$??From where did you get these?
– Magic K. Mamba
Dec 26 at 14:07




This is after using Solver?I use Sumproduct function,not Sum!Is this wrong?And what is these $1050000$ and $600000$??From where did you get these?
– Magic K. Mamba
Dec 26 at 14:07












It is $30cdot 35000=1,050,000$ for instance. And similar for y: $10cdot 60,000=600,000$
– callculus
Dec 26 at 14:10






It is $30cdot 35000=1,050,000$ for instance. And similar for y: $10cdot 60,000=600,000$
– callculus
Dec 26 at 14:10














So,i made mistake with the variables.I use 1 and 1 but that's wrong because i have a constraint that tells me that i have $Y geq 5$ and $X geq 5$.Right?
– Magic K. Mamba
Dec 26 at 14:12




So,i made mistake with the variables.I use 1 and 1 but that's wrong because i have a constraint that tells me that i have $Y geq 5$ and $X geq 5$.Right?
– Magic K. Mamba
Dec 26 at 14:12












And why you use Sum function?
– Magic K. Mamba
Dec 26 at 14:14




And why you use Sum function?
– Magic K. Mamba
Dec 26 at 14:14




1




1




No problem. We are here to help, especially on Christmas. Yeah, I´ve used the solver.
– callculus
Dec 26 at 14:25




No problem. We are here to help, especially on Christmas. Yeah, I´ve used the solver.
– callculus
Dec 26 at 14:25


















draft saved

draft discarded




















































Thanks for contributing an answer to Mathematics Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


Use MathJax to format equations. MathJax reference.


To learn more, see our tips on writing great answers.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3052913%2f%25ce%259fperational-research-and-linear-programming-the-houses-builder-problem%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Human spaceflight

Can not write log (Is /dev/pts mounted?) - openpty in Ubuntu-on-Windows?

張江高科駅