Question
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 |
- Calculate the seasonal indexes to three decimal places, show your calculations. (5 marks)
- 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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended 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
Students also viewed these General Management questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App