AUTOMATIC SOLUTION OF TRANSPORT PROBLEMS USING A NEW ADD-IN TO EXCEL

Author(s):  
Simona Filipova-Petrakieva ◽  
Ivan Stankov

Transport problem is a basic problem arising in transportation the products from several distributors to several clients. The solution of this problem consists of determining optimal transportation according to needed allocations the products. In fact, this problem describes with linear programming model which in general solves with simplex method. The algorithm of this method is a build-in tool for Excel – SOLVER. Unfortunately when it has the large amount of input data the filling of the Excel’s tables is a very difficult process. Thus, in this paper is suggested an add-in which visualize and make easier inputting the initial data. It is based on the Visual Studio tools for development the add-ins for MS Office. The main advantage of this solution consists of a user-friendly interface of the mathematical model of the problem which significantly makes easily and good visualization the input data and final solution in tables. As an illustrative example, the proposed add-in is applied for solving the real problem connected with transportation the products of pharmacy company.

2019 ◽  
Vol 10 (1) ◽  
pp. 1-9 ◽  
Author(s):  
Daniel Varecha ◽  
Robert Kohar ◽  
Frantisek Brumercik

Abstract The article is focused on braking simulation of automated guided vehicle (AGV). The brake system is used with a disc brake and with hydraulic control. In the first step, the formula necessary for braking force at the start of braking is derived. The stopping distance is 1.5 meters. Subsequently, a mathematical model of braking is created into which the formula of the necessary braking force is applied. The mathematical model represents a motion equation that is solved in the software Matlab by an approximation method. Next a simulation is created using Matlab software and the data of simulation are displayed in the graph. The transport speed of the vehicle is 1 〖m.s〗^(-1) and the weight of the vehicle is 6000 kg including load. The aim of this article is to determine the braking time of the device depending from the input data entered, which represent the initial conditions of the braking process.


Author(s):  
Rajeev Sapre ◽  
Muktai Desai ◽  
Mugdha Pokharanakar

The mathematical model presented here aims to enhance the precision in diagnostic process of diabetes, anaemia and hypertension by means of fuzzy interface. In real life, the imprecise nature of medical documentation and uncertain information provided by patients often do not give the desired degree of confidence to the diagnosis. To that end using the capability of fuzzy logic in representing, interpreting and utilizing data and information that are vague and lack certainty, a new algorithm based on different fuzzy matrices and fuzzy relations is developed. In the process a medical knowledge base is developed with the help of 51 doctors. The model achieved 94.44% accuracy in the diagnosis, which shows its usefulness. To implement this model-based diagnosis procedure a user-friendly Excel program is designed.  


Author(s):  
Mi Cho Cho ◽  
Khaing Khaing Win ◽  
Htay Htay Win

The purpose of this paper is to show how linear programming model can help to design dietary plan in developing brain functions for the children undertaken by dietician in health care. For the development of the whole body and mental development, child nutrition is very important. In this paper, the constraints of problem, specified objective, structured mathematical model are detailed. The required data are sought and systematic review was done by searching engine with words like nutrition, food, diet, etc. In this paper, food items such as fish, egg, tomato, orange, peanut and oats corresponding to the nutrients are considered and calculated. Excel Solver is used to solve the LP model. From these results, the children can achieve by following the dietary plan.


2017 ◽  
Vol 23 (1) ◽  
pp. 15-20
Author(s):  
Alexandru Baboș ◽  
Alina-Mihaela Baboș

Abstract The transport problem finds its application in situations where the upper echelons must draw up an optimal plan of resources allocation for combat capabilities on objectives. In order to achieve more reliable results for the real problem, the data needed to formulate the mathematical model are extracted from an order of operations. This paper presents the optimization of military action, showing how to solve a practical problem using the transportation problem.


2021 ◽  
Author(s):  
Gercek Budak ◽  
Xin Chen

Abstract The American economy has shifted toward services since the 1980s. The service industry is an important part of economy and is growing quickly in the last three decades. It is more human-capital intensive than the manufacturing sector and there is a shortage of highly-skilled workforce. One solution to this problem is to improve the efficiency through optimization. Because demand in the service industry changes constantly, it is a great challenge to determine the number of employees and their tasks to improve customer service while reducing cost. This article develops a multi-objective mixed-integer linear programming model to dynamically assign employees to different workstations in real time. A case study of the model is solved in less than one second and its pareto optimal solutions determine the number of employees who are assigned to each workstation and the expected customer service times. The mathematical model is robust and provides optimal employee assignment and service rates for workstations in many situations.


2012 ◽  
Vol 548 ◽  
pp. 767-771 ◽  
Author(s):  
C. Vanlisuta ◽  
Suksan Prombanpong

The objective of this paper is to determine the number and species of trees to be planted in order to maximize a profit through an integer linear programming model. The mathematical model is developed in terms of the profit function. This objective function is therefore, a difference between carbon credit revenue and costs of plantation. The economical plants are only considered in the model. Consequently, fourteen different tree species are to be investigated. The objective function is subjected to several constraints i.e. planting area, carbon sequestration and so on. The planting envelope of each tree is assigned 4 by 4 meters. In this paper, the Eastern part of Thailand is considered the case study. It is found that three kinds of plants, Copper pod, Cananga, and Bullet wood are suitable for planting. A number of trees to be planted in 1600 square meter are twenty, thirty, and fifty plants respectively. The profit earned is of 12,112 $ per year in the next fifth year.


2008 ◽  
Vol 54 (No. 11) ◽  
pp. 546-552
Author(s):  
H. Brožová ◽  
T. Šubrt ◽  
J. Bartoška

The possibility of knowledge maps use in the decision-making process in agriculture and rural development is discussed in this paper. Each knowledge map presents a visualization of knowledge using different tools, where a mathematical model can be applied as one of them. The hierarchical structure of a knowledge map conforms to the general structure of a mathematical model. The mathematical model, when successfully solved and correctly read, is a knowledge map in itself. The parallels exist also between the creation process of a mathematical model and of a knowledge map. In general, every phase of a system approach can lead to a special knowledge map. The following paper explains this process and demonstrates it on the farm production structure optimisation problem solved by using a linear programming model.


Author(s):  
U. DINESH KUMAR ◽  
DAVID NOWICKI ◽  
JOSÉ E. RAMÍREZ-MÁRQUEZ ◽  
DINESH VERMA

Reliability, Maintainability and Supportability (R, M and S) are the main drivers of the system operational effectiveness (SOE). New procurement strategies have been developed by both public and private sectors to focus on the R, M and S characteristics inherent to the design of a system. One such strategy known as Performance Based Logistics (PBL) has gained popularity due to its success in improving the operational effectiveness of the system. In a PBL contract the customer buys performance, typically measured using R, M and S metrics, instead of contracting for a specified collection of resources defining the underlying support infrastructure. In this paper we have developed a mathematical model, using Goal Programming to optimize multiple performance measures of a design. We show how the best design is chosen from competing design alternatives when systems engineering principles are considered in defining the evaluation measures. The proposed mathematical model simultaneously considers multiple system engineering metrics during the design stage of the product development. The engineering metrics considered are a representation of the system's operational availability, reliability, maintainability, supportability and total cost of ownership. The Goal Programming model developed in the paper can be easily solved using software such as LINDO, LINGO and Excel Solver.


1999 ◽  
Vol 30 (2) ◽  
pp. 109-128 ◽  
Author(s):  
A. Ziverts ◽  
I. Jauja

The mathematical model METQ98 for runoff simulation is described. The METQ98 is developed from the model METUL (Krams and Ziverts 1993). Input data for the model are daily mean values of air temperature, precipitation and vapour pressure deficit. The spatial variability of surface processes is represented by dividing the river basin into hydrological response units (HRUs) depending on the land cover. The analysis of the model parameters is based on hydrological and meteorological data of the Vienziemite Brook basin. Also the influence of drainage on the model parameters is analysed. The results of application of the model to the Daugava River basin are presented.


2020 ◽  
Author(s):  
László Hajdu ◽  
Attila Tóth ◽  
Miklós Krész

In the last years personnel cost became a huge factor in the financial management of many companies and institutions.The firms are obligated to employ their workers in accordance with the law prescribing labour rules. The companies can save costs with minimizing the differences between the real and the expected worktimes. Crew rostering is assigning the workers to the previously determined shifts, which has been widely studied in the literature. In this paper, a mathematical model of the problem is presented and a two-phase graph coloring method for the crew rostering problem is introduced. Our method has been tested on artificially generated and real life input data. The results of the new algorithm have been compared to the solutions of the integer programming model for moderate-sized problems instances.


Sign in / Sign up

Export Citation Format

Share Document