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.
