7. Quarterly billing for water usage is shown below. Year Quarter 1 2 3 4 Winter...

7. Quarterly billing for water usage is shown below.

Year Quarter 1 2 3 4

Winter 64 66 68 73

Spring 103 103 104 120

Summer 152 160 162 176

Fall 73 72 78 88

The forecast equation is: Ft = 64.875 – 6.1375 Qtr1t + 32.325 Qtr2t + 86.0375 Qtr3t + 1.2875 (t). Forecast the summer of year 5 and spring of year 6.

Expert Solution

orchestra answered 2 years ago

Quarterly billing for water usage is shown below. Assume the time series has seasonality with a...

Quarterly billing for water usage is shown below. Assume the time series has seasonality with a long term trend. Year Quarter 1 2 3 4 Winter 64 66 68 73 Spring 103 103 104 120 Summer 152 160 162 176 Fall 73 72 78 88 Forecast the next four quarters: FWinter = 81.625, FSpring = 126.375, FSummer= 175.375, FFall= 92.625 FWinter = 80.625, FSpring = 120.375, FSummer= 175.375, FFall= 90.625 FWinter = 82.625, FSpring = 120.375, FSummer= 174.375, FFall= 90.625...

Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales...

Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000 Selling price per unit $7 per unit 1 Chapter 7: Applying Excel 2 3 Data Year 2 Quarter Year 3 Quarter 4 1 2 3 4 1 2 5 Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000 6 7 � Selling price per unit $8 per unit 8 � Accounts receivable, beginning balance...

Quarter Year 1 Year 2 Year 3 1 5 8 10 2 1 3 7 3...

Quarter Year 1 Year 2 Year 3 1 5 8 10 2 1 3 7 3 3 6 8 4 7 10 12 (A) What type of pattern exists in the data? a. Positive trend, no seasonality b. Horizontal trend, no seasonality c. Vertical trend, no seasonality d. Positive tend, with seasonality e. Horizontal trend, with seasonality f. Vertical trend, with seasonality (B) Use a multiple regression model with dummy variables as follows to develop an equation to account for...

Chapter 9: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1...

Chapter 9: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit $8 per unit • Accounts receivable, beginning balance $65,000 • Sales collected in the quarter sales are made 75% • Sales collected in the quarter after sales are made 25% • Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter • Finished...

Chapter 8: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1...

Chapter 8: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit $8 per unit • Accounts receivable, beginning balance $65,000 • Sales collected in the quarter sales are made 75% • Sales collected in the quarter after sales are made 25% • Desired ending finished goods inventory is 30% of the budgeted unit sales...

Consider the following quarterly time series. Quarter Year 1 Year 2 Year 3 1 923 1,112...

Consider the following quarterly time series. Quarter Year 1 Year 2 Year 3 1 923 1,112 1,243 2 1,056 1,156 1,301 3 1,124 1,124 1,254 4 992 1,078 1,198 a. Construct a time series plot. What type of pattern exists in the data? b. Use 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,...

Consider the following time series data. Quarter Year 1Year2 Year 3 1 4 6 7 2...

Consider the following time series data. Quarter Year 1Year2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 b.) Use the following dummy variables to develop an estimated regression equation to account for any seasonal and linear trend 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 (to 3 decimals if necessary)....

Given the matrix as shown below n_array = 3 1 8 3 5 7 4 9...

Given the matrix as shown below n_array = 3 1 8 3 5 7 4 9 2 Write a M-file script program that generates this n_array, and answer each question using one line of MATLAB statement. a) Replace the second column of the n_array with a column of 0s b) Replace the element in the second-row, third-column with a zero c) Change the n_array to a 4 x 3 array by adding a row of 0s The end result for...

Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 4...

Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 4 5 2 4 5 8 3 1 3 4 4 7 9 10 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item 1 What type of pattern exists in the data? - Select your answer -Positive trend pattern, no seasonalityHorizontal pattern, no seasonalityNegative trend pattern, no seasonalityPositive trend pattern, with seasonalityHorizontal pattern, with...

Consider the quarterly electricity production for years 1-4: Year 1 2 3 4 Q1 99 120...

Consider the quarterly electricity production for years 1-4: Year 1 2 3 4 Q1 99 120 139 160 Q2 88 108 127 148 Q3 93 111 131 150 Q4 111 130 152 170 (a) Estimate the trend using a centered moving average. (b) Using a classical additive decomposition, calculate the seasonal component. (c) Explain how you handled the end points. - PLEASE PROVIDE ANSWER C ! Note: Explain all the steps and computations

Question