I require the answer in Excel Solver format if possible with necessary tables. I appreciate your help.
Posted: Sat Nov 27, 2021 10:37 am
I require the answer in Excel Solver format if possible with
necessary tables. I appreciate your help.
5.9 Modify the heuristics for the 1-BP problem for the case where each bin j, j = 1, ..., n, has a capacity 9; and a cost fj. Apply the modified version of the BFD algorithm to the following problem. Brocard is a road carrier operating TLFEBOOK 197 DESIGNING AND OPERATING A WAREHOUSE Table 5.23 List of the parcels to load and corresponding weight (in kilograms) in the Brocard problem. Parcel Weight Parcel Weight 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 228 228 228 217 217 217 217 210 210 210 210 195 195 195 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 170 170 170 170 95 95 95 95 75 75 75 75 75 75 55 55 55 170 170 170
mainly in France and in the Benelux. The vehicle fleet comprises 14 vans of capacity equal to 800 kg and 22 vans of capacity equal to 500 kg. The company has to deliver on behalf of the EU 34 parcels of different sizes from Paris to Frankfurt (the distance between these cities is 592 km). The characteristics of the parcels are reported in Table 5.13. As only five company-owned vans (all having capacity of 800 kg) will be available on the day of the delivery, Brocard has decided to hire additional vehicles from a third-party company. The following additional vehicles will be available: • two trucks with a capacity of 3 tons each, whose hiring total cost (inclusive of drivers) is €1.4 per kilometre; • one truck with trailer, with a capacity of 3.5 tons, whose hiring total cost (inclusive of drivers) is €1.6 per kilometre. Which trucks should Brocard hire?
necessary tables. I appreciate your help.
- I Require The Answer In Excel Solver Format If Possible With Necessary Tables I Appreciate Your Help 1 (50.91 KiB) Viewed 72 times
mainly in France and in the Benelux. The vehicle fleet comprises 14 vans of capacity equal to 800 kg and 22 vans of capacity equal to 500 kg. The company has to deliver on behalf of the EU 34 parcels of different sizes from Paris to Frankfurt (the distance between these cities is 592 km). The characteristics of the parcels are reported in Table 5.13. As only five company-owned vans (all having capacity of 800 kg) will be available on the day of the delivery, Brocard has decided to hire additional vehicles from a third-party company. The following additional vehicles will be available: • two trucks with a capacity of 3 tons each, whose hiring total cost (inclusive of drivers) is €1.4 per kilometre; • one truck with trailer, with a capacity of 3.5 tons, whose hiring total cost (inclusive of drivers) is €1.6 per kilometre. Which trucks should Brocard hire?