Budgeting and Forecasting Question

Jul 14th, 2015
DotaCN
Category:
Business & Finance
Price: $10 USD

Question description

1. (TCO 3) Using the following information regarding actual sales for Seafood City, calculate the regression (trend) line:

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

(Points : 4)

  y = 2,092.31. + 81.98x

  y = 2,092.31 + 121.98x

  y = 1,892.31 + 81.98x

  y = 1,892.31 + 81.98x

Question 2.

2. (TCO 3) Using the following information regarding actual sales for Paradise Pools, project sales for May of Year 3 using simple linear regression:

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

(Points : 4)

  168.79

  174.52

  178.35

  180.26

Question 3.

3. (TCO 3) Using the following information regarding actual sales for Paradise Pools, calculate the seasonal ratio for June of Year 3:

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

(Points : 4)

  0.67

  0.77

  1.08

  1.41

Question 4.

4. (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

(Points : 4)

  2,822.29

  3,006.17

  4,300.00

  5,614.30

Question 5.

5. (TCO 3) The regression statistic that measures the accuracy of regression predictions is the: (Points : 4)

  correlation coefficient.

  coefficient of determination.

  standard error of the estimate.

  t-statistic.


Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Duke University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
kevin12622
Dec 5th, 2016
" Goes above and beyond expectations ! "
kiln82
Nov 26th, 2016
" awesome work thanks "
ashleyisgod
Nov 21st, 2016
" Top quality work from this guy! I'll be back! "
likeplum4
Nov 12th, 2016
" Excellent work as usual "
Molly_Moon
Oct 30th, 2016
" AMAZING as always! "
kpcutie
Oct 21st, 2016
" Excellent job "
Hemapathy
Oct 7th, 2016
" all I can say is wow very fast work, great work thanks "
pmallory
Sep 28th, 2016
" Totally impressed with results!! :-) "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1828 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors