Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are...

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Compare the exponential smoothing with a smoothing constant of 0.3 and a three-year moving average forecasting method, which method do you think is better (use mean absolute deviation MAD for your analysis)? how to analyze each in excel and what determines which is best method?

YEAR	DEMAND FOR FERTILIZER (1,000s OF BAGS)
1	4
2	6
3	4
4	5
5	10
6	8
7	7
8	9
9	12
10	14
11	15

Group of answer choices

The three-year moving average is better.

Can no tell from the data given.

The exponential smoothing method is better

When smoothing constant equal to 0.3, it becomes the same model as the three-year moving average.

Solutions

Expert Solution

orchestra answered 1 year ago

Next > < Previous

Related Solutions

1. Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply...

1. Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a three-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are giveo9n a weight of 2 and sales in the other two years are each given a weight of 1. Which method do you think is best? Year Demand for Fertilizer (1,000s of...

Home Depot sells 50-pound bags of Scott’s Turf Builder fertilizer in its 2,200 retail stores in...

Home Depot sells 50-pound bags of Scott’s Turf Builder fertilizer in its 2,200 retail stores in the United States. The numbers of bags of the fertilizer sold at a certain Home Depot store for a random sample of days are provided below: 65, 55, 96, 39, 74, 55, 49, 116, 63, 81, 55, 57, 39, 44, 36, 80 Answer the questions below using this data. NOTE: Be certain to check your data entry. You will lose a considerable number of...

Tiller Co. makes organic fertilizer sold in one pound bags for the gardener market. The standard...

Tiller Co. makes organic fertilizer sold in one pound bags for the gardener market. The standard material is 25 ounces per bag of assorted meal at a cost of $0.78 per ounce. Tipper Co. budgeted to make 65,000 bags but due to high demand, they ended up making 76,000 bags. They paid $42,000 for 60,000 ounces of meal and used all in production during the period. What is their material cost variance for this period? Enter a favorable variance is...

The following data shows the yearly production data collected from country A and B. Yearly profit...

The following data shows the yearly production data collected from country A and B. Yearly profit in ‘000 Calculate: 1) the coefficient of variation for firms in State A and B 2) the interquartile range for firms in State A and B 3) the median profit for firms in State A and B 4) the mode profit for firms in State A and B 5) the profit variance for firms in State A and B 6) mean deviation from the...

Healthy Foods Inc. sells 50-pound bags of grapes to the military for $25 a bag. The...

Healthy Foods Inc. sells 50-pound bags of grapes to the military for $25 a bag. The fixed costs of this operation are $95,000, while the variable costs of grapes are $0.25 per pound. a. What is the break-even point in bags? (Round your answer to 2 decimal places.) b. Calculate the profit or loss (EBIT) on 10,000 bags and on 31,000 bags. c. What is the degree of operating leverage at 22,000 bags and at 31,000 bags? (Round...

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are...

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year 1 2 3 4 5 6 7 8 9 10 11 Registrations (000) 5.00 7.00 3.00 5.00 9.00 9.00 7.00 11.00 13.00 14.00 12.00 a. Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (α) of 0.40 and a starting forecast for 5.00 year 1 (round your responses to one demical...

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are...

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year 1 2 3 4 5 6 7 8 9 10 11 Registrations (000) 4.00 5.00 4.00 4.00 9.00 9.00 6.00 9.00 11.00 16.00 12.00 a) Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (α) of 0.30 and a starting forecast of 4.00 for year 1 (round your responses to...

The following data were collected on the yearly registration for a six sigma seminar at the...

The following data were collected on the yearly registration for a six sigma seminar at the University of Malaya Tahun/Year Pendaftaran/ Registration 1 400 2 600 3 400 4 500 5 1000 6 800 7 700 8 900 9 1200 10 1400 a. Calculate a 3-year moving average to forecast registration from year 4 to year 11.

Suppose you have been tasked with regulating a single monopoly firm that sells 50-pound bags of...

Suppose you have been tasked with regulating a single monopoly firm that sells 50-pound bags of concrete. The firm has fixed costs of $30 million per year and a variable cost of $1 per bag no matter how many bags are produced. a. If this firm kept on increasing its output level, would ATC per bag ever increase? Is this a decreasing-cost industry? b. If you wished to regulate this monopoly by charging the socially optimal price, what price would...

Suppose you have been tasked with regulating a single monopoly firm that sells 50-pound bags of...

Suppose you have been tasked with regulating a single monopoly firm that sells 50-pound bags of concrete. The firm has fixed costs of $30 million per year and a variable cost of $3 per bag no matter how many bags are produced. A. If this firm kept on increasing its output level, would ATC per bag ever increase? B. Is this a decreasing-cost industry? C. If you wished to regulate this monopoly by charging the socially optimal price, what price...

Subjects