Question

In: Advanced Math

South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island. Although...

South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island. Although the firm has been in business only five years, revenue has increased from $308,000 in the first year of operation to $1,084,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars: (Answer 1-3

1.Below is a simple linear regression analysis for this forecasting problem. Is this a valid model to use to forecast quarterly revenue for South Shore? Why or why not? Explain completely.

2.Based on the model in question 1, what is the forecast for Quarter 1 of Year 6?

3.Is there a seasonal trend in this data? Find the appropriate seasonal factor for Quarter 1 of Year 6 and apply it to get a new forecast for revenue in that quarter. Does this provide a better model than the one used in questions 1 and 2? Why or why not? Provide support for your answer (not necessarily numerical data).

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.555256

R Square

0.30831

Adjusted R Square

0.269882

Standard Error

106.0593

Observations

20

ANOVA

df

SS

MS

F

Significance F

Regression

1

90249.64

90250

8.02321

0.0110388

Residual

18

202474.4

11249

Total

19

292724

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

37.67895

49.26788

0.7648

0.45431

-65.829032

141.187

-65.829032

141.1869

X Variable 1

11.64962

4.112803

2.8325

0.01104

3.0089449

20.2903

3.00894485

20.2903

Solutions

Expert Solution


Related Solutions

South Shore Construction builds permanent docks and seawalls along the southern shore of long island, new...
South Shore Construction builds permanent docks and seawalls along the southern shore of long island, new york. Although the firm has been in business for only five years, revenue has increased from $308,000 in the first year of operation to $1,144,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars: Quarter Year 1 Year 2 Year 3 Year 4 Year 5 1 20 47 75 92 191 2 100 146 155 202...
South Shore Construction builds permanent docks and seawalls along the southern shore of long island, new...
South Shore Construction builds permanent docks and seawalls along the southern shore of long island, new york. Although the firm has been in business for only five years, revenue has increased from $320,000 in the first year of operation to $1,188,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars: Quarter Year 1 Year 2 Year 3 Year 4 Year 5 1 23 38 83 97 202 2 103 137 163 207...
South Shore Construction builds permanent docks and seawalls along the southern shore of long island, new...
South Shore Construction builds permanent docks and seawalls along the southern shore of long island, new york. Although the firm has been in business for only five years, revenue has increased from $308,000 in the first year of operation to $1,084,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars: Quarter Year 1 Year 2 Year 3 Year 4 Year 5 1 20 47 95 92 176 2 100 146 175 202...
South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New...
South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. Although the firm has been in business only five years, revenue has increased from $315,000 in the first year of operation to $1,075,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars. Quarter Year 1 Year 2 Year 3 Year 4 Year 5 1 24 40 80 92 163 2 97 144 154 197 292...
South Shore Construction builds permanent docks and seawalls along the southern shore of long island, new...
South Shore Construction builds permanent docks and seawalls along the southern shore of long island, new york. Although the firm has been in business for only five years, revenue has increased from $320,000 in the first year of operation to $1,116,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars: Quarter Year 1 Year 2 Year 3 Year 4 Year 5 1 23 59 76 92 184 2 103 158 156 202...
South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New...
South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. The following data show quarterly sales revenues (in $’000s) for the past 5 years. Quarter Year 1 Year 2 Year 3 Year 4 Year 5 1 20 37 75 92 176 2 100 136 155 202 282 3 175 245 326 384 445 4 13 26 48 82 181 Question 4 Now make adjustments for trend and seasonality. Quantify the trend in the...
Problem 15-28 (Algorithmic) South Shore Construction builds permanent docks and seawalls along the southern shore of...
Problem 15-28 (Algorithmic) South Shore Construction builds permanent docks and seawalls along the southern shore of long island, new york. Although the firm has been in business for only five years, revenue has increased from $320,000 in the first year of operation to $1,188,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars: Quarter Year 1 Year 2 Year 3 Year 4 Year 5 1 23 38 83 97 202 2 103...
Kevin Shirley, CEO of Shirley Construction builds condos in a booming retirement community in Florida. Although...
Kevin Shirley, CEO of Shirley Construction builds condos in a booming retirement community in Florida. Although sales have slowed because of a national recession, it now looks as if the recession is about to end. Mr. Shirley wants to be ready with material, labor, and foremen to meet the demand for condos. Last year, Kevin built and sold 30 condos. With the recent recession ending, Mr. Shirley thinks that his sales will increase to 40 units for the current year....
Section 03: Inventory South City is a construction company which builds houses, offices and hotels. Materials...
Section 03: Inventory South City is a construction company which builds houses, offices and hotels. Materials (cement, bricks, etc…) are purchased from a large number of suppliers. As a member of the audit team, you are required to attend the inventory count of South City. On the day of the inventory count, you attended the warehouse premises of South City and observed the following activities:  Pre-numbered count sheets were being issued to the client's staff carrying out the count....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT