Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is a nonlinear optimisation problem and how can I solve it in Excel Solver. Thanks :) You are going to build a new office
This is a nonlinear optimisation problem and how can I solve it in Excel Solver. Thanks :)
You are going to build a new office building. It will be a rectangular single storey building having area A square metres. The length of the perimeter wall has to be minimised to reduce costs. (a) Assuming that north-south walls have length X and east-west walls have length Y. What sizes of X and Y are optimal for a building area 54 square metres? What is the total perimeter and what are total lengths of all north-south walls and then all east-west walls? (b) Suppose that there will be an internal wall parallel to the side walls, to divide the building into two main rooms. The plan of the building looks like this: X Y So, there are 3 parallel (north-south) walls each of length X and 2 parallel (east-west) walls each of length Y. Use the Solver in Excel to minimise this total length subject to the area A being equal to 54 square metres. Again, calculate the total length of the all north-south walls (three of them) and the total length of the two east-west walls and compare these totals. What do you see any pattern? You can try to repeat this process for a different area. Perhaps try A = 24. Does the same kind of thing happen in as for A = 54? (c) Now suppose that there will be two internal walls parallel to the side walls, like this: X Y Now there are 4 walls of length X and 2 of length Y. Use the Excel Solver to minimise the total wall length for an area of 50 square metres. Report the answers to two decimal places. How does the value of all north-south walls compare with the value of east-west walls? You are going to build a new office building. It will be a rectangular single storey building having area A square metres. The length of the perimeter wall has to be minimised to reduce costs. (a) Assuming that north-south walls have length X and east-west walls have length Y. What sizes of X and Y are optimal for a building area 54 square metres? What is the total perimeter and what are total lengths of all north-south walls and then all east-west walls? (b) Suppose that there will be an internal wall parallel to the side walls, to divide the building into two main rooms. The plan of the building looks like this: X Y So, there are 3 parallel (north-south) walls each of length X and 2 parallel (east-west) walls each of length Y. Use the Solver in Excel to minimise this total length subject to the area A being equal to 54 square metres. Again, calculate the total length of the all north-south walls (three of them) and the total length of the two east-west walls and compare these totals. What do you see any pattern? You can try to repeat this process for a different area. Perhaps try A = 24. Does the same kind of thing happen in as for A = 54? (c) Now suppose that there will be two internal walls parallel to the side walls, like this: X Y Now there are 4 walls of length X and 2 of length Y. Use the Excel Solver to minimise the total wall length for an area of 50 square metres. Report the answers to two decimal places. How does the value of all north-south walls compare with the value of east-west wallsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started