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
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
Step by Step Solution
3.39 Rating (152 Votes )
There are 3 Steps involved in it
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 full answer
Get step-by-step solutions from verified subject matter experts
Study Help