Question: Task 2 - Demand Forecasting Mahindra Powerol is a leading brand of diesel generator across India. The sales of Powerol diesel generators over the past

Task 2 - Demand Forecasting Mahindra Powerol is aTask 2 - Demand Forecasting Mahindra Powerol is a

Task 2 - Demand Forecasting Mahindra Powerol is a leading brand of diesel generator across India. The sales of Powerol diesel generators over the past 12-month period of year 2020 is given in Table T2. Actual units sold 470 470 Month January 2020 February 2020 March 2020 April 2020 May 2020 June 2020 460 430 450 490 560 500 July 2020 August 2020 September 2020 October 2020 480 520 November 2020 610 December 2020 640 Table T2 - Sales Data of Year 2020 a. Develop a simple regression model of forecast with the data given in the Table T2 and determine the mean squared error (MSE) of the model. (10 Marks) b. Calculate the monthly demand forecast for the 6-month period from January 2021 to June 2021 using 3-month simple moving average method

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!

Q:

Task 2 - Demand Forecasting Mahindra Powerol is a leading brand of diesel generator across India. The sales of Powerol diesel generators over the past 12-month period of year 2020 is given in Table...

Q:

Task 2 - Demand Forecasting Mahindra Powerol is a leading brand of diesel generator across India. The sales of Powerol diesel generators over the past 12-month period of year 2020 is given in Table...

Q:

Please help Task 2 - Demand Forecasting Mahindra Powerol is a leading brand of diesel generator across India. The sales of Powerol diesel generators over the past 12-month period of year 2020 is...

Q:

Task 2 - Demand Forecasting Mahindra Powerol is a leading brand of diesel generator across India. The sales of Powerol diesel generators over the past 12-month period of year 2020 is given in Table...

Q:

Task 2 Demand Forecasting Mahindra Powerol is a leading brand of diesel generator across India. The sales of Powerol diesel generators over the past 12-month period of year 2020 is given in Table T2....

Q:

Task 2 - Demand Forecasting Mahindra Powerol is a leading brand of diesel generator across India. The sales of Powerol diesel generators over the past 12-month period of year 2020 is given in Table...

Q:

Task 2 - Demand Forecasting Mahindra Powerol is a leading brand of diesel generator across India. The sales of Powerol diesel generators over the past 12-month period of year 2020 is given in Table...

Q:

Task 2-Demand Forecasting Mahindra Powerol is a leading brand of diesel generator across India. The sales of Powerol diesel generators over the past 12-month period of year 2020 is given in Table T2....

Q:

Joshi was at a crossroads: should he borrow money to ramp up the growth of the business through new capacity building or see ServiceForce grow through more and more franchises? Evaluate financial...

Q:

The subject is marketing. Question 1 Based on the information in the case, identify and analyse the marketing environment in India. Discuss how these environmental factors would affect Hyundai Motors...

Q:

Templeton Windows is a small company that installs windows. Its cost structure is as follows: Selling price from each window installation 600 Variable cost of each window installation 400 Annual...

Q:

To ensure the quality of microprocessor chips manufactured by Sigma Electronics, the quality control department samples 100 chips produced each day. These chips are subjected to extreme operating...

Q:

Explain the difference between materials consumption report factory overhead account weighted average method work process inventory accounts conversion cost per equivalent unit equivalent units of...

Q:

What is an example of constructive feedback? provide reference