Question

In: Operations Management

. . The table below shows the sales of SCORE Detergent from the past two years....

.

. The table below shows the sales of SCORE Detergent from the past two years.

YEAR QUARTERS ACTUAL
2019 Q1 300
Q2 540
Q3 885
Q4 580
2020 Q1 416
Q2 760
Q3 1191
Q4 760


Required: A. Use the seasonality method to predict the forecast for all the four quarters of 2021.

Solutions

Expert Solution

Answer: Q1 - 521, Q2 -945, Q3 -1509, Q4-974

Step 1:

Calculate the Seasonal Factor

Seasonal Factor For Q1 (S1) = Total of Q1 Demand / Total Demand = 716/5432 =0.131811

S2 = 1300/5432 = 0.239323

S3 = 2076/5432 = 0.38218

S4 = 1340/5432 = 0.246686

Step 2: Demand Forecast for the Year 2021

Compute trend line using a regression for the year of the data in the table

For x =3 (year 2021)

y = 1483 +822 (3) = 3949

Step 3: Compute Seasonal Demand

By Multiplying Forecasted demand of the Year 2021 with seasonal Factor, we can predict Demand for quarters:

Q1 = 0.131811 * 3949 = 521

Q2 = 0.239323 * 3949 = 945

Q3 = 0.38218 * 3949 = 1509

Q4 = 0.246686 * 3949 = 974

keosha answered 1 day ago
Next > < Previous

Related Solutions

The table below shows the monthly sales of a motorcycle store during the last two years....
The table below shows the monthly sales of a motorcycle store during the last two years. Month Sales Month Sales 1 195 13 155 2 210 14 120 3 190 15 135 4 170 16 110 5 180 17 122 6 156 18 97 7 134 19 85 8 155 20 110 9 145 21 85 10 165 22 78 11 128 23 66 12 135 24 45 Compute an exponential smoothing and an adjusted exponential smoothing for the data...
An SAT prep course claims to improve the test score of students. The table below shows...
An SAT prep course claims to improve the test score of students. The table below shows the scores for seven students the first two times they took the verbal SAT. Before taking the SAT for the second time, each student took a course to try to improve his or her verbal SAT scores. Do these results support the claim that the SAT prep course improves the students' verbal SAT scores? Let d=(verbal SAT scores prior to taking the prep course)−(verbal...
An SAT prep course claims to improve the test score of students. The table below shows...
An SAT prep course claims to improve the test score of students. The table below shows the scores for seven students the first two times they took the verbal SAT. Before taking the SAT for the second time, each student took a course to try to improve his or her verbal SAT scores. Do these results support the claim that the SAT prep course improves the students' verbal SAT scores? Let d=(verbal SAT scores prior to taking the prep course)−(verbal...
A magazine tested LCD televisions. The table below shows the overall quality score and cost in...
A magazine tested LCD televisions. The table below shows the overall quality score and cost in hundreds of dollars. Use the rank correlation coefficient to test for a correlation between the two variables. Use a significance level of a=0.05.Based on these​ results, can you expect to get higher quality by purchasing a more expensive LCD​ television? Quality     75 71 67 64 63 60 57 54 54 53 51 Open in StatCrunch + Copy to Clipboard + Open in Excel +...
An SAT prep course claims to improve the test score of students. The table below shows...
An SAT prep course claims to improve the test score of students. The table below shows the scores for seven students the first two times they took the verbal SAT. Before taking the SAT for the second time, each student took a course to try to improve his or her verbal SAT scores. Do these results support the claim that the SAT prep course improves the students' verbal SAT scores? Let d=(verbal SAT scores prior to taking the prep course)−(verbal...
An SAT prep course claims to improve the test score of students. The table below shows...
An SAT prep course claims to improve the test score of students. The table below shows the scores for seven students the first two times they took the verbal SAT. Before taking the SAT for the second time, each student took a course to try to improve his or her verbal SAT scores. Do these results support the claim that the SAT prep course improves the students' verbal SAT scores? Let d=(verbal SAT scores prior to taking the prep course)−(verbal...
An SAT prep course claims to improve the test score of students. The table below shows...
An SAT prep course claims to improve the test score of students. The table below shows the scores for seven students the first two times they took the verbal SAT. Before taking the SAT for the second time, each student took a course to try to improve his or her verbal SAT scores. Do these results support the claim that the SAT prep course improves the students' verbal SAT scores? Let d=(verbal SAT scores prior to taking the prep course)−(verbal...
An SAT prep course claims to improve the test score of students. The table below shows...
An SAT prep course claims to improve the test score of students. The table below shows the scores for seven students the first two times they took the verbal SAT. Before taking the SAT for the second time, each student took a course to try to improve his or her verbal SAT scores. Do these results support the claim that the SAT prep course improves the students' verbal SAT scores? Let d=(verbal SAT scores prior to taking the prep course)−(verbal...
An SAT prep course claims to improve the test score of students. The table below shows...
An SAT prep course claims to improve the test score of students. The table below shows the scores for seven students the first two times they took the verbal SAT. Before taking the SAT for the second time, each student took a course to try to improve his or her verbal SAT scores. Do these results support the claim that the SAT prep course improves the students' verbal SAT scores? Let d=(verbal SAT scores prior to taking the prep course)−(verbal...
An SAT prep course claims to improve the test score of students. The table below shows...
An SAT prep course claims to improve the test score of students. The table below shows the scores for seven students the first two times they took the verbal SAT. Before taking the SAT for the second time, each student took a course to try to improve his or her verbal SAT scores. Do these results support the claim that the SAT prep course improves the students' verbal SAT scores? Let d=(verbal SAT scores prior to taking the prep course)−(verbal...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT