Least Squares Regression Analysis Bogota Corporation has gathered data on its overhead activites and associated costs for the past 12 months. Josh Hopper, from the accounting department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is the purchasing department (receiving and reviewing purchase recquisitions, issuing purchase orders, and managing vendor relationships), which he believes is driven by the number of purchase orders issued. Twelve months of data have been gathered for the purchasing activity and are as follows: Month 1 Purchase Orders Issued 1,050 750 1,550 1,250 2 3 4 Purchasing Cost $23,738 16,788 35,113 27,263 27,463 27,988 34,388 29,213 38,663 5 6 7 8 1,350 1,150 1,650 1,450 1,750 950 1,250 1,500 9 10 21,938 11 25,688 34,200 12 a. Run a regression using Excel or a similar computer spreadsheet program. Provide the intercept, slope, and R2 for the regression. Round Intercept and Slope to two decimal places. Round R to three decimal places. Intercept $ 0 a. Run a regression using Excel or a similar computer spreadsheet program. Provide the intercept, slope, and R2 for the regression. Round Intercept and Slope to two decimal places. Round R2 to three decimal places. Intercept $ 0 Slope $ 0. R2 0 b. Using the results from requirement a, prepare a cost formula for the purchasing activity. Total cost = $ 0 + ($ 0 x #purchase orders issued) c. Using the formula from requirement b, what is the predicted cost of purchasing for a month in which 1,375 purchase orders are issued? (Note: Round your answer to the nearest dollar.) $ 0