Preview

Mgt 391 Quantitative Analyses Case 8-1

Powerful Essays
Open Document
Open Document
946 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Mgt 391 Quantitative Analyses Case 8-1
University of Las Vegas Nevada

Alejandra Parra Case 8-1: Product Mix Managerial Report 04/04/2013

Product Mix Information

* 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. Each are made by mixing different percentages of these 5 nuts as follows: | Almond | Brazil | Filbert | Pecan | Walnut | Regular Mix | 15% | 25% | 25% | 10% | 25% | Deluxe Mix | 20% | 20% | 20% | 20% | 20% | Holiday Mix | 25% | 15% | 15% | 25% | 20% | * Tj’s purchased the following shipments at the prices shown:

Type of Nut | Shipment Amount (Pounds) | Cost per Shipment | Almond | 
6000 | $7500 | Brazil | 7500 | $7125 | Filbert | 7500 | $6750 | Pecan | 6000 | $7200 | Walnut | 7500 | $7875 |

* Customer Orders and their Profit Contribution per Pound:

| Profit per Pound | Customer Orders (Pounds) | Regular Mix | $1.65 | 1000 | Deluxe Mix | $2.00 | 3000 | Holiday Mix | $2.25 | 5000 |

Managerial Report

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.

Almonds | 7500/6000 = $1.25 | Brazil | 7125/7500 = $0.95 | Filberts | 6750/7500 = $0.90 | Pecans | 7200/6000 = $ 1.20 | Walnuts | 7875/7500 = $ 1.05 |

Regular Mix: 0.15(1.25)+0.25(0.95)+0.25(0.90)+0.10(1.20)+0.25(1.05) = $1.03
Deluxe Mix:
0.20(1.25)+0.20(0.95)+0.20(0.90)+0.20(1.20)+0.20(1.05) = $1.07
Holiday Mix:
0.25(1.25)+0.15(0.95)+0.15(0.90)+0.25(1.20)+0.20(1.05) = $1.10

2) After obtaining the Objective Function and constraints we enter all the information into Microsoft Excel and use the solver feature to find the optimal solution for this Product Mix. The Optimal Product Mix is to produce 17500 pounds of the Regular Mix, 10625 pounds of the Deluxe Mix, and 5000 pounds of

You May Also Find These Documents Helpful

  • Satisfactory Essays

    This file MGT 230 Week 4 Discussion Questions and Summary contains answers on the following problems:…

    • 369 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    In most case studies there is more information than you will need. The key skill is being selective in terms of which information best supports your explanation. This doesn’t mean that the rest of the information is useless, only that based on that assignment you don’t need it. For later assignments you may have a different issue to focus on, so other information would then become relevant to you.…

    • 3274 Words
    • 11 Pages
    Satisfactory Essays
  • Powerful Essays

    For a company to be successful in the long term today, they must be diverse. The company needs to be able to adapt to changes. The need for these changes can present themselves from many angles. Some would include changes in the economy, marketing, or even a change in the target audience. A company has to look at more than just the four levels of management. Organizations must look at how internal and external factors can affect the four levels of management, and adjust accordingly for these changes to be successful in today 's world.…

    • 1814 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    Tomato paste

    • 292 Words
    • 2 Pages

    a) What is the optimal solution, and what are the optimal production quantities? W=1.0 M=1.250 PROFIT=800000…

    • 292 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Our aim is to determine the optimal monthly production in order to maximize the total profit while satisfying the resource constraints such as assembly capacity and available hours for stamping and forming. We will use Excel Solver for optimizing monthly production and for maximizing total profit.…

    • 703 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Case 2-1 Bar Harbor Blueberry Farm Data from Case |Date |Supplier Invoice |Supplier Name |Supplier Address |Amount | |March 7 |AJ34 |Bud’s Soil Prep, Inc. |PO Box 34 |$2,067.85 | |March 11 |14568 |Osto Farmers Supply |45 Main |$ 67.50 | |March 14 |893V |Whalers Fertilizer, Inc. |Route 34 |$5,000.00 | |March 21 |14699 |Osto Farmers Supply |45 Main |$3,450.37 | |March 21 |10102 |IFM Package Wholesale |587 Longview |$4,005.00 | |March 24 |10145 |IFM Package Wholesale |587 Longview |$ 267.88 | Purchases Journal Page 1 |Date |Supplier |Supplier Invoice|Account Number |Post Ref |Amount | |March 7 |Bud’s Soil Prep, Inc. |AJ34 |23 |√ |$2,067.85 | |March 11 |Osto Farmers Supply |14568 |24 |√ |$ 67.50 | |March 14 |Whalers Fertilizer, Inc. |893V |36 |√ |$5,000.00 | |March 21 |Osto Farmers Supply |14699 |24 |√ |$3,450.37 | |March 21 |IFM Package Wholesale |10102 |38 |√ |$4,005.00 | |March 24 |IFM Package Wholesale |10145 |38 |√ |$ 267.88 | | | | | | |…

    • 379 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    * All contract is signed using Indonesian Rupiahs, but maybe converted to usd for overseas…

    • 434 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Mr Sajan

    • 1033 Words
    • 5 Pages

    Decision making is an important aspect of the Paper F5 syllabus, and questions on this topic will be common. The range of possible questions is considerable, but this article will focus on only one: linear programming. The ideas presented in this article are based on a simple example. Suppose a profit-seeking firm has two constraints: labour, limited to 16,000 hours, and materials, limited to 15,000kg. The firm manufactures and sells two products, X and Y. To make X, the firm uses 3kg of material and four hours of labour, whereas to make Y, the firm uses 5kg of material and four hours of labour. The contributions made by each product are $30 for X and $40 for Y. The cost of materials is normally $8 per kg, and the labour rate is $10 per hour. The first step in any linear programming problem is to produce the equations for constraints and the contribution function, which should not be difficult at this level. In our example, the materials constraint will be 3X + 5Y ≤ 15,000, and the labour constraint will be 4X + 4Y ≤ 16,000. You should not forget the non-negativity constraint, if needed, of X,Y ≥ 0. The contribution function is 30X + 40Y = C Plotting the resulting graph (Figure 1, the optimal production plan) will show that by pushing out the contribution function, 66 student accountant March 2008 the optimal solution will be at point B – the intersection of materials and labour constraints. The optimal point is X = 2,500 and Y = 1,500, which generates $135,000 in contribution. Check this for yourself (see Working 1). The ability to solve simultaneous equations is assumed in this article. The point of this calculation is to provide management with a target production plan in order to maximise contribution and therefore profit. However, things can change and, in particular, constraints can relax or tighten. Management needs to know the financial implications of such changes. For example, if new materials are offered, how much should be paid for them?…

    • 1033 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Today Condition of India

    • 881 Words
    • 4 Pages

    A.B.COIRS, S.F.NO.320/9, SERIPALAYAM(POST), ANDIPALAYAM VILLAGE, POLLACHI TALUK TRADING ACCOUNT FOR THE YEAR ENDED 31.3.2012 ------------------------------------------------------------------------------ PARTICULARS AMOUNT PARTICULARS AMOUNT ------------------------------------------------------------------------------ To OPENING BY SALES Coconut Husk & Fibre 11,52,000.00 Coconut Fibre 84,77,000.00 To PURCHASES BY CLOSING STOCK Coconut Husk 73,66,203.00 Coconut Husk & Fibre 28,88,000.00…

    • 881 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    FLOATEA

    • 583 Words
    • 3 Pages

    FLOATEA (Milk Tea + Ice Cream Float) Milk Tea Ingredients: 12oz. size -(43grams) 1/3 cup brewed black tea = P18.06 -(60ml) Flavor syrup(Wintermelon, Caramel, Strawberry, Chocolate, Vanilla) =…

    • 583 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Case Cashews India Brazil

    • 2241 Words
    • 9 Pages

    Due to en excess of processing capacity in India they have been supplied with raw nuts from other countries to cover the processing capacity.…

    • 2241 Words
    • 9 Pages
    Good Essays
  • Good Essays

    Main objective of the problem is to maximize profit of the company, that produces milk made products and minimize shipping cost of these products to supply at different stores in the city. The main objective is achieve by using linear programming optimization methods.…

    • 531 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    MGT 342 CASE 2 STUDYING

    • 296 Words
    • 2 Pages

    four major subsidiary questions to raise the issues and guide this case study_ The relevant…

    • 296 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Questionnaire Mgt 269

    • 372 Words
    • 2 Pages

    We are from Diploma Business Study (BM111) students. Our objective is to collect the information about “the migration of the Thailand’s influence the food culture in Perlis” for Business Communication subject. Your response and information will be kept strictly confidential. Thank you for your cooperation to answer this question.…

    • 372 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    This work MGT 230 Week 1 Discussion Questions and Summary contains answers on the following questions:…

    • 371 Words
    • 2 Pages
    Satisfactory Essays

Related Topics