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

Upload all your solution in an Excel file.

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**

** **

### Recently Asked Questions

- Please refer to the attachment to answer this question. This question was created from MGMT 303 Final Exam 1.

- Is the value of goods stolen during a burglary related to the likelihood that the offender will be arrested? A researcher collects data on the value of stolen

- Please refer to the attachment to answer this question. This question was created from Online BIO 114 Lab 2 Diffusion and Osmosis V-3.