Question: I ONLY NEED PART 3 please I HAVE THE REST Question 3) ( 25 points) Consider a machine in a manufacturing center that can process
I ONLY NEED PART 3 please
Question 3) ( 25 points) Consider a machine in a manufacturing center that can process multiple types of products. During a day, the machine is available for 8 hours. We have a set of potential items that can be processed on this machine and after the process, each item can be sold to a customer. Assume that we only can sell one copy of each item. Table below shows the processing times and the potential profit of each item. 1. Which items the manufacturer should select to process and sell to the customer in order to maximize his profit? Write a mathematical optimization model for this problem. Clearly define decision variables, objective function, and constraints for the optimization model. Use Excel to solve the optimization model. (Submit your Excel File) 2- How long (in minutes) the machine remains idle during a day? 3. What is the solution of the problem if we assume that we can sell multiple copies of each item? (Hint: this means, what happens if we consider integer values for decision variables instead of binary values when setting up the variable range constraints in Excel) How the objective function value changes if we consider this new assumption? Use excel to solve the problem with this new assumption. (Submit your Excel File) Part 3) Which item(s) should be selected if we can produce multiple copies of an item
I HAVE THE REST

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
