Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

solve in excel ) Calculate the forecast for 2020 using the Seasonal forecasting method we used in class. Also calculate MAD for this data set.

solve in excel image text in transcribed
) Calculate the forecast for 2020 using the Seasonal forecasting method we used in class. Also calculate MAD for this data set. (use 3 decimal places for calculations) (3 \begin{tabular}{|c|c|c|c|c|} \hline & & & & \\ \hline period & Year & Sales & SF & Avesesonalit \\ \hline 1 & 2017 & 73 & \\ \hline 2 & 2017 & 104 \\ \hline 3 & 2017 & 168 \\ \hline 4 & 2017 & 74 \\ \hline 5 & 2018 & 65 \\ \hline 6 & 2018 & 82 \\ \hline 7 & 2018 & 124 \\ \hline 8 & 2018 & 52 \\ \hline 9 & 2019 & 89 & \\ \hline 10 & 2019 & 146 & \\ \hline 11 & 2019 & 205 & \\ \hline 12 & 2019 & 98 & \\ \hline 13 & 2020 & & \\ \hline 14 & 2020 & & \\ \hline 15 & 2020 & & \\ \hline 16 & 2020 & & \\ \hline & & & \\ \hline & slope & & \\ \hline & intercept & \\ \hline \end{tabular} ) Calculate the forecast for 2020 using the Seasonal forecasting method we used in class. Also calculate MAD for this data set. (use 3 decimal places for calculations) (3 \begin{tabular}{|c|c|c|c|c|} \hline & & & & \\ \hline period & Year & Sales & SF & Avesesonalit \\ \hline 1 & 2017 & 73 & \\ \hline 2 & 2017 & 104 \\ \hline 3 & 2017 & 168 \\ \hline 4 & 2017 & 74 \\ \hline 5 & 2018 & 65 \\ \hline 6 & 2018 & 82 \\ \hline 7 & 2018 & 124 \\ \hline 8 & 2018 & 52 \\ \hline 9 & 2019 & 89 & \\ \hline 10 & 2019 & 146 & \\ \hline 11 & 2019 & 205 & \\ \hline 12 & 2019 & 98 & \\ \hline 13 & 2020 & & \\ \hline 14 & 2020 & & \\ \hline 15 & 2020 & & \\ \hline 16 & 2020 & & \\ \hline & & & \\ \hline & slope & & \\ \hline & intercept & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Concept Audits A Philosophical Method

Authors: Nicholas Rescher

1st Edition

1498540392, 978-1498540391

More Books

Students also viewed these Accounting questions

Question

5. How would you describe your typical day at work?

Answered: 1 week ago

Question

7. What qualities do you see as necessary for your line of work?

Answered: 1 week ago