A company that assembles three types of electric motor: Model 1 , Model 2 and Model 3 and the demand for these models are 2800,1900, and 1000, respectively. Assembly involves two major steps: wiring the motor's armature (winding copper wire repeatedly around a solid iron core), which requires specially trained labor to accomplish properly; and then assembling the completed armature and other parts (field magnet, commutator, brushes, etc.) into a finished motor, which also requires specialized training. The company has just received an order that is too large to fill using only the company's own labor resources. Therefore, it must subcontract one of its competitors to fill the remaining portion of the order. The following table shows the basic setup of the problem. Our objective is to fulfill the order at the lowest possible total cost. The following table provides information regarding how much (labor hours per unit) time is required for each model in wiring and assembling: There are a total of 9,500 labor hours available for armature wiring and 4,900 labor hours available for parts assembly in the company. The following table gives the cost information (\$ per unit) regarding models from 1 to 3 with respect to make or buy options: Formulate an appropriate model and Solve the problem in Microsoft Excel solver