Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Apr 27, 2023

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.

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 ?

Step by Step Solution

★★★★★

3.40 Rating (159 Votes )

There are 3 Steps involved in it

Step: 1

A Calculate MAD for 20172019 Year Sales 2017 900 1050 1200 1325 4475 20... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Statistics

Authors: Robert A. Donnelly

2nd Edition

0321925122, 978-0321925121

More Books

Students also viewed these Accounting questions

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

PROVE that for any convex polygon with three angles whose sum is 180 , then the polygon must be a triangle.

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

How does feedback value relate to predictive ability and accountability?

Answered: 1 week ago

Question

★★★★★

Eastman Publishing Company is considering publishing a paperback textbook on spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and production setup is...

Answered: 1 week ago

Question

★★★★★

Given that y = 3x 2 (5x 3) 3 , show that where n, A, B and C are constants to be determined. dy dx = Ax (5x - 3)" (Bx + C)

Answered: 1 week ago

Question

★★★★★

Where is the position?

Answered: 1 week ago

Question

★★★★★

Midwest Ventilation, Inc., produces industrial ventilation fans. The company plans to manufacture 72,000 fans evenly over the next quarter at the following costs: direct material, $2,880,000; direct...

Answered: 1 week ago

Question

★★★★★

19) How are cost drivers selected in activity-based costing systems

Answered: 1 week ago

Question

★★★★★

This problem continues the process of preparing the Kipley Company's Employee Payroll Register for the pay period ending January 8th, 20--. In previous chapters, gross wages were computed for each...

Answered: 1 week ago

Question

★★★★★

Rodriguez Company pays $410,670 for real estate with land, land improvements, and a building. Land is appraised at $208,000; land improvements are appraised at $52,000; and the building is appraised...

Answered: 1 week ago

Question

★★★★★

Mr. Jones is contemplating retirement. He has just celebrated his 55th birthday and his net worth is $2 million. He hopes that after retirement he can maintain a lifestyle that costs him $100,000 per...

Answered: 1 week ago

Question

★★★★★

5. A manager of a Merchandising firm wishes to test whether its three salesmen X, Y and Z tend to make sales of the same size or whether they differ in their selling abilities. During a week there...

Answered: 1 week ago

Question

★★★★★

What is one way a professional running a lineup can make the procedure suggestible to an eyewitness? A) encouraging the witness when they identify the suspect B) remaining silent when witnesses make...

Answered: 1 week ago

Question

★★★★★

Suppose that 3000 drivers in Wakanda were randomly breath-tested on 21 April 2019 and 116 were above the limit of 0.05 blood-alcohol level. On 15 May 2019, 4000 drivers were tested and 98 were above...

Answered: 1 week ago

Question

★★★★★

Which of the following is an appropriate guideline for waste disposal? O a. Clean trash cans regularly to remove drips and crumbs that provide food for pests Ob. Do not use plastic liners in trash...

Answered: 1 week ago

Question

★★★★★

Question 3 (20 marks) Accounting for Non-current Asset Part 1 (10 marks): Kiri Printing Service Ltd uses the straight-line method to account for the depreciation of their non-current assets. The...

Answered: 1 week ago

Question

★★★★★

Havel says the grocer doesnt believe what is on the sign and indeed, he says the grocers customers will barely notice it. But Havel maintains that the sign serves a specific function. How would you...

Answered: 1 week ago

Question

★★★★★

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 =...

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

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.

Answered: 1 week ago

Question

★★★★★

The Center on Budget and Policy Priorities (www. cbpp.org) reported that average out-of-pocket medical expenses for prescription drugs for privately insured adults with incomes over 200% of the...

Answered: 1 week ago

Question

★★★★★

The Jordeen Bottling Company recently did an extensive sampling of its soft-drink inventory in which 5,000 cans were sampled. Employees weighed each can and used these weights to determine the fluid...

Answered: 1 week ago

Question

★★★★★

For the following hypothesis test: H0: m 45 HA: m 45 a 0.02 with n 80, s 9, and 47.1, state a. the decision rule in terms of the critical value of the test statistic b. the calculated value of...

Answered: 1 week ago

Previous Question Next Question