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...
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...
The data table below shows the number of computers sold at the Bronco Store in a...
The data table below shows the number of computers sold at the
Bronco Store in a week, based on online advertising.
Online
Ads
Computers Sold
2
25
1
10
4
30
1
10
Sx = 10
2
25
Sy = 100
a. Calculate the means for both Ads and Computers Sold.
b. Calculate the slope for the estimated regression
equation.
The (x-x)(y-y) = 40, just need to calculate denominator.
c. Calculate the y-intercept for the estimated regression
equation. ...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Project [2]: Expressions and Operators Project Goals The goal of this project is to: 1. Get...
- Why is public participation important in a community development effort? Research some local efforts at public...
- Using fuel/ air ratios. Find the values to fill in the following combustion reaction chart. Note:...
- Explain why this segmentation strategy works for BMW. (10)
- 2. Do you think a firm operating in many countries is better advised to adopt a...
- 1. Anna knows that she is fat, she should work out but she is often lazy...
- n object with mass 100 kg moved in outer space. When it was at location <6,...
ADVERTISEMENT