Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. A company records reported below indicate monthly sales data for Rasihaba company: Sales Month (000, units) October 2 November 2 December 4 January

1. A company records reported below indicate monthly sales data for Rasihaba company: Sales Month (000, units) October 2 November 2 December 4 January 1 February 3 March 3 April 4 May 5 June 6 July 6 a) Use linear trend model to forecast next 2 months. Briefly explain. (Points 15) b) Determine the correlation coefficient, coefficient determination and standard deviation. Briefly explain. (Points 20) c) Plot the actual and forecasted values on a line graph. Briefly explain. (Points 15) 2. A company records reported below indicate monthly sales data for Rasihaba Company. Use the below mentioned techniques to help the administration: Sales Month (000, units) October 2 November 2 December 4 January February 1 + 3 March 3 April 4 May June 5 6 July 6 + a) 2-month moving average Briefly explain. (Points 15) b) Exponential smoothing with smoothing constant 0.3 and forecast value 3 (000, units) for the first period. Briefly explain. (Points 10) c) Use RMSE model and decide which technique (simple moving average or exponential smoothing) is better? Briefly explain. (Points 15) d) Plot the monthly data, moving averages and exponential smoothing estimates on a line graph. Briefly explain the pattern. (Points 10)

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

Business Forecasting

Authors: John E. Hanke, Dean Wichern

9th edition

132301202, 978-0132301206

More Books

Students also viewed these General Management questions

Question

What causes an Multiples Sclerosis plaque?

Answered: 1 week ago

Question

marketing research pros and cons

Answered: 1 week ago