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 fourweek and fiveweek 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 4Week Moving Average Forecast 5Week Moving Average Forecast (b) Compute the MSE for the fourweek moving average forecasts. (Round your answer to two decimal places.) Compute the MSE for the fiveweek 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 threeweek moving average is 11.70. Three weeks appears to be best, because the threeweek moving average provides the smallest MSE. Three weeks appears to be best, because the threeweek moving average provides the largest MSE. Four weeks appears to be best, because the fourweek moving average provides the smallest MSE. Five weeks appears to be best, because the fiveweek 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 fourweek and fiveweek 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 4Week Moving Average Forecast 5Week Moving Average Forecast (b) Compute the MSE for the fourweek moving average forecasts. (Round your answer to two decimal places.) Compute the MSE for the fiveweek 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 threeweek moving average is 11.70. Three weeks appears to be best, because the threeweek moving average provides the smallest MSE. Three weeks appears to be best, because the threeweek moving average provides the largest MSE. Four weeks appears to be best, because the fourweek moving average provides the smallest MSE. Five weeks appears to be best, because the fiveweek 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 plantsone 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...

On December 31, 2008, Lakeside Co. shows the following account for machinery it had assembled for its own use during 2008: An analysis of the details in the account disclosed the following: (a) The...

An aluminum beam was brought from the outside cold into a machine shop where the temperature was held at 65F. After 10 min, the beam warmed to 35F and after another 10 min it was 50F. Use Newtons Law...

The John Gore Organization owns and operates the Charles Playhouse, a theater in Boston, Massachusetts. Evelyn Castillo has diabetes, a disability under the Americans with Disabilities Act (ADA)....

Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, and ships them to its chain of retail stores. Upton's balance sheet as of December 31, 2004,...

A 20 kg dog requires treatment with ketoconazole at 5 mg/kg by oral suspension. The suspension contains 100 mg/5 mL oral solution. What volume does the dog require per dose?

You are a health care manager at a nursing home. You are looking to expand your business arrangements and your boss suggests Stanford Health as an option. She asks you to do an analysis on their...

Mr. Jones, eager to please the board of directors, requests you, as the newly appointed management accountant, to prepare appropriate statements highlighting the following: a) The standard production...

What has been your experience with leave benefits? What is the role of human resources in managing leave benefits? InText citations and references as needed from accredited academic sites.

What are the characteristic is NOT typically considered in the selection of market comparator firms

Explain the application of market research, segmentation, pricing, targeting, and positioning as they relate to a marketing plan.

What are the ethical dilemmas of Big data in human resources?

Who carries out the role of process improvement and why? What is the role of a Leader in the Coaching Kata mentality

Parul, Payal and Priyanka are partners. They decided to dissolve their firm. Pass necessary Journal Entries for the following after various assets (other than cash and bank) and the third party...

Refer to the data for problem 1336 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 Pvalue...

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,...

Consider your own interests and values. What is important to you and in what do you find meaning or purpose? Given this reflection, what type of social responsibility activities would most appeal to...

With your teammates, look at some of the online jobopening announcements. Consider at least a dozen ads and summarize those that include a description of social responsibility commitments or...

Suppose that you worked for an organization that promoted the establishment and running of selfmanaged teams. As head of HR, you have traditionally taken the lead role in the recruitment and...
Study smarter with the SolutionInn App