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?
-
Listed below are the results of Messier Chocolate's operations for 2011 and 2012. (Assume 5,000 shares of outstanding stock for both years.) Required: 1. Prepare a comparative income statement for...
-
Indicate whether each of the following statements is true or false by writing T or F in t he a nswer c olumn. Conditions subsequent are required acts that must be performed after a contract is signed.
-
The pump shown in Fig. P5.6 produces a steady flow of \(10 \mathrm{gal} / \mathrm{s}\) through the nozzle. Determine the nozzle exit diameter, \(D_{2}\), if the exit velocity is to be \(V_{2}=100...
-
Washington Mining began operations by issuing common stock for $150,000. The company paid $135,000 cash in advance for a one-year contract to lease machinery for the business. The lease agreement was...
-
Discuss disparities in the sentencing of defendants in our criminal justice system based on wealth. Cite at least one example and a valid external source of information (case, journal article, legal...
-
On November 10, 2020, Singh Electronics began to buy and resell scanners for $55 each. Singh uses the perpetual system to account for inventories. The scanners are covered under a warranty that...
-
A five-digit number divisible by 3 has to be formed using the numerals 0, 1, 2, 3, 4 and 5 without repetition. The total number of ways in which this can be done is
-
Explain the Figure 68 and Figure 69 briefly. P Pricing and Output under Pure Competition INDUSTRY S -P C FIRM Profit ID MC Output in Million Figure 68: Purely Competitive Model with Few Firms AC 151...
-
Identify the domain of the following functions: a) f(x) = log(-2x+6) Domain: b) f(x) = ln(2x - 8) Domain: c) f(x) = log7(-3x - 2) Domain
-
What advanced interventions can organizations implement to address emotional intelligence deficits among employees, such as targeted coaching, training, or immersive experiential learning programs?
-
K Write a system of equations in x and y describing the situation. Do not solve the system. Keiko has a total of $5900, which she has invested in two accounts. The larger account is $800 greater than...
-
The accompanying image features two charged objects: a 1 . 0 ?m radius sphere with its center at the origin and a long straight rod parallel to the z - axis, passing through the point ( 0 , 2 , 0 ) ...
-
The following data relate to Webster Manufacturing Anticipated sales Normal sales price/unit. Variable manufacturing cost/unit. Variable selling and administrative cost/unit.. Fixed manufacturing...
-
Draw two scatterplots, one for which r = 1 and a second for which r = 21.
-
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.
-
The five countries that have won the FIFA World cup more than once include Uruguay (2), Italy (4), Germany (4), Brazil (5), and Argentina (2). Use a Pareto chart to display the data. Organize the...
-
Use a dot plot to display the data, which represent the blood glucose levels (in milligrams per deciliter) of 24 patients at a pathology laboratory. Organize the data using the indicated type of...
-
Use a dot plot to display the data, which represent the weights (in kilograms) of 20 polar bears. Organize the data using the indicated type of graph. Describe any patterns. 426 428 436 545 510 386...
Study smarter with the SolutionInn App