Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sales in (thousands of dollars) of a new shirt designed for the current temperatures is given below for the first three weeks (Monday to Friday)

Sales in (thousands of dollars) of a new shirt designed for the current temperatures is given below for the first three weeks (Monday to Friday) at JPK Inc. The company wants to use the partial Excel Summary Output and the Time Series data below to develop a regression equation and use seasonal indexes to estimate their sales. Note: time period (t=1, 2, 3, …)

Quarter

Sales

t

Y/ ŷ

Week 1

M

47

0.958

T

51

1.031

W

45

0.903

T

56

1.115

F

57

1.127

Week 2

M

46

0.902

T

50

0.974

W

45

0.870

T

59

1.132

F

61

1.162

Week 3

M

48

T

50

W

46

T

57

F

58


  1. Calculate the seasonal indexes to three decimal placesshow your calculations. (5 marks)

  2. Forecast the sales on Friday of week 4. (2 marks)

Step by Step Solution

3.32 Rating (152 Votes )

There are 3 Steps involved in it

Step: 1

answer Answer Data Analysis The table shows the average sales ... 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

Applied Regression Analysis And Other Multivariable Methods

Authors: David G. Kleinbaum, Lawrence L. Kupper, Azhar Nizam, Eli S. Rosenberg

5th Edition

1285051084, 978-1285963754, 128596375X, 978-1285051086

More Books

Students also viewed these General Management questions

Question

Find the quantity if v = 3i - 5j and w = -2i + 3j. |v | + |w|

Answered: 1 week ago