This paper presents an optimization strategy based on mathematical programming to solve resource management problems regarding hospitalization of sick patients, considering emergency scenarios, such as those that can occur in a pandemic. This optimization strategy is based on the use of efficient optimization tools in solving complex problems in which other strategies are not efficient. The mathematical modeling of epidemiological phenomena is a very useful tool to predict the direction of a disease, as well as to adequately and timely manage the available resources and thus save as many lives as possible. This work uses a mathematical model formulation based on deterministic optimization developed in general algebraic modelling system (GAMS) environment. The main user interface has been developed in a MicrosoftTM (MS) Excel worksheet, which is familiar to many users. The linking code to send values from MS Excel to GAMS has been programmed in visual basic for applications (VBA) and it uses GAMS data exchange (GDX) files. The proposed optimization methodology is applied to case studies based on data obtained from affected people by severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2), which is the virus that causes coronavirus disease 2019 (COVID-19). The distances were taken as example from severely affected cities in USA. The obtained results offer attractive alternatives for the specified objective function in an acceptable computation time.