Having difficulty understanding the calculations and how to answer through excel. Need a step-by-step tutorial on the problem.

Following instructions from the corporate offices, the controller's office in Brazil collected the following information for monthly operations from last year.

Month Cases Price Index Operating costs

1 231000 125 5699167

2 354000 121 5806666

3 232000 122 5849933

4 425000 124 5927645

5 349000 126 5939163

6 350000 118 6043392

7 409000 129 5918523

8 452000 136 6133896

9 368000 130 6126158

10 425000 136 6186653

11 413000 127 6208827

12 453000 130 6362283

These data are considered representative for both past and future operations in Brazil.

c-1.Using Excel, calculate the simple regression of operating costs on cases shipped and enter the regression coefficients.

c-2.Compute the estimation of operating costs assuming that 450,000 cases will be shipped next month by using the results of a simple regression of operating costs on cases shipped.

C- 1Using Excel, calculate the simple regression of operating costs on cases shipped and enter the regression coefficients.(Round "Intercept" to nearest whole dollar amount.Round the case coefficient to 5 decimal places.)

C-2 Compute the estimation of operating costs assuming that 450,000 cases will be shipped next month by using the results of a simple regression of operating costs on cases shipped.(Round variable costs per unit to 5 decimal places. Round the intercept and final answer to the nearest whole dollar amount.)