Q1 create a graph of widget sales on the tab q1-graph and, Ask an Expert

Management Studies

Q1 Create a graph of widget sales on the tab "Q1-Graph" and characterize the time series. That is, does the time series appear to include the effects of (1) cyclicality, (1) seasonality, (1) trend, (1) irregular variation and, or (1) noise? Please characterize each effect as appropriate.

Q2 Prepare the following forecasting methods using the template provided on "Data" tab and assess how well each method is performing (RSFE, MAD, MSE, and MAPE using the appropriate columns from I-AF) and indicate which method is performing the best and why:

A. 3-month moving average (use "Data" tab, column C)

B. 6-month moving average (use "Data" tab, column D)

C. 3-month weighted moving average (.65, .2, .15) (use "Data" tab, column E)

D. Single exponential smoothing (α=.3), enter smoothing constant into cell F2 and use this cell in the calculations for SES (Use "Data" tab, column F)

Q3: Create a graph of widget Sales on tab "Q3-Graph" and then add to the graph the forecasts that you calculated in Q2.

View complete question

Marketing Management, Management Studies

Category:- Marketing Management
Reference No.:- M9524321

Have any Question?Write your Review or question?

Related Questions in Marketing Management

Question we chose ford to market a devise that will alert

Question: We chose Ford to market a devise that will alert you if you accidently left the child in the car. 1. A report with the final Marketing Plan that includes the three previous drafts, attached as an MS Word file. ...

Marketing design and innovation assignment -you are

Marketing Design and Innovation Assignment - You are required to select a contemporary consumer, industrial or commercial product or service that for one reason or another inspires you to critique within the context of t ...

Question review the followingbullfrom the great depression

Question: Review the following: • From the Great Depression Through the Great Recession: A Brief History of Marketing • The Evolution of Marketing • Vintage Ad Browser Select one product category from the Vintage Ad Brow ...

Question choose only one of the following learning outcomes

Question: Choose ONLY ONE of the following learning outcomes below. Describe how you were able to demonstrate the outcome within the course. Provide specific examples referencing submitted work, class activities, and Moo ...

Question write a 2-3 page double spaced narrative response

Question: Write a 2-3 page (double spaced) narrative response. Be sure to address every point within the prompt. Submit as DOC, DOCX, PDF, or RTF file attachments. Prompts: Recommended after Lecture 8 Find one commercial ...

Question respond to the followinghow has the internet

Question: Respond to the following: How has the internet affected marketing research? As a part of your answer address time, cost, approaches, or validity. The response must be typed, single spaced, must be in times new ...

Question you will research the various elements of the

Question: You will research the various elements of the marketing plan as it relates to this company. In Unit VI you will provide a comprehensive discussion of the promotion strategies of your company. Promotion This sec ...

Assignment -context you are required to select a

Assignment - Context: You are required to select a contemporary consumer, industrial or commercial product or service that for one reason or another inspires you to critique within the context of this module. Explain why ...

Strategic marketing proposalassessment descriptionyou are

Strategic Marketing Proposal Assessment description You are the Marketing Development Team of a global organisation. Your team is to plan for an integrated marketing communications launch of a new product. You are requir ...

Quesiton watch the videob pinkberry and answer the

Quesiton: Watch the video,B Pinkberry, and answer the following questions: • How would you update the personality of the brand to reinvigorate Pinkberry? Provide a rationale for your answer. • Determine the most viable t ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Marketing Management Expert