BUS 278 WEEK 2 HOME WORK Assignment I

BUS 278 WEEK 2 HOME WORK Assignment I

Question 1	Question 	TCO 3 Using the following information regarding actual sales for Paradise Pools, calculate the regression (trend) line:
 
Sales for Paradise Pools ($000s)
Month	First Year	Second Year
January	84	84
February	80	82
March	88	98
April	100	120
May	150	160
June	200	210
July	240	250
August	220	215
September	180	195
October	160	165
November	120	130
December	92	100


 	

 	


Question 2.	Question :	(TCO 3) Using the following information regarding actual sales for Sam- Ski Supplies, project sales for March of Year 3 using simple linear regression:
 
Sales for Sam- Ski Supplies ($000s)
Month	First Year	Second Year
January	380	400
February	340	360
March	320	330
April	280	290
May	265	270
June	230	235
July	220	230
August	200	205
September	210	220
October	250	270
November	400	450
December	450	502


 	Stu
 	Instructor Explanation:	
y = 283.64 + 1.67x
y = 283.64 + (1.67 x 27) = 328.61
Note: Regression line calculated using "Linear Regression" spreadsheet.



Question 3.	Question :	(TCO 3) Using the following information regarding actual sales for Seafood City, calculate the seasonal ratio for Saturday of Week 3:
Sales for Seafood City ($)
Day	Week 1	Week 2
Monday	1,700	1,800
Tuesday	1,900	2,000
Wednesday	2,100	2,100
Thursday	2,300	2,200
Friday	4,200	4,300
Saturday	4,400	4,600
Sunday	2,100	2,200


 	


Question 4.	Question :	(TCO 3) Using the following information regarding actual sales for Seafood City, calculate the seasonal forecast of sales for Friday of Week 3:
 
Sales for Seafood City ($)
Day	Week 1	Week 2
Monday	1,700	1,800
Tuesday	1,900	2,000
Wednesday	2,100	2,100
Thursday	2,300	2,200
Friday	4,200	4,300
Saturday	4,400	4,600
Sunday	2,100	2,200


 	
 		 	

 	



Question 5.	Question :	(TCO 3) The regression statistic that measures the “goodness of fit” in the regression is the: