Question: 1. Create a forecast for the data set provided using the regression formula. [Total - 85 marks] a. What is the forecasted value for November

1. Create a forecast for the data set provided using the regression formula. [Total - 85 marks] a. What is the forecasted value for November 2019? [60 marks] b. What is the forecast for the demand in the next three years? [20 marks] c. Does the forecast follow seasonality? [5 marks]

Year Month Demand 2014 January 238

February 228

March 213

April 200

May 202

June 201

July 217

August 224

September 230

October 224

November 201

December 235 2015 January 271

February 261

March 246

April 233

May 235

June 234

July 250

August 257

September 263

October 257

November 234

December 268

2016 January 339

February 329

March 314

April 301

May 303

June 302

July 318

August 325

September 331

October 325

November 302

December 336

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!

1. Create a forecast for the data set provided using the regression formula. [Total - 85 marks] a. What is the forecasted value for November 2019? [60 marks] b. What is the forecast of the demand in...

Create a forecast for the data set provided using the regression formula. [Total - 85 marks] a. What is the forecasted value for November 2019? [60 marks] b. What is the forecast of the demand in the...

GIVIISI V. Common Size Income Statement Prepare a common size income statement for two years and compare/contrast the changes (Refer to chapter 17) VI. Ratio Analysis of Financial Statements Prepare...

Plasma Pathology has incurred the following costs in its diagnostic blood laboratory during the past 12 months: Month Number of blood test completed Cost January 6100 $90000 February 5300 87000 March...

Hi, I need help with a statistics assignment related to excel. Properties sold in Melboune Property Location 3 1 8 1 28 1 29 1 30 1 31 1 34 1 37 1 45 1 47 1 51 1 54 1 55 1 56 1 57 1 58 1 60 1 61 1 62...

my questions Exercise 13.5 (Hard) Tammy lives for two periods. In the first period of life she works ` hours at a wage of w per hour. In the second period of life she is retired and supplies no...

MM305 Unit 7 Project Name: Holly Peterson 1. Even though independent gasoline stations have been having a difficult time, Susan Solomon has been thinking about starting her own independent gas...

oalll Question: Put together a portfolio of work documents you have drafted and written. If you are working you can use actual workplace documents, with identifying names redacted. Do not include any...

Section B (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "?" in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel...

JX A B C Electricity cost ($) Average outdoor temperature (OF) Tons of product QUESTION 3 24100 26 The facility manager at a sports textile company wants to build a regression model to forecast 23700...

Circle the functional groups in the following structures. State to which class (or classes) of compounds the structure belongs. (a) CH2=CHCH2COOH3 (b) CH3OCH3 (c) CH3CHO (d) CH3CONH2 (e) CH3NHCH3 (f)...

Mac Tools is trying to find out if increasing sales or cutting costs is more effective. Mac Tools has a profit margin of 9.06432749%, COGS of 126,000,000, sales of 171,000,000, pre-tax earnings of...

How can a firm hedge short-run exchange rate risk? Long-run exchange rate risk?

Financial Statements and Closing Entries Last Chance Company offers legal consulting advice to prison inmates. Last Chance Company prepared the end-of-period spreadsheet that follows at June 30,...