Stats Solutions

(See Solution) Data collected on the yearly demand for 50-pound bags of fertilizer at Sunshine Garden Supply are shown in the following table. Year Demand

Question: Data collected on the yearly demand for 50-pound bags of fertilizer at Sunshine Garden Supply are shown in the following table.

Year Demand for Fertilizer (1,000s of Bags)
1 4
2 7
3 5
4 5
5 10
6 7
7 8
8 9
9 11
10 14
11 15
  1. Develop a three-year moving average to forecast sales in year 12.
  2. Develop a 3-year weighted average to predict demand in year 12. Sales in the most recent year is given a weight of 2 and sales in the two years prior to that are each given a weight of 1.
  3. Develop a regression/trend line to estimate the demand of fertilizer in year 12.
  4. Based on the three forecasts you have created, which forecast is the most accurate?

Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document


∴ Other downloads you may be interested in ∴

log in to your account

Forgot password?
Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in