View the step-by-step solution to:

# Solve the following LP problem using the Solver in MS Excel. Each question carries 6 marks. Upload all your solution in an Excel file.

Solve the following LP problem using the Solver in MS Excel. Each question carries 6 marks.

Q1.     A candy manufacturer has 130 pounds of chocolate-covered cherries and 170 pounds of chocolate-covered mints in stock. He decides to sell them in the form of two different mixtures. One mixture will contain half cherries and half mints by weight and will sell for \$2.00 per pound. The other mixture will contain one-third cherries and two-thirds mints by weight and will sell for \$1.25 per pound. How many pounds of each mixture should the candy manufacturer prepare in order to maximize his sales revenue?

the revise : this is an assignment given to us and we should answer it like any other assignment uploaded by other users and it is answered here by the tutors in this website

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents