In this research paper, a resource allocation system for a Saudi industry is designed. There is a limited supply of four types of equipment in the company's main warehouse, which is causing equipment utilization problems. There are 13 ongoing sites where the equipment is transported and used. Instead of using the available equipment, project managers rent these items. As a result, the company incurs an avoidable cost. For the selected Saudi industry, the problem is identified, objectives are established, constraints are also identified, and the data was collected from the company, filtered, and analyzed. Two alternative solutions have been developed for each type of equipment using transportation models, lowest cost method, and mathematical models. In addition to developing a complete resource allocation system, the testing, validation, cost analysis, and recommendations for the company were conducted. After the analysis, the optimum solution for resource allocation problem was found, where all the analysis was done using XLS sheet solution to trace the system for optimum solution. The XLS sheet solution was used to analyze the data and identify the best allocation of resources. The findings were then used to create a plan to implement the new resource allocation system. Finally, the new system was recommended for the company to be put into operation.