Question: Please help me forecast the next five spots, I got the first correct but not after that i dont know what steps I'm missing. Please

Please help me forecast the next five spots, I got the first correct but not after that i dont know what steps I'm missing. Please show me IN EXCEL! Thank you!

Quarter Year 1 Year 2 Year 3 Year 4 1 101.5 96.5 120.4 108.6 2 127.3 111.6 142.6 132.5 3 148.8 137.9 163.7 154.3 4 166.6 152.1 180.7 169.0

Please help me forecast the next five spots, I Will like if it helps! Thank you!

The manager of a utility company in the Texas panhandle wants to develop quarterly forecasts of power loads for the next year. The power loads are seasonal, and the data on the quarterly loads in megawatts (MW) for the last four years are as follows: Quarter 1 2 3 4 Year 1 101.5 127.3 148.8 166.6 Year 2 96.5 111.6 137.9 152.1 Year 3 120.4 142.6 163.7 180.7 Year 4 108.6 132.5 154.3 169.0 The manager estimates the total demand for the next year at 684 MW. Use the multiplicative seasonal method to develop the forecast for each quarter. (Round all intermediate calculations to three decimal places.) The first quarter forecast is 131.3 MW. (Enter your response rounded to one decimal place.) The second quarter forecast is MW. (Enter your response rounded to one decimal place.) A C E F G Quarter Year 1 100.3 1 2 1 3 2 4 3 5 4 126.6 142.2 Year 2 97.2 118.5 144.8 150.8 =SUM(C2:05) =C6/4 Year 3 122.8 150.3 165.2 175.4 =SUM(D2:05) =D6/4 Year 4 103.3 130.3 145.2 169 =SUM(E2:E5) =E6/4 6 totals 161.5 =SUM(B2:B5) =B6/4 7 avg 8 9 Quarter Y1 Y3 Y4 9 10 11 12 1 13 2 14 3 15 4 16 17 18 19 20 =B2/B7 =B3/B7 =B4/B7 =B5/B7 Seasonal Indices Y2 =C2/C7 =C3/C7 =C4/C7 =C5/C7 =D2/D7 =D3/D7 =D4/D7 =D5/D7 =E2/E7 =E3/E7 =E4/E7 =E5/E7 avg =AVERAGE(B12:E12) =AVERAGE(B13:E13) =AVERAGE(B14:214) =AVERAGE(B15:E15) =171*F12 =171*F13 =171*F14 171*F15 . B C D E F G 1 Quarter 1 2 2 3 2 4 5 6 7 3 4 totals Year 1 Year 2 Year 3 Year 4 100.3 97.2 122.8 103.3 126.6 118.5 150.3 130.3 142.2 144.8 165.2 145.2 161.5 150.8 175.4 169 530.6 511.3 613.7 547.8 132.65 127.825 153.425 136.95 avg 8 9 Y3 Quarter 1 10 11 12 13 14 15 16 avg 0.768 Seasonal Indices Y1 Y2 0.756 0.760 0.954 0.927 1.072 1.133 1.217 1.180 Y4 0.754 0.951 2 0.953 0.800 0.980 1.077 1.143 131.3 163.0 185.6 204.1 3 1.085 1.060 1.234 4 1.194

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

I need to revise my essay below is how the teacher want my transcript formatted just like the example and I will also show what I put I need to make the changes Assignment #1: Role Play Wayneisha J...

Can you please help? I have attached the instructions on the word doc and the spreadsheet. Please let me know if you have any questions. Introduction: You are the senior financial analyst for Fosbeck...

please help me to answer this one, you can answer it based on your own understanding, thoughts or ideas. There are no missing data, link, graph. Activity 1 (please expand and explain it) Dealing with...

Jones & Bartlett Learning, LLC. NOT FOR RESALE OR DISTRIBUTION CHAPTER Hot Spot Analysis 10 LEARNING OBJECTIVES C A R R Provide a working definition of a \"hot spot.\" , Be able to explain different...

Please read the question Question: Choose one of the teaching strategies from the article that you read 1. What is the teacher is trying to accomplish by using this technique? (That is, what's the...

Please read the question Question: Choose another different one of the teaching strategies from the article that you read 1. What is the teacher is trying to accomplish by using this technique? (That...

Chapter 7 Revising and Presenting Your Writing I'm not a very good writer, but I'm an excellent rewriter. James A. Michener Half my life is an act of revision. John Irving Getting Started INT RODU CT...

Thoughts on what an outstanding HR manager would do to prevent this problem from happening in the first place and what intervention they should use at this point in these situations to improve and...

Please read the question Question: On pages 5 and 6 the authors write, "Narrative provides not only meaning but also a mental framework for imbuing future experiences and information with meaning, in...

Read Chapters 1,2,4,7 and Write a 800 - 1000 word Reflection Paper Grading : ?Thoughtfulness?Reactions,personal experiences,criticisms, etc. ?Application to your futureprofessional(and personal)life...

Calculate all the ratios below. Please show all work Liquidity ratios: Acid-test (quick) ratio Current ratio Activity ratios: Accounts receivable turnover Inventory turnover Profitability ratios:...

Carbon-14 dating is used to determine the age of some unearthed bones. (a) If the activity of bone A is higher than that of bone B, then bone A is (1) older than, (2) younger than, (3) the same age...

This question addresses the costs of software to be ( 1 ) marketed as a separate product or as part of a product or process or ( 2 ) used internally. Select the appropriate circle to indicate whether...

A firm's total cost of producing Q units of output is C(Q)= 500+20Q. There are ten potential consumers of the firm's product: six "rich" consumers, each with inverse demand P(Q)= 100-5Q; and four...