The task in Excel

System & Network Administration — incorrectly specified categories?

11 USD

Project translated automatically. Log in or register, to view the original Task No. 1 Graphic method.The enterprise may produce two types of products P1, P2 (e.g., pants, clothes), from which the amount of waste remains c1, c2 (kg) respectively.Three machines are used for production: M1, M2, M3, which for profitable use must work at least b1, b2, b3 hours.The time of use of the Mi machine for production j is aij (for example, the M2 machine for production P1 is used a21 hours).1) Build a mathematical model of the task of minimizing waste; 2) to solve the task by a graphic method, to find the optimal production plan with minimum waste; 3) to check the solution of the task with the help of SOLVER; 4) calculate the quantity of products P1, P2 and excess machine time M1, M2, M3 with minimum waste; 5) To make conclusions.Task No. 1 Simpleks Method The company can produce n types of products P1, P2, ... Pn (e.g., pants, clothes, pants, etc.), from which the amount of waste is formed c1, c2, ..., cn (kg) respectively.For production, three machines are used: M1, M2, M3, which to ensure profitability of use must work at least b1, b2, b3 hours.The time of use of the Mi machine for production j is aij (for example, the M2 station for production P1 is used a21 hours).1) Create a mathematical model for the task of minimizing waste; 2) Write the first table of the Simplex; 3) solve the SOLVER task, find the optimal production plan and a minimum of waste 4) find the time of use of the machine for production; 5) To make conclusions.N = 4. a31 = 2 b1 = 390. a32 = 2 b2 = 710. a33 = 6 b3 = 210. a34 = 2 a11 = 5 c1 = 3 a12 = 7 c2 = 2 a13 = 4 c3 = 8 a14 = 2 c4 = 6 A21 = 3 A22 = 4 A23 = 8 A24 = 3 There will be 4 more tasks on Excel. The budget is clarified

Proposals 2