Question: 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
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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help