The sale of this product is suspended.
The seller is blocked and sales of the product are suspended
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.
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.
Main features
- Content type File
- Content description 4,53 kB
- Added to the site 27.09.2015
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
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
Reviews
No reviews yet
The sale of this product is suspended.
Плэйселлер
Blocked
Плэйселлер
Blocked