Construct an Excel spreadsheet to help make cylindrical containers by drilling out aluminum cylinders The constraints: The drilled-out volume
Construct an Excel spreadsheet to help make cylindrical containers by drilling out aluminum cylinders
• The drilled-out volume must be 85 cm3.
• A minimum wall and bottom thickness of 0.4 cm must be allowed for strength.
• The cost of aluminum is $.025/cm3 (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).
This problem has been solved!
Step by Step Answer: