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