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
Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Motivation

This tests some key elements of major motivation theories.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

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