Question
a) Please formulate the mathematical equations of pottery to maximize profit from bowls and mugs. Describe the objective function, constraints and decision variables. b) Please
a) Please formulate the mathematical equations of pottery to maximize profit from bowls and mugs. Describe the objective function, constraints and decision variables.
b) Please draw a graph of the objective function and constraints (Need to show the feasible area inside the graph).
c) Please label on the graph the 3 extreme points (edge points on graph in which the lines intersect) that are candidate for being the optimal solution.
d) What is the value of slack in each of the 3 extreme points?
e) Which of the 3 extreme points is the optimal, explain?
f) Please open excel file of the pottery example posted on canvas (Exhibit 3,1). Using excel solver, please run the analysis and attach an output which shows the values for optimal solution of the pottery. Please copy paste the output into your word document homework.
g) Please run sensitivity analysis using excel solver of the pottery problem. Please attach the output of sensitivity analysis.
Tarnet C.all (Max) Adiustable Cells Cinnatrainta Adiuntahla r allo
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started