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?
-
A balanced three-phase wye-wye system has two parallel loads. Load 1 is rated at 3000 VA, 0.7 pf lagging, and load 2 is rated at 2000 VA, 0.75 pf leading. If the line voltage is 208 V rms, find the...
-
(a) Complete the following code by defining a macro Sum. Use parameters to initialize the numbers to 9 and 11. always @(posedge clk) begin $display("The sum of %d and %d is %d", A, B, Sum(A,B));...
-
A program that attaches to another legitimate program but does not replicate itself is called a a. virus. b. worm. c. Trojan horse. d. logic bomb.
-
Use the information provided in Problem P3-18 about Superstar Ice Rinks Inc. (SIR) to do the following: a. Prepare all necessary journal entries for fiscal 2017. Provide an explanation for each...
-
2 2 Convert the equation x+y-25=0 to polar form. Then solve the resulting equation for r. rr = = 0 89 = sin COS tar cot
-
Simplifying the ABC System: TDABC Golding Bank provided the following data about its two checking account products and their associated resources and activities: Resources Activities $60,000...
-
A. How difficult do you think it is it for people to see each others perspectives when solving problems? Explain. B. How would you manage people who are in conflict about a situation such as the one...
-
Define and discuss the purpose of a performance management system. What are some of the benefits and challenges of a performance management system?
-
Xie Company identified the following activities, costs, and activity drivers for this year. The company manufactures two types of go- karts: Deluxe and Basic. Activity Handling materials Expected...
-
What are the Operations of Sundrop? Visualize the Value Chain of Sundrop, from Sun an Sea to End Customer. How are the Operations and Supply Chain of Sundrop different from the operations and supply...
-
QUESTION ONE Bernie ltd. is a newly organized manufacturing business that plans to manufacture and sell 100,000 units per year of a new product. The following estimates have been made of the...
-
Define "value" in the context of Business Marketing.? What are two main types of value marketing?Discuss
-
A simple majority of employees that vote in a unionrepresentation election is required in order for employees to winunion representation.TrueFalse 2 answers
-
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.
-
Reida Oil Corporation incurred the following costs during the fiscal year ending May 31, 2015. Prepare journal entries for the above transaction, assuming that Reida Oil Corporation uses the full...
-
Revenue and costs for Optimistic Company for the year 2015 are presented below: Prepare income statements and unclassified balance sheets for a successful efforts (SE) company and a full cost (FC)...
-
Elizabeth Corporation incurred the following costs during 2015: Elizabeth uses the successful efforts method of accounting. Prepare the journal entries for the year-end December 31, 2015. January 12...
Study smarter with the SolutionInn App