Please include steps on how you solved the problem to better understand key concepts, thank you!

Walkthrough Problem: Emmert Vineyards produces the highest grade wine in all of the Midwest. Since grape yield varies per season, the Chief Financial Officer, Caroline, wants to estimate the total cost for this season's bottle yield. Unfortunately, their key competitor, Amato Winery, hacked and wiped out all of Emmert's data. Caroline is only left with a printed copy of the previous yields and total costs. Caroline wishes to estimate the total cost of production and expects this season will yield 1,200 bottles of wine. A Regression Analysis was completed, yielding the following results: SUMMARY OUTPUT