# Construct an Excel spreadsheet to help make cylindrical containers by drilling out aluminum cylinders The constraints: The drilled-out volume

## Question:

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

The constraints:
• The drilled-out volume must be 85 cm3.
• 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.