The following is data regarding the staffing costs for Brooklyn 99 Inc. for 2020: Month Staffing Hours Staffing Costs January 2,800 $16,300 February 2,550 15,800 March 2,900 16,800 April 2,760 16,100 May 2,840 16,250 June 2,320 14,300 July 1,840 12,100 August 1,640 11,260 September 2,900 16,700 October 3,400 18,900 November 3,280 18,500 December 2,960 17,850 Required:

a. Using Excel, make a scatter-graph of the data, with a linear trend line that includes the trendline and R2 . (2 marks) b. Run the regression analysis in Excel. Type the regression cost function equation on the spreadsheet with your regression statistics, and determine the utilities cost when 3,500 staffing hours are worked. Round your final answer to the closest dollar, but do not round your regression outputs (4 marks)

d. Using the high-low method, state the cost function for staffing costs. Using the cost function determined from the high-low method, estimate the staffing costs for a month in which 3,000 staffing hours are worked. Round your final answer to the closest dollar, but do not round before then. (3 marks)