I\'m attempting to find the minimum allowed surface area on a cylinder that has

Question

I'm attempting to find the minimum allowed surface area on a cylinder that has a volume of 1400m3. To do this, I'm using the Solver feature in Microsoft Excel to find the minimum value of a particular cell. My current set up looks like this:

When I run this however, cell B4's formula is removed and replaced only by the number 1400, so Excel has both the radius and height set to zero to achieve a minimum surface area in E4. Is there a way so that I can set the cell B4 to be equal to 1400 but still follow its formula (volume of a cylinder formula is in cell B4, and surface area of a cylinder formula is in E4)?

Volume (V) [m Radius ()m Height (h) [m Surface Area (S) [m2] 700.2767104 700.2767104 Solver Pa n neters 1399.697337 1399.697337 5.45 5.45 15 15 4 Solver Set Objective To: Max Min By Changing Variable Cells SE$4 Value Of: SC$4,SDS4,SBS4 10 Subject to the Constraints 12 13 14 15 16 17 18 19 20 21 SB$4 1400 SC$40 Add Change Delete Reset A Load/Save Make Unconstrained Variables Non-Negative 23 24 25 26 27 28 29 30 31 32 Select a Solving Method: GRG Nonlinear Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems and select the Evolutionary engine for Solver problems that are non- smooth. Close Solve 34

Explanation / Answer

First Most importantly remove B4 from the ' By changing Variable cell' category in solver wizard. We are supposed to make changes only in radius and height. ie only in cells C4 and D4.

Give proper formula with respective cell references in B4 (formula for volume) and E4(formula for surface area).

Now give some random values other than zero to radius and height that is is cells C4 and D4. This will prevent the solver from assuming zero to the variable cells.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.