Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with questions 1 5 - 2 0 ! All of them CozyforU is a manufacturer of down jackets. Its director of sales

I need help with questions 15-20! All of them
CozyforU is a manufacturer of down jackets. Its director of sales wants to develop seasonal forecast of sales that accounts for any trend or seasonality. The following table shows sales (in millions of units) of one product model for the past 16 seasons.
Year 1234
Winter 97.1596.2596.1095.35
Spring 56.3555.9056.0557.25
Summer 35.0536.1035.3534.90
Fall 67.9070.0067.6067.45
Question 15: Calculate the slope of the least square regression line starting with Winter of Year 1 as period 1 and ending with Fall of Year 4 as period 16(for example, Fall of Year 1 will be period 4 while Winter of Year 4 will be period 13). If your answer is not an integer, provide at least three decimal places, eCalculate the intercept of the least square regression line starting with Winter of Year 1 as period 1 and ending with Fall of Year 4 as period 16(for example, Fall of Year 1 will be period 4 while Winter of Year 4 will be period 13). If your answer is not an integer, provide at least three decimal places, e.g.,7.500..g.,7.500.
Question 16: Calculate the intercept of the least square regression line starting with Winter of Year 1 as period 1 and ending with Fall of Year 4 as period 16(for example, Fall of Year 1 will be period 4 while Winter of Year 4 will be period 13). If your answer is not an integer, provide at least three decimal places, e.g.,7.500.
Question 17: Use the regression results to calculate the seasonal index for each season of each year. From the indices for all sixteen seasons, calculate the average seasonal index for each season.
What is the Average Seasonal Index for Spring? If your answer is not an integer, provide at least three decimal places, e.g.,7.500.
Question 18: Use the regression results to calculate the seasonal index for each season of each year. From the indices for all sixteen seasons, calculate the average seasonal index for each season.
What is the Average Seasonal Index for Fall? If your answer is not an integer, provide at least three decimal places, e.g.,7.500.
Question 19: Using the regression results and the average seasonal indices, derive a sales forecast (in millions of units) for each season of Year 5 that accounts for both trend and seasonality.
What is the Final Forecast for Winter of Year 5?
Question 20: Using the regression results and the average seasonal indices from part, derive a sales forecast (in millions of units) for each season of Year 5 that accounts for both trend and seasonality.
What is the Final Forecast for Summer of Year 5?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Numeracy Calculations And Practice

Authors: Shane Hunt

1st Edition

9780131976535

More Books

Students also viewed these General Management questions