$16\mathrm{.}8$ Excel Problem$*$

Acme Manufacturing currently employs $13$ people in its receiving department. Each receiving dock clerk earns $$50,000$ per year. Each employee can unload up to $200$ pallets of inventory per day. It currently receives on average $2450$ pallets per day.

Acme is considering two options to improve productivity of its receiving dock employees. Option $1($Automation$)$ involves investing $$200,000$ in automation equipment that would enable each employee to unload up to $350$ pallets of inventory per day. Option $2($RFID$)$ involves investing $$50,000$ in RFID equipment that would enable each employee to unload up to $275$ pallets per day.

For both options, Acme plans to keep total costs of the receiving function the same as they currently are by eliminating some yorkers. Four workers would be eliminated if Acme chooses option $1($automation$)$ and one worker would be eliminated if it chooses option $2($RFID$).$

Required