Production planning Production and Inventory Planning Notes

Overview of Production and Inventory Planning

• Learning Objectives:

  • Understand foundational principles of production and inventory planning problems.
  • Construct an Excel spreadsheet model to solve production and inventory planning optimization problems.
  • Extend the base formulation to handle real-world operational complications, such as quality issues and inventory dynamics.

• Critical Characteristics of Production and Inventory Planning Problems:

  • Multiple Time Periods: Planning spans across several sequential time periods with fluctuating or varying demand.
  • Timely Demand Fulfillment: Monthly production outputs and inventory levels must be strategically planned so all customer demands are fulfilled in a timely manner.
  • Dynamic Production Capacities: Monthly production capacities vary across periods due to labor availability and resource constraints.

Problem Context: Upten Corporation

• Enterprise Overview:

  • Upten Corporation manufactures heavy-duty air compressors designed for home and light industrial usage.
  • The operational goal is to plan production and inventory levels for the next $6$\text{ months}.

• Month-Specific Planning Parameters:

  • Month $1$ Parameters:
  • Unit Production Cost: \\$240
  • Unit Demand: $1,000\\,\\text{units}$
  • Maximum Production Capacity: $4,000\\,\\text{units}$
  • Month $6$ Parameters:
  • Unit Production Cost: \\$2.60
  • Unit Demand: $4,000\\,\\text{units}$
  • Maximum Production Capacity: $3,500\\,\\text{units}$

• Facility Storage & Buffer Requirements:

  • Warehouse Capacity: The facility warehouse can hold a maximum storage limit of $6,000\\,\\text{units}$.
  • Safety Stock Buffer: The owner requires keeping a minimum stock of $1,500\\,\\text{units}$ in inventory to satisfy potential emergency demand surges.

Cost Parameters and Decision Variables

• Inventory Holding Cost Estimation:

  • Storage Cost Rate: Keeping inventory in stock incurs holding costs. An accountant estimates holding cost per month to be $1.5\\%$ of the unit production cost for that same month.
  • Initial Inventory Balance: The company begins the planning period with $2,750\\,\\text{units}$ already in inventory.

• Decision Variables:

  • Monthly Production Quantities: The central decision variables represent the exact production amounts for each individual month: Month $1$, Month $2$, Month $3$, Month $4$, Month $5$, and Month $6$.

• Objective Function:

  • Primary Goal: Minimization of total operational cost over the $6$\text{-month} planning horizon.
  • Cost Components:
  • Total Production Cost Component: Varies each month based on the unit production cost and the chosen monthly production quantities.
  • Total Inventory Holding Cost Component: Varies each month based on the ending inventory available at the end of the month and the monthly holding cost rate.

Model Constraints

• Production Capacity Constraints:

  • Maximum Production Boundary: In each month, production volume cannot exceed that month's maximum production capacity.
  • Minimum Production Boundary (Workforce Stability): To preserve workforce stability and avoid scenarios where workers are full-time one month and completely idle the next, production must maintain a balanced level.
  • Minimum Capacity Requirement: For each month, the company must produce at least half ($50\\%$) of its maximum production capacity for that period.

• Inventory Holding Constraints:

  • Maximum Inventory Capacity: Storage in any month cannot exceed the warehouse limit of $6,000\\,\\text{units}$.
  • Minimum Inventory Capacity: Storage in any month must not fall below $1,500\\,\\text{units}$ to handle emergency demands.

• Non-Negativity Constraints:

  • Non-Zero Decision Variables: Production amounts must be non-negative ($\\ge 0$). Allowing negative production amounts would contextually imply purchasing products back from customers, which is logically invalid.

Month-to-Month Inventory Dynamics

• Governing Inventory Balance Equation:

  • Balance Formula:     $\\text{Ending Inventory}_t = \\text{Beginning Inventory}_t + \\text{Production}_t - \\text{Demand}_t$
  • State Transfer Condition: Ending inventory at the conclusion of month $t$ becomes the beginning inventory for month $t+1$, assuming no inventory loss.

• Sequential Simulation Trace:

  • Month $1$ Trace:
  • Beginning Inventory: $2,750\\,\\text{units}$
  • Production Decision Example: $3,000\\,\\text{units}$
  • Observed Demand: $1,000\\,\\text{units}$
  • Ending Inventory Calculation:       $\\text{Ending Inventory}_1 = 2,750 + 3,000 - 1,000 = 4,750\\,\\text{units}$
  • Month $2$ Trace:
  • Transferred Beginning Inventory: $4,750\\,\\text{units}$
  • Production Decision Example: $3,250\\,\\text{units}$
  • Observed Demand: $4,500\\,\\text{units}$
  • Ending Inventory Calculation:       $\\text{Ending Inventory}_2 = 4,750 + 3,250 - 4,500 = 3,500\\,\\text{units}$
  • Month $3$ Trace:
  • Transferred Beginning Inventory: $3,500\\,\\text{units}$
  • Production Decision Example (Ramp Up): $4,000\\,\\text{units}$
  • Observed Demand: $6,000\\,\\text{units}$
  • Ending Inventory Calculation:       $\\text{Ending Inventory}_3 = 3,500 + 4,000 - 6,000 = 1,500\\,\\text{units}$
  • Note: Ending inventory hits the required baseline minimum stock of $1,500\\,\\text{units}$.
  • Month $4$ Transition:
  • Transferred Beginning Inventory: $1,500\\,\\text{units}$
  • Process continues identically for remaining periods to establish Optome Corporation's spreadsheet optimization model.