TY  - GEN
AB  - The COVID-19 pandemic has had a profound impact on supply chains across multiple 
industries, including the automotive sector. It has exposed notable challenges, such as navigating 
through unexpected delays, sourcing necessary supplies, and facing shortages of both raw 
materials and workforce. These challenges have had a direct and disruptive impact on production 
lines, creating obstacles that hinder the smooth flow of operations and pose significant 
challenges to maintaining productivity. Unfortunately, professionals have often been left to rely 
on intuition rather than data-driven analysis when making crucial decisions in these situations. 

To address these issues a customizable Excel based program has been created 
for optimizing decision making. The mathematical model was developed using Excel to harness 
data-driven analysis offering valuable insights and recommendations. The model will evaluate 
and weigh various alternatives, such as bringing in alternative equipment, sourcing parts from 
local suppliers, or allocating additional personnel. By utilizing this model, companies will be 
empowered to make informed decisions based on objective analysis rather than relying solely on 
gut instincts.
AD  - University of Southern Indiana
AU  - Martinez, Dennis Lopez
DA  - 2024-04-26
ID  - 1491790
KW  - Engineering
L1  - https://library.usi.edu/record/1491790/files/FFFinal%20senior%20report%20Dennis.pdf
L2  - https://library.usi.edu/record/1491790/files/FFFinal%20senior%20report%20Dennis.pdf
L4  - https://library.usi.edu/record/1491790/files/FFFinal%20senior%20report%20Dennis.pdf
LA  - eng
LK  - https://library.usi.edu/record/1491790/files/FFFinal%20senior%20report%20Dennis.pdf
N2  - The COVID-19 pandemic has had a profound impact on supply chains across multiple 
industries, including the automotive sector. It has exposed notable challenges, such as navigating 
through unexpected delays, sourcing necessary supplies, and facing shortages of both raw 
materials and workforce. These challenges have had a direct and disruptive impact on production 
lines, creating obstacles that hinder the smooth flow of operations and pose significant 
challenges to maintaining productivity. Unfortunately, professionals have often been left to rely 
on intuition rather than data-driven analysis when making crucial decisions in these situations. 

To address these issues a customizable Excel based program has been created 
for optimizing decision making. The mathematical model was developed using Excel to harness 
data-driven analysis offering valuable insights and recommendations. The model will evaluate 
and weigh various alternatives, such as bringing in alternative equipment, sourcing parts from 
local suppliers, or allocating additional personnel. By utilizing this model, companies will be 
empowered to make informed decisions based on objective analysis rather than relying solely on 
gut instincts.
PY  - 2024-04-26
T1  - Data Driven Decision Making through Mathematical Modeling
TI  - Data Driven Decision Making through Mathematical Modeling
UR  - https://library.usi.edu/record/1491790/files/FFFinal%20senior%20report%20Dennis.pdf
Y1  - 2024-04-26
ER  -