$6-33.$ White $6-33.$ White $6-33.$ White $6-33.$ White

$6-33.$ White & Becker Tools $($W&B$)$ requires $2,000$ electric motors next month for its product line of weed trimmers. Each motor is composed of three components: a coil, a shaft, and housing. W&B has the capability to produce these components or purchase them from an outside vendor. The costs of producing them and purchasing them are shown in the following table.

$\backslash$table$[[$Component$,$Production Cost per Unit,Purchase Cost per Unit$],[$Coil$,$$$2\mathrm{.}60,$$$3\mathrm{.}12$

Please USE and SOLVE this using excel, and excel solver. PLEASE INCLUDE SCREENSHOTS as these will help me learn the steps and inputs within the excel table. Show the screenshot of excel format and table with the formulas used. In addition PLEASE show screenshot of SOLVER so i know the values and imputs for which cells to put into it$.$ Thank you!! Please help!! INCLUDE SCREENSHOTS!!