Cost Management: A Strategic Emphasis 7th Edition by Edward Blocher,David Stout ,Paul Juras,Gary Cokins

Exercise 44

Time-Series; Regression Analysis Plantcity is a large nursery and retail store specializing in house and garden plants and supplies. Jean Raouth, the assistant manager, is in the process of budgeting monthly supplies expense for 2016. She assumes that in some way supplies expense is related to sales, either in units or in dollars. She has collected these data for sales and supplies expenses for June 2013 through December 2015 and has estimated sales for 2016:

Required
1. Develop the regression that Jean should use based on these data. Evaluate the reliability and precision of the regression you have chosen.
2. What are the predicted monthly figures for supplies expense for 2016