Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A beverage cans manufacturer makes 3 types of soft drink cans needed for the beverage producers to fill soft drinks of three different volumes. The
A beverage cans manufacturer makes types of soft drink cans needed for the beverage producers to fill soft drinks of three different volumes. The maximum availability of the machines' time allotted per day is hours and the supply of metal is limited to kg per day. The following table provides the details of the input needed to manufacture one batch of cans.
The manufacturer is interested in maximizing the total profit per day. The sensitivity report provided below was generated using the Excel Solver to determine the optimal solution to this problem. Using the sensitivity report, answer the following questions:
a Optimal production quantity of medium can per day:
b Optimal profit per day:
c Will the current optimal solution stay optimal if the unit profit of large can increases to Yes or No
d Will the current optimal solution stay optimal if the unit profit of small can decreases to Yes or No
e Will the current optimal solution stay optimal if we add a constraint that says production quantity of large can per day should be at least Yes or No
f Will the shadow price of the constraint related to the supply of metal remain valid if we increase the available supply to kg per day? Yes or No
g Calculate the effect on the total profit of decreasing the supply of metal to kg per day.
h Calculate the effect on the total profit of increasing the machine available time to hours per day.
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