Question: 25. Calculate the demand forecast using Exponential smoothing (alfa 0.3) for 2021. (Use 1764 as your first period's (2005) forecast. Round the number) Show your

25.

Calculate the demand forecast using Exponential smoothing (alfa 0.3) for 2021.

(Use 1764 as your first period's (2005) forecast. Round the number)

Show your work in Excel please.

Period Demand
2005 1498
2006 1514
2007 1524
2008 1552
2009 1576
2010 1612
2011 1642
2012 1690
2013 1734
2014 1790
2015 1840
2016 1908
2017 1972
2018 2048
2019 2118
2020 2206
2021 ?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

A periodic square wave m(t) (Fig. P5.4-2a) frequency-modulates a carrier of frequency fe 10 kHz with Af = 1 kHz. The carrier amplitude is A. The resulting FM signal is demodulated, as shown in Fig....

Q:

Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the past 24 months. This is shown. a. Develop a linear trend line for the data. (Round your answers to...

Q:

To test this backup system, they use the following historical data from a cloud - based system. Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 1 2 , 0 0 0 1 4 , 0 0 0 1 1 , 0 0 0 1 5 , 0 0 0 1 5 ,...

Q:

periods from 3 to 13 using the exponential smoothing method. Do not round intermediate calculations. Round your answers to the nearest whole number. 2. Choose the correct graph for the exponential...

Q:

1 Use data in Worksheet Q1-9 to answer questions 1 to 9. The data is for a sample of dealerships and was collected for the second week of August 2016. Which variables are qualitative? A. New Car...

Q:

please explain answers solve the equation, using rhe graph provided with the questions below the chart PROBLEM 1: In an assembly line, there are 7 workstations, as shown below. In row 1, you are...

Q:

Really needs help with my project. please show workings. can contain viruses. Unless you need to edit, it's Assignments must be legible and well-organized. Students can receive up to 5 marks for a...

Q:

Data collected from a single entities across a given period called: A. Cross-sectional data B. Time series data C. Categorical and quantitative data D. Random data E. None of the choices 2. Which of...

Q:

Use Trend Adjusted Exponential Smoothing formulas above to find Forecast for 1995-2004 and Calculate Error as Absolute value of Sales minus Forecast Please show work in excel, I should be able to...

Q:

Solve these on excel for me Problem 1 . United Dairies, Inc.: United Dairies, Inc. supplies milk to independent grocers in Collier County, Florida. Milk is perishable so forecast accuracy is critical...

Q:

Q1. A sales manager wants to forecast monthly sales of the machines the company makes using the following monthly sales data. (To receive full credit, please write the formulae for all the...

Q:

I D.2:- A fcc lattice such as inert gas turned solid at lov temp, the path energy can be expressed as U = N [1213 (7) - 14:45 (+)6]. 12 where 8 - distance b/w nearest neighbours & is a constant of...

Q:

Determine the pH of a 1.00 M solution of HNO2. The Ka for HNO2 is 5.6 104.

Q:

Use division to convert each fraction to an equivalent decimal. a 3/8 b 5/11 c 11/12

Q:

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...