Sales data of: 2006 - 17,000 2007 - 17,500 2008 - 18,200 2009 - 19,000 2010...
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 = 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 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...
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 с. В...
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
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 (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 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 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....
Construct a normal probability plot for the residuals. Comment on the normality assumption. Use MINITAB package software/other software to compute and plot your data (No manual calculation is required) Value of $1000 Year 2014 1863 2013 1639 Year-X (Independent) Value of $1000 Y-Dependent 2012 1239 2011 1068 2010 1046 2009 909 719 2008 2007 1141 2006 1081 2005 934 2004 890 803 2003 624 2002 801 2001 2000 909 Value of $1000 Year 2014 1863 2013 1639 Year-X (Independent)...