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.
from given forecast equation:
Forecast for summer of year 5 =64.875 +86.0375+1.2875*19 =175.3750
Forecast for spring of year 6 =64.875 +32.325+1.2875*22 =125.525
Quarterly billing for water usage is shown below. Year Quarter 1 2 3 4 Winter 64...
Period Year 20XX-2 Sales 63 94 118 129 20XX-1 204 215 227 Quarter Spring Summer Fall Winter Spring Summer Fall Winter Spring Summer Fall Winter Spring Summer Fall Winter Quarter Seasonal Deseas. Deseas. Ave. Factor Data Forecast Forecast 204. 0 0 .90 70.0 66. 9 60.2 219.3 0.96 97.9 96.1 92.3 236.7 1.04 113.5 125.3 130.3 251.0 1.10 117.3 154.5 170.0 0.90 226.7 183.7 165.3 0.96 224.0 212.9 204.4 1.04 218.3 242.1 251.8 1.10 222.7 271.3 298.4 0.90 383.3 300.5...
1. Forecast demand for Year 4. a. Explain what technique you utilized to forecast your demand. b. Explain why you chose this technique over others. Year 3 Year 1 Year 2 Actual Actual Actual Forecast Forecast Forecast Demand Demand Demand Week 1 52 57 63 55 66 77 Week 2 49 58 68 69 75 65 Week 3 47 50 58 65 80 74 Week 4 60 53 58 55 78 67 57 Week 5 49 57 64 76 77...
Consider the quarterly electricity production for years 1 to 4: 1 2 3 4 Qtr1 99 120 139 160 Qtr2 88 108 127 148 Qtr3 93 111 131 150 Qtr4 111 130 152 170 (This is the same time-series as from the first question) Use the seasonal naïve method for the seasonal component, and the naïve method for the seasonally adjusted component to forecast production over the next three years. Please show the results in table-form using EXCEL (there is...
E I MINDTAP Video eBook Consider the following time series. Quarter Year 1 Year 2 Year 3 71 49 58 73 68 41 60 86 62 51 53 72 a. Choose a time series plot. TimeSeries Value 60 40 20 TimePeriod(t) TimeSeries Value -60 40 20 Time Periodit) TimeSeries Value ype here to search TimeSeries Valu 60 40 20 Time Periodt) TimeSeries Vale 40 b. Use the folio ving dummy variables to devel。an estmsted regression munion to accent for seasonal...
You have two groups of apples (data below). You want to see if there is a statistical differnce between the two groups. Run descriptives and a two tailed, two sample assuming equal variance t-test. Here's your data: Weight of Apples in Grams Apple ID Farm A Farm B 1 131 151 2 147 159 3 134 162 4 134 158 5 136 159 6 137 160 7 140 150 8 134 160 9 136 160 10 133 160 11 134...
Quarter Year1 Year 2 Year 3 71 49 58 76 68 41 60 78 62 51 53 רך 2 4 a. Choose a time series plot. 2 TimeSeries Value 6 0 40 20 TimePeriod (t) 2 TimeSeries Value 60 4 0 20 TimePeriod(t) 3 TimeSeries Value 60 4 20 TimePeriod(t) 4 TimeSeries Value 0 0 20 TimePeriod (t) Select your answer What type of pattern exists in the data? - Select your answer rl uarteră, otherwise: is b. Use the...
Game_Number Winner Loser Duration 1 Jens Sven 41 2 Sven Jens 76 3 Sven Jens 156 4 Sven Jens 151 5 Sven Jens 105 6 Jens Sven 71 7 Sven Jens 123 8 Sven Jens 111 9 Sven Jens 164 10 Sven Jens 116 11 Jens Sven 46 12 Sven Jens 88 13 Jens Sven 59 14 Jens Sven 47 15 Jens Sven 57 16 Sven Jens 108 17 Sven Jens 78 18 Sven Jens 94 19 Jens Sven 86...
B D E F G 1 40,000 Year 2 Quarter 2 3 60,000 100,000 4 50,000 Year 3 Quarter 1 2 70,000 80,000 A 2 Master Budget: Excel Sheet 2 3 Data 4 5 Budgeted unit sales 6 7 . Selling price per unit 8 • Accounts receivable, beginning balance 9 • Sales collected in the quarter sales are made 10 - Sales collected in the quarter after sales are made 11 • Desired ending finished goods inventory is 12...
7. (a) (15 pts.) With Figure 1 below showing shifts A and B, fill in the blank Table 1 showing the computation of the fraction of Bin Hours in each shift for the different time groups. VI V IV Group 1 A 9-12 13-16 17-20 21-24 Sunday Monday Tuesday Wednesday B B Thursday Friday Saturday Figure 1 Table 1 Computation of Fraction of Bin Hours in Each Shift Days Total in Shift A Fraction in Each Shift B Fraction in...
Team League Wins ERA BA HR SB Errors Built Size Attendance Payroll Pittsburgh Pirates NL 57 5.00 0.242 126 87 127 2001 38496 1.61 34.9 San Diego Padres NL 90 3.39 0.246 132 124 72 2004 42445 2.13 37.8 Oakland Athletics AL 81 3.56 0.256 109 156 99 1966 34077 1.42 51.7 Texas Rangers AL 90 3.93 0.276 162 123 105 1994 49115 2.51 55.3 Florida Marlins NL 80 4.08 0.254 152 92 123 1987 36331 1.54 55.6 Arizona Diamondbacks...