- Arts & Culture 5937
- Business & Economics 689
- Computers 310
- Dictionaries & Encyclopedias 81
- Education & Science 75850
- Abstracts 252
- Astrology 4
- Astronomy 1
- Biology 8
- Chemistry 2221
- Coursework 15546
- Culture 9
- Diplomas 411
- Drawings 574
- Ecology 5
- Economy 83
- English 75
- Ethics, Aesthetics 3
- For Education Students 17607
- Foreign Languages 11
- Geography 2
- Geology 1
- History 89
- Maps & Atlases 5
- Mathematics 13855
- Musical Literature 2
- Pedagogics 19
- Philosophy 23
- Physics 14834
- 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 150
- Tests 9243
- Textbooks for Colleges and Universities 32
- Theses 24
- To Help Graduate Students 14
- To Help the Entrant 37
- Vetting 364
- Works 13
- Информатика 10
- Engineering 3058
- Fiction 696
- House, Family & Entertainment 107
- Law 132
- 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 |