Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Questor Corporation has experienced the following sales pattern over a 10year period: Complete the table using a rstorder exponential smoothing mode.-' with a w

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
The Questor Corporation has experienced the following sales pattern over a 10year period: Complete the table using a rstorder exponential smoothing mode.-' with a w = 0.9 to forecast sales in 2017. Sales (K) Exponential Smoothing (f1) Year (000) (w : 0.9) 2007 123 2008 138 123 2009 163 l 2010 198 l 2011 202 l 2012 216 l 2013 240 l 2014 274 l 2015 277 l 2016 290 l 201? * l Bell Greenhouses has estimated its monthly demand for potting soil to be the following: N=400+5X where N is the monthly demand for bags of potting soil and X is the time period in months (March 2016 = 0). Assume this trend factor is expected to remain stable in the foreseeable future. The following table contains the monthly seasonal adjustment factors, which have been estimated using actual sales data from the past five years: Complete the following table by forecasting Hell Greenhouses' demand for potting soil in March, June, August, and December 2017. Month Adjustment Factor (My) Forecast March +2 l June + 15 ; August + 10 l December 12 l The following table shows the forecasted and actual potting soil sales by Bell Greenhouses for April in five different years. Year Forecast Actual 20 17 465 498 "mu; Anl: )I'10 June +15 August +10 December -12 The following table shows the forecasted and actual potting soil sales by Bell Greenhouses for April in five different years. Year Forecast Actual 2017 465 498 2016 405 429 2015 345 362 2014 285 296 2013 225 232 What seasonal adjustment factor would you recommend be used to forecast in April 2018? O 3.1% O 2.4% O 5.0%SavingseMart (a chain of discount department stores) sells patio and lawn furniture. Sales are seasonal, with higher sales during the spring and summer quarters and lower sales during the fall and winter quarters. The company developed the following quarterly sales forecasting model: 1?, = 6.00 + 0.600: 2.7501, + 0.251); + 3.5133 where Y: = predicted sales (in millions a f dollars ) in quarter t 6.00 = quarterly sales (in millions afdollars) when t = 0 t : time period (qurter) where the fourth quarter 01'2012 : 0', first quarter (#2013 : I, . D1; : 1 for rst-qlmrter observations; 0 otherwise D; : I for secondquarter observations; (lather-wise D3 = I for thirdquarter obseiatiana; (lather-wise

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

blur-text-image

Step: 3

blur-text-image

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

Principles Of Microeconomics

Authors: N Gregory Mankiw

7th Edition

1305081676, 9781305081673

More Books

Students also viewed these Economics questions

Question

discuss what an intervention is in relation to work psychology;

Answered: 1 week ago