Explore BrainMass
Share

Explore BrainMass

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

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com April 3, 2020, 2:24 pm ad1c9bdddf
    https://brainmass.com/business/sales-revenue/34960

    Attachments

    Solution Summary

    You will find the answer to this puzzling question inside.

    $2.19

    ADVERTISEMENT