The task in Excel
11 USD 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
Current freelance projects in the category System & Network Administration
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 22 hours 54 minutes back ∙ 14 proposals |
Fortinet configurationGood day! It is necessary to configure Fortinet FortiGate 40F-3G4G. Set up remote access to the PLC. Work experience. Thank you! System & Network Administration, Software & Server Configuration ∙ 2 days 2 hours back ∙ 5 proposals |
Migration of Windows Server 2016.Need a system administrator for the setup and migration of Windows Server 2016. Task: 1. Conduct an audit of the current Windows Server 2016. 2. Check server roles: RDP/RDS, users, access rights, network settings, firewall, backup. 3. Prepare a migration plan without data… System & Network Administration, Software & Server Configuration ∙ 4 days back ∙ 12 proposals |
Connection of professional book scanners in Odesa
Connect professional book scanners (2 units) in 2 locations in Odesa. Perform assembly according to the instructions, connection, and software setup including test scanning to a file from the program on the PC. System & Network Administration, Software & Server Configuration ∙ 4 days 1 hour back ∙ 2 proposals |
Connection of professional book scanners.
Connect professional book scanners (2 units) at 2 locations in Kyiv. Perform assembly according to the instructions, connection, and software setup including test scanning to a file from the program on the PC. System & Network Administration ∙ 5 days 16 hours back ∙ 1 proposal |
Poltava