Question: PLEASE USE EXCEL AND SHOW ALL FORMULAS FOR EVERYTHING AND EXPLANATIONS Thanks 4. For the following sales data for 24 months: Month Period Jan-18 1

PLEASE USE EXCEL AND SHOW ALL FORMULAS FOR EVERYTHING AND EXPLANATIONS

Thanks

PLEASE USE EXCEL AND SHOW ALL FORMULAS FOR

4. For the following sales data for 24 months: Month Period Jan-18 1 Feb-18 2 Mar-18 3 Apr-18 4 May-18 5 Jun-18 6 Jul-18 7 Aug-18 8 Sep-18 9 Oct-18 10 Nov-18 11 Dec-18 12 Jan-19 13 Feb-19 14 Mar-19 15 Apr-19 16 May-19 17 Jun-19 18 Jul-19 19 Aug-19 20 Sep-19 21 Oct-19 22 Nov-19 23 Dec-19 Demand 1200 1400 1450 1580 1796 2102 2152 2022 1888 1938 1988 1839 1684 1944 1994 2154 2430 2827 2877 2687 2492 2542 2592 2382 24 a. Estimate the regression parameters: intercept (a) and slope (b) and the monthly seasonality indices for each month Slt. (Go through the trend-seasonality example spreadsheet we went through in class). b. Using your forecasting equation [a+bt ] * Sl , what is the forecast for June-20

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!

D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 A Month Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15...

Please make the same assignment on another company. this assignment is on apple company please make on another company Note: i Need same assignment on another company. .. Please make the same...

How do I calculate the MRP, Purchase Plan, and Capacity plan given the information provided? O AutoSave OFF A S U = Term Project Schedule STUDENT Home Page Layout Formulas Data Review View Share...

A boutique online retailer of home dcor and art compiled time series data that allows us to predict net dollar sales. Three years of monthly data is compiled in the Excel Workbook, including the...

You don't need Describe how the following would be executed using excel: . Find the 3 month moving average of flowers ordered for 2018. 4. Add a series of columns to your Orders data table that will...

PLEASE: DO NOT OPEN TAB(s) ON YOUR BROWSER OTHE DO NOT SEND THE SOLUTION FILE TO YOUR EM DO NOT OPEN ANY COURSE MATERIAL . SAVE YOUR FILE AS: CIS623_FinalExam_YourName Refresh your browser before...

Must know how to use excel. Please provide an explanation of how to execute the following. I just need a general understanding of how to do this. . Find the 3 month moving average of flowers ordered...

please can you please help me with this case in order for me to get prepared for my midterm. this is not a homework, its a case given by the professor for us to get ready for the upcoming exam...

Required: 1.Using Excel, prepare the following budgets for the twelve-month period from January 2018 to December 2018.The first worksheet should contain your raw data and assumptions and all future...

What is the quark composition of the E particle?

Preston Enterprises uses the direct write-off method of accounting for uncollectible accounts. On October 12, a very large account was written off. The amount was subsequently recovered on December...

1 . Secondary Market and How to Invest in the Stock MarketQuestion:Define the secondary market and describe its functioning. Create a step - by - step guide for a first - time investor on how to...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...