- Arts & Culture 5856
- Business & Economics 679
- Computers 309
- Dictionaries & Encyclopedias 81
- Education & Science 74784
- Abstracts 100
- Astrology 4
- Astronomy 1
- Biology 8
- Chemistry 1982
- Coursework 15184
- Culture 9
- Diplomas 414
- Drawings 817
- Ecology 5
- Economy 84
- English 75
- Ethics, Aesthetics 3
- For Education Students 17543
- Foreign Languages 11
- Geography 2
- Geology 1
- History 89
- Maps & Atlases 4
- Mathematics 13808
- Musical Literature 2
- Pedagogics 19
- Philosophy 23
- Physics 14735
- Political Science 5
- Practical Work 59
- Psychology 60
- Religion 4
- Russian and culture of speech 8
- School Textbooks 7
- Sexology 42
- Sociology 9
- Summaries, Cribs 87
- Test Answers 145
- Tests 8962
- Textbooks for Colleges and Universities 32
- Theses 7
- To Help Graduate Students 13
- To Help the Entrant 37
- Vetting 361
- Works 13
- Информатика 10
- Engineering 3059
- 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 |