Inventory Buffer and Batch Size Tradeoff Evaluation
Model economic order quantities, carrying costs, and reorder triggers to optimize industrial plant material replenishment.
Use this template when inventory carrying costs and stockout risks are misaligned across raw material stocks. It produces an exact cost-optimized lot size and safety stock calculation with sensitivity modeling.
Role: Senior Industrial Supply Chain Modeler specializing in lean material replenishment and deterministic cost optimization.
Context
- Facility location: {{facility_location}}
- Part identifier: {{component_part_number}}
- Annual demand volume: {{annual_demand_units}} units
- Unit acquisition cost: ${{unit_purchase_cost}}
- Order placement and setup cost: ${{ordering_setup_cost}} per batch
- Annual carrying cost rate: {{holding_cost_rate}}% of unit value
- Supplier lead time: {{lead_time_days}} calendar days
Task
Conduct an Economic Order Quantity (EOQ) and dynamic replenishment analysis to determine optimal batch sizing, annual total inventory cost, and reorder point thresholds for the target industrial component.
Method
- Calculate the annual per-unit holding cost by multiplying {{unit_purchase_cost}} by {{holding_cost_rate}}.
- Compute the raw EOQ using the standard Wilson formula against {{annual_demand_units}} and {{ordering_setup_cost}}.
- Calculate the baseline optimal annual order frequency and replenishment cycle time in days.
- Determine daily consumption rate assuming a standard 365-day operational year.
- Compute the deterministic Reorder Point (ROP) based on daily demand and {{lead_time_days}}.
- Model total annual inventory cost curve at EOQ, -20% batch size, and +20% batch size.
- Evaluate cash flow and storage capacity implications under minimum order quantities.
Constraints
- Calculations MUST include complete mathematical expressions before final values are presented.
- Total financial figures MUST NOT omit unit currency symbols and decimal precision.
- Restrict recommendations to single-echelon, deterministic demand parameters provided.
- Clearly document all boundary conditions and sensitivity limits.
Output format
- Section 1: Sizing Parameters (EOQ, Orders per Year, Cycle Time in a markdown table)
- Section 2: Total Cost Analysis (Annual Ordering Cost, Holding Cost, Total Cost breakdown)
- Section 3: Batch Sensitivity Model (Evaluation of -20%, Optimal, and +20% lot sizes)
- Section 4: Operational Recommendation (Replenishment policy, Reorder Point, within 200 words)
Self-review
- Ensure annual holding cost equals annual setup cost at optimal EOQ.
- Validate that Reorder Point reflects exact lead time times daily demand.
- Verify percentage holding cost rate was converted correctly to a decimal fraction.
Explicit role, a named task, and discrete steps the model can follow.
Background, inputs and variables the model needs before it starts.
Hard boundaries — what the model must and must not do.
A named, field-level shape for the response.
Ordered work items that force analysis before an answer.
Length and structure that travel across frontier models.
Signal density — instruction weight without padding.
Documented variables so the scaffold adapts to new inputs.
Quality bar, assumptions and behaviour when inputs are thin.
How much real usage the template has behind it.