Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

using Excel solver, solve the following LP problem Question number 2 Using excel solver, solve the following LP problem. X, number of cases of model A made X2= number of cases of model B made...

BUSINESS 275, WINTER 2016 ASSIGNMENT #2: LINEAR PROGRAMMING Administrative Matters 1.1 Deadline This assignment is due by 11 AM on Wednesday, March 23, 2016 in the correct labeled drop box outside...

1. (Linear Programming: basic formulation and graphical solution) A wood product firm uses available time at the end of each week to make goods for stock. Currently, two products on the list of items...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

How do I formulate question 3 as a transportation problem? ADM2302 Section M, N and P Solution Assignment # 2 SOLUTION Assignment # 2 LP Formulations and Applications ADM2302 students are reminded...

Assignment 3- LP A+ Start Assignment Due Monday by 11:59pm Points 100 Submitting a file upload Available Mar 2 at 4pm - Mar 7 at 11:59pm 5 days Assignment 3(A)- LP.docx Assignment 3 (B) LP.pdf Pl....

bv the 4. (20%) Read Farmer Leary problem narrative. It is Winston page 2414 1 Section 5.2. Solve the problem using Excel. Generate the sensitivity report and answer questions a-c as written below,...

no more information. Please help me solve this Due date: 12 April 2021, 23:59 1. A textile company produces two types of silk wearsties and shirts Shirt is a heavier grade of silk cloth and, as such,...

ADM2302 -Summer 2016 Instructor: Davood Astaraky Assignment one Linear Programming Formulation, Graphical Method and Excel Solver Please note that submitted assignments must be neat, readable, and...

PROJECT 3 INSTRUCTIONS! USE EXCEL PROPERLY!!!!! Please download the template attached and complete the requirements for this project using my template. You should upload the one Excel file to this...

Following is information about the assembly department of a company: 1. There were 200,000 units in work in process on August 1. With respect to units transferred in, 100% were complete and costs...

Triplett Services Co. experienced the following events in 2013: 1. Provided services on account. 2. Collected cash for accounts receivable. 3. Attempted to collect an account and, when unsuccessful,...

1 0 . Which of the following would be included in investment spending? A ) The purchase of paint to repaint a ten - year - old factory. B ) The purchase of a factory by a business in the current...

Suver Corporation has a standard costing system. The following data are available for June: Actual quantity of direct materials purchased 70,000 pounds Standard price of direct materials $ 8.00 per...