Objective: The objective of this assignment is to determine the optimal number and location of universal charging stations. Instructions: You are required to develop a mathematical optimization model using Excel to determine the optimal number and location of universal charging stations for V-ORE's electric autonomous vehicle fleet. The model should be designed to minimize electricity usage, while ensuring that all vehicles can be charged at any point in time. You may make assumptions in the development of your model. (Things to be ploted and constrains to be used in solver in detail. 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

Please solve it in an excel using solver