Question: just e pls n ty! e) Which of the developed forecasts (3-year moving averages, weighted moving average exponential smoothing, and trend line) would you use

just e pls n ty!

e) Which of the developed forecasts (3-year moving averages, weighted moving average exponential smoothing, and trend line) would you use based on each of MAD, MSE, MAPE, and bias? Explain your answer. 1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. YEAR -MOOO 2 3 4 5 6 7 8 DEMAND FOR FERTILIZER (1,000S OF BAGS) 7 6 5 7 10 9 13 15 YEAR 1 2 3 4 5 6 7 8 DEMAND FOR FERTILIZER (1,000S OF BAGS) 7 6 5 7 10 I a) Develop a 3-year moving averages model to forecast sales. b) Develop a 3-year weighted moving averages model in which sales in the most recent year are given a weight of 3 and sales in the other 2 years are each given a weight of 2. c) Use exponential smoothing with a smoothing constant of 0.4 to forecast the demand for fertilizer. Assume that last period's forecast for year 1 is 5,000 bags to begin the procedure. d) Develop a trend line model to forecast sales. You may use excel to find the intercept and slope coefficients of the trend line. e) Which of the developed forecasts (3-year moving averages, weighted moving averages, exponential smoothing, and trend line) would you use based on each of MAD, MSE, MAPE, and bias? Explain your

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: a. If each project's cost of capital is 12%, which project should be...

Answer A-E with complete work and explanations typed. 1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. DEMAND FOR...

1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. YEAR 1 2 3 4 5 6 7 8 DEMAND FOR FERTILIZER (1,000S OF BAGS) 7 6 5 7...

pls help! will leave a good review! thank you! 1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. 1 YEAR 1 2 3 00 ON-...

Please provide the formulas/functions with the answers. I need the most help with parts g, h, and i. Thank you in advance, I will rate complete answers! Year A major source of revenue in Texas is a...

what would the excel formula be for each question a-i? A major source of revenue in Texas is a state sales tax. One category of tax is classified as Retail Trade. The following table gives four years...

i need the answers to D and E here is the solution for A B C 1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. YEAR 1 2...

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Year DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 7 2 6 3 5 4 7 5 10 6 9 7...

Instructions: Solve the homework by hand, take photos, and submit them as a single PDF file on Blackboard. To receive full credit, complete answers including all steps of formulating the problems and...

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. YEAR 1 2 3 4 5 6 7 8 DEMAND FOR FERTILIZER (1,000S OF BAGS) 7 6 5 7 10 9...

1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. YEAR 1 2 2. 3 4 5 6 7 8 DEMAND FOR FERTILIZER (1,000S OF BAGS) 7 6 5...

The osmotic coefficient' ф defined as ф = - (xA/xB) In aA By writing r =xSlxA, and using the Gibbs-Duhem equation, show that we can calculate the activity of B from the activities of A...

All of the stereo isomers of 1, 2, 3, 4, 5, 6-hexachlorocyclohexane have very similar rates of E2 reaction except the following stereo isomer, which reacts about 7000 times more slowly than the...

Is investing profit and financial profit types of profit are not seen on an income statement?

I need someone to help explain the steps? CNNBC recently reported that the mean annual cost of auto insurance is 991 dollars. Assume the standard deviation is 244 dollars. You take a simple random...