Construct an Excel spreadsheet to help make cylindrical containers by drilling out aluminum cylinders

The constraints:
• The drilled-out volume must be 85 cm³.
• A minimum wall and bottom thickness of 0.4 cm must be allowed for strength.
Other information:
• The cost of aluminum is $.025/cm³ (applied to the volume before drilling).
• The drilling cost is $0.13×L + $0.34×D for D $0.13×L + $0.41×D for D ≥ 3cm where L and D are the length and diameter of the drilled hole (in cm), respectively.
Objectives: Find the cost for various possible dimensions, and find the minimum cost.
Construct your spreadsheet so that each numerical value given above is displayed in a cell on the spreadsheet, and so that changing any one of those values will automatically change all calculations accordingly.
Also have Excel graph the total cost of the part as a function of the drilled diameter (use a diameter range of 2.0 - 5.0 cm.
Turn your spreadsheet and graph based on the given values (with your formulas also indicated).

Transcribed Image Text:

L D