Instructions: You are required to develop a mathematical optimization model using Excel to determine the optimal number
Fantastic news! We've Found the answer you've been seeking!
Question:
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 plotted 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
Expert Answer:
Fundamental Definations 1Define the decision variables Let Xi be the number of charging stations at location i where i 1234 four potential charging lo... View the full answer
Related Book For 
Supply Chain Network Design Applying Optimization and Analytics to the Global Supply Chain
ISBN: 978-0133017373
1st edition
Authors: Michael Watson, Sara Lewis, Peter Cacioppi, Jay Jayaraman
Posted Date:
