You started to work at a company. The company's first initiative for you is to reduce transportation costs. You've been tasked with overseeing the shipping of ten different items(A,B,C,D,E,F,G,H,I,J). You'll be in charge of shipping the goods to ten stores(S1,S2,S3,S4,S5,S6,S7,S8,S9,S10) in ten different cities. The company operates out of three massive warehouses. The X warehouse has a daily capacity of 40 tons, the Y warehouse has a capacity of 25 tons, and the Z warehouse has a capacity of 35 tons for these ten items. Every day, you must load goods from these three warehouses onto trucks and deliver them to ten stores under your supervision.

You sell 10 types of goods.( Each store sells 1,000 A, 200 B, 200 C, 500 D, 10,000 E, 2,000 F, 2,000 G, 1,000 H, 1,000 I, 2,000 J. )

The exact data is that the average daily sales of ten goods in all stores total 100 tons. Trucks leave the warehouses at 6 a.m. every day (except Sunday) and must deliver all of their cargo to the last store by 10 a.m. the same day.

Each company truck can transport up to 5 tons of goods. These trucks are one-of-a-kind. Every truck has three separate compartments. These three compartments have a capacity of 1 ton, 2 ton, and 2 ton, respectively. Only one form of product can be transported in each compartment in each transport due to companys’ consistency and cleaning regulations. You must purchase the trucks you need. A truck costs 700,000$ per piece to buy. cost of truck fuel per km is 2.01 $, Daily cost for per driver is 136$, , the annual maintenance cost of per truck is 2,000$ and each toll road payment is 50$

A)Identify how many drivers you need.

B)How many trucks can be used to complete this operation

C)What is the least amount of Money for his operation?

*You should also include the LP and/or ILP models you developed, as well as the models' performance.

*Also, specify the number of trucks by evaluating the data in your report in Excel Solver, which calculates the lowest cost based on the information you have.

S1 is 43 km (35 min) away from Warehouse X . (toll road 50$), 43 km( 32 min) away from Warehouse Y(Free Road) and 64 km( 48 min) away from Ware house Z(Free Road).

S2 is 61 km (49 min) away from Warehouse X. (toll road 50$), 10 km( 18 min) away from Warehouse Y(Free Road) and 44 km( 57 min) away from Ware house Z(Free Road).

S3 is 54 km (42 min) away from Warehouse X. (Free Road), 14 km( 23 min) away from Warehouse Y(Free Road) and 44 km( 64 min) away from Ware house Z(Free Road).

S4 is 63 km (50 min) away from Warehouse X. (toll road 50$), 13 km( 21 min) away from Warehouse Y(Free Road) and 44 km( 64 min) away from Ware house Z(Free Road).

S5 is 40 km (31 min) away from Warehouse X. (Free Road) 40 km( 31 min) away from Warehouse Y(Free Road) and 63 km( 45 min) away from Ware house Z(Free Road).

S6 is 51 km (40 min) away from Warehouse X. (toll road 50$), 14 km( 23 min) away from Warehouse Y(Free Road) and 44 km( 60 min) away from Ware house Z(Free Road).

S7 is 41 km (33 min) away from Warehouse X. (toll road 50$), 41 km( 29 min) away from Warehouse Y(Free Road) and 60 km( 75 min) away from Ware house Z(Free Road).

S8 is 77 km (60 min) away from Warehouse X. (Free Road), 5 km( 12 min) away from Warehouse Y(Free Road) and 44 km( 57 min) away from Ware house Z(Free Road).

S9 is 67 km (60 min) away from Warehouse X. (Free Road), 39 km( 53 min) away from Warehouse Y(Toll Road 50$) and 39 km (53 min) away from Ware house Z(Toll Road 50$).

S10 is 103 km (68 min) away from Warehouse X. (Free Road), 27 km( 27 min) away from Warehouse Y(Free Road) and 44 km( 57 min) away from Ware house Z(Free Road).

 

Products A Quantity Total KG Products Quantity Total KG Warehouse X B Products Qty. Total KG 4000 4000 Warehouse Y B A 3500 3500 Warehouse Z A 2500 2500 B 800 4000 700 3500 500 2500 C C C 800 4000 700 3500 500 2500 D D D 2000 4000 1750 3500 1250 2500 E E E 40000 4000 35000 3500 25000 2500 F F F 8000 4000 7000 3500 5000 2500 G G G 8000 4000 7000 3500 5000 2500 H H H 4000 4000 3500 3500 2500 2500 I I | 4000 4000 3500 3500 2500 2500 J J J 8000 4000 40Tons 7000 3500 35Tons 5000 2500 25Tons