"Efficient and Versatile Methodology for Solving Solid Transportation Problem Using Excel Solver: A Comparative Study with LINGO Code"

Abstract

This research paper presents a novel and efficient methodology for solving the solid transportation problem (STP) using Excel Solver, a widely available and affordable software tool. The proposed approach offers versatility and rapid adjustment of constraints, making it suitable for solving multi-dimensional transportation problems. To validate the efficacy of the methodology, a numerical example is presented, illustrating the step-by-step process for finding the optimal solution. The numerical results, accompanied by figures and explanations, demonstrate the effectiveness of the proposed approach when compared to the results obtained using LINGO code.By utilizing Excel Solver, this paper provides a user-friendly and accessible tool for researchers and practitioners seeking to solve the solid transportation problem. The methodology explains in detail how to utilize Excel Solver and formulate the problem constraints. One of the advantages of Excel Solver is its ease of use and flexibility in modifying constraints or the objective function to accommodate changing problem parameters.The research results indicate successful solutions to the solid transportation problem using Excel Solver, with an optimal solution. The comparison with the results obtained from LINGO software confirms the effectiveness and accuracy of Excel Solver. Additionally, Excel Solver offers advantages such as providing the optimal solution directly without requiring initial solutions, as well as the availability of additional tools like macros or VBA to facilitate the solution process.