Product Mix Optimization: Integer Programming & Branch-and-Bound Modeling

To ensure absolute precision and verify computational reliability, a cross-platform optimization strategy was executed using Microsoft Excel Solver and LINGO alongside manual Branch-and-Bound tree search computations. All analytical approaches successfully converged on the identical global optimum, prescribing the production of exactly 2 medium units and 31 large units, maximizing total profit to Rp 107,100 while completely eliminating raw material waste.