please use excel solver to solve this problem.

Candoit Inc, an aerospace parts manufacturing cornpary, investieates an upgrade plan according to which some of its old machines wil be replaced with company his emploved 3 utility workers and utilues 15 similar machines, exch beire operated by 6 direct workers. Each worker's hourly wage is 511.6 . Candou can dectease its manning level by reducing the number of its direct workers, which is possible thanks to the higher automation levels of the new advanced machinec. Currently, there are two models of autornatic machines avallable in the inarloet with the followirs soecifications: at $7.000 intt replaced br a new Buse or Premkim model machine, Note that the total mumber of ruchines remains constant: neseti integrt