Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Week 1 2 3 4 5 6 7 8 9 10 11 12 Sales (1,000s of gallons) 17 21 19 24 18 16 21 18 22 20 15 22 (a) Compute four-week and five-week moving averages for the time series. Week 1 2 3 4 5 01 6 7 8 10 11 12 Time Series Value 17 21 19 24 18 16 21 18 22 20 15 22 4-Week Moving Average Forecast 5-Week Moving Average Forecast (b) Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.) (c) What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? MSE for the three-week moving average is 11.70. Three weeks appears to be best, because the three-week moving average provides the smallest MSE. Three weeks appears to be best, because the three-week moving average provides the largest MSE. Four weeks appears to be best, because the four-week moving average provides the smallest MSE. Five weeks appears to be best, because the five-week moving average provides the smallest MSE. None appear better than the others, because they all provide the same MSE. 0000 Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Week 1 2 3 4 5 6 7 8 9 10 11 12 Sales (1,000s of gallons) 17 21 19 24 18 16 21 18 22 20 15 22 (a) Compute four-week and five-week moving averages for the time series. Week 1 2 3 4 5 01 6 7 8 10 11 12 Time Series Value 17 21 19 24 18 16 21 18 22 20 15 22 4-Week Moving Average Forecast 5-Week Moving Average Forecast (b) Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.) (c) What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? MSE for the three-week moving average is 11.70. Three weeks appears to be best, because the three-week moving average provides the smallest MSE. Three weeks appears to be best, because the three-week moving average provides the largest MSE. Four weeks appears to be best, because the four-week moving average provides the smallest MSE. Five weeks appears to be best, because the five-week moving average provides the smallest MSE. None appear better than the others, because they all provide the same MSE. 0000
Expert Answer:
Related Book For
Posted Date:
Students also viewed these general management questions
-
If the focal length of a lens is 3 centimeters and the image distance is 5 centimeters from the lens, what is the distance from the object to the lens?
-
A manufacturer purchases a part for use at both of its plants-one at Roseville, California, the other at Akron, Ohio. The part is available in limited quantities from two suppliers. Each supplier has...
-
On April 23, 2022, Protanica Company, a florist, purchased $112,000 of merchandise, terms were 3/15, n/45 from Botail Garden Center. Protanica returned $7,500 of damaged merchandise to Botail, which...
-
a. Distinguish between internal common equity and new common stock. b. Why is there a cost associated with internal common equity? c. Describe two approaches that could be used in computing the cost...
-
The rod in Problem 34.78 is shortened to a distance of 25.0 cm between its vertices; the curvatures of its ends remain the same. As in Problem 34.78, the object for the surface at the left end is an...
-
Explain uniform pressure and uniform wear theories for a clutch.
-
Picture Gallery, Inc. works weddings and prom-type parties. The balance of retained earnings was \($18,000\) at December 31, 2010. At December 31, 2011, the businesss accounting records show these...
-
Nick Company had the following transactions during April. 1. Sold merchandise on account. 2. Purchased merchandise on account. 3. Collected cash from a sale to Athletic Company. 4. Recorded accrued...
-
Cheyenne Manufacturing Corporation uses both standards and budgets. The company estimates that production for the year will be 100,000 units of Product Fast. To produce these units of Product Fast,...
-
Refer to the FY2016 income statement and balance sheet for General Mills, Inc. (GMI), along with the forecasted FY2017 income statement that you computed in the last exercise. Use that information...
-
The budgets of four companies yield the following information: Company Blue Red Green Yellow Net Sales Revenue $ 1,900,000 (d) $ 1,500,000 (1) Variable Costs (a) 47,250 1,050,000 256,200 Fixed Costs...
-
What is an on-site tour? What is its purpose?
-
Explain the economic benefits of a financial statement audit.
-
Describe the opening conference.
-
A control deviation caused by an employee performing a control proce- dure that he or she is not authorized to perform is always considered a a. Deficiency in design. b. Deficiency in operation. c....
-
What distinguishes preliminary surveys from other audit preparation?
-
You've been added to the DB design team for a small company, and tasked with creating a table or tables as needed to keep track of the company's employees (this will eventually be integrated with the...
-
Refer to the data for problem 13-36 regarding Long Beach Pharmaceutical Company. Required: Compute each division's residual income for the year under each of the following assumptions about the...
-
The weights in ounces of a sample of running shoes for men and women are shown. Calculate the variances for each sample, and test the claim that the variances are equal at = 0.05. Use the P-value...
-
In a Gallup Poll of 1005 individuals, 452 thought they were worse off financially than a year ago. Find the 95% confidence interval for the true proportion of individuals who feel they are worse off...
-
At a large factory, the employees were surveyed and classified according to their level of education and whether they smoked. The data are shown in the table. If an employee is selected at random,...
-
Find an organization that used FEMAs four phase framework of emergency management and explain what and how they did it.
-
Of the seven community lifelines, which ones must be done first. Justify your conclusion.
-
Select one of the five operations management categories and explain how it can help managers and organizations plan and build supply chain capability for disruptions or disasters.
Study smarter with the SolutionInn App