Abstract: Described are system, method, and computer program product embodiments for performing real-time supply chain response planning. Described embodiments operate by receiving, from a client device, a request that specifies a quantity of a product requested by a deadline. Then, a list of constraint variants associated with the product is identified from a constraint variants table. Each constraint variant in the list is associated with a net-availability table stored in a column-store in-memory database. Based on the constraint variants table, a required capacity for each constraint variant in the list to satisfy the request is determined. To determine whether the required capacity is satisfied for each constraint variant, the request is simulated within a current supply chain plan by aggregating an available capacity for each constraint variant using one or more columns of the associated net-availability table. Based on the simulated request, a result is sent to the client device.

Abstract: A system determines usage of material inventory stored in different physical locations. Material inventory at the physical locations is determined. Material inventory usage settings of the material inventory at the physical locations are determined. A tree data structure is generated for usage of the material inventory at the physical locations based on the material inventory usage settings. The tree data structure is traversed to locate material inventory from the physical locations to satisfy a material usage request using the material inventory usage settings. Physical locations and corresponding material inventory usage are identified.