Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 . Barbara Lynch is the product manager for a line of skiwear produced by HeathCo Industries and privately branded for sale under several different

1. Barbara Lynch is the product manager for a line of skiwear produced by HeathCo Industries and privately branded for sale under several different names, including Northern Slopes and Jacque Monri. A new part of Ms. Lynch's job is to provide a quarterly forecast of sales for the northern United States, a region composed of 27 states stretching from Mame to Washington. A 10-year sales history is shown:a. Because Ms. Lynch has so many other job responsibilities, she has hired you to help with the forecasting effort. First, she would like you to prepare a time-series plot of the data and to write her a memo indicating what the plot appears to show and whether it seems likely that a simple linear trend would be useful in preparing forecasts. b. In addition to plotting the data over time. you should estimate the least-rquares trend line in the form: SALES -a+b( TIME ) Set TIME =1 for 2007 Q 1 through TIME =40 for 20 I6Q4. Write the trend equation: SALES =4(TIME)(Circle + or - as appropriate) c. Do your regression results indicate to you that there is a significant tiend to the data? Explain why or why not. d. On the basis of your results, prepare a forecast for the four quarters of 2017. Q 2=328.982, Q 3=317,921. and Q 4=330.118. How accurale was your moded What was the meen absohine perontage mioc (MAPE)

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

Successful Time Management

Authors: Patrick Forsyth

4th Edition

0749475811, 978-0749475819

More Books

Students also viewed these General Management questions