Sales for the last 12 months at a company are the following: Actual Sales ($ Month...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sales for the last 12 months at a company are the following: Actual Sales ($ Month M) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 20 24 27 31 37 7 55 62 4 35 32 29 238438433338 47 53 54 36 a. Calculate the forecast according to the Simpl Moving Average Method (3-Month SMA, 4-Month SMA) b. Calculate the forecast according to the 3-Month Weighted Moving Average Method (Weights are 0.50, 0.33, 0.17, from most recent month to least recent month, respectively (Weights are actually 3, 2.1) c. Calculate the forecast according to the Exponetial Smoothing Method (Alpha is 0.6) Assume that the forecast for Jan is 22. d. Calculate the MAD for each method e. Which forecasting method would you choose for your company? Sales for the last 12 months at a company are the following: Actual Sales ($ Month M) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 20 24 27 31 37 7 55 62 4 35 32 29 238438433338 47 53 54 36 a. Calculate the forecast according to the Simpl Moving Average Method (3-Month SMA, 4-Month SMA) b. Calculate the forecast according to the 3-Month Weighted Moving Average Method (Weights are 0.50, 0.33, 0.17, from most recent month to least recent month, respectively (Weights are actually 3, 2.1) c. Calculate the forecast according to the Exponetial Smoothing Method (Alpha is 0.6) Assume that the forecast for Jan is 22. d. Calculate the MAD for each method e. Which forecasting method would you choose for your company?
Expert Answer:
Answer rating: 100% (QA)
SOLUTION To calculate the forecasts and MAD for each method lets start by organizing the given data Month Actual Sales Jan 20 Feb 24 Mar 27 Apr 31 May ... View the full answer
Related Book For
Complete Business Statistics
ISBN: 9780077239695
7th Edition
Authors: Amir Aczel, Jayavel Sounderpandian
Posted Date:
Students also viewed these general management questions
-
Treasury stock is an 1 point Liability Asset Contra-liability Contra-equity Contra-asset 2. Question 2 Gal is the treasurer of Katz corp. They repurchased stock last year for a total of $120,000....
-
As a market risk analyst, each day you calculate VaR from the available prior data. Then, you wait ten days to compare your prediction value VaRt-10 to the realised return and check if the prediction...
-
Stacks should contain in order the columns FRAME, SYMBOL, TYPE, ADDRESS, VALUE. 1. Consider the following program. 01 02 03 04 05 06 07 08 09 10 11 12 20 13. 14 15 16 17 18 19 20 21 22 23 24 25 26 27...
-
Using the Trust Services Principles and Criteria for the Online Privacy Principle, develop an online privacy policy for Alltel Stadium that could be posted on the stadiums website for customers to...
-
Consider Figure 26-3, and suppose that this typical firm has agreed to participate in the proposed cartel. What is the total dollar amount of the firm's economic incentive to cheat on the cartel...
-
Which of the following best describes situations with complex frauds and financial crimes? 1. Organizations associated with complex frauds and financial crimes often dismantle legitimate businesses....
-
Determine which of the following are rational numbers: 1. \(\sqrt{13}\) 2. \(-13 . \overline{21}\) 3. \(\frac{-48}{-16}\) 4. \(-4 \frac{18}{19}\) 5. 14.1131
-
Hillside issues $4,000,000 of 6%, 15-year bonds dated January 1, 2013, that pay interest semiannually on June 30 and December 31. The bonds are issued at a price of $3,456,448. Required 1. Prepare...
-
2. Prepare a memo to the CEO of Halloran company summarizing your findings about the financial health of the company, using your calculations from above as evidence to support your conclusions.
-
You have exams in economics and chemistry coming up, and you have 5 hours available for studying. The following table shows the trade-offs you face in allocating the time you will spend studying each...
-
1.Broussard Skateboard's sales are expected to increase by 15% from $7.8 million in 2019 to $8.97 million in 2020. Its assets totaled $5 million at the end of 2019. Broussard is already at full...
-
Discuss the place of selling in the marketing mix.
-
Even as conditions in the telecommunications industry deteriorated in 2000 and 2001, WorldCom continued to post impressive revenue numbers. In April 2000 CEO Ebbers told analysts that he remain[ed]...
-
Give reasons as to why the shape of the curve of the product life cycle is similar to that of the adoption of innovations curve.
-
Every four years, the International Federation of Accountants (IFAC) organizes the World Congress of Accountants.1 Accountants from across the globe attend this meeting to share their views on major...
-
The major fixed assets of Waste Managements North American business consisted of garbage trucks, containers, and equipment, which amounted to approximately $6 billion in assets. The second largest...
-
sofa (used in office) Someday's office chair Asset Someday's black leather Placed in Service (or purchased) 4/4/21 Sold Basis Initial Accumulated Selling Depreciation Price 10/16/22 $ 3,720 $ 720 $...
-
Sandcastles, Inc.s management has recently been looking at a proposal to purchase a new brick molding machine. With the new machine, the company would not have to buy bricks. The estimated useful...
-
Repeat problem 1066 for the regression of problem. Produce residual plots for the regression of problem. Is there any apparent model inadequacy? In problem Income quartile: Wealth growth (%): 17.3...
-
A real estate agent has four houses to sell before the end of the month by contacting prospective customers one by one. Each customer has an independent 0.24 probability of buying a house on being...
-
An article in Real Estate Finance displays the following data for Brazils short-term interest rates (in percent). Develop a good forecasting model, and use it to forecast Brazils short-term rate for...
-
Amazon.com, Inc. is the world's leading online retailer selling books, music, DVDs, videos, toys, electronics, software, video games, and home improvement products. The following foot- note appeared...
-
In its 2002 annual report to shareholders, Aon Corporation described its mandatorily redeemable preferred stock as follows: In January 1997, Aon created Aon Capital A, a wholly-owned statutory...
-
The octogenarian founders of X-Rite Inc. spend less time these days on the golf course and more with estate planners, thanks to an accounting standard introduced last year. This same accounting...
Study smarter with the SolutionInn App