Linear Programming

Satisfactory Essays
King Fahd University of Petroleum & Minerals College of Industrial Management Second semester (052) 2005-2006

CASE PROBLEM ( PRODUCT MIX) Prepared for DR Taqi Al-Faraj

Group J 225742 Bara'a Al-Jumbaz 4 226352 Mwuaffag Baswaid Ahmad Al-Abdul Muney" 205943

30 May 2006

Case Problem PRODUCT MIX
Background:
TJ's Inc., makes 3 nut mixes for sale to grocery chains located in the Southeast. The three mixes are: Regular Mix, Deluxe Mix and Holding Mix. They are made by mixing different percentages of five types of nuts as follow:

Regular Mix Deluxe Mix Holding Mix

Almond 15% 20% 25%

Brazil 25% 20% 15%

Filbert 25% 20% 15%

Pecan 10% 20% 25%

Walnut 25% 20% 20%

TJ's has just purchased the following shipments of nuts at the prices shown: Type of Nut Shipment Cost per Shipments($) Amount(Pounds) Almond 6000 7500 I I Brazil 7500 7125 Filbert 6750 7500 Pecan 6000 7200 7875 Walnut 7500
I

1

The ~ r o f icontribution Der Pound and Customer orders are: t Profit contribution per Pound Customer Orders (Pounds) Regular mix $1.65 10000 Deluxe mix $2 3000 Holding Mix $ 2.25 5000

Solution:
Xij = quantity of nut (i) to mix j i= 1,2,3,4,5 j= 1,2,3 Profit
1$1.65

I $2.00
D

I $2.25
H
X13

R A
F P
-

Available
6,000 pounds

I
I
I

XI1 X21

I
I
I

X12 X22

I X23
I X33

1 7,500 pounds I
1 7,500 pounds 1 6,000 pounds
I
I

w
Max s.t.

I X51

I X31 I X41

I X32 I X42

Orders

I 10.000 pounds

I X52

I X43 I X53
I
I

I

( 3.000 pounds

1 5,000 pounds

1 7,500 pounds

1.65(Xll+X21+X3 1+X41+X51) + 2(X12+X22+X32+X42+X52) + 2.25(Xl3+X23+X33+X43+X53) X1 l+X12+X1316,000 X2 1+X22+X2317,500 X3 1+XX?+X3317,5OO X4 1+X42+X4316,000 X5 1+X52+X5317,5OO 0.15X11+0.25X21+0.25X31+0.10X41+0.25X51>10,000 0.20X12+0.20x22+0.20X32+0.20x42+0.20X52>3,000 0.25X13+0.15X23+0.15X33+0.25X43+0.20X53>5,000 Xij>O for all ij

1- Cost per pound of the nuts ( cost per shipmentslshipments Amount)

I Almond
Brazil Filbert

You May Also Find These Documents Helpful

  • Good Essays

    Est1 Task 4

    • 1193 Words
    • 5 Pages

    This model assumes all nuts can only be used in these particular mixes and cannot be sold individually or as part of any other nut mixes…

    • 1193 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Linear Programming

    • 887 Words
    • 4 Pages

    Decision Variables represents choices available to the decision maker in terms of amount of either inputs or outputs…

    • 887 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Linear Programming

    • 737 Words
    • 3 Pages

    The EI Paso plant was expanded when the company began marketing its meters in Arizona, California, Nevada, and Utah. With the growth of the West Coast business, the Darby…

    • 737 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    A common form of the product-mix linear programming seeks to find the quantities of items in the product mix that maximizes profit in the presence of limited resources.…

    • 1510 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Unit 3 Nessa P6

    • 859 Words
    • 3 Pages

    This product contains crunchy nuts and toasted oats for a delightful sweet and nutty flavour which comes in three variations and they are the following; peanut, almond, and chocolate. They are further dipped into nutty flavour coating. The bars are available in boxes of three with 5 bars entailed. The average pricing for the granola bars are £2.39.…

    • 859 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Linear Programming

    • 431 Words
    • 4 Pages

    The Southern Textile Mill produces 5 different fabrics. Each fabric can be woven on one or…

    • 431 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Bulk items include all the essentials for baking, but also nuts, dried fruits, candies, herbs and spices. They also feature canned good from Jake and Amos and Grandma's Jam House.…

    • 495 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Linear Programming

    • 5826 Words
    • 43 Pages

    Not quite sure if this ebook is right for you? See the below description to determine if…

    • 5826 Words
    • 43 Pages
    Good Essays
  • Good Essays

    Nonlinear Programming

    • 769 Words
    • 4 Pages

    • It is easy to use the Excel Solver to solve NLPs. • The process is similar to a linear model. • For NLPs having multiple local optimal solutions, the Solver may fail to find the optimal solution because it may pick a local extremum that is not a global extremum. 22 Example 2 • Trucko is trying to determine where they should locate a single warehouse. The positions in the x‐y plane of their four customers and the number of shipments made annually to each customer are given. Trucko wants to locate the warehouse to minimize the total distance trucks must travel annually from the warehouse to the four customers. Customer X‐coordinate Y‐coordinate Number of Shipments 1 5 10 200 2 10 5 150 3 0 12 200 4 12 0 300 23 1 Example 3 • Q& H Company advertises on soap operas and football games. Each soap opera ad costs $50000, and each football game ad costs $10000. Giving all figures in millions of viewers, S soap opera ads are bought, they will be seen by 5S men and 20 S women. If F football Ads are bought they will be seen by 17F men and 7F women. Q&H wants at least40 million men and at least 60 million women to see its ads. • Formulate the NLP • Suppose the number of women reached by F football ads and S soap opera ads is 7F+ 20 S ‐0.2 (FS). Why might this be a more realistic representation of the number of women viewers seeing Q&H’s ads? 24 Example 3: cont’d • Let S = soap opera ads and F = football ads. Then we wish to min z = 50S + 100F st 5S1/2 + 17F1/240 (men) 20S1/2 + 7F1/260 (women) S0, F0 25 2 Review of Differential Calculus • The equation lim f ( x)  c x a means that as x gets closer to a (but not equal to a), the value of f(x) gets arbitrarily close to c. • A function f(x) is continuous at a point if lim f ( x)  f (a ) xa If f(x) is not continuous at x=a, we say that f(x) is discontinuous (or has a discontinuity) at a. 26 Review of Differential Calculus • The derivative of a function f(x) at x = a (written f’(a)] is defined to be lim x  0 f (a…

    • 769 Words
    • 4 Pages
    Good Essays
  • Best Essays

    Asst Prof & Head, Dept of Business Administration, S.S.B.T’s College of Engg & Tech., Jalgaon (M.S)…

    • 3430 Words
    • 14 Pages
    Best Essays
  • Good Essays

    Case Study Final

    • 1010 Words
    • 3 Pages

    industry leader in the world market. Beech-Nut, which has the lowest market share of the three,…

    • 1010 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Tjs Product Mix

    • 260 Words
    • 2 Pages

    TJ’s, Inc., makes three nut mixes for sale to grocery chains located in the Southeast. The three mixes, referred as the Regular Mix, Deluxe Mix, Holiday Mix. Now TJ’s is committed to using the available nuts to maximize profit of the fall seasons, and they must satisfy the received orders.…

    • 260 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    1) The cost per pound for Almonds is $1.25, of the Brazil Nuts is $0.95, of the Filberts is $0.90, of the Pecans is $1.20, and of the Walnuts is $1.05. The cost per pound of the Regular Mix is $1.03, of the Deluxe Mix is $1.07, and the Holiday Mix is $1.10.…

    • 946 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    The decision to be made in this problem is how many of each type of backpack to make. Therefore, we add two changing cells with range name UnitsProduced (C11:D11). The…

    • 531 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Product Mix TJ's inc

    • 545 Words
    • 3 Pages

    1. The cost per pound of the almonds is $1.25 The cost per pound of the Brazil Nuts is $.95. The cost per pound of the filberts is $.90. The cost per pound of the pecans is $1.20. Finally the cost per pound of the walnuts is $1.05. Therefore, the cost per pound of the Regular Mix is $1.03, of the Deluxe Mix is $1.07, of the Holiday Mix is $1.10…

    • 545 Words
    • 3 Pages
    Satisfactory Essays

Related Topics