part A. please show linear program

part B. please show screenshots of excel

part C. please show final answer

A plant manager for a sporting goods manufacturer is in charge of assigning the manufacture of four new aluminum products to four different departments. Because of varying expertise and workloads, the different departments can produce the new products at various rates. If only one product is to be produced by each department and the daily output rates are given in the table below, which department should manufacture which product to maximize total daily product output? (Note: Department 3 does not have facilities to produce tennis rackets.) Department 1 2. 3 4 Baseball Bats 90 120 70 85 Tennis Rackets 60 80 X 50 Golf Clubs 120 140 150 100 Racquetball Rackets 80 100 90 75 a Formulate this assignment problem as a linear program. (4 points) b. Solve using excel Solver (4 points) Provide an answer in management language. (2 points) A plant manager for a sporting goods manufacturer is in charge of assigning the manufacture of four new aluminum products to four different departments. Because of varying expertise and workloads, the different departments can produce the new products at various rates. If only one product is to be produced by each department and the daily output rates are given in the table below, which department should manufacture which product to maximize total daily product output? (Note: Department 3 does not have facilities to produce tennis rackets.) Department 1 2. 3 4 Baseball Bats 90 120 70 85 Tennis Rackets 60 80 X 50 Golf Clubs 120 140 150 100 Racquetball Rackets 80 100 90 75 a Formulate this assignment problem as a linear program. (4 points) b. Solve using excel Solver (4 points) Provide an answer in management language. (2 points)