Question: Please help me out with this problem. This must be done using Excel and Solver , if you don't have Solver allow another person to
Please help me out with this problem. This must be done using Excel and Solver, if you don't have Solver allow another person to help out who does. Also, please show all the formulas you used so I can implement the same on my end. Thank you so much!! :)

Review the Integer Linear Program Problem outlined below and complete in Solver. Incline Electronics produces three different products in a plant that is open 40 hours per week. Each product requires the following processing times (in hours) on each of three machines. Product 1 Product 2 Product 3 Machine 1 2 2 Machine 2 3 4 6 Machine 3 4 6 5 Each machine must be run by one of 19 cross-trained workers who are each available 35 hours per week. The plant has 10 type-1 machines available, 6 type-2 machines available, and 8 type-3 machines available. Products 1, 2, and 3 contribute $90, $120, and $150, 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
Get step-by-step solutions from verified subject matter experts
