Preview

Red Brand Canners – Case Study

Good Essays
Open Document
Open Document
974 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Red Brand Canners – Case Study
REPORT ON RED BRAND CANNERS – CASE STUDY

Introduction:

Red Brand Canners is a medium sized company that cans and distributes a variety of fruit and vegetable products under private brands in the western states. The company makes three different tomato products including whole tomatoes, tomato juice and tomato paste. They also distribute Choice peach halves, peach nectarine and cooking apple products.

As part of their discussion over the amount of tomato products to pack in a particular season , it was observed that 3 million pounds of tomatoes are available for packing and distributing. This included two kinds of tomatoes ‘Grade A’ which constituted 20% of available crop and ‘Grade B’ being the remaining.

Problem Statement:

The problem can be divided into the following parts:

(a) How to allocate 3 million pounds of tomatoes in order to maximize profits?
(b) Should the company purchase additional Grade ‘A’ tomatoes? if so, what is the maximum amount the company can purchase and also formulate the new optimum product mix

Analysis

(A) Optimal Solution:
The objective is to maximize the profit by obtaining an optimal mix of Grade A and Grade B tomatoes. Hence, the problem can be formulated algebraically as below:

.

Where: si : selling price li : pounds of tomatoes used vi : variable costs per case of ith product xai : Amounts of Grade A in pounds used in ith product. xbi : Amounts of Grade A in pounds used in ith product.

The problem can be solved using excel solver solution of the same has been given in Appendix A.
Also, solving the problem using Lingo, we obtain:

MAX = xa1 + xb1 + xa1 -
3*xa2
xa1 + xa2 + xa3 + xa1 > xa2 > xa3 > xb1 > xb2 > xb3 >

Maximum Profit: 53340 $ xa1: 525000 lbs xb1: 175000 lbs xa2: 75000 lbs xb2: 225000 lbs xa3: 0.000000 lbs xb3: 2000000 lbs

(B) Coopers Solution:
Cooper agreed that the company would do well on the tomato crop, and that the incremental profit on whole

You May Also Find These Documents Helpful

  • Powerful Essays

    Cadman Food Processors

    • 3980 Words
    • 16 Pages

    The decision that Mr. Gordon and Cadman Foods faces is one that can be clearly solved when the situation it faces is broken down to the core and certain fundamentals are clearly understood. To make the analysis more palatable, it is important that two key elements are understood. The first is that the contribution margin must equal the difference between the selling price and the variable cost price not including the cost of tomato’s, and secondly the cost of the tomato crop is a sunk cost regardless of whether the cost is an average or a ratio based on quality. If any of the crop is not used, or if the costs of tomatoes was applied prior to optimizing production, not all the costs are captured in the analysis. This was one of the findings of our analysis and a key omission made by both Bill Cooper’s and Charles Myers strategies.…

    • 3980 Words
    • 16 Pages
    Powerful Essays
  • Powerful Essays

    Final Accounting

    • 1555 Words
    • 5 Pages

    As reflected in the Production Budget captured in Exhibit B below and included in the overall Peyton Approved budget worksheet included in Appendix A. First budgeted sales units for each month in the quarter was used to multiply with ratio to inventory future sales to compute budgeted ending inventory. The company stated that it was company's policy to have a given month's ending finished goods inventory to equal 70% of the next month's expected unit sales. Then, budgeted sales units of 18,000, 22,000 and 20,000 units are added to the budgeted ending inventory units of 15,400, 14,000 and 16,800 units for the month of July, August and September, respectively to arrive to required units to be produced of 33,400, 36,000 and 36,800 units for each respective months. Subsequently, beginning inventory is deducted from required…

    • 1555 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Accounting 315

    • 1877 Words
    • 8 Pages

    Extensive detail and information is contained within the help function of Microsoft Excel and in the provided text.…

    • 1877 Words
    • 8 Pages
    Good Essays
  • Best Essays

    In the world of upscale specialty foods, Kudler Fine Foods is one of the leaders in the San Diego metropolitan area. Capable of providing the finest foodstuffs, wines, and specialty foods as well as attention to detail and customer satisfaction, the company takes pride in obtaining the very best of domestic and foreign foodstuffs to meet any customer’s needs. From its beginning in 1998, Kudler has grown to three major retail store locations in La Jolla, Encinitas, and Del Mar within the San Diego metropolis, allowing Kudler to fulfill needs all over the community at anytime.…

    • 3220 Words
    • 13 Pages
    Best Essays
  • Satisfactory Essays

    problems below and submit your work in an Excel document. Be sure to show all of your work and clearly label all…

    • 263 Words
    • 1 Page
    Satisfactory Essays
  • Powerful Essays

    C. In USDA yield grading the objective of the judge is to estimate the total…

    • 1170 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Week 3 Assignment

    • 497 Words
    • 2 Pages

    b What number of workers appears to be most efficient in terms of pizza product per worker?…

    • 497 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    You may use the Excel workbook NCC.xls (available on the course page) to analyze this case, although the analysis can be done without it.…

    • 426 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Midterm Study Guide 1

    • 834 Words
    • 4 Pages

    How does dumping, human and drug trafficking influence how tomatoes are regulated and trans ported?…

    • 834 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Allegro Answers

    • 655 Words
    • 3 Pages

    1. Using the Simple Sheet, what happens when Allegro cuts advertising and selling effort to 0$ and raises price to $500/unit? Comment.…

    • 655 Words
    • 3 Pages
    Good Essays
  • Better Essays

    The tomato was originally cultivated by the Aztecs in Central America, and has historic origins that can be traced back to around 700 A.D. They were also known to be native to western South America. It was during the 16th century that the Europeans were introduced to this fruit when the early explorers set tail to discover new lands. In 1519, Cortez brought tomato seeds back to Europe where they planted as ornamental curiosities but didn’t eat them. The first tomatoes that reached to Europe weren’t the typical red tomatoes that we see today. They were yellow in color, and therefore were named as yellow or golden apples. It was a pale fruit with an acid flavor and unpleasant smell that…

    • 902 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    Mid Term Exams

    • 1230 Words
    • 5 Pages

    | The owner of Chips etc. produces 2 kinds of chips: Lime (L) and Vinegar (V). He has a limited amount of the 3 ingredients used to produce these chips available for his next production run: 4800 ounces of salt, 9600 ounces of flour, and 2000 ounces of herbs. A bag of Lime chips requires 2 ounces of salt, 6 ounces of flour, and 1 ounce of herbs to produce; while a bag of Vinegar chips requires 3 ounces of salt, 8 ounces of flour, and 2 ounces of herbs. Profits for a bag of Lime chips are $0.40, and for a bag of Vinegar chips $0.50. Which of the following is not a feasible production combination?Answer…

    • 1230 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Also assume that Thomas foods purchases on average 1,000 pounds of tomatoes from a local farmer and that two months prior to harvest, and proposes a hedging strategy in which local farmer sells a two-month futures contract to Thomas Foods for 1,000 pounds of tomatoes. Even though the futures contracts are for the tomatoes that are expected to harvest in two months, the futures contracts and hedged tomatoes have different bases since the futures contracts are based on the ripened, harvested tomatoes, while the hedged item still has two months left in its growing cycle. Therefore, Thomas Foods cannot automatically assume that the hedge will be highly successful in counterbalancing the changes in fair…

    • 593 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    A. In Europe it is mandatory for farmers to label each product that has been modified…

    • 654 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    SWOT of tomato for Greece

    • 196 Words
    • 2 Pages

    In the world of Tomato, Greece has an important role, because of opportunity for becoming a main exporter for Europe. Every year Greece gathers harvests two times: winter through unheated greenhouses and summer in the open area. But Despite the abundance, Greece has problems with logistics for exporting and absence of new technology for growing and packaging. Nowadays, some growers have started investing in new technology, including one $30 million project called Wonderplant in northern Greece. Tough the Greeks aren’t the tomato-growing giants, here are the Dutch tomato business and Spaniards is doing well. After entering single currency, Greece had a short-term happiness, but long-term tragedy, as “Dutch Disease”. So, Greece must work with his weaknesses, such as logistic or technology, for best future of production tomatoes.…

    • 196 Words
    • 2 Pages
    Satisfactory Essays