Let us solve the constrained optimization problem posed in expressions (4.7 through 4.10) earlier, using the parameters stated in Example 4.2. The Excel set-up for this is shown in Figure 4.1, and we use Excel Solver to find the optimal solution. It turns out that our solution validates the decision from Example 4.2 to ship in full truckload quantities, as the optimal solution to the problem is Q = 2973 and R = 150. As a possible alternative solution, note that for fixed value of R, expression (4.7) can be optimized to yield a transportation-inclusive economic order quantity, given by