Question: 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 :)

 This is a nonlinear optimisation problem and how can I solve

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 walls

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!