HomeworkLib
Question

Sales data of: 2006 - 17,000 2007 - 17,500 2008 - 18,200 2009 - 19,000 2010...

Sales data of:
2006 - 17,000
2007 - 17,500
2008 - 18,200
2009 - 19,000
2010 - 19,500
2011 - 20,100
2012 - 20,500
2013 - 21,000

Show Exponential Smoothing of the data with a smoothing constant of 45%
math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Using exponential smoothing, list all terms for the time series [17000,17500,18200,19000,19500,20100,20500,21000 using a 0.45 S117000 s2ax2-1(1 - a)s2-1 S2 :045(%) + (1-045s1 s,-0.45(%) + (0.55)s1 S2 0.45(17500) + (0.55)17000 s2 7875 9350 S217225 S3-09-1 + (1 -a)S3-1 S3 0.45(x2)+(1-0.45)s2 S30.45(x2)(0.55)s2 S30.45(18200) + (0.55)17225 S381909473.75 S317663.75 StaXt-1(1 - a)st-1 s,-0.45%) + (1-045)S3 s,-0.45(%) + (0.55)s3 S40.45(19000) + (0.55)17663.75 S4- 8550 + 9715.0625 S4 18265.0625StaXt-1(1- a)st-1 s5-0.45(%) + (1-045)S4 S5-045(%) (0.55)s4 0.45(19500)+ (0.55)18265.0625 S5877510045.784375 S5 18820.784375

0 0
Add a comment
Know the answer?
Add Answer to:
Sales data of: 2006 - 17,000 2007 - 17,500 2008 - 18,200 2009 - 19,000 2010...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Budget Total (in Billions of Dollars) 2006 2007 2008 2009 2010 2011 2012 2013 2014 Revenues...

    Budget Total (in Billions of Dollars) 2006 2007 2008 2009 2010 2011 2012 2013 2014 Revenues 2,407 2,568 2,524 2,105 2,162 2,304 2,450 2,775 3,032 Outlays 2,655 2,729 2,983 3,518 3,456 3,603 3,537 3,455 3,523 Surplus (deficit) (248) (161) (459) (1,413) (1,294) (1,301) (1,087) (680) (492) From 2008 to 2010, by how much did each of the following change? Instructions: Enter your responses rounded to the nearest whole number. Indicate negative changes with a (-) negative sign. (a) Tax revenue:...

  • 2005 2006 2007 2008 2009 2010 6,5es 7,205 7.30 8,333 8.263 9,368 7,697 8,599 9,607 10,945 10.592 ...

    2005 2006 2007 2008 2009 2010 6,5es 7,205 7.30 8,333 8.263 9,368 7,697 8,599 9,607 10,945 10.592 14.,801 Ctr3 8.184 8,950 10,171 11,244 11,080 15,514 Ctr4 10,096 10,383 12,346 2,729 13297 18,155 Click here for the Excel Data Fie (a-1) Use Megastat or MINTAB to deseasonalize Pepsico's quarterly data (Round your answers to 3 decimal places.) (a-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.) Q3 04 (a-3) what is the trend model for the...

  • What is the correlation between year and student population? Year 2006 = 8,860 Students 2007 =...

    What is the correlation between year and student population? Year 2006 = 8,860 Students 2007 = 9,056 2008 = 9,050 2009 = 9,429 2010 = 9,407 2011 = 9,352 2012 = 9,608 2013 = 10,107 2014 = 10,382 2015 = 10,340 2016 = 10,805 2017 = 11,034 2018 = 11,639

  • PLEASE ANSWER!!!!!!!! Use scratch paper as needed. Be sure to label the answer if it is written on the scratch pape...

    PLEASE ANSWER!!!!!!!! Use scratch paper as needed. Be sure to label the answer if it is written on the scratch paper. Q1. (20 POINTS) The following are the sales figures for your company for the past 6 years. Use the exponential smoothing method and moving average to smooth the data and provide the forecast for 2013. Also find the MAPE for the series. Which of the two values of alpha yields the best results? Show all calculations Forecasted Sales Sales...

  • find the average annual growth rate for each of the firms Firm 2006 2007 2008 2009...

    find the average annual growth rate for each of the firms Firm 2006 2007 2008 2009 2010 2011 Loewen 1 1.07 1.3 1.21 1.27 1.35 Morse 1.12 0.8 0.8 1.2 1.35 1.35 Huddleston 1.75 2.5 3.6 3.75 3.8 4.25 Meyer 2.25 2.5 2.1 2.74 2.85 2.96

  • Question Completion Status: Year Unemployment rate 2001 4.7 2002 5.8 2003 6.0 2004 5.5 2005 5.1...

    Question Completion Status: Year Unemployment rate 2001 4.7 2002 5.8 2003 6.0 2004 5.5 2005 5.1 2006 4.6 2007 4.6 2008 5.8 2009 9.3 2010 96 2011 89 2012 8.1 National Bureau of Labor Statistic Source: Use your cakulator to draw a time series plot for this data and describe the trend you A 8.87 see, B. The unemployment rate is steadily increasing from 2001 to 2012 Predict the unemployment rate for 2013 using a 5-year moving average с. В...

  • Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past...

    Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 410.00, the following sales forecast has been developed: Year Sales 2005 2006 2007 2008 2009 450 495 518 563 580 Forecasted Sales 410.00 422.00 443.90 466.13 495.19 The MAD for a forecast developed using exponential smoothing with a = 0.30 is 73.76 sales (round...

  • Pro Forma Income Statement for Ideko, 2005-2010 2009 Year 2005 2006 2007 2008 2010 Income Statement...

    Pro Forma Income Statement for Ideko, 2005-2010 2009 Year 2005 2006 2007 2008 2010 Income Statement (000) 1 Sales 75,000 119,777 138,149 158,526 103,234 88,358 2 Cost of Goods Sold (16,000) (18,665) (21,593) (18,000) (21,622) (25,757) (24,808) (28,333) (32,193) (30,471) (35,834) (41,925) 84.407 3 Raw Materials 4 Direct Labor Costs 41,000 48,071 55,883 64,498 73.982 5 Gross Profit 6 Sales and Marketing 7 Administrative (11,250) (14,579) (13,500) (13,254) 16.250 20,238 (18,582) (31,705) (20,608) (23,356) (27,630) (16,769) (17,959) 24,373 28,393 (15.485)...

  • s Below is 10 years' data on the Manager's Salary Index (MSI). Year 2008 2009 2010...

    s Below is 10 years' data on the Manager's Salary Index (MSI). Year 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 MSI 93 100 Change in MSI 3.9% 5.0 115 126 1.2 8.3 5.1 12.0 4.5 138 145 170

  • Coca-Cola Revenues ($ millions), 2005-2010 Quarter 2005 2006 2007 2008 Qtri 5,196 5,109 6,065 7,360 Qtr2...

    Coca-Cola Revenues ($ millions), 2005-2010 Quarter 2005 2006 2007 2008 Qtri 5,196 5,109 6,065 7,360 Qtr2 6,300 6,455 7,695 9,035 Qtr3 6,027 6,402 7,652 8,299 Otr4 5,541 5,895 7,293 7,015 2009 2010 7,130 7,700 8,212 8,655 8,015 8,407 7,468 10,475 Click here for the Excel Data File (2-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round your answers to 3 decimal places.) 2 3 2005 2006 2007 2008 2009 2010 mean (a-2) State the adjusted four quarterly indexes....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT