Need to display missing price ranges along with valid price ranges
Wish to hear you are safe & healthy!!!
Got a specification to display the missing price ranges along with valid price ranges in a module where we calculate the price of the contracts based on contract quantity for each supplier & materials. In this module, we calculate the contract quantity and appropriate price based on contract quantity. Able to display the valid price ranges but trying hard to bring in the missing price ranges in the same module. Like to have your guidance for this situation.
1. Contract calculation module is based on weekly time scale
2. Price list is maintained as separate module for each supplier and materials.
3. attached the excel with current module design and the expected outcome