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

a. Sales of the Flying Flintmobile has been increasing over the past five years. The operations manager has estimated sales in 2017 to be 410 Flving Flintmobiles. Using exponential smoothing with a weight of a = 0.30, develop forecasts for 2017 through 2022. Year Sales Forecast 2016 450 2017 495 2018 518 2019 563 2021 584 2022
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?
Describe the patterns in quantity sold and own and rival prices during this time period using basic descriptive statistics. Graphs are welcome as well. Take the logs of the variables, and estimate the demand function. Interpret the R-square. Interpret the coefficients for logP and logPsub Interpret the p-values associated with each independent variable Are consumers price sensitive? Why or why not? (be as precise as you can – you have estimates!). Does this price sensitivity make sense given the good we are examining? How sensitive are our consumers to changes in the rival good’s price? Explain in detail. Suppose we decide to charge a per ounce price of $2, while at the same time our rival charges a price of $2.15. All else equal, what would you expect sales to be? How confident are you in your forecast? Suppose we are charging a price of $2 and our current marginal cost is $1.50 Are we maximizing profits at this price? If not, should we raise or lower price? Why?
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…
Year, x 2009, 0 2010, 1 2011, 2 2012, 3 2013, 4 2014, 5 Average Monthly Cost to Workers for Family Health Insurance $296 338 348 362 384 404
The below data represent the advertising expenditure and sales of Liu Liu Ltd from year 2010 to 2019. Table: Advertising Expenditure vs. Sales from 2010 to 2019 Year Advert. Expenditure Sales Growth rate of Ad. Expenditure Growth rate of Sales (x, £000) (y, £000) 2010 19 84 2011 22 108 18% 29% 2012 32 82 46% -24% 2013 42 86 32% 6% 2014 47 84 11% -3% 2015 46 94 -2% 11% 2016 58 103 27% 10% 2017 63 115 8% 12% 2018 70 106 11% -8% 2019 80 142 15% 34% Total 479 1004 a. What is the statistical relationship shown in the table and list out 3 characteristics of this relationship?
The company has data on demand and factory capacity for the next 4 months as in the table. Unit cost with regular time $ 24, overtime cost $ 28, on subcontract $ 34. Storage costs $ 2 per unit per month; backorders cost $ 5 per unit per month. Initial inventory is as many as 120 units, and it is expected that by the end of July there will be an inventory of 100 units. April May June July Demand 460 450 480 480 Regular Capacity 370 370 380 380 Overtime Capacity 60 60 60 60 Subcontract Capacity 30 30 30 30 Use the transportation method to optimize the aggregate plan. Determine the production cost each month and the total cost for 4 months
rials eo uations ow....zip Process . @ 2 D W Yaster Outfitters manufactures and sells extreme-cold sleeping bags. The table below shows the price-demand and total cost data, where: D • p is the wholesale price (in dollars) of a sleeping bag for a weekly demand of a sleeping bags; . C is the total cost (in dollars) of producing a sleeping bags. x (sleeping bags) p ($) 95 240 235 155 50 120 180 220 Use this data to create regression models to answer all of the questions below. #3 Price Model Find a quadratic regression equation for the price-demand data, using a as the independent variable. E p=a+bx+cr² Round a to the nearest integer, round b to 2 decimal places, and round c to 4 decimal places. Use this price model to answer question 1-2 below. $ 4 5 6 MacBook Pro C ($) 13,000 14,300 18,500 21,000 Y PEAR & * 8 ( 9 0 0 P A
Obtain the regression of demand on price from the following data and estimat demand when the price is 7.5 Price Demand Price Demand 2.0 75 4.5 40 2.5 60 5.0 40 3.0 55 5.5 35 3.5 50 6.0 30 4.0 45 6.5 30
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 ______

SEE MORE QUESTIONS

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