Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Week Demand for Fertilizer

image text in transcribed
Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Week Demand for Fertilizer (1,000 of bags) 10 8 9 12 10 14 11 15 Calculate the forecast of the price for week 12 by using 3 weeks weighted moving average (WMA). Use the weight of 3 for the latest period, 2 for the second latest period and 1 for the third latest period (4 marks) (b) Calculate the forecast of the price for week 12 by using exponential moving average (EMA) model with a = 0.2 as the smoothing constant Initial week 1 forecast was 4. (5 marks) Determine the forecast error of (@) and (b) using mean squared error (MSE) and mean absolute deviation (MAD) (14 marks) Justify which forecast is more accurate based on answer in (c). (2 marks) [Total: 25 marks]

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 Statistics for Contemporary Decision Making

Authors: Ken Black

6th Edition

978-0470409015, 9780470559062, 470409010, 470559063, 978-0470910184

More Books

Students also viewed these Economics questions

Question

Relate the companies roll in employee health and wellness.

Answered: 1 week ago