I need the solution on excel please

An electronics firm produces electronic components, which it supplies to various electrical manufacturers. Quality control records indicate that different employees produce different numbers of defective items. The average number of defects produced by each employee for each of six components is given in the following table: A E Employee 1 2 3 30 22 18 14 25 32 Component B C D 24 16 26 28 14 30 16 25 14 22 18 23 18 14 16 14 10 14 30 20 12 21 16 18 F 22 13 22 30 28 20 Using Excel solver, determine the optimal assignment that will minimize the total average number of defects produced by the firm per month