Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Predict the sales for 20X9 using the moving average method. Year Sales 20X2 $450,000 20X3 $385,000 20X4 $495,000 20X5 $720,000 20X6 $680,000 20X7 $590,000
1. Predict the sales for 20X9 using the moving average method. Year Sales 20X2 $450,000 20X3 $385,000 20X4 $495,000 20X5 $720,000 20X6 $680,000 20X7 $590,000 20X8 $620,000 $562,857 projection using the moving average method. Year Sales 20X2 $450,000 20X3 $385,000 20X4 $495,000 20X5 $470,000 ($720,000-$250,000) 20X6 $680,000 20X7 $590,000 20X8 $620,000 $527,143 Predict the 20X9 sales using exponential smoothing. Predict the 20X9 using a trend line technique using (GROWTH function in Excel). Predict the sales for 20X9 using a graphing technique. It has been suggested that sales for the company may be connected to disposable income. Using the information below regarding historical disposable income, predict the sales for 20X9 using regression analysis if a reliable prediction for disposable income for 20X9 is $45,720. Year/Sales 20X2$36,200 20X3$37,140 20X4$38,120 20X5$38,450 20X6$41,190 20X7$43,220 20X8$42,850 5Which method do you think provides the most realistic sales projections for 20X9? Why
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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