Question: Question 2) (25 points) Consider a box with a limited weight of 50 and a limited volume of 8 . We want to select a

Question 2) (25 points) Consider a box with a

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. 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 problem? Your Answer: Part 1) Decision Variables: Objective Function: Constraints: Part 2) Which items should be selected to maximize total value: Part 2) Optimal Total Value: Part 3) (Optional) Explain your algorithm here

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!