Preview

Group 2 Red Brand Canners Case Study

Good Essays
Open Document
Open Document
2910 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Group 2 Red Brand Canners Case Study
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 the highest profit is obtained with 615.000 pounds of canned whole tomatoes from grade A and 205,000 from grade B, 65.000 juice from grade A and 195.000 from B, and 2.000.000 paste tomatoes from grade B. So the whole net profit will be $47.600. This means that by adding 80.000 pounds of grade A tomato, the achievement for the whole profit will stand at it is optimal region.
Furthermore, the report provides information about diverse alternatives such as what happens if the amount of any products are increased, or which type of quality would be better to use for juice or any other products, cost changes and how they influences the whole objective function.
The attached report gives the details of what we have done in order to come up with the best solution, the analysis procedure, the recommendations and the alternatives that can be considered in the problem. If you have any question or require further information, please do not hesitate to contact us.
Sincerely,
Jennifer Solano
Nima Molajafar
Wenhao Ma

RED BRAND CANNERS

By
Jenniffer Solano
Nima Molajafar
Wenhao Ma

TOMS 5301 – Modeling Business Decisions
Prof. Uma Kumar
January 29th 2015

SUMMARY
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. Optimal Solutions was hired to make recommendations and provide the best production distribution for the company.
The solution. Based

You May Also Find These Documents Helpful

  • Good Essays

    Nt1310 Unit 4 Lab Report

    • 2595 Words
    • 11 Pages

    ❺ A quality control supervisor in a cannery knows that the exact amount each can contains…

    • 2595 Words
    • 11 Pages
    Good Essays
  • Powerful Essays

    One such factor is seasonal demand. Swimsuits sell better in the spring and summer months, whereas, snow shovels sell better in the fall and winter months. Recognition of this factor helps management avoid under and over estimating stock requirements. Knowing how much inventory is needed requires historical data and mathematical forecasting equations. The seasonal inventory system fills this role and provides management accurate seasonal inventory requirement…

    • 2245 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    Course Projectb Acct. 505

    • 636 Words
    • 3 Pages

    Cost to produce Annual cost of direct material: Need of 1,100,000 cans per year Annual cost of direct labor for new employees: Wages Health benefits Other benefits Total wages and benefits Other variable production costs Total annual production costs Annual cost to purchase cans…

    • 636 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Total Profits = $800 - $760 = $40. The firm will continue to produce as it is earning economic profits. If this firm is typical of the banana bread industry, more resources will flow toward banana bread as other potential firms are attracted to the economic profits in the industry.…

    • 673 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Sci/230 Scientific Method

    • 325 Words
    • 2 Pages

    In completing the Tomato Plant experiment I had to apply the scientific method. I observed that my tomato plants were producing less fruit each year. I then questioned some of the elements that may have affected the tomato plants and caused them to bear fewer tomatoes being a deficiency in warmth, water, or nutrients. I then selected my hypotheses that the plants were in need of more nutrients. Following my hypothesis I developed my prediction which was that my plants would bear more tomatoes if I was to replace the old soil with new soil before planting. I then concluded, based off of the graph depicting the number of tomatoes per plant, that my hypothesis was supported because; my predication was accurate and the plants grew more tomatoes after I had replaced the soil.…

    • 325 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Hamptonshire Express Case

    • 632 Words
    • 3 Pages

    c. The optimal profit derived in this scenario is $371.33 per day, which is a $40 increase from the profit derived in problem #1, of $331.43.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Quain Case Analysis

    • 1013 Words
    • 6 Pages

    Specifications (i.e constraints) for the mixture demanded that Chemical E-11 must constitute for at least 15% of the blend, C-92 and C-30 must together constitute at least 45% of the blend, and D-21 and C-92 can together constitute no more than 30% of the blend. Lastly, Quain-Grow is packaged and sold in 50-pound bags.…

    • 1013 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Two pounds of material are required for each finished unit. The inventory of materials at the end of each month should equal 20% of the following month's production needs. Purchases of raw materials for May should be:…

    • 437 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    CH01ProblemsCasespg453 455

    • 1827 Words
    • 8 Pages

    Additional Problems and Cases Chapter 1 Extra Problems/Cases 41. What is the difference between a parameter and a decision variable in a mathematical model? 42. Discuss how a spreadsheet can facilitate the development of a model shell and the model itself. 43.…

    • 1827 Words
    • 8 Pages
    Good Essays
  • Good Essays

    Although the optimal profit is increased from scenario 1 to scenario 2 by $39.90 the per unit…

    • 850 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    References: Taylor, B. M. (2010). Introduction to management science (11th ed.). Upper Saddle River, NJ:…

    • 649 Words
    • 3 Pages
    Powerful Essays
  • Good Essays

    Flexible Budgets

    • 734 Words
    • 3 Pages

    McCarver produced 20,000 squares of shingles during October. How much is budgeted for total manufacturing costs in October?…

    • 734 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Craddock Cup

    • 712 Words
    • 3 Pages

    Three Possible Mutually Exclusive Alternatives that Might be used to Solve the Problem (these must not include the status quo (current practice) and should include at least one alternative that is not mentioned in the case):…

    • 712 Words
    • 3 Pages
    Powerful Essays
  • Satisfactory Essays

    Question

    • 369 Words
    • 2 Pages

    “Each box ordered must contain between 4 and 8 bags of each different bean type” in cells F3 to F5, I have added a data validation to meet your constraint.…

    • 369 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Break-Even Analysis

    • 355 Words
    • 2 Pages

    The fixed costs of this operation are $80,000, while the variable costs of the grapes are $.10 per pound.…

    • 355 Words
    • 2 Pages
    Satisfactory Essays

Related Topics