You are a regional logistics director for Federal Emergency Management Agency assigned to various states. Given the current COVID-19 situation, you need to ensure that your states obtain the required N95 masks that they need. Currently, there are five new plants from which you can purchase these masks. While they have far greater capacity than you need, you are only allotted a portion of these (assume everyone's portion is the same). The allotments are: Allotment (millions) Facility Smithfield, Island (3M/GM Partnership) Maplewood, Minnesota (3M/GM Partnership) Aberdeen, South Dakota (3M/GM Partnership) Eden Prairie, Minnesota (Stratasys) Warren, Michigan (3M/GM Partnership) 7.5 5.5 6 8.5 Also assume the following: it costs $0.01 per mile to transport 1 mask for simplicity, we will assume that the masks are being shipped to the state capital of each of your assigned states The demand has the following assumptions: assume that 20% of the population of your state will require hospitalization each hospitalization lasts for an average of 6 days each day a person is hospitalized, the hospital requires 4 masks Based on a minimum cost analysis, how many masks will you optimally ship to each of your states? You must include: an appropriate cost table (with supply and demand included) the mathematical model (defining variables, etc...) results and conclusions You should solve this in Excel or another solver, not by hand. Be sure to submit all your files. The assigned states, as well as their population and capital are shown below. Arizona Florida California Michigan Louisiana 7,278,717 21,477,737 39,512,223 9,986,857 4,648,794 Phoenix Tallahassee Sacramento Lansing Baton Rouge You are a regional logistics director for Federal Emergency Management Agency assigned to various states. Given the current COVID-19 situation, you need to ensure that your states obtain the required N95 masks that they need. Currently, there are five new plants from which you can purchase these masks. While they have far greater capacity than you need, you are only allotted a portion of these (assume everyone's portion is the same). The allotments are: Allotment (millions) Facility Smithfield, Island (3M/GM Partnership) Maplewood, Minnesota (3M/GM Partnership) Aberdeen, South Dakota (3M/GM Partnership) Eden Prairie, Minnesota (Stratasys) Warren, Michigan (3M/GM Partnership) 7.5 5.5 6 8.5 Also assume the following: it costs $0.01 per mile to transport 1 mask for simplicity, we will assume that the masks are being shipped to the state capital of each of your assigned states The demand has the following assumptions: assume that 20% of the population of your state will require hospitalization each hospitalization lasts for an average of 6 days each day a person is hospitalized, the hospital requires 4 masks Based on a minimum cost analysis, how many masks will you optimally ship to each of your states? You must include: an appropriate cost table (with supply and demand included) the mathematical model (defining variables, etc...) results and conclusions You should solve this in Excel or another solver, not by hand. Be sure to submit all your files. The assigned states, as well as their population and capital are shown below. Arizona Florida California Michigan Louisiana 7,278,717 21,477,737 39,512,223 9,986,857 4,648,794 Phoenix Tallahassee Sacramento Lansing Baton Rouge