Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EvTel is preparing to enter the smart home market. Thus, they are conducting market research in Istanbul. The company is planning to analyze the

 

EvTel is preparing to enter the smart home market. Thus, they are conducting market research in Istanbul. The company is planning to analyze the past 3 years' smart home device sales data with various forecasting methods to predict future sales. Help the company with the analysis by solving the questions below. Answers Smart Home Device Sales Orun, the product manager of EvTel needs insight about the sales trends of the smart home market. He managed to find the past market sales data of some smart home oriented companies. Answer the following questions by using the table given. Part 1 Years Quarters Past Sales Q1 What is the difference between the saies of the first quarter of 2018 and the first quarter of 2019? Report a positive number What is the total sales at the end of 2020? 01 155.949,00 22 02 142.620,00 2018 Q3 What percentage of the total sales at the end of 2020, occurred in the second quarter of 2020? Part 2 Orun needs you to fit 3 time-series; Linear, 3rd Degree Polynomial, and Power trendlines to the past quarterly sales of the smart home market. Q3 171.411.00 Q4 256.212,00 2018-Q3 Linear Q1 Q2 Q3 According to your trendlines, report the projected sales for the given periods and trendlines. 240.004,00 2019-Q1 3rd Degree Polynomial 270.351,00 2019-Q4 Power 2019 259.041,00 Find the difference between the estimated sales according to the 3rd Degree Polynomial and Power Trendlines for the first half of 2022. Report a positive number Q2 Q4 308.751,00 Q3 According to the Power Trendline, when will EvTel reach 14979808,0 total sales? Click Here 01 414.058,00 04 Decide which trendline has the best fit for the actual data Then, report the sales of the third quarter of 2021 for that method. 2020 Q2 546.812,00 art 3 Orun asked you the following questions about forecasting methods and theory. For Polynomial Trendlines; the higher the degree is, the better forecasting results are. A better fit to the actual data guarantees better forecasts of the future. Q3 671.035,00 Q1 Click Here Q4 741.837,00 22 Click Here

Step by Step Solution

3.41 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

To Construct a trendline in microsoft excel Select the X and Y axis as shown in below table Select scatter graph with markers in the insert tool bar D... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles of Marketing

Authors: Philip Kotler, Gary Armstrong

17th edition

013449251X, 978-0134461434, 134461436, 978-0134492513

More Books

Students also viewed these Accounting questions