Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the information provided below to answer the following questions. As a demand planner at Grootegeluk Mine, you want to determine the monthly sales forecast

image text in transcribed
Use the information provided below to answer the following questions. As a demand planner at Grootegeluk Mine, you want to determine the monthly sales forecast of coal (in tonnes). Table 1, below, depicts the volume of coal sold by the mine for each of the 12 months of 2022 Table 1: Volume of coal sold monthly during 2022 REQUIRED: Using the data provided in Table 1, answer each of the following questions: 5.1. Using the three-month weighted moving average method, calculate the monthly forecasts for April 2022 to January 2023 by assigning weights of 0.1,0.3, and 0.6 (the oldest data to the most recent data, respectively) (Round off forecast values to one decimal place). (10 marks) 5.2. Calculate the mean absolute deviation (MAD) of the forecasts for April 2022 to December 2022 (Round off the answer to two decimal place) (5 marks) 5.3. Calculate the mean absolute percentage error (MAPE) of the forecasts for April 2022 to December 2022 (Round off the answer to two decimal place)

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

ISE Business Accounting

Authors: Frank Wood, Alan Sangster

8th Edition

0273638408, 9780273638407

More Books

Students also viewed these Accounting questions

Question

Describe how to get and give criticism effectively.

Answered: 1 week ago