Methods of Optimization computer workshop RFEI

Affiliates: 0,06 $ — how to earn
Pay with:
i agree with "Terms for Customers"
Sold: 3
Refunds: 1

Uploaded: 27.09.2015
Content: Поиск решения.rar (4,53 kB)

Description

Methods of Optimization computer workshop RFEI

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

0
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)