An optimization model for the delivery of plants to nurseries

The purpose of the development is to present an option for reducing costs in the delivery of ornamental plants to nurseries. The nursery is located in the town of Parvomai and is located in the eastern part of the Plovdiv region, in the Thracian plain, at about 134 meters above sea level. Different varieties of flowers are produced in it - petunias, violets, verbena, tagetis, sakezets and other species. The nursery stocks and delivers goods to 5 small sites in the surrounding area To achieve the goal, the following tasks must be solved: to characterize the used vehicles; to optimize transport costs by solving a transport task under certain conditions. By using MS Excel Solver, proposed algorithm for describing a transport task and its subsequent solution, significantly speeds up the calculation procedures and helps to reduce costs when making deliveries.