User Account

All Pages

Develop a four-month moving average forecast

Assignment Help Advanced Statistics
Reference no: EM132242123

QUESTION 1

1) Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD. A three-month moving average forecast was developed in the attached table. You may also view this table at Resources Tab under the Problem Sets Tab.

Question Based on above no.1

a) The four-month moving average forecast for Wallace Garden Supply is ___________.? (Please round it to an integer and include no units.)

b) The Mean Absolute Deviation (MAD) for the above forecast is . (Please round it to two decimal points.)

Question No. 2 - example of table above.

2) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the table attached. Develop a 3-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1. You may also view this table at Resources Tab under the Problem Sets Tab.
Question Based on above - no.2
a) The three-year moving average forecast for Wallace Garden Supply is . ?(Please round it to two decimal points and include no units.)
b) The Mean Absolute Deviation (MAD) for the above moving average forecast is .? (Please round it to two decimal points.)
c) The three-year weighted moving average forecast for Wallace Garden Supply is .? (Please round it to an integer and include no units.)
d) The Mean Absolute Deviation (MAD) for the above weighted moving average forecast is .? (Please round it to two decimal points.)

Question 3) Based on your previous calculation, which method do you think is the best?

A. 3-year moving average.
B. 3-year weighted moving average.

Question 4) Sales of Cool-Man air conditioners have grown steadily during the past 5 years as shown in the attached table. The sales manager had predicted, before the business started, that year 1's sales would be 410 air conditioners. Please use exponential smoothing with a weight of α = 0.30 to answer the following questions. You may also view this table at Resources Tab under the Problem Sets Tab.

a) The starting /initial forecast for the sales of Cool-Man air conditioners is _________.?
b) The Year 2 forecast for the sales of Cool-Man air conditioners is _______ ?
c) The Year 6 forecast for the sales of Cool-Man air conditioners is _______ ?
d) The Mean Absolute Deviation (MAD) for the above exponential smoothing forecast is ______ ?

Attachment:- Problem set.rar

Verified Expert

The two main types of quantitative forecasting used by business analysts are the explanatory method that attempts to correlate two or more variables and the time series method that uses past trends to make forecasts.

Reference no: EM132242123

Questions Cloud

Discussion about the health care information systems : Suppose you are the administrator at a hospital of your choosing. From the e-Activity, suggest the most important attributes of other hospital's information.
Identify challenges you will face in developing leadership : Identify two challenges you will face in developing and presenting your approved leadership book to the class. For each challenge, research and share approaches
Who are the top three competitors of nike : Who are the top three competitors of Nike, and what are their advantages/disadvantages with respect to their product/service development?
How the internet affects international business activity : Explain how the Internet affects international business activity and the globalization of the world economy. By the due date assigned, post your response.
Develop a four-month moving average forecast : Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD. A three-month moving average forecast was developed
What are the benefits to you of staying loyal : What are the benefits to you of staying loyal and not switching to another provider? What would it take for you to switch?
How can loyalty be measured from a marketing approach : Loyal customers offer multiple benefits to a healthcare organization. What are some of these benefits? How can loyalty be measured from a marketing approach?
How do employees spend their time away from work : Billy Q's is located close to the CSUSB Palm Desert Campus in beautiful Palm Desert California. The Palm Desert Campus food is limited to processed pre-package.
Describe the basic elements of marketing : Research a local health care organization of your choice, and complete the following tasks: Perform a strengths, weaknesses, opportunities, and threats (SWOT).

Reviews

len2242123

2/25/2019 2:29:31 AM

Hi team, I am sending two files. First attachment is assigned questions and second attachment is help file for assigned questions. Please review the assigned questions when you preparing the answers.

Write a Review

Advanced Statistics Questions & Answers

  Write r code in order to compute an approximate matrix

Write R code in order to compute an "approximate" correlation matrix from this data using pairwise deletion method.

  Relative frequency approach

A calculus instructor uses computer aided instruction and allows students to take the midterm exam as many times as needed until a passing grade is obtained.

  Computing corporation tax

Karen is a single taxpayer and transfers property with a basis of $130,000 and a fair market value of $65,000 to the Southland Corp in exchange for shares of section 1244 stock.

  Compute the expected tree radius and its variance

Compute the expected value and variance of the ring width in a single year and compute the expected tree radius and its variance of a 50 year old tree.

  Significant correlation between quadriceps strength

Significant correlation between Quadriceps strength indices

  Prepare a draft paper on the given topic

Prepare a draft that include the following:Sampling: A careful description of how you obtained the samples. Be very specific. Include sample sizes, population of interest, and description of sample. Also include a copy of the survey if you used on..

  Suppose 10 of the tubes produced by a machine are

suppose 10 of the tubes produced by a machine are defective. if six tubes are inspected at random determine

  Explain how to go about finding in general

Find fY(t)(y). Show that your answer reduces to that of (5.30) in the limit as t → ∞. Explain how to go about finding fY(t)(y) in general, assuming that fX has a rational Laplace transform.

  Show that sn has a density that is positive

Then show that Sn has a density that is positive for all t > 0.

  Construct and plot a confidence ellipse

Construct and plot a 95% confidence ellipse for the pair and Given the data, do you think bivariate normal distribution is a good model for the data? Use a QQ-plot, as well as a formal test, to answer this question.

  Do you always trust the statistics you see in print

Post a complete response to the question - Given the nature of tons question, no commenting to others is requires - Do you always trust the statistics

  Value of preferred stock

A firm has an issue of preferred stock outstanding that has a stated annual dividend of $4. The required return on the preferred stock has been estimated to be 10%. Compute the value of the preferred stock.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd