Task in Excel
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 Accounting Services
MPSR management and financial report in Excel
67 USD
Help to understand the logic of the report, understand how the controls and formulas work, possibly assist with filling out from the accounting program. Accounting Services, Consulting ∙ 2 days back ∙ 13 proposals |
Бухгалтер для ТОВ (імпорт, ЗЕД, медичні вироби)
16 USD
Шукаємо бухгалтера на часткову зайнятість (аутсорс) для ТОВ на початковому етапі діяльності. Завдання:— податкова та фінансова звітність ТОВ — супровід ЗЕД операцій (імпорт з Китаю) — облік поворотної фінансової допомоги від засновника — консультації з ПДВ на медичні вироби… Accounting Services ∙ 2 days 21 hours back ∙ 3 proposals |
We are looking for a strong accountant/financial controller to build an accounting system for a clothing brand.
334 USD
We are looking for a strong accountant/financial controller to build an accounting system for a clothing brand. Main tasks: • Build the company's management accounting from scratch. • Set up the accounting for the movement of goods: warehouse → cutting → sewing → quality control… Accounting Services ∙ 4 days 4 hours back ∙ 8 proposals |
Accountant with experience in international taxation, Delaware LLC
111 USD
Looking for a accountant with experience in international taxation who can handle fully or partially: Bookkeeping for LLC (Stripe transactions, expenses, invoices) Delaware LLC (form 5472, franchise tax) CFC declaration in Ukraine Contract FOP → LLC OSS VAT declaration quarterly… Accounting Services, Legal Services ∙ 8 days 15 hours back ∙ 3 proposals |
Consultation on working with EDIN for the supplier Epicenter
17 USD
Consultation needed on working with the electronic document flow EDIN in collaboration with Epicenter We are a supplier of goods for the Epicenter network and work through the electronic document flow system EDIN. A consultation is needed from a specialist who has practical… Accounting Services, Project Management ∙ 8 days 22 hours back |
Poltava