Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the Fastgro Fertilizer Company data again, develop a seasonally adjusted forecast for the demand. Use the linear trend line and the seasonal factors to

Using the Fastgro Fertilizer Company data again, develop a seasonally adjusted forecast for the demand. Use the linear trend line and the seasonal factors to compute the forecast for all of 2019. Also compute the cumulative error, MAD and MAPD. How does this method compare to the methods from Question #1?

I've listed the same data in two different formats so that you can use the table that you like best, though to compute the error measures, I would suggest using the lower table.

PLEASE USE EXCEL AND SHOW FORUMALS, THANK YOU :)

image text in transcribed

image text in transcribed

Instructions to the right. \#2. Using the Fastgro Fertilizer Company data again, develop a seasonally adjusted forecast for the demand. Use the linear trend line and the seasonal factors to compute the forecast for all of 2019. Also compute the cumulative error, MAD and MAPD. How does this method compare to the methods from Question \#1? I've listed the same data in two different formats so that you can use the table that you like best, though to compute the error measures, I would suggest using the lower table. E:MAD=MAPD= How does this method compare to the methods from Question \#1? Part d) \begin{tabular}{|r|c|} \hline \multicolumn{1}{|l|}{ Trend Line: } \\ \hline Intercept = & 120.258 \\ \hline Slope = & 1.948 \\ \hline \end{tabular} Instructions to the right. \#2. Using the Fastgro Fertilizer Company data again, develop a seasonally adjusted forecast for the demand. Use the linear trend line and the seasonal factors to compute the forecast for all of 2019. Also compute the cumulative error, MAD and MAPD. How does this method compare to the methods from Question \#1? I've listed the same data in two different formats so that you can use the table that you like best, though to compute the error measures, I would suggest using the lower table. E:MAD=MAPD= How does this method compare to the methods from Question \#1? Part d) \begin{tabular}{|r|c|} \hline \multicolumn{1}{|l|}{ Trend Line: } \\ \hline Intercept = & 120.258 \\ \hline Slope = & 1.948 \\ \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

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

Throughput Modeling Financial Information Used By Decision Makers

Authors: Waymond Rodgers

1st Edition

0762303409, 978-0762303403

More Books

Students also viewed these Accounting questions

Question

Characterize intercultural communication in the age of colonialism.

Answered: 1 week ago