Handle capacity planning edge cases and invalid data