Problem 2 (30 points) Cardinal Company to analyze operating data from the last ten months of the year to estimate the foxed and variable components of transportation costs. The activity base used by Cardinal Company is pross-ton miles" traveled, which is he total number of tons multiplied by the miles moved (more than you need to know!). March April May June July August September October November December Gross-Ton Miles 125,000 180,000 136,000 150,000 105,000 175,000 178,000 186,000 176,000 196,000 Trans portation Costs $2,100,000 2,095,800 1,950,000 2,050,000 1,950,000 2,050,000 2,620,400 3,100,600 3,001,000 3,536,600 Required: 1 Determine the variable and fixed-cost components of transportation costs as a function of Gross-Ton Miles using both the high-low method and using linear regression. For linear regression, using excel, prepare a scatter chart, have the trend line exactly intersect the Y-axis, and have the chart include the linear equation and R for the data set, as was shown in the lectures, homework, and quiz. 2. Compute the estimated total transportation costs if 166,000 gross tone miles are driven, using both the high-low method and linear regression Problem 2 (30 points) Cardinal Company to analyze operating data from the last ten months of the year to estimate the foxed and variable components of transportation costs. The activity base used by Cardinal Company is pross-ton miles" traveled, which is he total number of tons multiplied by the miles moved (more than you need to know!). March April May June July August September October November December Gross-Ton Miles 125,000 180,000 136,000 150,000 105,000 175,000 178,000 186,000 176,000 196,000 Trans portation Costs $2,100,000 2,095,800 1,950,000 2,050,000 1,950,000 2,050,000 2,620,400 3,100,600 3,001,000 3,536,600 Required: 1 Determine the variable and fixed-cost components of transportation costs as a function of Gross-Ton Miles using both the high-low method and using linear regression. For linear regression, using excel, prepare a scatter chart, have the trend line exactly intersect the Y-axis, and have the chart include the linear equation and R for the data set, as was shown in the lectures, homework, and quiz. 2. Compute the estimated total transportation costs if 166,000 gross tone miles are driven, using both the high-low method and linear regression