Wyniki wyszukiwania - BazTech

Ograniczanie wyników

Znaleziono wyników: 2

Liczba wyników na stronie

Wyniki wyszukiwania

Wyszukiwano:
w słowach kluczowych: narzędzie Solver

Sortuj według:

Ogranicz wyniki do:

Management of the Size of the Supply Under the Conditions of Inflation

Ślaski Paweł

New Trends in Production Engineering

2019

Vol. 2, Iss. 2

279-288

The publication describes two ways of shopping, taking into account the CPI (Consumer Price Index) inflation rate. In the first case, changes in the sales price are made in a continuous manner in accordance with the inflation rate, and therefore it is better to make larger purchases. In the second case, it is better to carry out smaller purchases, because it is characterized by one-time adjustment of sales prices to the entire purchased a lot of goods. Both cases were verified based on the Solver tool, using non-linear, integer-based optimization. The final result was to determine the optimal purchase quantities with the minimum inventory costs.

Solver II alternatywą narzędzia Solver w Exelu

Drapella A., Górska M.

Zeszyty Naukowe Akademii Marynarki Wojennej

2012

R. 53 nr 1 (188)

57-71

Artykuł dotyczy zadania znalezienia maksimum globalnego otoczonego licznymi maksimami lokalnymi na drodze numerycznej. Przedstawiono wyniki nieudanych prób wykonania tego zadania za pomocą, skądinąd bardzo skutecznego, narzędzia, jakim jest wbudowany w Excela Solver. Przedstawiono algorytm narzędzia o nazwie Solver II oraz jego implementację w środowisku programistycznym VBA. Pokazano, że Solver II znakomicie radzi sobie z realizacją postawionego zadania.

This paper deals with the problem of finding a global maximum of the task function when this maximum is surrounded by several local maximums. A tool named Solver, offered in Excel spreadsheet, was employed to find the global maximum. Unfortunately, instead of finding the global maximum, Solver finds the local one that is nearest to the point from which it starts. The paper puts forward an alternative procedure that reliably finds the surrounded global maximum. This procedure randomly samples an area where all the maximums are located, investigates the shape of the task function and in consecutive iterations tightens the area around the global maximum. When this area becomes sufficiently small, coordinates of the center of the area are taken as approximate coordinates of unknown actual coordinates of the global maximum.