Question: please help solve using excel or spreadsheet! Daisy Drugs manufactures two druge 1 and 2 The drugs are produced by blending two chemicals: 1 and

please help solve using excel or spreadsheet!

Daisy Drugs manufactures two druge 1 and 2 The drugs are produced by blending two chemicals: 1 and 2. By weight, drug I must contain at least 65chemical and drug 2 must contain a least 55% chemical 1. Drug 1 solls for So, and drug 2 sells for $4/ Chemicals 1 and 2 can be produced by one of two production processes Running process using 4 hours of skilled labor yields 3 oz of each chemical Running process 2 using 3 hours of skilled labor yields 3 or of chemical and 1 of chemical 2. A total of 120 hours of sted laboris available. Formulate an LP that can be used to maximize Daisy's sales revenue with the following extra requirements Extra Requirement a) Please use the following decision variables to formulate the LP T = the amount of drug i, i=1,2 the amount of chemical contained in drugi.i-1.2.1-1.2 V total times of running process t, 1,2 3; the amount of chemical produced during two processes, j-1,2 Extra Requirement b) Please use Excel solver to solve the LP and fill the following tables with the optimal solution you obtain: X2= V11 V12= V21= V22= Y2= Z: Optimal Value= ya Extra Requirement c) Please print out your Excel spreadsheet and submit

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 General Management Questions!

Instructions: Model the following problem(s) then code it using google colab and submit your code by the end of the lab session.You need to submit your linear program along with your code. You need...

Problem 3 (Adapted from Winston, 2004): Daisy Drugs manufactures two drugs: 1 and 2. The drugs are produced by blending two chemicals: 1 and 2. By weight, drug 1 must contain at least 65% chemical 1,...

Daisy Drugs manufactures two drugs: 1 and 2. The drugs are produced by blending two chemicals: 1 and 2. By weight, drug 1 must contain at least 65% chemical 1, and drug 2 must contain at least 55%...

hello i want the answer for this question as a code on python please 1 Problem Statement Daisy Drugs manufactures two drugs: 1 and 2. The drugs are produced by blending two chemicals: 1 and 2. By...

Daisy Drugs manufactures two drugs: 1 and 2. The drugs are produced by blending two chemicals: 1 and 2. By weight, drug 1 must contain at least 65% chemical 1, and drug 2 must contain at least 55%...

3. - [15 points) The nutritionist working at a university is planning a nutritious and not-so expensive meal plan for students. The meal should include at least one serving from each of three...

Daisy Drugs manufactures two drugs: 1 and 2. The drugs are produced by blending two chemicals: 1 and 2. By weight, drug 1 must contain at least 65% chemical 1, and drug 2 must contain at least 55%...

6 Daisy Drugs manufactures two drugs: 1 and 2. The drugs are produced by blending two chemicals: 1 and 2. By weight, drug 1 must contain at least 65% chemical 1, and drug 2 must contain at least 55%...

Capsule Drugs manufactures two drugs. The drugs are produced by blending two chemicals. By weight, drug 1 must contain at least 75% chemical 1, and drug 2 must contain at least 45% chemical 1. Drug 1...

Capsule Drugs manufactures two drugs. The drugs are produced by blending two chemicals. By weight, drug 1 must contain at least 65% chemical 1, and drug 2 must contain at least 55% chemical 1. Drug 1...

Read the case study Henry Schein Case: Doing Well by Doing Good? The critical issues that you are to discuss are how outside hiring can be assimilated into the corporate culture of henry schein as...

Your fellow student was playing Angry Birds on a mobile phone in the lecture theatre when they suddenly stopped, looked up at you and said, Deferred tax liabilities and assets should be measured...

Consider a 3 0 - year, $ 1 6 5 , 0 0 0 mortgage with a rate of 6 . 7 5 percent. Seven years into the mortgage, rates have fallen to 5 . 4 5 percent. Suppose the transaction cost of obtaining a new...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...