Case analysis Red brand canners

Satisfactory Essays
MODEL DESCRIPTION
The problem: Mr Mitchell Gordon, vice president of operations of Red Brand Canners, wants to determine the amount of tomato products to pack that season based on the demand for the coming year. A total of 3 million pounds of tomato crop was purchased, however, according to Dan Tucker, the production manager, about 20% of the tomato crop was grade A quality and the remaining portion was grade B. In addition, although the company has ample production capacity, the production manager alerted that it was impossible to produce all whole tomatoes because only a small portion of the crop was grade A quality. The demand per cases, the contribution per product (Canned whole tomatoes, Tomato juice and Tomato paste) and quality results were given to us for the analysis and are detailed on Appendix A. You want to determine the optimal canning policy for the season’s crop.

The solution approach: Using a mathematical model and linear programming we obtained the proposed solutions. The main objective of this model is to determine the optimal canning policy for the season’s crop and maximize profits. The mathematical model consists of an objective function, 6 variables and 7 constraints based on the information provided to us. The detailed mathematical model is on appendix B. The optimal solution was obtained from Excel Solver by the simplex linear programming method.

Variables: The mathematical model has in total 6 nonnegative variables defined in terms of pounds of tomatoes. Each product has 2 variables, one representing the pounds of grade A tomatoes and the other representing the pounds of grade B tomatoes.

Constraints: Seven (7) constraints related to limitations on the demand, quality and quantity of the pounds of tomatoes for the products. The demand forecast constitutes three constraints, one for each type of product based on the information provided. In terms of quality, we determined two constraints, one for canned whole tomatoes and one for

You May Also Find These Documents Helpful

  • Powerful Essays

    Red Brand Canners

    • 1644 Words
    • 7 Pages

    Red Brand Canners Case Study Red Brand Canners 2 Summary Context ............................................................................................................................................................. 3 Purpose of the document ................................................................................................................................. 3 Cooper’s solution .............................................................................................…

    • 1644 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    Red Brand Canner

    • 1350 Words
    • 6 Pages

    RED BRAND CANNERS On Monday, September 12, 1995, Mr. Mitchell Gordon, vice president of operations, asked the controller, the sales manager, and the production manager to meet with him to discuss the amount of tomato products to pack that season. The tomato crop, which had been purchased at planting, was beginning to arrive at the cannery, and packing operations would have to be started by the following Monday. Red Brand Canners was a medium-sized company which canned and distributed a variety…

    • 1350 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    Red Brand Canners

    • 2093 Words
    • 9 Pages

    RED BRAND CANNERS REVISITED Resource allocation report Decision and Risk analysis Contents Executive Summary page 2 Introduction page 2 1 The basic model without the option of additional A tomatoes page 2 2 Additional supply of A tomatoes (AA) page 3 3 Advertising page 3 4 Additional supply of B tomatoes (BB) page 4 5 Closing down production lines? page 4 Appendix 1 - The Basic Model page 5 Appendix 2 – Additional Supply of A tomatoes page 7 Appendix…

    • 2093 Words
    • 9 Pages
    Powerful Essays
  • Powerful Essays

    Red Brand Canners

    • 2064 Words
    • 9 Pages

    Case Study: RED BRAND CANNERS Vice President of Operations Mr. Michell Gorden Controller Mr. William Copper Sale Manager Mr. Charles Myers Production Manager Mr. Dan Tucker Purpose: Decide the amount of tomato products to pack at this season. Tomato Products Whole Tomato Tomato Juice Tomato Paste Information: 1. Amount of Tomato: 3,000,000 pounds to be delivered. Tomato quality: 20% (grade A) × 3,000,000 = 600,000 pounds 80% (grade B) × 3,000,000 = 2,400,000 pounds (provided by production…

    • 2064 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    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…

    • 974 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Red Brand Canners

    • 1143 Words
    • 5 Pages

    Answers to Red Brand Canners Case Part I 1. Based on the availability of 600,000 pounds of grade “A” tomatoes (grade 9), one can mix in some grade “B” tomatoes (grade 5) to generate a mix of grade 8. Let X denote the pounds of grade “B” tomatoes that can be mixed in. Then: (600,000*9+X*5)/(600,000+X)=8. Solving this, yields X=200,000 lbs for a total weight of 800,000 lbs. 2. Cooper’s suggestion restricts the usage of tomatoes to merely 800,000 lbs (as shown in 1). The leftover tomatoes…

    • 1143 Words
    • 5 Pages
    Good Essays
  • Good Essays

    RED BRAND CANNERS On Monday, November 15th, 2004, Mitchell Gordon, Vice-President of Operations, asked the Controller, the Sales Manager, and the Production Manager of Red Brand Canners to meet with him to discuss the amount of tomato products to pack that season. The tomato crop, which had been purchased at planting, was beginning to arrive at the cannery. Packing operations would have to start by the following Monday because, after this time the fruit would begin to deteriorate. In effect this…

    • 1254 Words
    • 6 Pages
    Good Essays
  • Good Essays

    Red Canners

    • 986 Words
    • 4 Pages

    Red Brand Canners On Monday, June 10, 2013, Mr. Mitchell Gordon, Vice-President of Operations, asked the Controller, the Sales Manager, and the Production Manager to meet with him to discuss the amount of tomato products to pack that season. The tomato crop, which had been purchased at planting, was beginning to arrive at the cannery, and packing operations would have to be started by the following Monday. Red Brand Canners was a medium-size company which canned and distributed a variety of fruit…

    • 986 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Optimal Solutions Carleton University 29 Jan 2015 Mr. Mitchell Gordon, Vice president of operations Red Brand Canners. Dear Mr. Gordon, We have completed the analysis of your goal to determine the amount of tomato products to pack for the season. This report consists of defining the whole problem and the solution as you desired to be, with respect to limitations and possibilities that already exist, management policies, recommendations and alternatives. By modulating the problem, we found out that…

    • 2910 Words
    • 71 Pages
    Good Essays
  • Satisfactory Essays

    Red Canners

    • 550 Words
    • 3 Pages

    There are three options in the case on which a decision needs to be made 1) What grade of tomatoes should be used to make what type of product in the existing scenario? 2) Should the company purchase additional tomatoes? 3) Should the company consider Myers costing methods First Option: Firstly, we will calculate the product mix used to make different type of products in the existing scenario to maximize profit. Decision Variables: Let AW be the pounds of “Canned Whole Tomatoes” produced…

    • 550 Words
    • 3 Pages
    Satisfactory Essays