Please read the question carefully and solve it properly.

8. In ABC company, four different persons are to be assigned to three different jobs with the restriction that exactly one person is allowed for each job. The associated costs are as follows: Jobs Persons 1 2 3 A 60 80 50 B 50 30 60 70 90 40 D 80 50 70 Formulate a program for determining the job-person assignments that minimize the total cost spent making the 3 jobs. And then do the calculation using Excel solver