Betty DeRose, Inc. produces and sells two products, L and V. Revenue and cost information for the two products from last month appear below:

**Product L Product V**

selling price per unit ……….. $15.00 $12.00

variable costs per unit ………. $ 8.00 $ 7.00

For the coming month, Betty would like to use linear programming in order

to maximize monthly profits.

Each month Betty has 80,000 direct labor hours available and 60,000 machine

hours available. Product L requires 5 direct labor hours for each unit and

2 machine hours for each unit. Product V requires 4 direct labor hours for

each unit and 8 machine hours for each unit.

**Calculate the** **number of units of Product L that should be produced in order
to maximize net income**.

**.**

*Do not use the $, decimals, or type the word units*

after your answerafter your answer

## Expert Answer

**Decision Variables:**

L = units of product L to be produced

V = units of product V to be produced

Objective Function:

Objective is to maximize the monthly profit. The profit is given as follows:

Profit = unit Selling price – unit Variable cost

The objective or profit function is given as follows:

Max. Z = (15 – 8)L + (12 – 7)V

**Max. Z = $7L + $5V**

Subject To:

1) Available direct labor hours are 80,000 hours per month. Product L and V requires 5 and 4 hours respectively

5L + 4V <= 80,000

2) Available machine hours are 60,000 hours per month. Product L and V requires 2 and 8 hours respectively

2L + 8V <= 60,000

3) Non-negativity constraint:

L, V >= 0

Excel Formulation and Solver Solution:

Copy paste following table in excel:

Decision Variable |
L |
V |
Total Profit |
||

Unit Selling Price | 15 | 12 | |||

Unit Variable cost | 8 | 7 | |||

unit Profit | =+B2-B3 | =+C2-C3 | |||

Number of Units | 12500 | 4375 | =SUMPRODUCT(B3:C3,$B$5:$C$5) |
||

Subject to |
LHS | RHS | |||

Labor Hours | 5 | 4 | =SUMPRODUCT($B$5:$C$5,B8:C8) | <= | 80000 |

Machine Hours | 2 | 8 | =SUMPRODUCT($B$5:$C$5,B9:C9) | <= | 60000 |

Optimal Solution:

**Unit of Product L = 12,500 units**

**Units of Product L = 4,375**

**Total Profit = $130,625**