Question

2. The table below shows (1) sales forecasts for the respective quarters before adjusting for seasonality,...

2. The table below shows (1) sales forecasts for the respective quarters before adjusting for seasonality, and (2) the seasonal indices for each of the four quarters. Adjust these sales forecasts for seasonality and put the final (adjusted) forecasts in the table. Quarter 1 2 3 4 Sales forecast 400 400 400 400 Seasonal Index 1.2 0.8 0.7 1.3 Adjusted Forecast

Homework Answers

Answer #1
Quarter Sales Forecast Seasonal Index Adjusted forecast
1 $           400 1.2 $           480
2 $           400 0.8 $           320
3 $           400 0.7 $           280
4 $           400 1.3 $           520
$        1,600 $        1,600
Adjusted forecast=Sales forecast * Seasonal index
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Using only the Chicago sales data, generate the following sales forecasts in Excel: Naïve forecasts (using...
Using only the Chicago sales data, generate the following sales forecasts in Excel: Naïve forecasts (using the deseasonalized sales data) for January 5th through January 30th. You will need to adjust the sales data to remove the seasonality effects. Four-day moving average forecasts for January 8th through January 30th. Twelve-day moving average forecasts for January 16th through January 30th. Note that, for example, you will not be able to make a four-day moving average forecast for January 7th since four...
1. A firm’s sales for a product line during the 12 quarters of the past 3...
1. A firm’s sales for a product line during the 12 quarters of the past 3 years were as follows: Quarter Sales Quarter Sales 1 600 7   2,600 2   1,550 8 2,900 3 1,500 9 3,800 4 1,500 10 4,500 5 2,400 11 4,000 6 3,100 12   4,900 a. Determine the forecast for the 13th quarter using the Naïve method. b. Determine the forecast for the 13th quarter using the moving average k=4. c. Determine the seasonal index of each...
The following table shows the past two years of quarterly sales information. Assume that there are...
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES QUARTER SALES 1 218 5 162 2 238 6 190 3 209 7 156 4 176 8 141 Use regression and seasonal indexes to forecast quarterly sales for the next year. (Do not round intermediate calculations. Round your answers to the nearest whole number.) The following table shows the...
The following table shows the past two years of quarterly sales information. Assume that there are...
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES 1 161 2 190 3 145 4 133 5 210 6 235 7 205 8 185 Use time series decomposition to forecast quarterly sales for the next year. (Do not round intermediate calculations. Round your answers to the nearest whole number.) Quarter Forecast 9 10 11 12
The table below shows the forecast for Company X over the next four quarters. Management has...
The table below shows the forecast for Company X over the next four quarters. Management has decided to use a level capacity strategy with 20 employees. The company works 1 eight hour shift a day, and workers are given 2 paid 15 minute breaks. It takes 2 hours to make a unit and the company works 60 days in a quarter. What would be the production plan in every quarter under this plan? (Round any fractional output to the nearest...
Using either Excel's Data Analysis/Solver Add-in or Excel QM for the following problem: A major source...
Using either Excel's Data Analysis/Solver Add-in or Excel QM for the following problem: A major source of revenue in Texas is a state sales tax on certain types of goods and services. Data are com- piled, and the state comptroller uses them to project future revenues for the state budget. One particular category of goods is classified as Retail Trade. Four years of quarterly data (in $1,000,000s) for one particular area of southeast Texas follow: QUARTER                  YEAR 1         ...
The table below shows the results of two methods (Forecast 1 and Forecast 2) of forecasting...
The table below shows the results of two methods (Forecast 1 and Forecast 2) of forecasting for frozen prepared dinners, as well as the demand for the five periods.          PREDICTED DEMAND Period Demand F1 F2 1 68 67 65 2 75 72 64 3 70 72 70 4 74 67 70 5 69 75 74 6 72 67 79 7 80 74 77 8 78 73 81          a. Compare the accuracy of Forecast 1 and Forecast 2 by...
QUESTION 1 TABLE 11-2 A realtor wants to compare the mean sales-to-appraisal ratios of residential properties...
QUESTION 1 TABLE 11-2 A realtor wants to compare the mean sales-to-appraisal ratios of residential properties sold in four neighborhoods (A, B, C, and D). Four properties are randomly selected from each neighborhood and the ratios recorded for each, as shown below. A: 1.2, 1.1, 0.9, 0.4 C: 1.0, 1.5, 1.1, 1.3 B: 2.5, 2.1, 1.9, 1.6 D: 0.8, 1.3, 1.1, 0.7 Interpret the results of the analysis summarized in the following table: Source df SS MS F PR >...
Using only the California sales data through Excel Date Chicago Seasonal Relatives for Chicago Sales California...
Using only the California sales data through Excel Date Chicago Seasonal Relatives for Chicago Sales California New York 1/4/18 152 0.3 640 456 1/5/18 195 0.4 586 650 1/6/18 653 1.5 420 543 1/7/18 187 0.5 645 632 1/8/18 240 0.6 507 546 1/9/18 207 0.8 623 531 1/10/18 311 0.9 511 544 1/11/18 373 1.2 500 639 1/12/18 225 0.5 576 570 1/13/18 276 0.3 540 544 1/14/18 475 0.7 475 674 1/15/18 755 1.1 645 711 1/16/18 732...
Year Quarter Sales ($000) 2015 1 $400 2015 2 2,000 2015 3 3,500 2015 4 260...
Year Quarter Sales ($000) 2015 1 $400 2015 2 2,000 2015 3 3,500 2015 4 260 2016 1 740 2016 2 2,720 2016 3 4,900 2016 4 520 2017 1 1,500 2017 2 3,100 2017 3 6,520 2017 4 960 2018 1 1,840 2018 2 4,040 2018 3 7,680 2018 4 1,640 2019 1 3,520 2019 2 5,640 2019 3 8,900 2019 4 3,620 Problem 2 House Depot’s quarterly sales of a lawn, landscaping, and gardening items – like lawnmowers,...