Question
In: Finance
Problem 1: The following table shows the number of gallons of gasoline sold by a gasoline...
Problem 1: The following table shows the number of gallons of gasoline sold by a gasoline distributor in Providence, Rhode Island, over the past 7 weeks. Forecast sales using a 3-week weighted moving average where the weights are 3, 2, and 1.
| Week | Sales (100s of Gallons) |
| 1 | 17 |
| 2 | 21 |
| 3 | 19 |
| 4 | 23 |
| 5 | 18 |
| 6 | 16 |
| 7 | 20 |
Solutions
Expert Solution
3 week weighted moving average is calculated with the help of weights given as 3,2 and 1. For the nearest week, the highest weight is considered.
In this case, F4 = 3*Sales of week 3 + 2*Sales of week 2 + 1*Sales of week 1. similarly for other weeks.
Solution is in the below image.
jeff jeffy answered 3 years agoRelated Solutions
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in...
Suppose these data show the number of gallons of gasoline sold
by a gasoline distributor in Bennington, Vermont, over the past 12
weeks.
Week
Sales (1,000s
of gallons)
1
17
2
21
3
19
4
23
5
18
6
16
7
21
8
19
9
23
10
21
11
16
12
23
(a) Using a weight of 1/2 for the most recent
observation, 1/3 for the second most recent observation, and
1/6 for third most recent observation, compute a
three-week weighted moving...
These data show the number of gallons of gasoline sold by a gasoline distributor in Bennington,...
These data show the number of gallons of gasoline sold by a
gasoline distributor in Bennington, Vermont, over the past 12
weeks.
Week
Sales (1,000s
of gallons)
1
17
2
21
3
19
4
23
5
18
6
16
7
20
8
18
9
22
10
20
11
15
12
22
(a)
Compute four-week and five-week moving averages for the time
series.
Week
Time Series
Value
4-Week
Moving
Average
Forecast
5-Week
Moving
Average
Forecast
1
17
2
21
3
19...
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in...
Suppose these data show the number of gallons of gasoline sold
by a gasoline distributor in Bennington, Vermont, over the past 12
weeks.
Week
Sales (1,000s
of gallons)
1
17
2
22
3
20
4
24
5
19
6
17
7
21
8
18
9
23
10
21
11
16
12
22
(a)
Compute four-week and five-week moving averages for the time
series.
Week
Time Series
Value
4-Week
Moving
Average
Forecast
5-Week
Moving
Average
Forecast
1
17
2
22
3...
Bob Nale would like to determine the mean number of gallons of gasoline sold to his...
Bob Nale would like to determine the mean number of gallons of
gasoline sold to his customers. Assume the number gallons of
gasoline sold is 2 gallons. From his records, he selects 64 samples
and finds the mean is 9 gallons. Find the 95% confidence interval
for the population mean.
Following table shows the probability distribution for the number of bathrooms for homes sold in the...
Following table shows the probability distribution for the
number of bathrooms for homes sold in the Goodyear, Arizona.
Number of baths (X)
Count
1.5
16
2.0
65
2.5
15
3.0
9
Total
105
Compute the mean and the standard deviation of this
distribution.
The following table shows part of the probability distribution for the number of boats sold daily...
The following table shows part of the probability distribution
for the number of boats sold daily at Boats Unlimited. It is known
that the average number of boats sold daily is 1.57. x f(x) 0 0.20
1 0.30 2 0.32 3 ? 4 0.05 5 0.02 Compute the variance and the
standard deviation for this probability distribution.
The following table shows part of the probability distribution for the number of boats sold daily...
The following table shows part of the probability distribution
for the number of boats sold daily at Boats Unlimited. It is known
that the average number of boats sold daily is 1.57. x f(x) 0 0.20
1 0.30 2 0.32 3 ? 4 0.05 5 ? Complete the distribution by computing
the probabilities of selling 3 nd 5 boats per day.
All boats sell for $2000. What is the standard deviation of the
daily revenue of the company?
The following table shows the frequency distribution for the number of personal computers sold during the...
The following table shows the frequency distribution for the
number of personal computers sold during the past month in a
sample of 40 computer stores located on the
island.
Computers sold
Number of stores
4 < 13
6
13 < 22
9
22 < 31
14
31 < 40
7
40 < 49
4
Calculate the mean. Provide your answer to a decimal place.
Following table shows the monthly sales of cars at a dealership: Month Number of cars Sold...
Following table shows the monthly sales of cars at a
dealership:
Month
Number of cars Sold
1
79
2
79
3
86
4
93
5
101
6
107
7
102
8
What is the Trend equation for the above data?
What is the expected sales for the 8th month based on
the Trend method?
How much error is there in this forecasting method using
MAD?
The following table shows the number of cars sold last month by six dealers at Centreville...
The following table shows the number of cars sold last month by
six dealers at Centreville Nissan dealership and their number of
years of sales experience.
Years of Experience
Sales
1
7
2
9
2
9
4
8
5
14
8
14
A: Management would like to use simple regression analysis to
estimate monthly car sales using the number of years of sales
experience. Estimate and interpret the following: a) Regression
Equation, b) Slope, c) y-intercept.
B: what happens when...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- For the past several weeks you have addressed several different areas of telecommunications and information technology...
- Draw the structure of a compound with molecular formula C5H12 that exhibits only one kind of...
- (1) Discuss your reaction to Hitler's Degenerate Art Show. Is it ever justified for a government...
- The probability of success is 0.68. A sample of 15 is taken. Assume independent trials. (Please...
- The following data are taken from the financial statements of Sigmon Inc. Terms of all sales...
- what is Transcranial magnetic stimulation (TMS)? For who and when is it used on? How effective...
- A value stream has three activities and two products. The units produced and shipped per week...
ADVERTISEMENT