Calculate the regression line and forecast sales


Assignment:

Use the table "Food and Beverage Sales for Paul's Pizzeria" to answer the questions below.

Food and Beverage Sales for Paul's Pizzeria Restaurant
($000s)

Month

First Year

Second Year

January
55
60

February
53
54

March
53
56

April
63
44

May
64
44

June
54
34

July
33
36

August
35
37

September
25
28

October
30
30

November
35
38

December
54
52

Part (a) Calculate the regression line and forecast sales for March of Year 3.

Part (b) Calculate the seasonal forecast of sales for March of Year 3.

Part (c) Which forecast do you think is most accurate and why?

Solution Preview :

Prepared by a verified Expert
Accounting Basics: Calculate the regression line and forecast sales
Reference No:- TGS01869755

Now Priced at $25 (50% Discount)

Recommended (93%)

Rated (4.5/5)