The University Logo Company needs to predict the labor cost in producing specialty coffee mugs. The following production information is available: Year Production Volume Labor Hours Labor Dollars 2006 2,550 1,700 $25,500 2007 3,400 1,950 $31,200 2008 2,400 1,600 $27,200 2009 4,600 2,000 $36,000 2010 3,200 1,900 $36,100 2011 2,800 1,775 $35,500 2012 2,650 1,725 $36,225 2013 2,700 1,755 $ TBA Wage rates have steadily increased since 2006; however, management expects no further increases in 2014. a. Select the most appropriate independent variable for estimating labor cost. Explain the reason for your selection. b. Use regression to develop an equation [cost formula] to predict the 2014 labor cost of producing specialty mugs. c. Create a scattergram of your results. d. Estimate labor needs if 2014 production is estimated at 3,200 units. e. What are some considerations that should be made before making a decision based on the results of your analysis? What would you suggest that management do in order to make the best decision