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?

Transcribed Image Text:

Date Supplies ExpenseSales Units Sales Dollars Jun 2013 Jul Aug Sep Oct Nov Dec $2,745 ,200 3,232 2,199 2,321 3,432 4,278 2,190 2,878 1,856 436 525 15 199 543 1,189 2,152 2,463 Jan 2014 Feb Mar Apr May Jun Jul 2,310 2,573 2,487 2,484 3,384 2,945 2,758 3,394 2,254 212 284 246 278 498 424 312 485 188 276 1,999 2,190 1,894 2,134 3,210 2,850 2,265 2,435 1,893 2,232 3,004 3,309 Sep Oct Nov Dec 3,245 4,576 1,045 Jan 2015 Feb Mar May Jun Jul Aug Sep Oct Nov Dec 2,103 2,056 3,874 2,784 2,345 2,912 2,093 2,873 2,563 2,384 2,476 3,364 104 167 298 398 187 334 264 2,195 2,045 2,301 2,345 1,815 2,094 1,934 2,054 1,977 1,857 2,189 3,433 143 245 232 1,122 $1,600 2,000 1,900 2,400 2,300 2,300 2,500 3,000 2,500 2,500 3,200 3,900 180 230 190 Jan 2016 (estimated) Feb Mar Apr May 350 350 Jul Aug Sep Wet Nov 550 300 300 450