I am stuck on this and have no idea of how to set up my excel spreadsheet...

Your homework assignment is to develop a spreadsheet to calculate the total cost of the packaging materials in a carton of 24 "tin" cans in which each can has a volume of 16 pi cubic inches. Due to the way they are manufactured, cans are in the shape of a right circular cylinder. Also, the cardboard boxes the cans are shipped in are in the shape of a rectangular prism. To simplify the calculations, use the cost of the materials to make the cans as $0.109 per square foot of surface area. The materials to make the box cost $0.056 per square foot. The box must have all six complete sides and there is no overlap. Determine three sets of dimensions that result in a volume of 16 pi cubic inches. For example, if the radius is 1.00 in, the height would be 16.00 inches. For each of these try three ways of packing the can:s in a carton. For example, one way could be 2 high X 6 wide X 2 deep. A second way could be 1 high X6 wide X 4 deep. Therefore, you wil have a total of nine cases. Once the calculations are done, prepare an isometric drawing of the lowest total cost case and the corresponding orthographic views. Since orthographic views are two dimensional, one view will show the cans as circles and the other two will show the cans as rectangles Attached is an example spreadsheet with one set of dimensions and one packing arrangement calculated. The drawings for the one case calculated is also shown. Notice that there is one degree of freedom in the dimensions of the can. I designed the spreadsheet to input the radius and calculate the height using the given volume and chosen radius. There are two degrees of freedom in the packing arrangement. I designed the spreadsheet to input the number high and number wide. The number deep can then be calculated from these inputs and the specification that there are 24 cans in a carton. It is recommended that you do some reverse engineering and can replicate my case 1A before trying other sets of inputs. The drawings may be free hand ll ll ll Your homework assignment is to develop a spreadsheet to calculate the total cost of the packaging materials in a carton of 24 "tin" cans in which each can has a volume of 16 pi cubic inches. Due to the way they are manufactured, cans are in the shape of a right circular cylinder. Also, the cardboard boxes the cans are shipped in are in the shape of a rectangular prism. To simplify the calculations, use the cost of the materials to make the cans as $0.109 per square foot of surface area. The materials to make the box cost $0.056 per square foot. The box must have all six complete sides and there is no overlap. Determine three sets of dimensions that result in a volume of 16 pi cubic inches. For example, if the radius is 1.00 in, the height would be 16.00 inches. For each of these try three ways of packing the can:s in a carton. For example, one way could be 2 high X 6 wide X 2 deep. A second way could be 1 high X6 wide X 4 deep. Therefore, you wil have a total of nine cases. Once the calculations are done, prepare an isometric drawing of the lowest total cost case and the corresponding orthographic views. Since orthographic views are two dimensional, one view will show the cans as circles and the other two will show the cans as rectangles Attached is an example spreadsheet with one set of dimensions and one packing arrangement calculated. The drawings for the one case calculated is also shown. Notice that there is one degree of freedom in the dimensions of the can. I designed the spreadsheet to input the radius and calculate the height using the given volume and chosen radius. There are two degrees of freedom in the packing arrangement. I designed the spreadsheet to input the number high and number wide. The number deep can then be calculated from these inputs and the specification that there are 24 cans in a carton. It is recommended that you do some reverse engineering and can replicate my case 1A before trying other sets of inputs. The drawings may be free hand ll ll ll