Question

Consider the quarterly electricity production for years 1 to 4: 1 2 3 4 Qtr1 99...

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 no need to plot the results).

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1yearquarter demand year Year508 verage177 ear6 788 average 197 868 217 ggi Ці 120 i 1 139 //Í 160. 88108 93111131150 93 127 148 quarter 152 170 108 549 97.75117.25 137.25 total 391 628 ear7 130 139 127 131 152 160 148 150 170 avera 10 3 year 1.01281.0235 1.0128 1.01911.0170 123 133 14 4 0.90030.9211 0.9253 0.9427 0.9223 0.95140.9467 0.9545 0.9554 0.9520 1.13551.1087 1.1075 quarter 15 4 16 17 4 828 1.1086 total 3163.3 19 20 5 163.3 168.5 4196.2 200.4 181.7 calculated 1875values 24 25 6 6 218.4 6 71 220.7 27 7 200.1 206.6 240.6 30 31 32 Sheeti Sheet2 Sheet3 2 Readysir if u need excel sheet orginal please leave me a comment

Add a comment
Know the answer?
Add Answer to:
Consider the quarterly electricity production for years 1 to 4: 1 2 3 4 Qtr1 99...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6...

    Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 (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, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your...

  • Quarter Year 1 Year 2 Year 3 Year 4 Year 5 1 20 42 69 98...

    Quarter Year 1 Year 2 Year 3 Year 4 Year 5 1 20 42 69 98 175 2 101 141 149 211 288 3 168 250 333 388 436 4 6 20 47 91 181 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 $295,000 in the first year of operation to $1,080,000 in the most recent year....

  • 2019 Quarter Return expenses 1 .. 2 3 4 Calculate the quarterly forecasts for 2019 using...

    2019 Quarter Return expenses 1 .. 2 3 4 Calculate the quarterly forecasts for 2019 using the results of a regression analysis. Evaluate the results of the regression analysis and make appropriate changes to improve the model. (Round your answers to 2 decimal places for Regression One.) Regression One 2019 Quarter Predicted expenses 1 2 3 4 Regression Two 2019 Quarter Predicted Expenses 1 2 3 4 Required informatio [The following information applies to the questions displayed below.] Lexon Inc....

  • Bubba's Burgers - Statistics Question

    Sampled StoreDessert Orders Per 1,000 TransactionsStore 1185Store 2226Store 3290Store 4226Store 5255Store 6293Store 7138Store 8203Store 9276Store 10173Store 11275Store 12199Store 13213Store 14321Store 1597Store 16152Store 17319Store 18193Store 19126Store 20215Store 21186Store 22289Store 23181Store 24196Store 25183Store 2690Store 27178Store 28103Store 29173Store 30231Store 31158Store 32202Store 33234Store 34273Store 35218Store 36247Store 37223Store 38108Store 39238Store 40143Store 41206Store 42300Store 4389Store 44202Store 45250Store 46210Store 47137Store 48215Store 49204Store 50188Store 51255Store 52196Store 53123Store 54189Store 55206Store 56146Store 57136Store 58211Store 59164Store 60246Store 61324Store 62125Store 63195Store 64173Store 65179Store 6676Store 67248Store 68199Store 69223Store 70240Store 71224Store 72215Store 73222Store 74170Store...

  • Your IT department provided you data on patients that received ER services, their GHHS, and their recovery time. Prepare a report to share with the owners of the facility that will help you make infor...

    Your IT department provided you data on patients that received ER services, their GHHS, and their recovery time. Prepare a report to share with the owners of the facility that will help you make informed decisions about how long you can expect a patients’ recovery time would be based on their GHHS. Based on your findings provide recommendations on your plan moving forward to improve the functioning of your facilities in generating revenue. Prepare a report that addresses each of...

  • 33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim...

    33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim plans to repay the loan on March 11. Assume the loan is on ordinary interest. How much will Jim repay on March 11? (Use Days in a year table) (Round your answer to the nearest cent.) Jm repay etbook 7-1 TABLE Exact days-in-a-year calendar (excluding leap year)" Day of month 30 31 30 31 28 31 30 31 31 30 31 31 Dec Mar...

  • data: (copy and paste in excel to view columns in alignment) Sample   Repair Time (days) 1  ...

    data: (copy and paste in excel to view columns in alignment) Sample   Repair Time (days) 1   12 2   17 3   9 4   16 5   10 6   18 7   12 8   14 9   15 10   14 11   14 12   8 13   11 14   10 15   8 16   8 17   14 18   12 19   14 20   13 21   12 22   15 23   15 24   10 25   24 26   17 27   13 28   15 29   13 30   15 31   36 32   40 33  ...

  • Problem #1: TO SELECT THE MOST ECONOMICAL Wio SHAPE COLUMN ZO FEET IN HEIGHT SUPPORT AH...

    Problem #1: TO SELECT THE MOST ECONOMICAL Wio SHAPE COLUMN ZO FEET IN HEIGHT SUPPORT AH AXIAL LORD OF 370 KIPS using soksi STEEL! ASSUME A FIXED BASE ANDA PINGED TOP (CASE C) WIDE FLANGE SHAPES HP Axis Y-Y Theoretical Dimensions and Properties for Designing Flange Axis X-X | Weight Area Depth Web Section per of of Thick- Thick- Number Foot Section Section Width S 'T Sy Ty ness ness < * A by tw in. in. in.' in. in....

  • Need help with b,c and d. A30 fx III. A B с 78 79 TOTAL LIABILITIES...

    Need help with b,c and d. A30 fx III. A B с 78 79 TOTAL LIABILITIES 80 81 b) In the next 3 months the following accounting events happened to the company (the VAT is 25% in each 82 event wherever it is possible). Record the accounting events in the books! (24p) 83 84 85 86 1. The owners opened a bank account and paid 300.000 K HUF in as a startup capital to launch the business. 87 88 2....

  • Need Help filling in all yellow blocks. Thank you in advance! 2 Joshua & White Technologies:...

    Need Help filling in all yellow blocks. Thank you in advance! 2 Joshua & White Technologies: December 31 Balance Sheets 3 Thousands of Dollars) 2016 21,000 3,759 52,500 Assets 6 Cash and cash equivalents Short-term investments 8 Accounts Receivable g Inventories 10 Total current assets 11 Net fixed assets 12 Total assets 2015 20,000 3,240 48,000 84000 56.000 $161,259 $127,240 218400 200,000 $379,659 $327 240 4 Liabilities and equity 15 Accounts payable 16 Accruals 17 Notes payable 18 Total current...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT