Please use excel solver

Heller Manufacturing has two production facilities that manufacture baseball gloves. Production costs at the two facilities differ because of varying labor rates, local prop- erty taxes, type of equipment, capacity, and so on. The Dayton plant has weekly costs that can be expressed as a function of the number of gloves produced:

TCD(X)5X2 2X15

where X is the weekly production volume in thousands of units, and TCD(X) is the cost

in thousands of dollars. The Hamilton plant's weekly production costs are given by

TCH(Y)5Y2 22Y13

where Y is the weekly production volume in thousands of units, and TCH(Y) is the cost in thousands of dollars. Heller Manufacturing would like to produce 8,000 gloves per week at the lowest possible cost.

1. Formulate a mathematical model that can be used to determine the optimal number

of gloves to produce each week at each facility.

2.Solve the optimization model to determine the optimal number of gloves to produce

at each facility.

Please use excel solver