Instructions:

- For each problem, please come up with a LP formulation (decision variables, objective function, and constraints) with clearly defined decision variables, an objective function, and constraints.

- Solve each problem by Excel. Make sure to pay attention on the problem representation and layout. You also need to follow the color scheme of this class (data-green, decision variable-blue, objective function-red, formula-black).

Question:

The Aviston Electronics company manufactures motors for toys and small appliances. The marketing department is predicting sales of 6,100 units of the Dynamonster motor in the next quarter. This is a new high and meeting this demand will test Avistons production capacities. A Dynamonster is assembled from three components: a shaft, base, and cage. It is clear that some of these components will have to be purchased from outside suppliers because of limited in-house capacity. The variable in-house production cost per unit is compared with the outside purchase cost in the table below:

Component	Outside Cost	Inside Cost
Shaft	1.21	0.81
Base	2.50	2.30
Cage	1.95	1.45

Avistons plant consists of three departments. The time requirements in hours of each component in each department if manufactured in-house are summarized in the following table. The hours available for Dynamonster production are listed in the last row.

Component	Cutting Department	Shaping Department	Fabrication Department
Shaft	0.04	0.06	0.04
Base	0.08	0.02	0.05
Cage	0.07	0.09	0.06
Capacity	820	820	820

Formulate the problem as a linear program to find out the minimum cost production plan (you need to be more specific in your formulation) for Aviston.