Appendix Linear Programming

In this chapter’s Power Recreation example (see Product-Mix Decisions With Capacity Constraints), suppose both the snowmobile and boat engines must be tested on a very expensive machine before they are shipped to customers. The available machine-hours for testing are limited. Production data are as follows:

Use of Capacity in Hours per Unit of ProductDaily Maximum Production in Units
DepartmentAvailable Daily Capacity in HoursSnowmobile EngineBoat EngineSnowmobile EngineBoat Engine
Assembly600 machine-hours2.0 machine-hours5.0 machine-hours300a snowmobile engines120 boat engines
Testing120 testing-hours1.0 machine-hour0.5 machine-hour120 snowmobile engines240 boat engines
a For example, 600 machine-hours÷2.0 machine-hours per snowmobile engine=300, the maximum number of snowmobile engines that the assembly department can make if it works exclusively on snowmobile engines.

Exhibit 12-13 summarizes these and other relevant data. In addition, as a result of material shortages for boat engines, Power Recreation cannot produce more than 110 boat engines per day. How many engines of each type should Power Recreation’s managers produce and sell daily to maximize operating income?

Exhibit 12-13 

Operating Data for Power Recreation

Table shows the operating data for Power Recreation’s snowmobile and boat engines under various categories.

The details of the table are as follows:

1. Only snowmobile engines

a. Department Capacity per day In Product Units

• Assembly: 300

• Testing: 120

b. Selling Price: $800

c. Variable Cost per Unit: $560

d. Contribution Margin per Unit: $240

2. Only boat engines

a. Department Capacity per day In Product Units

• Assembly: 120

• Testing: 240

b. Selling Price: $1,000

c. Variable Cost per Unit: $625

d. Contribution Margin per Unit: $375

Because there are multiple constraints, managers can use a technique called linear programming (LP) to determine the number of each type of engine to produce. LP models typically assume that all costs are either variable or fixed for a single cost driver (units of output). We will see that LP models also require certain other linear assumptions to hold. When these assumptions fail, managers should consider other decision models.*

Steps in Solving an LP Problem

We use the data in Exhibit 12-13 to illustrate the three steps in solving an LP problem. Throughout this discussion, S equals the number of snowmobile engines produced and sold, and B equals the number of boat engines produced and sold.

Step 1: DETERMINE THE OBJECTIVE FUNCTION. The objective function of a linear program expresses the objective or goal to be maximized (say, operating income) or minimized (say, operating costs). In our example, the objective is to find the combination of snowmobile engines and boat engines that maximizes total contribution margin. Fixed costs remain the same regardless of the product-mix decision and are irrelevant. The linear function expressing the objective for the total contribution margin (TCM) is

TCM=$240S+$375B  

  1. Step 2: SPECIFY THE CONSTRAINTS. A constraint is a mathematical inequality or equality that must be satisfied by the variables in a mathematical model. The following linear inequalities express the relationships in our example:
Assembly department constraint2S + 5B ≤ 600
Testing department constraint1S + 0.5B ≤ 120
Materials-shortage constraint for boat enginesB ≤ 110
Negative production is impossibleS ≥ 0 and B ≥ 0
  1. The three solid lines on the graph in Exhibit 12-14 show the existing constraints for assembly and testing and the materials-shortage constraint.* The feasible or technically possible alternatives are those combinations of quantities of snowmobile engines and boat engines that satisfy all the constraining resources or factors. The shaded “area of feasible solutions” in Exhibit 12-14 shows the boundaries of those product combinations that are feasible.

Exhibit 12-14 

Linear Programming: Graphic Solution for Power Recreation

Exhibit shows a graphic solution related to Linear Programming for Power Recreation with three solid lines, three dotted lines, an optimal corner, and an area of feasible solutions marked on the graph.

Y-axis shows the boat engine units ranging from 0 to 250 with an increment of 50 units and X-axis shows the snowmobile engine units ranging from 0 to 300 with an increment of 50 units.

Three solid lines have been marked on the graph representing the existing constraints for assembly, testing and the materials-shortage constraint. The details of the same are as follows. All values mentioned are approximate.

a. The units of the testing department constraint marked by the solid line are:

• Snowmobile engine: 120 units

• Boat engine: 235 units

b. The units of the assembly department constraint marked by the solid line are:

• Snowmobile engine: 300 units

• Boat engine: 122 units

c. The units of the material-shortage constraint for boat engines marked by the solid line are: 110 units

Three dotted lines representing equal contribution margin lines have been marked on the graph. The details of the same are as follows. All values mentioned are approximate.

a. The units of the first dotted line are:

• Snowmobile engine: 50 units

• Boat engine: 40 units

b. The units of the second dotted line are:

• Snowmobile engine: 120 units

• Boat engine: 80 units

c. The units of the third dotted line are:

• Snowmobile engine: 210 units

• Boat engine: 140 units

The details of the optimal corner marked on the graph are:

• Snowmobile engine: 75 units

• Boat engine: 90 units

The area of feasible solutions shows the boundaries of the product combinations restricted by the intersecting point of optimal corner marked on the graph. The details of the same are:

• Snowmobile engine: 120 units

• Boat engine: 110 units

  1. Step 3: COMPUTE THE OPTIMAL SOLUTION. Linear programming (LP) is an optimization technique used to maximize the objective function when there are multiple constraints. We present two approaches for finding the optimal solution using LP: trial-and-error approach and graphic approach. These approaches are easy to use in our example because there are only two variables in the objective function and a small number of constraints. Understanding these approaches provides insight into LP. In most real-world LP applications, managers use computer software packages to calculate the optimal solution.*

Trial-and-Error Approach

Managers can find the optimal solution by trial and error, by working with coordinates of the corners of the area of feasible solutions. As we will see, the optimal solution always lies at an extreme point of the feasible region.

First, select any set of corner points and compute the total contribution margin. Five corner points appear in Exhibit 12-14. It is helpful to use simultaneous equations to obtain the exact coordinates in the graph. To illustrate, the corner point (S=75, B=90) can be derived by solving the two pertinent constraint inequalities as simultaneous equations:

2S+5B=600 11S+0.5B=120 2Multiplying 2 by 2:2S+B=240 3Subtracting 3 from 1:4B=360Therefore,B=360÷4=90Substituting for B in 2:1S+0.590=120S=120-45=75

Given S = 75 snowmobile engines and B = 90 boat engines, TCM=($240per snowmobile engine×75snowmobile engines) + ($375per boat engine ×  90boat engines)=$51,750.

Second, move from corner point to corner point and compute the total contribution margin at each corner point.

<p>A table shows the total contribution margin at each corner point</p>

The table depicts corner point, snowmobile engines, boat engines, and total contribution margin for trials 1 through 5. The details of the table are as follows:

  1. Trial 1
    • Corner point (S, B): 0, 0
    • Snowmobile engines: 0
    • Boat engines: 0
    • Total contribution margin: The quantity 240 dollars times 0 plus the quantity 375 dollars times 0 equals 0 dollars
  1. Trial 2
    • Corner point (S, B): 0, 110
    • Snowmobile engines: 0
    • Boat engines: 110
    • Total contribution margin: The quantity 240 dollars times 0 plus the quantity 375 dollars times 110 equals 41,250 dollars
  1. Trial 3
    • Corner point (S, B): 25, 110
    • Snowmobile engines: 25
    • Boat engines: 110
    • Total contribution margin: The quantity 240 dollars times 25 plus the quantity 375 dollars times 110 equals 47,250 dollars
  1. Trial 4
    • Corner point (S, B): 75, 90
    • Snowmobile engines: 75
    • Boat engines: 90
    • Total contribution margin: The quantity 240 dollars times 75 plus the quantity 375 dollars times 90 equals 51,750 dollars. This is the optimal solution.
  1. Trial 5
    • Corner point (S, B): 120, 0
    • Snowmobile engines: 120
    • Boat engines: 0
    • Total contribution margin: The quantity 240 dollars times 120 plus the quantity 375 dollars times 0 equals 28,800 dollars

 

The optimal product mix is the mix that yields the highest total contribution: 75 snowmobile engines and 90 boat engines. To understand the solution, consider what happens when moving from the point (25, 110) to (75, 90). Power Recreation gives up $7,500 [$375×(110−90)] in contribution margin from boat engines while gaining $12,000 [$240×(75−25)] in contribution margin from snowmobile engines. This results in a net increase in contribution margin of $4,500 ($12,000−$7,500), from $47,250 to $51,750.

Graphic Approach

Consider all possible combinations that will produce the same total contribution margin of, say, $12,000. That is,

$240S+$375B=$12,000  

This set of $12,000 contribution margins is a straight dashed line through [S=50 ($12,000÷$240);B=0] and [S=0;B=32 ($12,000÷$375)] in Exhibit 12-14. Other equal total contribution margins can be represented by lines parallel to this one. In Exhibit 12-14, we show three dashed lines. Lines drawn farther from the origin represent more sales of both products and higher amounts of equal contribution margins.

The optimal line is the one farthest from the origin but still passing through a point in the area of feasible solutions. This line represents the highest total contribution margin. The optimal solution—the number of snowmobile engines and boat engines that will maximize the objective function, total contribution margin—is the corner point (S=75, B=90). This solution will become apparent if you put a straight-edge ruler on the graph and move it outward from the origin and parallel with the $12,000 contribution margin line. Move the ruler as far away from the origin as possible—that is, increase the total contribution margin—without leaving the area of feasible solutions. In general, the optimal solution in a maximization problem lies at the corner where the dashed line intersects an extreme point of the area of feasible solutions. Moving the ruler out any farther puts it outside the area of feasible solutions.

Sensitivity Analysis

What are the implications of uncertainty about the accounting or technical coefficients used in the objective function (such as the contribution margin per unit of snowmobile engines or boat engines) or the constraints (such as the number of machine-hours it takes to make a snowmobile engine or a boat engine)? Consider how a change in the contribution margin of snowmobile engines from $240 per unit to $300 per unit would affect the optimal solution. Assume the contribution margin for boat engines remains unchanged at $375 per unit. The revised objective function will be

TCM=$300S + $375B  

Using the trial-and-error approach to calculate the total contribution margin for each of the five corner points described in the previous table, the optimal solution is still (S=75, B=90). What if the contribution margin of snowmobile engines falls to $160 per unit? The optimal solution remains the same (S=75, B=90). Thus, big changes in the contribution margin per unit of snowmobile engines have no effect on the optimal solution in this case. That’s because, although the slopes of the equal contribution margin lines in Exhibit 12-14 change as the contribution margin of snowmobile engines changes from $240 to $300 to $160 per unit, the farthest point at which the equal contribution margin lines intersect the area of feasible solutions is still (S=75, B=90).