Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Table below gives information about the cubed meat sales of a butcher through November 2 0 1 6 October 2 0 1 7 . Estimate

Table below gives information about the cubed meat sales of a butcher through November 2016 October 2017. Estimate the next months (November 2017) forecasted sales value by using the techniques mentioned below:
Period Sales (kg)
2016 November 20
December 21
2017 January 15
February 14
March 13
April 16
May 17
June 18
July 20
August 20
September 21
October 23
a) Nave method
b)3-month moving average
c) Exponential smoothing with alpha 0.3 and forecast value 18.2 for November 2016.
d) Use RMSE model and decide which technique (simple moving average or exponential) is better? Briefly explain.
e) Plot the monthly data, moving averages and exponential smoothing estimates. Briefly explain the pattern.
f) Use trend linear model to forecast next two months. Briefly explain.
g) Determine the correlation coefficient, coefficient determination and standard deviation. Briefly explain.Table below gives information about the cubed meat sales of a butcher through November 2016 October 2017. Estimate the next months (November 2017) forecasted sales value by using the techniques mentioned below:
Period Sales (kg)
2016 November 20
December 21
2017 January 15
February 14
March 13
April 16
May 17
June 18
July 20
August 20
September 21
October 23
a) Nave method
b)3-month moving average
c) Exponential smoothing with alpha 0.3 and forecast value 18.2 for November 2016.
d) Use RMSE model and decide which technique (simple moving average or exponential) is better? Briefly explain.
e) Plot the monthly data, moving averages and exponential smoothing estimates. Briefly explain the pattern.
f) Use trend linear model to forecast next two months. Briefly explain.
g) Determine the correlation coefficient, coefficient determination and standard deviation. Briefly explain.

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_2

Step: 3

blur-text-image_3

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

Supply Chain Logistics Management

Authors: Donald Bowersox, David Closs, M. Bixby Cooper

4th edition

78024056, 978-0078024054

More Books

Students also viewed these General Management questions

Question

Briefl y discuss the theories of wage determination.

Answered: 1 week ago