Due on March 2nd 2021 Q3) There are two main types of Covid-19 vaccines that are approved in the US; the weakened-virus type and the mRNA type. Each vaccine type requires different storage and handling features. Therefore, the cost of last-mile delivery varies for each vaccine type. Texas state is recently delivered 3 million doses of the weakened-virus vaccine and 5 million doses of the mRNA vaccine. The state is asked to give shots to the priority group which consists of three subgroups; the essential workers in hospitals, elderly people in long-term care facilities, and individuals with underlying medical conditions. The state estimated that there are at least 1.5 million essential workers, 4 million elderly people, and 2.5 million people with underlying conditions who are considered in the priority group in Texas. Average last-mile delivery cost of a single dose of each vaccine type are estimated for three subgroups as the following. Essential workers in Elderly people in Individuals with hospitals care facilities underlying conditions Weakened-virus $10/dose $12/dose $15/dose mRNA $12/dose $18/dose $20/dose How many doses of each vaccine type should be allocated to each priority subgroup, so that the total last-mile delivery cost would be minimized? (Assume that a single dose is enough for a patient.) a) List the decision variables. b) Write out the objective function. c) Write out the constraints. d) Write the linear program. e) Type the LP into the Excel and solve it using Excel Solver. Write down the optimal amounts of doses from each vaccine type to be allocated to the priority subgroups. (Example of a correct format; 2300000. Please avoid commas or letters in your answers.) Due on March 2nd 2021 Q3) There are two main types of Covid-19 vaccines that are approved in the US; the weakened-virus type and the mRNA type. Each vaccine type requires different storage and handling features. Therefore, the cost of last-mile delivery varies for each vaccine type. Texas state is recently delivered 3 million doses of the weakened-virus vaccine and 5 million doses of the mRNA vaccine. The state is asked to give shots to the priority group which consists of three subgroups; the essential workers in hospitals, elderly people in long-term care facilities, and individuals with underlying medical conditions. The state estimated that there are at least 1.5 million essential workers, 4 million elderly people, and 2.5 million people with underlying conditions who are considered in the priority group in Texas. Average last-mile delivery cost of a single dose of each vaccine type are estimated for three subgroups as the following. Essential workers in Elderly people in Individuals with hospitals care facilities underlying conditions Weakened-virus $10/dose $12/dose $15/dose mRNA $12/dose $18/dose $20/dose How many doses of each vaccine type should be allocated to each priority subgroup, so that the total last-mile delivery cost would be minimized? (Assume that a single dose is enough for a patient.) a) List the decision variables. b) Write out the objective function. c) Write out the constraints. d) Write the linear program. e) Type the LP into the Excel and solve it using Excel Solver. Write down the optimal amounts of doses from each vaccine type to be allocated to the priority subgroups. (Example of a correct format; 2300000. Please avoid commas or letters in your answers.)
