Explore BrainMass
Share

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 March 21, 2019, 11:06 am ad1c9bdddf
https://brainmass.com/business/sales-revenue/34960

Attachments

Solution Summary

You will find the answer to this puzzling question inside.

$2.19