Purchase Solution

Determine the optimal number of cases of tomato juice and tomato paste the company should produce to maximize revenue

Not what you're looking for?

Ask Custom Question

Introduction:

A canning company is about to receive 60,000 pounds of ripe tomatoes from which it can produce canned tomato juice or tomato paste. Each case of tomato juice requires 24 pounds of tomatoes to produce whereas each case of tomato paste only requires 8 pounds of tomatoes. At most, the company can sell a maximum of 2,000 cases of tomato juice. At most, the company can sell a maximum of 6,000 cases of tomato paste. The company can sell a case of juice for $18 and a case of paste for $9.

Instruction:

- Review the attached document.

Problem:

- Create a spreadsheet in Excel to represent this situation and then use the Excel add-in Solver to determine the optimal number of cases of tomato juice and tomato paste the company should produce to maximize revenue.
- Return the spreadsheet showing the optimal solution.

Attachments
Purchase this Solution
Solution Summary

You will find the answer to this puzzling question inside.

Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Motivation

This tests some key elements of major motivation theories.

View More Free Quizzes
Related BrainMass Solutions

  • Linear programming : excel solution

    (Hint: Your decision is to determine to use the two inputs, Grade A and B raw tomatoes, to produce each of the three finished products and your variables should be defined accordingly.) 2.

  • Quantitative Methods - Tom's Inc.

    Develop a linear programming model that will enable Tom's Inc. to determine the mix of salsa products that will maximize the total profit contribution. b. Find the optimal solution.

  • Important information about Cost allocation

    Red Sauce Canning Company processes tomatoes into catsup, tomato juice, and canned tomatoes. During the summer of 20X5, the joint costs of processing the tomatoes were $420,000. There was no beginning or ending inventories for the summer.

  • Price determination in a free market

    What was the approximate size of the US GDP last year. Size of US GDP: $______________________ 8. What are opportunity costs, and how do they help a firm decide which of its many products to produce to maximize profit.? 9.

  • Charge Non Customer Assessments

    The increase in price of orange juice causes people to substitute orange juice for tomato juice and hence the quantity of tomato juice sold would increase.

  • Joint Costs

    #2 Red Sauce Canning Company processes tomatoes into catsup, tomato juice, and canned tomatoes. During the summer of 20x3, the joint costs of processing the tomatoes were $420,000.

  • P value for Hypothesis testing

    Q1) The mean number of calories per 6-ounce can of tomato paste is supposed to be 150. A weight watchers group thought that was larger than 150.

  • Juice Red Tomato Company

    In reference to the case study of Juice Red Tomato company, this solution provides assistance for the selection and maintenance of managerial personnel.

  • Realizable Value Method for Cost per Case by Product

    331672 Realizable Value Method for Cost per Case by Product Red Sauce Canning Company processes tomatoes into catsup, tomato juice, and canned tomatoes. During the summer of 20X8, the joint costs of processing the tomatoes were $420,000.

View More Related Solutions