Question

In: Statistics and Probability

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 297
3 175 255 326 384 460
4 13 36 48 82 196
  1. Use Excel Solver to find the coefficients of a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. Round your answers to two decimal places.

    Ft =  + Qtr1 + Qtr2 + Qtr3
  2. Let Period = 1 to refer to the observation in Quarter 1 of year 1; Period = 2 to refer to the observation in Quarter 2 of year 1; . . . and Period = 20 to refer to the observation in Quarter 4 of year 5. Using the dummy variables defined in part (b) and Period, develop an equation to account for seasonal effects and any linear trend in the time series using Excel Solver. Round your answers to two decimal places. If your answer is negative value enter minus sign.

    Ft =  + Qtr1 + Qtr2 + Qtr3 + Period

    Based upon the seasonal effects in the data and linear trend, compute estimates of quarterly sales for year 6. Round your answers to one decimal place.

    Quarter 1 forecast =  

    Quarter 2 forecast =  

    Quarter 3 forecast =  

    Quarter 4 forecast =

Solutions

Expert Solution

orchestra answered 2 years ago
Next > < Previous

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 $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...
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....
Go Party Ltd (GPL) is a successful New Zealand catering company, operating in South Island. It...
Go Party Ltd (GPL) is a successful New Zealand catering company, operating in South Island. It has a balance date of 30 June. During the preparation of the 30 June 2020 financial statements, the following two issues have come into the light. The details of these issues are as follows: (a) After a wedding party held by a customer in January 2020, 60 people became seriously ill, possibly as a result of food poisoning from food served by GPL. Legal...
Go Party Ltd (GPL) is a successful New Zealand catering company, operating in South Island. It...
Go Party Ltd (GPL) is a successful New Zealand catering company, operating in South Island. It has a balance date of 30 June. During the preparation of the 30 June 2020 financial statements, the following two issues have come into the light. The details of these issues are as follows: (a)   After a wedding party held by a customer in January 2020, 60 people became seriously ill, possibly as a result of food poisoning from food served by GPL. Legal...
The port of South Louisiana, located along 54 miles of the Mississippi River between New Orleans...
The port of South Louisiana, located along 54 miles of the Mississippi River between New Orleans and Baton Rouge, is the largest bulk cargo port in the world. The U.S. Army Corps of Engineers reports that the port handles a mean of 4.5 million tons of cargo per week.† Assume that the number of tons of cargo handled per week is normally distributed with a standard deviation of 0.89 million tons. (a) What is the probability that the port handles...
The port of South Louisiana, located along 54 miles of the Mississippi River between New Orleans...
The port of South Louisiana, located along 54 miles of the Mississippi River between New Orleans and Baton Rouge, is the largest bulk cargo port in the world. The U.S. Army Corps of Engineers reports that the port handles a mean of 4.5 million tons of cargo per week (USA Today, September 25, 2012). Assume that the number of tons of cargo handled per week is normally distributed with a standard deviation of .82 million tons. a. What is the...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT