Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve using excell please!! Determine the following; 1 Periodicity Number 2 Historical Market Demand Deseasonalized 3 Regression Equation 4 Historical Forecast Demand Deseasonalized 5

Please solve using excell please!!

Determine the following;

1 Periodicity Number

2 Historical Market Demand Deseasonalized

3 Regression Equation

4 Historical Forecast Demand Deseasonalized

5 Historical Seasonal Factor

6 Forecast Factor

7 Forecast Demand by quarter for the next year (year number 5)

image text in transcribed

\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline Period & Year & Quarter & Demand & \begin{tabular}{c} Historical Market Demand \\ Deseasonalized \end{tabular} & Linear Equation & Value & \begin{tabular}{c} Historical Forecast Demand \\ Deseasonalized \end{tabular} & Historical Seasonal Factor \\ \hline 1 & 1 & 1st qtr & 513 & & Slope & \#DIV/0! & & \\ \hline 2 & & 2nd qtr & 932 & & Intercept & \#DIV/0! & & \\ \hline 3 & & 3rd qtr & 1509 & & & & & \\ \hline 4 & & 4th qtr & 1902 & & Y=a+bx & Y=####+#### + & & \\ \hline 5 & 2 & 1st qtr & 693 & & & & & \\ \hline 6 & & 2nd qtr & 1163 & & & & & \\ \hline 7 & & 3rd qtr & 1857 & & & & & \\ \hline 8 & & 4th qtr & 2469 & & & & & \\ \hline 9 & 3 & 1st qtr & 846 & & & & & \\ \hline 10 & & 2nd qtr & 1439 & & & & & \\ \hline 11 & & 3rd qtr & 2271 & & & & & \\ \hline 12 & & 4th qtr & 3079 & & & & & \\ \hline 13 & 4 & 1st qtr & 1070 & & & & & \\ \hline 14 & & 2nd qtr & 1751 & & & & & \\ \hline 15 & & 3rd qtr & 2785 & & & & & \\ \hline 16 & & 4th qtr & 3613 & & & & & \\ \hline \multicolumn{9}{|c|}{ Determine the following; } \\ \hline 1 & \multicolumn{2}{|c|}{ Periodicity Number } & & & & & & \\ \hline 2 & \multicolumn{4}{|c|}{ Historical Market Demand Deseasonalized } & & & & \\ \hline 3 & \multicolumn{2}{|c|}{ Regression Equation } & & & & & & \\ \hline 4 & \multicolumn{4}{|c|}{ Historical Forecast Demand Deseasonalized } & & & & \\ \hline 5 & \multicolumn{3}{|c|}{ Historical Seasonal Factor } & & & & & \\ \hline 6 & \multicolumn{2}{|c|}{ Forecast Factor } & & & & & & \\ \hline 7 & \multicolumn{4}{|c|}{ Forecast Demand by quarter for the next year (year number 5 ) } & & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Applied Regression Analysis And Other Multivariable Methods

Authors: David G. Kleinbaum, Lawrence L. Kupper, Azhar Nizam, Eli S. Rosenberg

5th Edition

1285051084, 978-1285963754, 128596375X, 978-1285051086

Students also viewed these General Management questions