Question: Please, solve mathematical model. Excel is not neccessary. Problem 2. (20 pts) IP modeling Doug needs to rent a truck to transport his stuff. In

Please, solve mathematical model. Excel is not neccessary. Please, solve mathematical model. Excel is not
Problem 2. (20 pts) IP modeling Doug needs to rent a truck to transport his stuff. In order to do this, he needs to pack some of his items into boxes and then pack everything into the back of a truck. Fortunately, he has boxes left over from a previous move. Doug wants to fit all of his stuff into as small a truck as possible. The following tables list the different items that need to be packed as well as the available boxes. (For this problem, assume that the listed items cannot be split between boxes. Also note that a box does not need to be packed completely full. For instance, a 30 m box could be packed with the Computer and CDs or with the Board Games and CDs.) Item# Item Size (m) Box # Size (m) 1 Textbooks 11 1 20 2 CDs 12 2 20 3 Computer 17 3 25 4 Board Games 18 4 25 5 Electronics 22 5 6 30 Sports Equipment 26 6 30 Formulate an Integer Program to minimize the truck space which can take all of the packed items in the boxes. (You need to define your decision variables clearly to receive full credit.)

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!