Question: Review the Integer Linear Program Problem outlined below and complete in Solver. Incline Electronics produces three different products in a plant that is open 4
Review the Integer Linear Program Problem outlined below and complete in Solver.
Incline Electronics produces three different products in a plant that is open hours per week. Each product requires the following processing times in hours on each of three machines.
Product
Product
Product
Machine
Machine
Machine
Each machine must be run by one of crosstrained workers who are each available hours per week. The plant has type machines available, type machines available, and type machines available. Products and contribute $ $ and $ respectively, in marginal profit per unit produced.
A Formulate mathematical integer linear problem
B Implement the model in a separate Excel tab and solve it
C What is the integer optimal solution? How many workers should be assigned to each type of machine, and how many products should we produce?
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
