- Arts & Culture 5971
- Business & Economics 690
- Computers 317
- Dictionaries & Encyclopedias 82
- Education & Science 76572
- Abstracts 226
- Astrology 4
- Astronomy 1
- Biology 8
- Chemistry 2652
- Coursework 15846
- Culture 8
- Diplomas 411
- Drawings 576
- Ecology 6
- Economy 82
- English 78
- Ethics, Aesthetics 3
- For Education Students 17637
- Foreign Languages 11
- Geography 3
- Geology 1
- History 89
- Maps & Atlases 5
- Mathematics 13871
- Musical Literature 2
- Pedagogics 19
- Philosophy 23
- Physics 15074
- Political Science 5
- Practical Work 101
- Psychology 60
- Religion 4
- Russian and culture of speech 8
- School Textbooks 7
- Sexology 42
- Sociology 9
- Summaries, Cribs 87
- Test Answers 154
- Tests 8965
- Textbooks for Colleges and Universities 32
- Theses 24
- To Help Graduate Students 14
- To Help the Entrant 37
- Vetting 364
- Works 13
- Информатика 10
- Engineering 3062
- Fiction 695
- House, Family & Entertainment 106
- Law 133
- Website Promotion 71
Methods of Optimization computer workshop RFEI
Refunds: 1
Uploaded: 27.09.2015
Content: Поиск решения.rar 4,53 kB
Product description
Finding solutions
a computer workshop for the course "Methods of Optimization
solutions´ you need to perform control
Computer workshop on this discipline.
The control computer workshop presented
tasks that are implemented in a software product MS Excel.
Additional information
In the computer, the problem of the workshop
maximum profit. You need to implement the decision
this problem with the help of the add "Solver"
software package Excel, save it on the page of the book
Excel, named Objective 1.
Next, you need to change the condition of the job
(change plates value or the amount of resources or
Sizes costs) and run on the basis of decisions that have
you already have a solution to your problem. Your changes
You should be reflected in the table you built on
analogy with Table 1.
Table 1
Expenses
A batch of 100 boards
Available
resources for the month of improved conventional
Material (kg) 16 1600 8
Time
pressing
(clock)
4 6900
Time to finish
(clock)
4 4600
Facilities
(dollars)
30 50 6000
Task 2
In the computer, the problem of the workshop
minimize the cost of transportation.
Similarly, the first task you need to perform
solution to this problem with the help of add-ons "Solver"
software package Excel, save it on the page of the book
Excel, named Objective 3.
Next, you need to change the condition of the job
(cost of transport to consumers, or queries, or the amount of
stocks or stock) and run on the basis of the decision,
which you already have a solution to your problem. Your
changes should be reflected in your built
Table similar to Table 2.
Transportation costs
consumers (ten thousand. rub.
for 1 thousand. units)
Availability
(thous. units)
B1 B2 B3
Warehouses
A1
8 May 6120
A2
9 4 180 7
Query (thous. Units.) 70 140 90 300
Feedback
0Period | |||
1 month | 3 months | 12 months | |
0 | 0 | 0 | |
0 | 0 | 0 |