Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Financial Theory

Authors: Jean-Pierre Danthine, John B. Donaldson

3rd Edition

0123865492, 9780123865496

More Books

Students also viewed these Finance questions

Question

10. Describe the relationship between communication and power.

Answered: 1 week ago