Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. your company has the sales for year 1 below. you w

Your company has the sales for year 1 below. You want to select from one of...

80.2K

Verified Solution

Question

Accounting

Your company has the sales for year 1 below. You want to selectfrom one of three models for forecasting: a three-month movingaverage, a weighted moving average (you believe that the weightsshould be 0.2, 0.3, and 0.5), and an exponential smoothing averagein which you use an alpha of 0.2 and an assumed forecast forJanuary of year one of $35,000. Determine sales forecast forJanuary year 2 and calculate MAD.


Jan Yr 1 34284
Feb 34000
Mar 31017
Apr 33406
May 34518
Jun 35469
Jul 35360
Aug 34894
Sep 34547
Oct 31015
Nov 31167
Dec 32925

A) Three-month moving average:
Sales forecast: $  
MAD:  

B) Weighted moving average:
Sales forecast: $  
MAD:  

C) Exponential moving average:
Sales forecast: $  
MAD:  

Which forecasting method should you use for your company? (enter A,B, C):

Answer & Explanation Solved by verified expert
4.5 Ratings (825 Votes)
Year1 Months Sales 3month Moving Average 3month Weighted Moving Average weights 02 03 05 Exponential Smoothing alpha 02 Jan 34284 Feb 34000 02342800834280 34280 Mar 31017 02340000834280 34224 Apr 33406 3428434000310173 33100 023428403340000531017 32562 02310170834224 33582 May 34518 3400031017334063 32808 023400003310170533406 32808 02334060833582 33547 Jun 35469 3101733406345183 32980 023101703334060534518 33484 02345180833547 33742 Jul 35360 3340634518354693 34464 023340603345180535469 34771 02354690833742 34088 Aug 34894 3451835469353603    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Q: Asking for assistance in understanding and solving this example on Modern Algebra II with the...

Advance Math
Q

Question: How would British Airlines or how did they recover the trust of their passengers and...

Programming
Q

Why will lenders lend only a certain percentage of the value of a transaction?

General Management
Q

1 The potential difference across the 100 resistance in the circuit is measured by a...

Physics
Q

Consider the function f x 20x e on the domain U On its domain the...

Calculus
Q

ine sales of certain products in three cities are given in the 4 by 3...

Algebra
Q

Solve the equation by the square root property x 20 OA 20 OB 10 OC...

Algebra
Q

Modern Building Supply sells various building materials to retail outlets. The...

Accounting
Q

Winston Co. tena dos productos con el cdigo X e Y. La empresa tena el...

Accounting
Q

Jellison Company had the following operating data for its first two years of operations: ...

Accounting
Q

Enterprise Risk Management (ERM) is currently one of the hottest topics being written about in...

Accounting
Q

Salmone Company reported the following purchases and sales of its only product. Salmone uses a...

Accounting