For the mathematical models either use Word Equations, or write down the formulas on a paper, take a photo, and copy the photo.

you MUST upload the word file and an Excel Workbook, in which each question is solved in a separate worksheet. For the optimization problems, you must use the Excel solver.

Question 2) (25 points) Consider a box with a limited weight of 50 and a limited volume of 8. We want to select a subset of the following items and put them into the box to maximize the total value. We cannot violate the weight and volume capacity of the box. Item ABCDEFG Weight 13 20 8 18 15129 Volume 4 424 1 20 Value 8168 1410107 1- Write a mathematical optimization model for this problem. Clearly define decision variables, objective function, and constraints for the optimization model. 2- Use Excel to solve the optimization model. Which items should be selected? What is the optimal value of the objective function? 3- (Bonus question) (5 points) Can you design a simple algorithm that simultaneously incorporates weights, volumes, and values of the items to solve this