I would appreciate if you explain in detail :)

Problem BauLog Trucking Co. has 3 identical trucks. Ecach truck has a capacity of 20 m3, and could carry at the maximum weight of 15 tons. The marketing department gets reguest for 20 load orders, where the volume, weight and the corresponding revenue expected from each are given in the table below. As the company's operations manager choose the best loads (orders) such that you will not exceed the limits of each truck and obtain the highest revenue.

Assume that the shapes of packages are uniform, so that volume is the constraint not individual dimensions of packages. Therefore as long as sum of the volumes of a number of packages is less than 30 m3, then it will fit into the truck.

Package 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 TOTAL

Volume 4 4 3 3 4 1 2 3 4 2 4 6 4 3 3 3 7 2 4 4 70

Weight 2 1 3 4 5 4 3 3 4 5 6 3 4 5 2 2 1 3 3 2 65

Revenue ($) 40 23 13 25 17 12 13 11 16 15 18 15 14 16 13 12 9 12 4 4

Note: A decision variable could be zero one such that do you assign a load into the container of truck number-i or not?

a) Generate a model that lists the decision variables and total revenue clearly and calculate the idle capacity and total revenue if a certain load-truck assignment is done

b) Solve the model using Solver and find the optimum revenue value.

Bonus c) Can you modify the model in part b, while having the same revenue as in part b, can you make sure that the unused volume capacity in any truck will not be more than 8 m3.

please show all solution

please read the transcript

4) wores Preblem Problem BauLog Trucking Co. has 3 identical trucks. Ecach truck has a capacity of 20m3, and could carry at the maximum weight of 15 tons. The marketing department gets reguest for 20 load orders, where the volume, weight and the corresponding revenue expected from each are given in the table below. As the company's operations manager choose the best loads (orders) such that you will not exceed the limits of each truck and obtain the highest revenue. Assume that the shapes of packages are uniform, so that volume is the constraint not individual dimensions of packages. Therefore as long as sum of the volumes of a number of packages is less than 30m3, then it will fit into the truck. Note: A decision variable could be zero one such that do you assign a load into the container of truck number-i or not? a) Generate a model that lists the decision variables and total revenue clearly and calculate the idle capacity and total revenue if a certain load-truck assignment is donec b) Solve the model using Solver and find the optimum revenue value. Bonus c) Can you modify the model in part b, while having the same revenue as in part b, can you make sure that the unused volume capacity in any truck will not be more than 8 m3. please show all solution please read the transcript