3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 31 32 33 34 35 858895 36 37 38 39 40 Month Jan Feb Mar Q1 A product has a consistent year round demand. You are responsible for the forecast and have been tasked with experimenting with some time series analysis. Using this previous monthly demand, calculate the following forecasts for each period possible. A) 4 Period Simple moving average B) Two Period Weighted moving average using weights of .7,3, C) three-period weighted moving average with weights of .5, .3,.2 and D) Exponential Smoothing forecast using an Alpha of .40 and a Week 1 forecast of 800 units. Round all forecasts to whole numbers. Apr May Jun Jul Ready Aug Sep Oct Nov Dec Week 123456 By uploading this assignment, I affirm that I have not given or received any unauthorized help and that all work submitted is my own. I have abided by Seneca's Academic Integrity Policy and I understand that any violation of academic integrity will be subject to the penalties outlined in the policy. 41 42 6 43 ANSWER 44 Demand 725 680 720 800 902 876 825 950 956 1021 995 1050 Demand 360 390 410 385 420 405 SMA 4 Period Q2 For each of the forecasts and demand below, calculate the Mean Absolute Deviation, Mean Squared Error and Mean Absolute Percent Error. Use the ABS formula for Absolute Value. NOTE: Use formulas for each calculation. Sheet2 Forecast 425 400 450 WMA 7,3 350 380 400 WMA 5,3,2 Error (e) EXP Sm .40 800 Absolute Error MAD MSE e^2 MAPE Abs e/A 5 5 7 B 9 0 1 2 83 34 35 36 37 38 39 40 41 42 43 44 839888388283 2868465 A Jul Aug Sep Oct Nov Dec 62 Week 1234in 5 6 ANSWER 03 Season Winter Spring 55 Summer Fall Q2 For each of the forecasts and demand below, calculate the Mean Absolute Deviation, Mean Squared Error and Mean Absolute Percent Error. Use the ABS formula for Absolute Value. NOTE: Use formulas for each calculation. 58 Table 2 Last Year 2020 Sold 900 678 Season B 825 950 956 1021 995 1050 Winter Spring Summer Fall Ready Demand 360 390 410 385 420 405 Forecast 425 400 450 720 D 450 350 380 400 Error (e) Sheet2 Average Seasonal Factor E Average Seasonal Factor Forecast F Absolute Error The Actual demand for snowboards from a large GTA Sporting Goods chain is shown below for 2020. Calculate the Seasonal Index for last year for each of the four seasons. Use the seasonal Index to calculate the demand for each of the seasons for this coming year (Table #2) based on a new ANNUAL demand of 3200 snowboards. Use two decimal places for your seasonal factor. Round your final forecasts to whole numers. G MAD MSE e^2 H MAPE Abs e/A 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 31 32 33 34 35 858895 36 37 38 39 40 Month Jan Feb Mar Q1 A product has a consistent year round demand. You are responsible for the forecast and have been tasked with experimenting with some time series analysis. Using this previous monthly demand, calculate the following forecasts for each period possible. A) 4 Period Simple moving average B) Two Period Weighted moving average using weights of .7,3, C) three-period weighted moving average with weights of .5, .3,.2 and D) Exponential Smoothing forecast using an Alpha of .40 and a Week 1 forecast of 800 units. Round all forecasts to whole numbers. Apr May Jun Jul Ready Aug Sep Oct Nov Dec Week 123456 By uploading this assignment, I affirm that I have not given or received any unauthorized help and that all work submitted is my own. I have abided by Seneca's Academic Integrity Policy and I understand that any violation of academic integrity will be subject to the penalties outlined in the policy. 41 42 6 43 ANSWER 44 Demand 725 680 720 800 902 876 825 950 956 1021 995 1050 Demand 360 390 410 385 420 405 SMA 4 Period Q2 For each of the forecasts and demand below, calculate the Mean Absolute Deviation, Mean Squared Error and Mean Absolute Percent Error. Use the ABS formula for Absolute Value. NOTE: Use formulas for each calculation. Sheet2 Forecast 425 400 450 WMA 7,3 350 380 400 WMA 5,3,2 Error (e) EXP Sm .40 800 Absolute Error MAD MSE e^2 MAPE Abs e/A 5 5 7 B 9 0 1 2 83 34 35 36 37 38 39 40 41 42 43 44 839888388283 2868465 A Jul Aug Sep Oct Nov Dec 62 Week 1234in 5 6 ANSWER 03 Season Winter Spring 55 Summer Fall Q2 For each of the forecasts and demand below, calculate the Mean Absolute Deviation, Mean Squared Error and Mean Absolute Percent Error. Use the ABS formula for Absolute Value. NOTE: Use formulas for each calculation. 58 Table 2 Last Year 2020 Sold 900 678 Season B 825 950 956 1021 995 1050 Winter Spring Summer Fall Ready Demand 360 390 410 385 420 405 Forecast 425 400 450 720 D 450 350 380 400 Error (e) Sheet2 Average Seasonal Factor E Average Seasonal Factor Forecast F Absolute Error The Actual demand for snowboards from a large GTA Sporting Goods chain is shown below for 2020. Calculate the Seasonal Index for last year for each of the four seasons. Use the seasonal Index to calculate the demand for each of the seasons for this coming year (Table #2) based on a new ANNUAL demand of 3200 snowboards. Use two decimal places for your seasonal factor. Round your final forecasts to whole numers. G MAD MSE e^2 H MAPE Abs e/A
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
3 4 5 6 7 8 9 10 11 12 13 A 14 Cost of the Asset 15 Life of the Asset in Years 16 Book Value of the Asset after 5 years 17 Depreciable Basis 18 Yearly depreciation 19 After tax Salvage Value in year...
-
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Mo's Motor Corp. issued $ 380,000 of 7%, 5-year bonds on April 1, 2021. Interest is payable semi-annually on April 1 and October 1. On April 1, 2023,...
-
3 4 5 6 7 8 9 10 11 12 13 14 15 4am-6am 6am - 8am 8am -10am 10am-12pm 12pm-2pm 2pm-4pm 4pm - 6pm 6pm - 8pm 8pm - 10pm Monday 2022 Daily Attendance Trends 50 125 100 90 75 62 125 125 75 Balance S...
-
Hatch plc has two classes of share capital outstanding: 8%, 20 par preference and 5 par ordinary. At December 31, 2021, the following accounts were included in equity. Share CapitalPreference,...
-
Marx and Winter, Inc. operate a chain of retail clothing stores throughout the U.S. Midwest. The firm recently entered into a loan agreement for $20 million that carries a floating rate of interest...
-
What must be the distance between point charge q1 = 26.0C and point charge q2 = 47.0C for the electrostatic force between them to have a magnitude of 5.70 N?
-
In the months leading up to the 2016 election, Christopher Steele, a former British intelligence agent, was hired by a Washington, D.C., research firm to investigate whether then-candidate Donald...
-
John Adams Companys record of transactions for the month of April was as follows. Instructions (a) Assuming that perpetual inventory records are kept in units only, compute the inventory at April 30...
-
6. (a) Given == 2-23i.Find |=| and arg (=*). Hence, solve z=2-23i leave your answers in polar form. (b) Given that z = 1 + i is a root of the polynomial equation z4-4z3 +11z2 - 14z + 10 = 0. Find the...
-
You are holding one of the tethers attached to the top of a giant character balloon that is floating approximately 20 feet above ground level. You are standing approximately 100 feet ahead of the...
-
Let F be a vector field given by F(x, y, z) = xyi-xyj + 2k, and let Q be a cylindrical region bounded by three equations x + y = 1, z = 0, 2 = 3. (1) (5 points) Compute the outward flux of F through...
-
It should be Ct = PV (1 + r)10, not Ct = PV (1 + r)20, to calculate the future value after 20 years in scenario A. This is due to the fact that there are 10 compounding periodsthat is, 20 years of...
-
There are 3 million common and 1 million preferred Kline Inc. shares outstanding. Common shares closed on the TSX November 18 at $80.64 each, after an announcement that net income for the year was...
-
Draw the Central Dogma of Molecular Biology and label the diagram with the appropriate terms-should have 3 molecules (like DNA) & 5 processes (like RNA replication, DNA replication, reverse...
-
Harry Calhoun is auditing the current year's 20X2 financial statements for X Corporation. The prior period 20X1 financial statements were audited by another auditor. In Harry's current year 20X2...
-
Liquidity refers to: Question 8 options: access to ready cash, including savings and credit, which is used to cover short term or unexpected expenses access to ready cash, including savings but not...
-
Let I = [ ii dx (x +1)" dx i Show that +1 (+1)-(24) -S -=S (x +1)" dx Hence, or otherwise find lim 1 lim x dx Use the identity above to find constants A and B such that I, = dx (x + 1) Ax (x+1)^-1...
-
Given that all the choices are true, which one concludes the paragraph with a precise and detailed description that relates to the main topic of the essay? A. NO CHANGE B. Decades, X-ray C. Decades...
-
Construct a pie chart depicting the distribution of blood groups from Exercise 29 in Section 2-2.
-
How many daily rainfall amounts in Boston must be randomly selected to estimate the mean daily rainfall amount? We want 99% confidence that the sample mean is within 0.010 in. of the population mean,...
-
Assume that you have access to a computer that can randomly generate whole numbers between any two values. Describe how this computer can be used to simulate the rolling of a pair of dice.
-
The financial records of Dunbar Inc. were destroyed by fire at the end of 2015. Fortunately, the controller had kept the following statistical data related to the income statement. 1. The beginning...
-
Maher Inc. reported income before income tax during 2015 of 790,000. Additional transactions occurring in 2015 but not considered in the 790,000 are as follows. 1. The corporation experienced an...
-
Presented below is the trial balance of Thompson Corporation at December 31, 2015. Instructions Prepare an income statement and a retained earnings statement. Assume that the only changes in retained...
Study smarter with the SolutionInn App