ABS Toys sells a variety of toys and games. For the last 3 years the following...
ABS Toys sells a variety of toys and games. For the last 3 years the following quarterly sales were reported.
| Sales | |||
| 2017 | Quarter 1 | 9 | |
| Quarter 2 | 5 | ||
| Quarter 3 | 15 | ||
| Quarter 4 | 26 | ||
| 2018 | Quarter 1 | 20 | |
| Quarter 2 | 12 | ||
| Quarter 3 | 34 | ||
| Quarter 4 | 51 | ||
| 2019 | Quarter 1 | 44 | |
| Quarter 2 | 38 | ||
| Quarter 3 | 62 | ||
| Quarter 4 | 84 | ||
| Answers: | |||||||
| a. | Calculate the seasonal indexes for each quarter. | ||||||
| Q1 | |||||||
| Q2 | |||||||
| Q3 | |||||||
| Q4 | |||||||
| b. | Deseasonalize the time series. Develop a forecasting equation. | ||||||
| c. | What are your forecasts for 2020? | ||||||
| 2020 Q1 | |||||||
| 2020 Q2 | |||||||
| 2020 Q3 | |||||||
| 2020 Q4 | |||||||
Homework Answers
(a)
| Seasonal |
| Indexes |
| 0.973 |
| 0.590 |
| 1.025 |
| 1.413 |
(b) y = 5.4635x - 2.9652
(c)
| Forecast |
| 12.62347 |
| 8.246044 |
| 15.34499 |
| 22.56863 |
Add Answer to:
ABS Toys sells a variety of toys and games. For the last 3 years
the following...
8. Examine the following quarterly data: Quarter 11 Quarter 2 2 Quarter 3 3 15 26 20 12 34 51 Quarter 44 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 8 Quarter 1 9 Quarter 2 1 38 62 Quarter 311...
8. Examine the following quarterly data: Quarter 11 Quarter 2 2 Quarter 3 3 15 26 20 12 34 51 Quarter 44 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 8 Quarter 1 9 Quarter 2 1 38 62 Quarter 311 Quarter 4 12 84 Calculate the seasonal indexes for each quarter. a. Quarter 1 Quarter 2 Quarter 3 Quarter 4 b. Deseasonalize the time series. Produce the trend line using the deseasonalized data. Produce seasonaly adjusted...
DATA ANALYTICS
Item 9Item 9 2 pointsCoca-Cola Revenues ($ millions), 2005–2010Quarter200520062007200820092010Qtr15,2045,1266,0857,4007,1708,000Qtr26,3086,4757,7159,0558,2288,663Qtr36,0356,4187,6728,3118,0358,415Qtr45,5495,9157,3137,0807,49210,483 Click here for the Excel Data File (a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola’s quarterly data. (Round your answers to 3 decimal places.) 1234200520062007200820092010mean (a-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.) Q1Q2Q3Q4 (a-3) What is the trend model for the deseasonalized time series? (Round your answers to 2 decimal places.) yt = xt + (b) State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers to 4 decimal places.) yt = + t + Q1...
Year Quarter Units 1 Q1 20 1 Q2 100 1 Q3 175 1 Q4 13 2...
Year Quarter Units 1 Q1 20 1 Q2 100 1 Q3 175 1 Q4 13 2 Q1 37 2 Q2 136 2 Q3 245 2 Q4 26 3 Q1 75 3 Q2 155 3 Q3 326 3 Q4 48 4 Q1 92 4 Q2 202 4 Q3 384 4 Q4 82 5 Q1 176 5 Q2 282 5 Q3 445 5 Q4 181 Using this data: a. Plot this data on a line chart with quarters from years 1-5 on...
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....
Consider the following time series data: Quarter Year 1 Year 2 Year 3 1 71 68...
Consider the following time series data: Quarter Year 1 Year 2 Year 3 1 71 68 62 2 49 41 51 3 58 60 53 4 78 81 72 Question: Use a multiple regression linear model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Q1=1 if quarter 1, 0 otherwise Q2=1 if quarter 2, 0 otherwise Q3=1 if quarter 3, 0 otherwise What is the R^2 (coefficient of determination)? Round to...
Quarterly Sales ($ thousands) Q1 Q3 15 Q2 11 12 Q4 5 Year 1 Year 2...
Quarterly Sales ($ thousands) Q1 Q3 15 Q2 11 12 Q4 5 Year 1 Year 2 8 13 9 6 What are the quarterly seasonal indices? OA. S1 = 1.30 S2 = 1.15 S3 = 0.91 S4 = 0.64 OB. 51 = 0.30 S2 = 1.15 S3 = 0.91 S4 = 1.64 OC. 51 = 1.15 S2 = 0.45 S3 = 0.91 S4 = 0.64 OD. S1 = 1.40 S2 = 1.15 S3 = 1.50 S4 = 0.64
Problem description: The quarterly sales for specific educational software over the past five years are given...
Problem description: The quarterly sales for specific educational software over the past five years are given in the following table. YEARYEAR2 YEAR3 YEAR4 YEARS Quarter 11710 1820 1830 1920 2010 Quarter 2 960 Quarter 32720 910 2840 1090 2900 1130 3200 1230 3350 Quarter 4 2430 2200 27402790 You are asked to conduct a time series analysis on this set of data and provide your quarterly forecasts of sales for specific educational software for Year 6. You should use the...
The quarterly sales in units for “Retailsale Sports” for the last two years are as follows:...
The quarterly sales in units for “Retailsale Sports” for the last two years are as follows: Quarter Year 1 Year 2 I 440 560 II 460 490 III 420 500 IV 390 400 Using linear regression, a straight line was fitted to the sales data. Assume that the equation of the fitted line is Y = 420 + 6 × t. The first quarter in the data is labeled t = 1. Calculate seasonal indexes for this product using the...
Quarterly Sales ($ thousands) Q3 Q1 15 13 Year 1 Year 2 Q2 11 12 8...
Quarterly Sales ($ thousands) Q3 Q1 15 13 Year 1 Year 2 Q2 11 12 8 Q4 5 6 9 What are the quarterly seasonal indices? O A. S1 = 1.30 S2 = 1.15 S3 = 0.91 S4 = 0.64 OB. 51 = 0.30 S2 = 1.15 S3 = 0.91 S4 = 1.64 C. S1 = 1.15 S2 = 0.45 S3 = 0.91 S4 = 0.64 OD. S1 = 1.40 S2 = 1.15 S3 = 1.50 S4 = 0.64
Calculating Payments
Confusion Products has projected the following sales for the coming year:Q1 $620 Q2 $690 Q3 $860 Q4 $780Sales in the year following this one are projected to be 15 percent greater in each quarter.Calculate payments to suppliers assuming that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assume thatthe company pays immediately.1. What is the payables period in this case?2. For payment of accounts:Q1 $Q2 $Q3 $Q4 $Calculate payments to...
8. Examine the following quarterly data: Quarter 11 Quarter 2 2 Quarter 3 3 15 26 20 12 34 51 Quarter 44 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 8 Quarter 1 9 Quarter 2 1 38 62 Quarter 311 Quarter 4 12 84 Calculate the seasonal indexes for each quarter. a. Quarter 1 Quarter 2 Quarter 3 Quarter 4 b. Deseasonalize the time series. Produce the trend line using the deseasonalized data. Produce seasonaly adjusted...
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....
Quarterly Sales ($ thousands) Q1 Q3 15 Q2 11 12 Q4 5 Year 1 Year 2 8 13 9 6 What are the quarterly seasonal indices? OA. S1 = 1.30 S2 = 1.15 S3 = 0.91 S4 = 0.64 OB. 51 = 0.30 S2 = 1.15 S3 = 0.91 S4 = 1.64 OC. 51 = 1.15 S2 = 0.45 S3 = 0.91 S4 = 0.64 OD. S1 = 1.40 S2 = 1.15 S3 = 1.50 S4 = 0.64
Problem description: The quarterly sales for specific educational software over the past five years are given in the following table. YEARYEAR2 YEAR3 YEAR4 YEARS Quarter 11710 1820 1830 1920 2010 Quarter 2 960 Quarter 32720 910 2840 1090 2900 1130 3200 1230 3350 Quarter 4 2430 2200 27402790 You are asked to conduct a time series analysis on this set of data and provide your quarterly forecasts of sales for specific educational software for Year 6. You should use the...
Quarterly Sales ($ thousands) Q3 Q1 15 13 Year 1 Year 2 Q2 11 12 8 Q4 5 6 9 What are the quarterly seasonal indices? O A. S1 = 1.30 S2 = 1.15 S3 = 0.91 S4 = 0.64 OB. 51 = 0.30 S2 = 1.15 S3 = 0.91 S4 = 1.64 C. S1 = 1.15 S2 = 0.45 S3 = 0.91 S4 = 0.64 OD. S1 = 1.40 S2 = 1.15 S3 = 1.50 S4 = 0.64
Most questions answered within 3 hours.
-
Below is the trial balance of Tom’s Tents at 5 April 2018.
£
£
Trading account:...
asked 2 minutes ago -
For this question, we want to implement the basic
java classes to support the concept of an...
asked 3 minutes ago -
Two random variables X and Y have joint density function f(x,y)
=c(where c >0 denotes an...
asked 6 minutes ago -
Bonita Corporation issued 1,900 shares of $10 par value common
stock upon conversion of 950 shares...
asked 10 minutes ago -
When finding confidence interval for mu , if population standard
deviation (sigma) is known, we use...
asked 40 minutes ago -
Convert your enthalpy of reaction (kJ/mol) to heat of explosion
(kJ/kg) using the molar mass of...
asked 25 minutes ago -
At what annual rate would the following have to be
invested?
$8,929, to grow to $55,581,...
asked 24 minutes ago -
If the codon were 5 bases long instead of three, how many codons
would exist in...
asked 31 minutes ago -
Mittuch Corp. is evaluating a project with the following cash
flows. The company uses a discount...
asked 38 minutes ago -
An income elasticity coefficient of −1.8 means the product is a
normal good.
true or false
asked 31 minutes ago -
PLEASE ANSWER ASAP ASIAN AMERICAN HISTORY
Considering the number of migrants and the time period in...
asked 38 minutes ago -
1. If a good has a price elasticity of demand equal to
0, ________.
a) the...
asked 41 minutes ago