technical report

This report will include two parts first an excel and the a word document.

The excel would include the optimized solution for the box size.

The word would include an introduction, abstract, result & discussions, conclusion and references.

check the attachment for the assignment details. 

We want to construct a box with a height, ????, and has a square base area with a base length ????. The material used to build the top and bottom faces costs 0.2 $/m2 and the material used to build the sides costs 0.15 $/m2. In this assignment, you need to formulate the required equations and use Microsoft Excel to find an optimized solution for the box size and cost. Then use Microsoft Word to write a report about this optimization process and discuss your results.