Customer is in Business of Booking fairs for School and there was a fixed capacity for each branch based on number of Cases to fulfill a fair. Profitability of fair is significantly reduced if fair is delivered in peak period. Customer implemented Peak leveling and stopped Sales rep to book a fair if there is no capacity within the fair period.
Challenges
Capacity Planning Solution was built to:
- Real time capacity monitoring
- Reduced CPU errors on limits
- Area capacity to fulfil each other's orders
- Avoid CPU time out on large volumes of data
Solution
After Analyzing all the issues and requirements, solution was built that is a Combination of Batch and real time.
- Calculation of all used Capacity of all future fairs and store in object in nightly job
- Capture all changes during day in separate object (delta changes)
- Combine Nightly numbers and delta number to check if used there is available capacity ( Total capacity – Nightly Capacity – Delta Changes)
Outcome
- Built a Screen that shows the available capacity
- Response time reduced to Sub seconds from 20 seconds
- Implemented Area Capacity without any performance issue.