Product Mix Problem Optimization and Mathematical Modeling

Product Mix Problem Definition and Objectives

• Definition: A product mix problem requires choosing the most profitable combination of products to produce while operating under defined resource and capacity constraints.

• Optimization Objectives Hierarchy:

  • Maximize Profit: This is the primary objective. Decisions are made with a business mindset focused on the bottom line.

  • Maximize Revenue: This is the secondary objective, used when profit cannot be calculated directly due to a lack of cost information.

  • Minimize Cost: This is the tertiary objective, utilized when revenue information is unavailable.

Application Areas of Product Mix Optimization

• Manufacturing: Deciding the specific quantities of various products to produce in order to maximize overall operational goals.

• Land Allocation: Determining which crops or products to plant across large plots of land within specific timeframes to maximize total revenue.

• Retail Product Selection: Choosing how to allocate limited shelf storage space in retail stores to maximize product sales and overall company profit.

Blue Ridge Hot Tubs Case Study Background and Decision Variables

• Company Perspective: The problem analyzes decisions made by Howie Jones, who is both the owner and manager of Blue Ridge Hot Tubs.

• Product Line: The company produces two distinct hot tub models: the Aqua Spa and the Hydrolux.

• Decision Variables:

  • Let $A$ represent the total number of Aqua Spas produced.

  • Let $H$ represent the total number of Hydrolux hot tubs produced.

Objective Function Formulation

• Profit Margins:

  • Each Aqua Spa sold yields a profit of $\text{\$350}$.

  • Each Hydrolux sold yields a profit of $\text{\$300}$.

• Mathematical Representation:

  • $\text{Maximize } Z = 350A + 300H$

Resource Constraints and Mathematical Model

• Pump Availability Constraint:

  • Total available pumps in stock: $200\,\text{pumps}$.

  • Pump consumption: Each Aqua Spa requires $1\,\text{pump}$, and each Hydrolux requires $1\,\text{pump}$.

  • Mathematical formulation: $1A + 1H \le 200$

• Labor Hours Constraint:

  • Total available production labor hours: $1566\,\text{hours}$.

  • Labor consumption: Each Aqua Spa requires $9\,\text{hours}$ of labor, while each Hydrolux requires $6\,\text{hours}$ of labor.

  • Mathematical formulation: $9A + 6H \le 1566$

• Tubing Availability Constraint:

  • Total available tubing in stock: $2880\,\text{feet}$.

  • Tubing consumption: Each Aqua Spa consumes $12\,\text{feet}$ of tubing, and each Hydrolux consumes $16\,\text{feet}$ of tubing.

  • Mathematical formulation: $12A + 16H \le 2880$

• Non-Negativity Constraints:

  • Mathematical formulation: $A \ge 0$ and $H \ge 0$

  • Logical Justification: Eliminates negative production values from the decision space. A negative production figure, such as $A = -4$, implies disassembling 4 Aqua Spas. While disassembly would theoretically yield back $4\,\text{pumps}$ and $48\,\text{feet}$ of tubing, it is impossible to recover the labor hours spent building them. Therefore, negative values are non-viable and decision variables must be limited to zero or positive numbers.

Structural Terminology of Mathematical Representations

• Left-Hand Side (LHS): The algebraic expressions containing the decision variables ($A$ and $H$) and their usage coefficients, storing the total consumed resources.

• Right-Hand Side (RHS): The constant values representing the maximum limits or capacity constraints available.