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.

Components	Production cost per unit	Purchase cost per unit
Coil	2.60 dollar	3.12 dollar
Shaft	1.80 dollar	2.16 dollar
Housing	1.40 dollar	1.68 dollar

The components that are produced by W&B must pass through three departments: fabrication, molding, and inspection. The number of hours each component requires in each department and the total number of hours available next month in each department are shown in the following table:

Department	Coil (HR.)	Shaft (HR.)	Housing (HR.)	Availability (HR)
Fabrication	0.5	0.2	0.6	3000
Molding	0.4	0.7	0.3	3000
Inspection	0.2	0.3	0.4	1800

In order to determine the number of components that will be produced and the number that will be purchased, W&B has set the following goals, in rank order:

Rank 1: The total costs to produce and purchase components next month should not exceed $14,000.

Rank 2: Idle time in the fabrication department should be minimized.

Rank 3: At least 200 coils should be purchased from the vendor next month.

Determine the number of components produced and purchased next month, according to these ranked goals.

Please explain and show in Excel and Solver