Question: this two pictures are one questionn There are two main types of Covid-19 vaccines that are approved in the US, the weakened-virus type and the
this two pictures are one questionn
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.) Write the linear program. Type the LP into the Excel and solve it using Excel Solver. Write down the optimal amounts of doses from each vaccine tvoe to be allocated to the oriority that the total last-mile delivery cost would be minimized? (Assume that a single dose is enough for a patient.) Write the linear program. 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.) Please answer the following as integers, and avoid any letter or comma in the answers Number of weakened virus vaccine doses allocated for the essential workers in hospitais: Number of weakened virus vaccine doses allocated for the elderly people in care facilities: Number of weakened virus vaccine doses allocated for the individuals with underlying conditions: Number of mRNA vaccine doses allocated for the essential workers in hospitals: Number of mRNA vaccine doses allocated for the elderly people in care facilities: Number of mRNA vaccine doses allocated for the individuals with underlying conditions

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
