1234Year D 3 month mov avg67:5-17 Data collected on the yearly demand for 50-poundbags of fertilizer at Wallace Garden Supply areshown in the following table. Develop a 3-year mov-ing average to forecast sales. Then estimate demandagain with a weighted moving average in whichsales in the most recent year are given a weight of 2and sales in the other 2 years are each given a weightof 1. Which method do you think is better?45 101061145co88 979 1214YEAR123451567891011DEMAND FOR FERTILIZER(1,000s OF BAGS)4645108791214153 month weighted moving avgTOTAL ABS DEVABS Dev (3 yr)ABS DEV (moving)

Answered: Image /qna-images/answer/88e7aab5-b52b-4bee-95fe-621ba05471f8.jpg

Answered: Data collected on the yearly demand for…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Repair revenues from labor costs of the bicycle shop are given below: X 7.1 2.2 7.2 3.1 3.3 3.5 7.7 4.1 6.8 4.7 5.3 5.5 6.1 Y 3.9 1.7 3.7 1.5 2.2 1.4 4.9 2.5 4.5 3.4 2.3 3.6 3.2 Determine whether there is significant relationship at 0.05 level of significance Predict the value of Y if x are 2.7 and 1.5.
An environmental engineer wants to evaluate three different methods for disposing of nonhazardous chemical waste: land application, fluidized-bed incineration, and private disposal contract. Use the estimates below to help her determine which has the least cost at /= 15.00% per year on the basis of an annual worth evaluation. First Cost AOC per Year Salvage Value Life Land $-145000 $-86000 $23000 4 years Incineration $-760000 $-70000 $260000 6 years Contract O $-132000 O 2 years
Describe the results of your two graphs as they compare to the movement of demand. Be specific. Choosing between the three-period and the five-period forecasts, which length of averaging would you use as a purchasing manager of Greenfield’s Tannery? Be sure to factor in the cumulative forecast errors in your answer. Also, make sure you include some rationale about why you are picking the method you do for this particular business. So for example, does picking one method over the other have any impact on how much inventory they will have on hand to meet customer demand? What happens when the demand drops? Which method better supports that?
Using the actual sales (in units) over the past 15 months, a demand planner at a leading e-commerce firm has forecasted the demand for a popular consumer product as shown below. Forecast 1 and Forecast 2 represent the outputs of two comparative forecasting methods currently used by the sales and marketing, and operations departments of the firm. Month October 22 November 22 December 22 January 23 February 23 March 23 April 23 May 23 June 23 July 23 August 23 September 23 October 23 November 23 December 23 Actual sales (units) 120 000 138 000 172 000 120 000 114 000 98 000 118 000 112 000 132 000 138 000 108 000 126 000 144 000 162 000 189 000 QUESTION 24 Determine the mean absolute deviation of Forecast 1. A 234 290 units a 18 721 units c 19 524 units 22 670 units QUESTION 25 Determine the mean absolute deviation of Forecast 2. A 21 638 units a 35 280 units c. 19 330 units 23 600 units Forecast 1 (units) 133 280 130 620 127 300 121 440 120 750 119 000 121 600 124 900 121 500 122400 126…
The marketing manager of "ABC Tapes" wants to assess the competitiveness of the company's product in the market. Table 1 represents the prices and quantities of blank cassette tapes sold in January 2016 and January 2020. TABLE 1 2016 2020 Length of tapes Price Quantity Price Quantity 30 minutes R 4.00 32 R 5.60 40 60 minutes R 4 30 150 R 6.15 190 90 minutes R 4.60 100 R 7.40 130 Using 2016 as base and calculate for 2020 the following: Determine the Laspeyres price index: a) 149.492 Ob) 149.367 Oc) 66.949 d) 66.893
Month Actual demand Forecasted Demand 1 950 1000 2 1070 1000 3 1100 1000 4 960 1000 5 1090 1000 6 1050 1000 For the dataset above, compute the overall MAPE.
As a sales analyst for the shoe retailer Foot Locker, one of your responsibilities is measuring store productivity and then reporting your conclusion back to management. Foot Locker uses sales per square foot as a measure of store productivity. While preparing your report for the second quarter results (Q2), you are able to determine that annual sales for last year ran at a rate of $406 per square foot. Therefore, $406 per square foot will be your sales estimate for the population of all Foot Locker stores during Q2. For your Q2 Sales Report, you decide to take a random sample of 64 stores. Using annual data from last year, you are able to determine that the standard deviation for sales per square foot for all 3,400 stores was $80. Therefore $80 per square foot will be your population standard deviation when compiling your Q2 report. Management has asked for the probability that your sample mean based on 64 stores is 1) within $15 and 2) within $5 of the population mean…
Using the photo attached, One Stop Car Repairs ollects data on the actual demand for its services and uses this data to make forecasts. The actual number of transmissions that were repaired for the last ten periods IS ATTACHED IN THE PHOTO answer the following. 1. Using the trend projection manual method, forecast demand for transmission repairs for periods 11 and 12
The following are historical demand data: ACTUAL YEAR 2011 SEASON DEMAND Spring 201 Summer 142 Fall 380 Winter 578 2012 Spring 469 Summer 273 Fall Winter 683 963 Use regression analysis on deseasonalized demand to forecast demand in summer 2013. (Do not round intermediate calculations. Round your answer to the nearest whole number.) Forecast for summer 2013
An entrepreneur who owns and operates two businesses (A and B) would like to analyze their profitability. They would like your help in the analysis. They give you the annual net profit (in thousands of $) for each business from 2008-2020. Table 1: Annual Net Profits for Businesses A and B Business Year Profit Business Year Profit 2008 -50 2008 -10 2009 57 2009 30 2010 71 2010 27 2011 64 2011 22 2012 60 2012 21 2013 50 2013 20 A 2014 41 2014 24 2015 59 2015 24 2016 71 2016 32 2017 71 2017 36 2018 74 2018 37 019 81 20 40 2020 97 2020 49 a. Suppose you want to graph the distribution of profits. Explain why using only one stem- plot might not be optimal for the analysis. b. Describe the correct stemplot to use. Generate this stemplot. Explain your steps. What can you say about the distribution from this stemplot? c. When are stemplots useful? And why is that? d. Suppose that instead of having 26 observations you have 200 observations. What graph should you generate? e. What other type of…
Use regression analysis on deseasonalized demand to forecast demand in summer 2013. Forecast for summer 2023 ______

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS