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