Question: Use the data below to answer the question parts (a) and (b). This data is for forecasting fure sale consdiering additive seasonality approach and answer

Use the data below to answer the question parts (a) and (b). This data is for forecasting fure sale consdiering additive seasonality approach and answer related questions.

SHOW EACH CALCULATION STEP AND DESCRIBE IT

ROUND answers to 2 decimal points.

Time Year Season Sale
1 2018 Q1 1
2 Q2 7
3 Q3 3
4 Q4 2
5 2019 Q1 6
6 Q2 8
7 Q3 1
8 Q4 9

PART a) What is the seasonality index for second season (Q2) ?

Part b)

Assume that we run the regression for the deseasonalized data after calculating seasonality index . We find that regression line slope is 0.4 , and intercept is 2.8. By considering the slope and intercept, what is your final forecast for second season of 2020 by considering both trend and seasonality?

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!

Q:

This data is for forecasting future sale considering additive seasonality approach and answer related questions. Time Year Season Sale 1 2018 Q1 1 2 Q2 7 3 Q3 3 4 Q4 2 5 2019 Q1 6 6 Q2 8 7 Q3 1 8 Q4...

Q:

Brands in the Salesforce Dilem DS. INC: SPECTRUM BRAN company's individual and maintain customer relationships, and to clude competition from tak ing advantage of any perceived disruptions during...

Q:

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...

Q:

Hello I need help with requirenments 7-11. please and thank you ACG2021 Comprehensive Financial Statement Analysis Project Spring 2017 Group Members Last Name First Name Instructions: You will need...

Q:

Hello I need help with requirenments 7-11. please and thank you ACG2021 Comprehensive Financial Statement Analysis Project Spring 2017 Group Members Last Name First Name Instructions: You will need...

Q:

Hello I need help with requirenments 7-11. please and thank you ACG2021 Comprehensive Financial Statement Analysis Project Spring 2017 Group Members Last Name First Name Instructions: You will need...

Q:

Hello, I need help answering questions on this excel sheet regarding accounting financial comparisons between Walgreens and CVS. I began to answer requirements 2-6 and need them looked over. I mostly...

Q:

Hello, I need help answering these questions regarding Walgreens and CVS financial statement comparisons. Particularly requirements 7-11 and 5e and 10e and need the rest of my work checked over. I'll...

Q:

Please see first picture for questions. Thank you! Greatly rewarded! Crest Whitestrips Questions 1. What is P&G's motivation for the Advanced Seal launch? What competitive considerations influence...

Q:

Need help on this Project. All Ross 10K, Kohls 10K fiels are the files where the data will be retrieved for the Project. Thank you ACG2021 Spring 2016 Comprehensive Financial Statement Analysis...

Q:

Suppose that the accounts receivable turnover ratio of a company is low when compared with other firms within its industry. How would this information be useful to the managers of a company?

Q:

Within the area where you live, work, or attend school, name three businesses that would likely use job costing and three that would likely use process costing

Q:

The dividend growth model: A ) can be used to valloe both dividend paying and womediviou B ) assumes dividends increase at a decreosings rate. C ) requires the growth rate to be less than the...

Q:

What is an example of constructive feedback? provide reference