The Excel model should be designed to minimize electricity usage, while ensuring that all vehicles can be charged at any point in time. Making assumptions in the development of your model, but these should be clearly stated. 1: the problem 2: The method used. 3: The optimal number and location of universal charging stations, and the associated electricity usage, sensitivity analysis 4: Discussion of results and recommendations. Your report should be uncluttered, focus on explaining your approach, assumptions, and the impact of solution on the electricity usage. Distance from charging stations to pits (km) Pit A Pit B Pit C Pit D Pit E Charging Station 1 2.38 3.52 3.95 6.56 9.15 Charging Station 2 3.45 2.36 2.02 4.98 5.10 Charging Station 3 3.24 2.90 1.68 3.72 5.87 Charging Station 4 6.34 3.73 2.75 2.17 2.06 Distance from charging stations to crushers (km) Crusher 1 Crusher 2 Charging Station 1 3.0 4.2 Charging Station 2 2.9 3.6 Charging Station 3 2.4 3.6 Charging Station 4 3.1 4.1 Daily demand at Pit (Tonnes) Pit Tonnes Pit A 10369 Pit B 8382 Pit C 7421 Pit D 9084 Pit E 8648 Daily demand at crushers (Tonnes) Crusher Tonnes Crusher 1 21583 Crusher 2 22321 Average truck load = 239 With assumption values like charging time per truck, The model assumes that the distance between each pit and crusher is fixed, and the distance between the charging stations and pits/crushers is accurately measured. The model assumes that the charging time for each truck is fixed and does not vary based on the state of charge (SOC) of the truck's battery. The model assumes that the charging stations are universally compatible with all mining truck models. The model assumes that the average truck load is constant across all pits. (all the values before going in solver)