The Questor Corporation has experienced the following sales pattern over a 10-year period: Complete the table using...

80.2K

Verified Solution

Question

Accounting

The Questor Corporation has experienced the following salespattern over a 10-year period:
Complete the table using a first-order exponential smoothingmodel with a w=0.9w=0.9 to forecast sales in2017.
Year
Sales (YtYt)
Exponential Smoothing (YˆtY^t)
(000)
(w = 0.9)
2007 187
2008 214 187
2009 216 =216,203, or 211
2010 234 = 228,205, or 216
2011 268 = 238, 222, or 232
2012 277 = 287,255, or 264
2013 302 = 263, 276, or 293
2014 302 = 323, 299, or 287
2015 318 =287, 302, or 320
2016 350 =302, 321, or 316
2017 * = 356, 347, or 302

Year	Sales (YtYt)	Exponential Smoothing (YˆtY^t)
2007	187
2008	214	187
2009	216	=216,203, or 211
2010	234	= 228,205, or 216
2011	268	= 238, 222, or 232
2012	277	= 287,255, or 264
2013	302	= 263, 276, or 293
2014	302	= 323, 299, or 287
2015	318	=287, 302, or 320
2016	350	=302, 321, or 316
2017	*	= 356, 347, or 302

Answer & Explanation Solved by verified expert

4.4 Ratings (916 Votes)

The above solution can be derived in several medium1 If solved with in Excel through Data Analysis Tool Step 1 Enter the data in excelStep 2 On Data Tab See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Year	Sales (YtYt)	Exponential Smoothing (YˆtY^t)
Year	(000)	(w = 0.9)
2007	187
2008	214	187
2009	216	=216,203, or 211
2010	234	= 228,205, or 216
2011	268	= 238, 222, or 232
2012	277	= 287,255, or 264
2013	302	= 263, 276, or 293
2014	302	= 323, 299, or 287
2015	318	=287, 302, or 320
2016	350	=302, 321, or 316
2017	*	= 356, 347, or 302