Question: Question #3 1. From the data base for the company sales during the last six years were shown in the table below, so calculate the

Question #3 1. From the data base for the company

Question #3 1. From the data base for the company sales during the last six years were shown in the table below, so calculate the following parameters for forecasting the sales for next year (2021). Period (Years) 2015 2016 2017 2028 2019 2020 Actual (sales) 1550 1940 2123 2400 2812 3511 Forecast (sales) 1670 2070 2543 3100 3320 4000 IN a) The Error (difference between actual value and predicted value) for the previous (6) years according to following: Mean Absolute Deviation (MAD) ii. Mean Squared Error (MSE) Mean Absolute Percent Error (MAPE) b) The forecast of the seventh year (2021) according to the following techniques: i. Simple Moving Average. Weighted Moving Average by assuming the weights (3.0,2.5,2.0,1.5,1.0. 0.5) Exponential Smoothing by assuming (a = 0.2) iv. Linear Trend 2. From the data base for the company sales during the last year, which was shown in the table below, so calculate the productivity accordingly. a) Single factor productivity for the last year for each parameter (labor, materials & overhead). b) Multifactor productivity for the last year (Factors), Overhead Cost Produced Units 9000 Sales SR/unit 2.5 Labor Cost (SR) 1200 Materials Cost (SR) 800 (SR) 4000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!