Question

In: Statistics and Probability

The following table presents the orders of Samson Company for the last 36 months (3 years)....

The following table presents the orders of Samson Company for the last 36 months (3 years).

Month

Order Year 1

Order Year 2

Order Year 3

January

450

600

612

February

418

575

668

March

490

580

680

April

451

534

653

May

466

555

674

June

511

604

702

July

522

624

724

August

500

612

716

September

502

633

712

October

523

634

724

November

533

643

735

December

534

676

755

  1. Use the data in the above table and regression analysis to forecast the orders for the next 12 months (4th year). Include your excel work sheet and your work in your write up. Show the regression equation, values of intercept, slope, correlation coefficient and coefficient determination and the forecast of orders for the next 12 months.
  2. Explain how you could make your forecast’s results more reliable by incorporating a qualitative research to your quantitative results.

Solutions

Expert Solution

ANSWER::

FORMULAS:

Slope

b1= nE(xy)-ExEy/nE(x2)-(Ex2)

Intercept b0=Ey-b1Ex/n
Regression n(Exy)-(Ex)(Ey)/sqrt(nEx2-(Ex)2)(nEy2-(Ey)2)

By including qualitative factors such as customer's preferences, external variables, regulatory changes, one can make the forecast more robust and reduce the error in the forecast. Also, this would lead to better planning and optimizing the inventory in the process.

NOTE:: I HOPR THIS ANSWER IS HELPFULL TO YOU......**PLEASE SUPPORT ME WITH YOUR RATING......

**PLEASE GIVE ME "LIKE".....ITS VERY IMPORTANT  FOR,ME......PLEASE SUPPORT ME .......THANK YOU


Related Solutions

the following table presents the orders of Samson Company for the last 36 months (3 years)....
the following table presents the orders of Samson Company for the last 36 months (3 years). Month Order Year 1 Order Year 2 Order Year 3 January 450 600 612 February 418 575 668 March 490 580 680 April 451 534 653 May 466 555 674 June 511 604 702 July 522 624 724 August 500 612 716 September 502 633 712 October 523 634 724 November 533 643 735 December 534 676 755 Use the data in the above...
The following table presents the orders of Samson Company for the last 36 months (3 years)....
The following table presents the orders of Samson Company for the last 36 months (3 years). Month Order Year 1 Order Year 2 Order Year 3 January 450 600 612 February 418 575 668 March 490 580 680 April 451 534 653 May 466 555 674 June 511 604 702 July 522 624 724 August 500 612 716 September 502 633 712 October 523 634 724 November 533 643 735 December 534 676 755 Use the data in the above...
The following table presents the orders of Samson Company for the last 36 months (3 years)....
The following table presents the orders of Samson Company for the last 36 months (3 years). Month Order Year 1 Order Year 2 Order Year 3 January 502 614 712 February 408 592 698 March 491 584 686 April 456 532 644 May 481 599 694 June 511 604 702 July 522 624 724 August 500 612 716 September 510 625 732 October 512 627 740 November 520 650 745 December 536 680 756 1. Use the data in the...
A 36 years old Caucasian obese female presents to the ER with a complaint of epigastric...
A 36 years old Caucasian obese female presents to the ER with a complaint of epigastric pain for the last 2 days. The pain radiates through to her back, is constant, sharp in nature, and reliever with sitting up. Associated symptoms include nausea and non-bloody emesis. Eating makes the pain worse and therefore she has not eaten for the last 24 hours. She is married with 2 children. She denies any alcohol or drug use. On assessment she is afebrile,...
The following table gives the age (in years) of 36 randomly selected U.S. millionaires. The sample...
The following table gives the age (in years) of 36 randomly selected U.S. millionaires. The sample mean x−=58.53 years. Assume that the standard deviation of ages of all U.S. millionaires is 13.0 years.   Test at the 10% significance level whether the average year of all U.S. millionaires is above 55 years. What is the P-value of the hypothesis test in part (a)? Obtain a confidence interval corresponding to the hypothesis test in part (a). Does the interval in part (c)...
Assume a loan of $30,000, 36 months, 6.5% interest. Generate a table of payments showing the...
Assume a loan of $30,000, 36 months, 6.5% interest. Generate a table of payments showing the principal payment and the interest payment for each of the 36 months.
3. The following table presents data on the presence and absence of respiratory distress syndrome (RDS)...
3. The following table presents data on the presence and absence of respiratory distress syndrome (RDS) in two groups of infants. Group 1 consisted of 42 infants whose fetal membrances ruptured 24 hours or less before delivery, while group 2 was composed of 22 infants whose membrances ruptured more than 24 hours before delivery. Test the null hypothesis that the two populations are homogeneous. Let α=.05. Incidence of respiratory distress syndrome (RDS) in two groups of infants RDS Group Yes...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 31...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 31 2 34 3 35 4 39 5 40 6 45 7 45 8 47 9 43 10 44 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 31. (Round your answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.30, a...
The following table contains the demand from the last 5 months. Month Actual Demand 1 25...
The following table contains the demand from the last 5 months. Month Actual Demand 1 25 2 30 3 33 4 35 5 38 Calculate the single exponential smoothing forecast for these data using an α of 0.3 and an initial forecast (F1) of 28. Report the forecast for Month 6 in AnswerSheet. Show your work in worksheet “Show your work for Q1.” (2 pts.) Calculate the exponential smoothing with trend forecast for these data using an α of 0.25,...
The following table shows the actual demand observed over the last 11 years
The following table shows the actual demand observed over the last 11 years Year1234567891011Demand7951013713149118This exercise contains only parts b, c, and d.b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Year456789101112Forecastc) Using the 3-year weighted moving average with weights 0.20. 0.35. and 0.45. using 0.45 for the most recent period provide the forecast from periods 4 through 12.Year456789101112Forecastd) Mean absolute deviation for the forecast developed using the 3-year moving average...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT