VERY URGENT

NO P S B C D E F GHIJKL R Problem BauLog Trucking Co. has 1 identical truck with a capacity of 40 m3, and could carry at the maximum weight of 30 tons. The marketing department gets reguest for 20 load orders, where the volume, weight and the due dates, with 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. The truck could complete this journey within 3 days, or 6 days. The cost of 3 day trip is $150 and 6 days trip costs 75$. 1 Assume that the shapes of packages are uniform, so that volume is the constraint not individual dimensions of p 4 Package 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 5 Volume 4 4 3 3 4 1 2 3 4 6 4 3 3 3 7 2 1 3 4 5 4 3 3 4 5 2 2 1 6 Weight Revenue ($40 Due date 23 13 25 17 12 13 11 16 15 14 16 13 12 9 8 4 3 6 7 6 6 3 2 7 8 5 4 3 3 4 4 10 Note: A decision variable could be zero one such that do you assign a load into the container of truck number-i or not? 11 a) Generate a model that lists the decision variables and total revenue clearly and at which speed the truck will complete its journey b) Solve the model using Solver and find the optimum profit. H2345=25 7 9 12 13 14 15 92526 1468 15 35 ALA 4 NO P S B C D E F GHIJKL R Problem BauLog Trucking Co. has 1 identical truck with a capacity of 40 m3, and could carry at the maximum weight of 30 tons. The marketing department gets reguest for 20 load orders, where the volume, weight and the due dates, with 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. The truck could complete this journey within 3 days, or 6 days. The cost of 3 day trip is $150 and 6 days trip costs 75$. 1 Assume that the shapes of packages are uniform, so that volume is the constraint not individual dimensions of p 4 Package 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 5 Volume 4 4 3 3 4 1 2 3 4 6 4 3 3 3 7 2 1 3 4 5 4 3 3 4 5 2 2 1 6 Weight Revenue ($40 Due date 23 13 25 17 12 13 11 16 15 14 16 13 12 9 8 4 3 6 7 6 6 3 2 7 8 5 4 3 3 4 4 10 Note: A decision variable could be zero one such that do you assign a load into the container of truck number-i or not? 11 a) Generate a model that lists the decision variables and total revenue clearly and at which speed the truck will complete its journey b) Solve the model using Solver and find the optimum profit. H2345=25 7 9 12 13 14 15 92526 1468 15 35 ALA 4