a. Plot the monthly data. b. Forecast September sales volume using the following: 1) A linear regression 2) A 6-month moving average 3) Exponential smoothing with a smoothing constant equal to 0.20 and assuming a March forecast of 600,000. 4) The naïve approach 5) A weighted average using 0.7 for Dec, 0.2 for November and 0.1 for October. 6) Correlation Which mothod in hl the MOST appropriate method to be used? Why?

a. Plot the monthly data. b. Forecast September sales volume using the following: 1) A linear regression 2) A 6-month moving average 3) Exponential smoothing with a smoothing constant equal to 0.20 and assuming a March forecast of 600,000. 4) The naïve approach 5) A weighted average using 0.7 for Dec, 0.2 for November and 0.1 for October. 6) Correlation Which mothod in hl the MOST appropriate method to be used? Why?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Use the data shown in the following table: K a. Compute the average return for each of the assets from 1929 to 1940 (the Great Depression). b. Compute the variance and standard deviation for each of the assets from 1929 to 1940. c. Which asset was the riskiest during the Great Depression? How does that fit with your intuition? Note: For all your answers type decimal equivalents. Data table Year 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 S&P 500 -0.08906 -0.25256 - 0.43861 -0.08854 0.52880 -0.02341 0.47221 0.32796 -0.35258 0.33204 -0.00914 - 0.10078 Small Stocks - 0.43081 -0.44698 -0.54676 -0.00471 2.16138 0.57195 0.69112 0.70023 - 0.56131 0.08928 0.04327 -0.28063 Corp. Bonds 0.04320 0.06343 -0.02380 0.12199 0.05255 0.09728 0.06860 0.06219 0.02546 0.04357 0.04247 0.04512 World Portfolio -0.07692 -0.22574 -0.39305 0.03030 0.66449 0.02552 0.22782 0.19283 -0.16950 0.05614 -0.01441 0.03528 Treasury Bills 0.04471 0.02266 0.01153 0.00882 0.00516 0.00265 0.00171 0.00173…
please show steps in excel
Use the following output from a market model regression of the weekly percentage returns on the AIG commodities index on a market index to answer questions a. - f. a. What is the formula for the Commodities Index' characteristic line? b. You forecast a market return of 1.0% for next week. What is next week's expected return for the commodities index? c. What is the correlation between the return on the commodities index and the return on the market Index? d. How much of the variation in the commodities index's returns are explained by the model? e. Based on these regression results, the commodities index would be considered what kind of an investment? f. Does this regression have much explanatory power? Why or why not?
1)Find the forecast for 2012 using the time series trend method. Period Demand 2007 200 2008 150 2009 125 2010 100 2011 50 2) Find the forecast for all possible periods N=3, using the data and the moving average method.
The data presented below represents the expected returns on a financial asset in different seasons of the year. Season of year Probability Returns Spring 40% 2% Summer 35% 6% Winter 25% 10% What is the expected return on the asset? ii) What is the standard deviation on the asset? What is the covariance of the asset?
The last four years of returns for a stock are as shown here: a. What is the average annual return? b. What is the variance of the stock's returns? c. What is the standard deviation of the stock's returns? Note: Notice that the average return and standard deviation must be entered in percentage format. The variance must be entered in decimal format. Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 4 Return +3.51% 1 - 4.17% 2 +27.82% 3 + 11.88% X
4. The sales manager of a company projected the following sales for next year with the following probabilities: Scenario Sales (in Millions) Probability 0.10 1 20 2 0.30 18 0.30 15 4 0.30 14 Find the (a) variance and (b) standard deviation
The last four years of returns for a stock are shown here: a. What is the average annual return? b. What is the variance of the stock's returns? c. What is the standard deviation of the stock's returns? Note: Notice that the average return and standard deviation must be entered in percentage format. The variance must be entered in decimal format. a. What is the average annual return? The average return is ☐ %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year Return 1 -4.12% 2 +27.56% 3 + 12.24% +4.35% Print Done - X
There is a probability of 0.53 that there will be extremely cold weather this coming Winter. If it does, we expect investors of Star & Bucks to achieve a return of 0.15. Else, investors may expect a lower return of 0.07. Can you estimate the variance of this rate of return? (In Excel with Formulas) Please answer fast i give you upvote.
4. Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year 1 2 3 4 5 X 12% 28% 9% -7% 10% Return Y 25% 34% 13% -27% 14%
S1: The percentage increase in selling price is found by dividing the favorable sales price variance by last year's sales at the current year's sales quantity. S2: The percentage decrease in units sold is found by dividing the favorable cost volume variance by the planned level of cost of sales. A. both are true C. S1 is true D. S2 is true B. both are false
Expected Return, Variance, Std. Deviation and Cofficient of Variation:Magee Inc.'s manager believes that economic conditions during the next year will be strong, normal, or weak, and she thinks that the firm's returns will have the probability distribution shown below. What's the standard deviation of the estimated returns?Round your answer to two decimal places. For example, if your answer is $345.6671 round as 345.67 and if your answer is .05718 or 5.7182% round as 5.72. State of the Economy Probability of State Occurring Stock's Expected Return Boom 20% 24.15% Normal 50% 13.50% Recession 30% –13.30% Group of answer choices 15.68% 16.39% 14.26% 13.54% 10.69%