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 2 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
- Suppose you are trying to determine the capacity (in gallons) of the gas tank needed on...
- List the arithmetic operators used in BASIC and state their priorities of execution in a statement....
- Describe the espoused values of a company you have worked for (or been exposed to -...
- Can you explain to me the differnces in how we paid for the health care (access...
- Discuss proactive and defensive marketing in context to the company position in the hypothetical market structure...
- Write a java code that could be used to show the simulation of a tornado. use...
- A Canadian company issues an 8-year term bond with face value of $1,000 and 6% coupon...
ADVERTISEMENT