I need an mathematical solution solved by excel with explaination in detail with above data set.

CHARGING STATION INFRASTRUCTURE perform up to 200 charges per day, and PLACEMENT collected the average daily mine plan for Project VOLT's base assumptions and each pit so that the required number of constraints are informed by data provided charges could be. by V-ORE procurement and finance teams. VOLTEngineering are currently constructing Having completed the initial analysis, AI a detailed project timeline, though scope will found himself lost on how to select the best be adjusted after study completion . spots to place the stations and what would Excited about the new project, and using his be the network design of the new structure (which route is charged by each station and knowledge of the mine site, Alan started to how many trucks/day) in a way that the total map the possible locations that could be a distance is minimised. good fit for the charging stations. He knew that a truck required charging every time He's hoping you might be able to help him they returned from the crusher to one of the out! 5 mine pits. Based on this he identified 4 candidate positions for the charging stations and calculated the distance to travel from the crusher to pits, diverting through the potential charging stations. Diving into the technical details, Al started to read the manufacturer's documentation of the charging stations and of the electric vehicles which would be installed at the site. He found that each station is able to Distance from charaina stations to bits (km) Distance from charging stations to crushers (km) Dailv demand at Pit (Tonnes) naily demand at rrushers (Tonnes) Objective: The objective of this assignment is to determine the optimal number and location of universal charging stations for V-ORE's electric autonomous vehicle fleet at their test site in northern Western Australia, while minimizing electricity usage. 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. Assumptions: You may make assumptions in the development of your model, but these should be clearly stated in your report. For instance, you may assume that all vehicles have the same battery capacity, and that they consume the same amount of electricity per distance travelled. CHARGING STATION INFRASTRUCTURE perform up to 200 charges per day, and PLACEMENT collected the average daily mine plan for Project VOLT's base assumptions and each pit so that the required number of constraints are informed by data provided charges could be. by V-ORE procurement and finance teams. VOLTEngineering are currently constructing Having completed the initial analysis, AI a detailed project timeline, though scope will found himself lost on how to select the best be adjusted after study completion . spots to place the stations and what would Excited about the new project, and using his be the network design of the new structure (which route is charged by each station and knowledge of the mine site, Alan started to how many trucks/day) in a way that the total map the possible locations that could be a distance is minimised. good fit for the charging stations. He knew that a truck required charging every time He's hoping you might be able to help him they returned from the crusher to one of the out! 5 mine pits. Based on this he identified 4 candidate positions for the charging stations and calculated the distance to travel from the crusher to pits, diverting through the potential charging stations. Diving into the technical details, Al started to read the manufacturer's documentation of the charging stations and of the electric vehicles which would be installed at the site. He found that each station is able to Distance from charaina stations to bits (km) Distance from charging stations to crushers (km) Dailv demand at Pit (Tonnes) naily demand at rrushers (Tonnes) Objective: The objective of this assignment is to determine the optimal number and location of universal charging stations for V-ORE's electric autonomous vehicle fleet at their test site in northern Western Australia, while minimizing electricity usage. 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. Assumptions: You may make assumptions in the development of your model, but these should be clearly stated in your report. For instance, you may assume that all vehicles have the same battery capacity, and that they consume the same amount of electricity per distance travelled