Question: Need Excel solution please. browse my computer 5 minutes, 44 seconds. Question Completion Status: QUESTION 18 5 po A company produces three products which must
Need Excel solution please.
browse my computer 5 minutes, 44 seconds. Question Completion Status: QUESTION 18 5 po A company produces three products which must be painted, assembled, and inspected. The machinery must be cleaned and adjusted before each batch is produced. They want to maximize their profits for the amount of operating time they have. The unit profit and setup cost per batch are: Product Profit per unit Setup cost per batch 9 500 2 10 600 3 12 650 The operation time per unit and total operating hours available are: Operating Time per Unit Operation Product 1 Product 2 Product 3 Operating Hours Available Paint 2 2 400 Assemble 2 3 2 600 Inspection 2 4 3 540 . Formulate the ILP for this problem. (submit separately) What is the maximum profit earned? How much of each product should be produced? How much is the total set up cost? (You need to answer the next question to answer this part of the problem) 1 Arial 3 (12pt) E- T- T T T F Paragraph DOO fx Mashups HTML CSS
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
