You need to formulate the LP/ILP model and solve it using Excel Solver (Simplex). So please make sure to include both (LP/ILP model and the Excel solver solutions) Note: Please include the formulas used in the Excel Solver. SHOW ALL WORKINGS.. The goal of the question is to minimize the transportation costs and to find how many trucks are needed for this operation with the minimum cost. The case: We have a market and we need to deliver 10 products to 10 stores in different districts from 3 warehouses daily, the capacity of the first warehouse is 40 tons daily, the second warehouse 25 tons daily, third warehouse 35 tons daily, the total sales of all stores is 100 tons daily Trucks leave the warehouses every morning (except Sunday) at 6.00 and must leave all of their cargo to the last store at 10.00 in the morning-same day, each truck can carry 5 tones, in addition, there are 3 compartments in each truck. The capacity of these three compartments is 1 ton, 2 ton, and 2 ton respectively. we can't fill more than one type of product in the compartment, the truck price is 100,000$, the fuel cost is 0.25$ each km, the cost of the driver is 100$ daily. find out how many trucks this operation can be done with minimum cost, daily sales amounts for each store, and every cost item required to resolve the issue. Formulate the LP/ILP model and solve it using Excel Solver (Simplex)

store 1 store 2 store 3 store 4 store 5 store 6 store 7 store 8 store 9 store 10 warehouse 1 0.8 km 4.2 km 4.2 km 17 km 6.3 km 24 km 38 km 40 km 36 km 32 km warehouse 2 39 km 39 km 33 km 26 km 46 km 22 km 8.6 km 1.5 km 4.6 km 8.2 km warehouse 3 8.2 km 10 km 4.4 km 9.3 km 17 km 18 km 30 km 32 km 28 km 24 km