Case Problem 1_Product Mix

Profit contribution Quantity to produce

Almond (%) Brazil (%) Filbert (%) Pecan (%) Walnut (%) Minimum to produce(Regular mix) Ponds Minimum to produce(Premier mix) Ponds Minimum to produce(Holiday mix) Ponds

Regular (R ) Premier(P) Holiday(H) $1.65 $ 2.00 $ 2.25 17500 10625 5000

0.15 0.25 0.25 0.1 0.25

0.2 0.2 0.2 0.2 0.2

0.25 0.15 0.15 0.25 0.2

1 1 1

OPTIMAL PRODUCT MIX:

Regular (R ) Pounds

17500

Premier(P) Pounds Holiday(H) Pounds Total Pr Profit

10625 5000 $ 61,375.00

$ 61,375.00

Total Profit

6 00 0 7 25 0 7 25 0 5 12 5 7 50 0

<= <= <= <= <=

Total Available (Pounds) 6 0 00 75 00 7 5 00 60 00 75 00

17 50 0

>=

1 00 00

10 62 5

>=

30 00

5 00 0

>=

5 0 00

Microsoft Excel 10.0 Answer Report Worksheet: [126747_Model.xls]Sheet1 Report Created: 4/23/2007 12:22:40 PM

Target Cell (Max) Cell Name $E$4 Profit contribution

Original Value 0

Final Value 61375

Adjustable Cells Cell Name $B$5 Quantity to produce Regular (R ) $C$5 Quantity to produce Premier(P) $D$5 Quantity to produce Holiday(H)

Original Value 0 0 0

Final Value 17500 10625 5000

Cell Value 17500 10625 5000 6000 7250 7250 5125 7500

Formula $E$13>=$G$13 $E$14>=$G$14 $E$15>=$G$15 $E$8<=$G$8 $E$9<=$G$9 $E$10<=$G$10 $E$11<=$G$11 $E$12<=$G$12

Constraints Cell Name $E$13 Minimum to produce(Regular mix) Ponds $E$14 Minimum to produce(Premier mix) Ponds $E$15 Minimum to produce(Holiday mix) Ponds $E$8 Almond (%) $E$9 Brazil (%) $E$10 Filbert (%) $E$11 Pecan (%) $E$12 Walnut (%)

Status Slack Not Binding 7500 Not Binding 7625 Binding 0 Binding 0 Not Binding 250 Not Binding 250 Not Binding 875 Binding 0

Case Problem 1

PRODUCT MIX

TJ's Inc. Cell $B$5 $C$5 $D$5

Name Quantity to produce Regular (R ) Quantity to produce Deluxe(D) Quantity to produce Holiday(H)

Final Reduced Objective Value Cost Coefficient 17500 0 1.65 10625 0 2 5000 0 2.25

Allowable Allowable Increase Decrease 0.35 0.15 0.2 0.107692308 0.175 1E+30

Constraints Cell $E$13 $E$14 $E$15 $E$8 $E$9 $E$10 $E$11 $E$12

Name Minimum to produce(Regular mix) lbs Minimum to produce(Deluxe mix) lbs Minimum to produce(Holiday mix) lbs Almond (%) Brazil (%) Filbert (%) Pecan (%) Walnut (%)

Final Shadow Constraint Allowable Value Price R.H. Side Increase 17500 0 10000 7500 10625 0 3000 7625 5000 -0.175 5000 4692.307692 6000 8.5 6000 583.3333333 7250 0 7500 1E+30 7250 0 7500 1E+30 5125 0 6000 1E+30 7500 1.5 7500 250

Allowable Decrease 1E+30 1E+30 5000 610 250 250 875 750

4958.333

Case Problem 1

PRODUCT MIX

Target Cell Name $E$4 Profit contribution

Value 61375

Adjustable Cell Name $B$5 Quantity to produce Regular (R ) $C$5 Quantity to produce Deluxe(D) $D$5 Quantity to produce Holiday(H)

Value 17500 10625 5000

Lower Target Limit Result 10000 49000 3000 46125 5000 61375

Upper Target Limit Result 17500 61375 10625 61375 5000 61375

Case Problem 1

PRODUCT MIX Profit contribution Quantity to produce

 Almond (%) Brazil (%) Filbert (%) Pecan (%) Walnut (%) Minimum to produce(Regular mix) lbs Minimum to produce(Deluxe mix) lbs Minimum to produce(Holiday mix) lbs

Regular (R ) Pounds

Regular(R) Deluxe(D) Holiday(H) $1.65 $ 2.00 $ 2.25 $ 66,333.33 11666.67 17916.67 5000

0.15 0.25 0.25 0.1 0.25

0.2 0.2 0.2 0.2 0.2

0.25 0.15 0.15 0.25 0.2

1 1 1

11666.66667

Deluxe(D) Pounds 17916.66667 Holiday(H) Pounds 5000 Total Profit $ 66,333.33

Total Profit

6583.33 7250.00 7250.00 6000.00 7500.00

<= <= <= <= <=

Total  Available(P ounds) 7000 7500 7500 6000 7500

11666.67

>=

10000

17916.67

>=

3000

5000.00

>=

5000

Case Problem 1

PRODUCT MIX Case Problem 1

PRODUCT MIX Cell (Max) Cell Name $E$4 Profit contribution

Adjustable Cell Name $B$5 Quantity to produce Regular (R ) $C$5 Quantity to produce Deluxe(D) $D$5 Quantity to produce Holiday(H)

Constraints Cell Name $E$13 Minimum to produce(Regular mix) Ponds $ E$ 14 Minimum to p roduc e(Deluxe m ix) P onds $E$15 Minimum to produce(Holiday mix) Ponds $E$8 Almond (%) $E$9 Brazil (%) $E$10 Filbert (%) $E$11 Pecan (%) $E$12 Walnut (%)

Original Value $ 61,375.00

Final Value $ 66,333.33

Original Value 17500 10625 5000

Final Value 11666.66667 17916.66667 5000

Cell Value 11666.66667 1 79 16 .66 66 7 5000 6583.333333 7250 7250 6000 7500

Formula $E$13>=$G$13 $E$1 4>= $G$1 4 $E$15>=$G$15 $E$8<=$G$8 $E$9<=$G$9 $E$10<=$G$10 $E$11<=$G$11 $E$12<=$G$12

Status Not Binding Not B inding Binding Not Binding Not Binding Not Binding Binding Binding

Slack 1666.666667 1 49 16 .6 66 67 0 416.6666667 250 250 0 0