please show your work in Excel .

Baseball bats are manufactured at two different plants in Kentucky and Tennessee.

The Kentucky plant has weekly costs that can be expressed as a function of the total number of bats produced:

TCD(X)=X²-7*X+11

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

The Tennessee plants weekly production costs are given by

TCH(Y)=Y²-3Y+7

Where Y is the weekly production volume in thousands of units, and TCH(Y) is the cost in thousands of dollars.

The company would like to produce 17,000 bats per week at the lowest possible cost.

Formulate and solve the non-linear optimization model to determine the optimal number of bats to produce at each facility. (Even though you cannot produce a non-integer amount of bats, we will not enforce that in our model, i.e. your answer can be a non-integer amount of gloves.)

What is the Optimal Number of Bats (in thousands, 000s) at Kentucky and Tennessee ?

What is the Total Cost (in 000s of dollars, no dollar sign, for example if your answer was $20,500, report 20.5)?