Given the following actual sales, A(t) 8 4 9 11 10 t 1 2 3 4...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Given the following actual sales, A(t) 8 4 9 11 10 t 1 2 3 4 5 6 7 8 9 10 a. Use Simple Moving Average method (with n = 3) to forecast sales in periods 6, 7, and 8, 9 and 10 (10pts) b. Use Weighted Moving Average method (with weights of 0.6, 0.3, 0.1) to forecast sales in periods 6, 7, 8, 9 and 10. (10 pts) c. Use Exponential Smoothing method (with a = 0.4) to forecast sales in periods 6, 7, and 8, 9 and 10 (Hint: Use the first 2 data sets to initialize the Exponential Smoothing forecasting model, then update the forecasts in periods 3, 4, and 5.) (10 pts) d. Show solutions Given the following actual sales, A(t) 8 4 9 11 10 t 1 2 3 4 5 6 7 8 9 10 a. Use Simple Moving Average method (with n = 3) to forecast sales in periods 6, 7, and 8, 9 and 10 (10pts) b. Use Weighted Moving Average method (with weights of 0.6, 0.3, 0.1) to forecast sales in periods 6, 7, 8, 9 and 10. (10 pts) c. Use Exponential Smoothing method (with a = 0.4) to forecast sales in periods 6, 7, and 8, 9 and 10 (Hint: Use the first 2 data sets to initialize the Exponential Smoothing forecasting model, then update the forecasts in periods 3, 4, and 5.) (10 pts) d. Show solutions
Expert Answer:
Answer rating: 100% (QA)
Sure lets tackle each part of the forecasting question based on the methods specified a Simple Moving Average method n 3 The Simple Moving Average SMA ... View the full answer
Related Book For
Introduction To Statistical Investigations
ISBN: 9781118172148
1st Edition
Authors: Beth L.Chance, George W.Cobb, Allan J.Rossman Nathan Tintle, Todd Swanson Soma Roy
Posted Date:
Students also viewed these accounting questions
-
The graph below displays the distribution of word lengths (number of letters) in the Gettysburg Address, which you explored in Exploration 2.1A. a. Describe the shape of this distribution. b. Based...
-
The General's Pizza is a small restaurant catering to patrons with a taste for European pizza. One of its specialties is Polish Prize pizza. The manager must forecast weekly demand for these special...
-
The file S12_75.xlsx contains five years of monthly data for a particular company. The first variable is Time (1 to 60). The second variable, Sales1, contains data on sales of a product. Note that...
-
Cost of goods available for sale consists of two elements: beginning inventory and: (a) ending inventory. (b) cost of goods purchased. (c) cost of goods sold. (d) All of the answer choices are...
-
Lily Craft, Inc., is a manufacturer of electric pencil sharpeners. The following is information regarding Lily Craft for the fiscal year-end, May 31, 2010: Assume a tax rate of 25%. Prepare a...
-
A review of the accounts of Tucker and Wu Pan Accountants reflected the following transactions, which may or may not require adjustment for the year ended December 31, 2020. 1. The Prepaid Rent...
-
(Hard) Prove that propositional logic and first-order predicate logic are sound and complete.
-
Noah Amusement Park has a fiscal year ending on September 30. Selected data from the September 30 worksheet are presented below. Instructions(a) Prepare a complete worksheet.(b) Prepare a classified...
-
The LOL Company had the following items in its complex capital structure on December 31, 2023: Preferred stock, $8 par value, $1 dividend, 10,000 shares issued and outstanding. Common stock, $5...
-
San Francisco led the movement to ban plastic shopping bags and is now proposing to ensure people have access to safe high-quality tap water and ban bottled water. A supporter of the ban says The...
-
What strategies can organizations employ to address unethical behavior and promote a culture of integrity and accountability?
-
In center of gravity, if all destinations require the same degree of service, should their coordinates be added or averaged?
-
Which logistical mode is most appropriate for a small shipment that must be some- where very fast and far away?
-
If tasks are always finished on their deadlines and never earlier, is this timing known as forward or backward scheduling?
-
A point of significance in the time line or history of a project is referred to as a what?
-
Valentino S.p.A., is a vertically integrated, international manufacturer and retailer of womens clothing, headquartered in Milan, Italy. Currently, the firm has no coordinated cash management system....
-
GON manufacturing company produces product X in two stage process. The company has molding and finishing operation. The company uses weighted average method of process costing. During July, the...
-
A firm offers two products for sale. The marginal cost of one product is new zero once the first unit has been produced. The marginal cost of the other product rises as output rises. What would be...
-
Reconsider Harley the dog from Exploration 1.1 and the previous exercise. We found that the observed data provided very strong evidence that Harley the dog was doing better than random chance. Which...
-
Reconsider the previous exercises about the study of whether there is an association between number of Facebook friends and a persons sex. a. Use the 2SD method and the information available in the...
-
Biased samples either overestimate or underestimate the parameter of interest. List the samples from Exercise 2.CE.7 you think might overestimate the following parameters. a. Average student GPA b....
-
A container of an organic liquid a $25^{\circ} \mathrm{C}$ has a mass of $1100 \mathrm{~kg}$ and a volume of $0.94 \mathrm{~m}^{3}$. Find the liquid's weight, its density, and its specific gravity.
-
A vertical, cylindrical tank with a diameter of $10 \mathrm{~m}$ and a depth of $4 \mathrm{~m}$ is filled to the top with water at $25^{\circ} \mathrm{C}$. If the water is heated to $60^{\circ}...
-
The system in Figure P1.6 is at $20^{\circ} \mathrm{C}$. If atmospheric pressure is $101.3 \mathrm{kPa}$ and the absolute pressure at the bottom of the tank is $264.1 \mathrm{kPa}$, what is the...
Study smarter with the SolutionInn App