use excel solver to solve the problem

The Red Cross is planning for the blood distribution for seven patients who need transfusions. There are four blood types: A, B, AB and 0. Type AB is called the universal recipient (they can receive blood of any types). Type O is called the universal donor (all blood types can receive type O blood). The blood supply and patient data are as follows: Patient Type Supply (in pints) Cost per pint A 7 $1 Blood type Need (in pints) 1 A 2 AB 6 $2 2 AB 3 B 4 $4 3 . 1 O 5 $5 4 0 2 5 A 3 6 B 2 7 AB 1 As the planning manager, your job is to ensure that each patient receives the required amount of the proper type of blood and to use the existing supply so that the cost can be minimized. Do the following in your report: 1. Formulate an appropriate LP for the above problem, carefully stating the meaning of your variables and their units, the objective function and the constraints