A. Calculate the MAD for the period 2017-2019 (2 points) B. Calculate the 2020 forecast using...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A. Calculate the MAD for the period 2017-2019 (2 points) B. Calculate the 2020 forecast using Exponential Smoothing. The smoothing constant (a) is 0.30. (2 points) C. Using the information below and your answer for B above, calculate the monthly seasonal index and 2020 monthly forecast. (4 points) Month Jan Feb Mar Apr Total 2017 900 1050 1200 1325 2018 1110 1175 1250 1350 2019 1200 1425 1275 1400 X Sea. Index 2020 Forecast YEAR FORECAST ACTUAL DEMAND 2017 12,000 13,742 2018 14,300 15,439 2019 16,530 16,290 2020 ? A. Calculate the MAD for the period 2017-2019 (2 points) B. Calculate the 2020 forecast using Exponential Smoothing. The smoothing constant (a) is 0.30. (2 points) C. Using the information below and your answer for B above, calculate the monthly seasonal index and 2020 monthly forecast. (4 points) Month Jan Feb Mar Apr Total 2017 900 1050 1200 1325 2018 1110 1175 1250 1350 2019 1200 1425 1275 1400 X Sea. Index 2020 Forecast YEAR FORECAST ACTUAL DEMAND 2017 12,000 13,742 2018 14,300 15,439 2019 16,530 16,290 2020 ?
Expert Answer:
Answer rating: 100% (QA)
A Calculate MAD for 20172019 Year Sales 2017 900 1050 1200 1325 4475 20... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
YESUCAN COMPANY in the Philippines. (the Company) was registered with the Department of Trade and Industry (DTI) on January 1, 2021 and is primarily engaged in the business of buying and selling of...
-
PROVE that for any convex polygon with three angles whose sum is 180 , then the polygon must be a triangle.
-
The U. S. stock market experienced an economic recovery during 2011 and 2012 after a major recession. The data in the Excel file S& P 500.xlsx show the end of month values for the S& P 500 Index...
-
How does feedback value relate to predictive ability and accountability?
-
Suppose that the regression model is y = + , where has a zero mean, constant variance, and equal correlation across observations. Then Cov [i, j] = 2 if i j . Prove that the least squares...
-
In the Fig. 108 shown, the relative velocity of link 1 with respect to link 2 is \(12 \mathrm{~m} / \mathrm{sec}\). Link 2 rotates at a constant speed of \(120 \mathrm{rpm}\). The magnitude of...
-
Derive Eq. (14-15a) and the corresponding equation for \(\mathrm{x}_{\mathrm{D}, \mathrm{M}}\). (14--15a) XA.M EOYA,0 + FXA,N+1 EO+F 0+(1000) (0.2) 662+1000 = 0.120
-
Balfore Office makes metal five-drawer desks and, occasionally, takes custom orders. The companys overhead costs for a month in which no custom desks are produced are as follows: Purchasing...
-
Sandra Gilbert, Retiree Sandra Gilbert, would reach the age of 65 next year and was preparing for retirement. She had been working for Wolfson Manufacturing Company as an accountant and quality...
-
Louie Long started a business called Louie's Lawn Service. The trial balance as of March 31, after the first month of operation, is as follows: REQUIRED 1. Analyze the following adjustments and enter...
-
3. Applications are scanned in a process with two resources. The first resource has a capacity of 0.74 applications per minute. The capacity of the second resource is 1.5 applications per minute. The...
-
During the year, in Sigma Corporation, Job P90 was started, completed, and sold to the customer for $4.000 The plantwide predetermined overhead rate was $20 per machine hours. The following...
-
How does the availability of career development and advancement opportunities affect job satisfaction, and what strategies can organizations implement to support employee growth ?
-
Marie is a single taxpayer that operates a small shop in Boston. The business operates as a sole proprietorship with no employees. Marie's Schedule C reports income of $90,000. Her taxable income is...
-
What does this loop do? int x = 1; while (x = 12) { cout < < x < < endl; x = x + 2; }
-
Beginning Work in Process Inventory $575 Direct materials used in production $1,125 Indirect materials used in production $338 Direct labor $891 Indirect labor $222 Applied manufacturing overhead...
-
What distinguishes a real-time operating system (RTOS) from general-purpose operating systems, and what are the critical factors in ensuring deterministic behavior in RTOS ?
-
Consider a game of poker being played with a standard 52-card deck (four suits, each of which has 13 different denominations of cards). At a certain point in the game, six cards have been exposed. Of...
-
Consider the following data collected from four independent populations: a. Calculate the total sum of squares (SST). b. Partition the total sum of squares (SST) into its two components. c. Using =...
-
Comcasts customer service department asks its customers to rate their over the phone service on a scale of 120 immediately after their service has been completed. The company then matches each...
-
Consider the following hypothesis statement: H 0 : 2 = 12.0 H 1 : 2 12.0 State your conclusion given that s = 4.6, n = 36, and = 0.05.
-
Which of the following items would be most useful in analyzing the separation of duties and functions in an application system? (a) document flowchart (b) program flowchart (c) HIPO chart (d) source...
-
An important omission from flowcharts and matrix techniques is ( ___________________ ). (a) the ability to represent decisions (b) the ability to include internal control considerations (c) the...
-
In the preparation of a logical data flow diagram for a payroll processing application, which of the following symbols should be used to indicate the payroll data? (a) terminator symbol (b) data...
Study smarter with the SolutionInn App