Question
In: Finance
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 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.
- Explain how you could make your forecast’s results more reliable by incorporating a qualitative research to your quantitative results.
PreviousNext
Solutions
Expert Solution
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.
jeff jeffy answered 1 year agoRelated 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
Latest Questions
- For Questions 1-3: consider the following code: public class A { private int number; protected String...
- You are tasked with assessing the health department’s intervention program in preventing recurrence of acute alcohol...
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
ADVERTISEMENT