Linear programming task will pay $25

Pls see attached the task i need done in linear programming and you can bid $25 for this

9/25/22, 6:19 PM
Quiz: Mini-project 1: linear programming
Mini-project 1: linear programming
Started: Sep 25 at 3:35pm
Quiz Instructions
You are given 4 attempts at the mini-project. After each attempt, you would only know
which questions are answered correctly, but the answers are not shown. You will see
the answers after the deadline for the mini-project. Only the grade for the last
submitted attempt would count. If you open and work partially on an attempt
(without submitting), you still have a chance to come back to that attempt and
complete it later before the deadline. So you can open the mini-project and start
working on it early.
If you do not intend to submit a new attempt, make sure that you do not open one after
your last submitted attempt, as all open attempts would be submitted automatically by
the system when the mini-project closes at the deadline and the grade for that
automatically submitted attempt would be recorded.
Answer all question in the fields provided. For all numbers, enter them to within
two decimal places (unless specified otherwise in the question), after properly
rounding the final answer. If your calculations involve multiple steps, do not round
intermediate numbers, round only the final answer.
Eli Orchid has designed a new pharmaceutical product, Orchid Relief, which uses
two new ingredients. Eli Orchid can procure limited amounts of each ingredient for
each month, that is, the company has 75 tons of ingredient 1 and 60 tons of
ingredient 2 available each month.
Eli Orchid can manufacture the new product using any of its three existing processes.
The processes are different in their cost per batch of Orchid Relief produced, use
different amounts of each ingredient, and yield different amounts of Orchid Relief.
Details of the three processes are summarized in the following table.
https://csufullerton.instructure.com/courses/3332004/quizzes/8275502/take
1/7
9/25/22, 6:19 PM
Quiz: Mini-project 1: linear programming
Process 1
Process 2
Process 3
$14,000
$19,000
$11,000
3
2
7
Ingredient 2
required per
batch (tons)
1
7
2
Orchid Relief
yielded per
2
5
1
Cost of
production per
batch
Ingredient 1
required per
batch (tons)
batch (tons)
Eli Orchid needs to find how many batches to produce with each process. It is
interested to do this in the least costly way that produces at least 50 tons of Orchid
Relief per month, given the limited availability of the two ingredients.
Verbally state the objective function and all the constraints, define the decision
variables and provide a mathematical formulation of the optimization problem. Create
an excel spreadsheet that represents your mathematical formulation. Use Excel
Solver to find the optimal solution and obtain the sensitivity report. Make sure that
you provide proper labeling of objective function, decision variables, and constraints
so that the Excel sensitivity report is easier to read.
Then answer the following questions:
Question 1
https://csufullerton.instructure.com/courses/3332004/quizzes/8275502/take
1 pts
2/7
9/25/22, 6:19 PM
Quiz: Mini-project 1: linear programming
How many decision variables do we have in this problem?
Question 2
1 pts
Except the non-negativity constraints, how many constraints the problem has?
Question 3
1 pts
Which of the following can represent the objective function:
14000X1+19000X2+11000X3
3 X1+ X2 +2 X3
X1+7X2+2X3
2X1+5X2+X3
Question 4
1 pts
What is the optimal objective?
https://csufullerton.instructure.com/courses/3332004/quizzes/8275502/take
3/7
9/25/22, 6:19 PM
Quiz: Mini-project 1: linear programming
Question 5
1 pts
How much of ingredient 1 is optimally used?
Question 6
1 pts
What is the total cost of production of each ton of Orchid Relief?
Question 7
1 pts
Currently at least 50 tons of Orchid Relief is produced. If Eli Orchid requires one more
ton of output to be produced, how much more would it cost? (this is also commonly
called the marginal cost of each additional ton of Orchid Relief produced – not
necessarily the same as the answer to the last question)
Question 8
1 pts
We would like to produce 80 tons of Orchid Relief (instead of 50). The impact on
optimal cost can be found using the sensitivity report only.
True
https://csufullerton.instructure.com/courses/3332004/quizzes/8275502/take
4/7
9/25/22, 6:19 PM
Quiz: Mini-project 1: linear programming
False
Question 9
1 pts
How much more would it cost to produce 80 tons of Orchid Relief?
It is not possible to produce this much
0
8778
263,333
Question 10
1 pts
Up to how much should Eli Orchid be willing to pay more to obtain an amount of 10
more tons of ingredient 1? (Find the answer using sensitivity report only. If the answer
cannot be determined using sensitivity report, enter -1000)
Question 11
1 pts
Up to how much should Eli Orchid be willing to pay more to obtain an amount of 10
more tons of ingredient 2? (Find the answer using sensitivity report only. If the answer
cannot be determined using sensitivity report, enter -1000)
https://csufullerton.instructure.com/courses/3332004/quizzes/8275502/take
5/7
9/25/22, 6:19 PM
Quiz: Mini-project 1: linear programming
Question 12
1 pts
The management thinks that the pharmaceutical market is going to improve over the
next month so that it can sell 5% more Orchid Relief and at the same time procure
3% more of ingredient 2. However, thinking that they might have too much ingredient
1, the plan is to cut on some of the ingredient 1 and reduce its supply by 5%. How
much more does it cost to produce the higher required amount of Orchid Relief?
(Find the answer using sensitivity report only. If the answer cannot be determined
using sensitivity report, enter -1000)
Question 13
1 pts
By how much should the cost of the third process drop so that management is willing
to use it to produce Eli Orchid? (Find the answer using sensitivity report only. If the
answer cannot be determined using sensitivity report, enter -1000)
Question 14
1 pts
If the cost of process 2 increased to $36,000 per batch, how much would then be the
cost of producing the 50 tons of Orchid Relief? (Find the answer using sensitivity
report only. If the answer cannot be determined using sensitivity report, enter -1000)
https://csufullerton.instructure.com/courses/3332004/quizzes/8275502/take
6/7
9/25/22, 6:19 PM
Quiz: Mini-project 1: linear programming
Question 15
1 pts
A new maintenance strategy is going to come into place that increases the cost of
each of the three processes by $6000. How much would then be the cost of
producing the 50 tons of Orchid Relief? (Find the answer using sensitivity report only.
If the answer cannot be determined using sensitivity report, enter -1000)
Question 16
1 pts
Going back to the original problem from question 3, Eli Orchid would like to make
sure that at most 30% of all batches produced is produced using process 2.
Formulate this limitation and implement in Excel. What would be the new total cost of
production?
No new data to save. Last checked at 6:19pm
https://csufullerton.instructure.com/courses/3332004/quizzes/8275502/take
Submit Quiz
7/7