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 Explanation of Benefits.
- A research institute conducted clinical trials of a method designed to increase the probability of conceiving a boy. Among 161 babies born to parents using the
- hi i have an exam on wednesday about vital signs and pain management on fundamental of nursing .which questions can help me ?thanks in advance