-
+1 - 312-224-1615
Get in touch with us
-
support@helpwithassignment.com
Send us an e-mail
Solution Library
Explain Exponential Smoothing Model With Sales Forecast
Question
The table below provides a list of sales figures for this past year for your mountain resort. You want to project a forecast for January of the following year. You want to select from 3 models to make your forecast: 1) a 3-month moving average; 2) a weighted moving average (you believe your weights should be 0.2, 0.3, & 0.5); and 3) an exponential smoothing model in which will use an a = 0.2. Your assumed forecast for January is $32,000.
a. Construct a table that shows each of these forecasts for the current year and provide the forecast for January of this coming year.
b. Using the data given, and your forecasts, which model do you think is the best model for your business?
|
Month |
Previous year sale $ |
|
January |
32,645 |
|
February |
31,456 |
|
March |
30,270 |
|
April |
33,129 |
|
May |
34,456 |
|
June |
35,256 |
|
July |
36,218 |
|
August |
35,456 |
|
September |
34,250 |
|
October |
32,156 |
|
November |
30,125 |
|
December |
32,275 |
|
January |
Summary
The question belongs to Statistics and it discusses about forecasting sales for a business using exponential smoothing model. The calculations have been in the Excel sheet and attached along with the solution.
Total Word Count 404
Download Full SolutionWHAT OUR STUDENTS SAY
I had missed the classes on Isometrics because I had to miss school for some family emergencies. With the existing course load I had not got time to catch up with the topic and so when time came to write the assignment on Isometrics I was absolutely clueless. Thanks to the basic mathematics assignment experts at HwA I was able to not only understand the assignment but also submit the essay on time. The quality of work provided is also very high and I have been noticing an upturn in my overall grades.
Jamal Akhtar Student
I was badly stuck with my Faraday’s law assignment and was unable to do the calculations. However, when I came across HwA they did help me a lot and from there on I hire their help for all of my science assignments.
Martin Collins Student
Concepts like diffusion between phases often confused me in the past. I used to stumble at each given assignment. However, when I came across HwA, they took time to make me understand and solved all the critical problems, thereby helping me get excellent grades.
Jill Green Student
Dissertation paper completed on time and this credit completely goes to TheReliableTutor.com. Thank you so much guys, its only just because of you that I completed on time and got good job.
Austin Student
The most fascinating thing is how they actually respond to quick demand. It was a classic mistake! The actual deadline of my ratio analysis assignment was on 16th and I mentioned to them that it is 26th. Just when I had pinged them on 14th, they instantly delivered me the accounting homework by 15th evening. I was so relieved and thrilled to get in the same.
John Stamford Student
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.