Service providers face daily problems while looking for opportunities to improve their activities and impacts on customers. Depending on how operations are carried out, it limits or enables supply chain operations at the echelon it belongs. The work focuses on addressing a current and specific problem that a company faces by incorporating a new client to provide fastening components under the full-service provider model, where it seeks to find the optimal assignment of the orders (pallets) to the operators in charge of receiving and delivering materials with different mixtures and quantities of products in each shift in facilities of the end customer to supply an assembly line. The application of modeling and optimization techniques with Solver in MS Excel is designed to build a minimization model that determines the proportional and equitable allocation of distances that operators must travel from the landing door to each utilization point or temporary storage, guaranteeing the delivery of all the pallets received. This framework modeling is implemented in a template that facilitates the decision-making process, later ensures the transfer of the tool to the company, and finally, is incorporated into its daily operation.