Question: I need help with this using excel. My App is a small but growing start-up that sees demand for several of its apps increasing quickly.
I need help with this using excel.
My App is a small but growing start-up that sees demand for several of its apps increasing quickly. The table below shows the last six months of downloads. Use a forecast for the first month of 240,000, an initial trend forecast of 50,000, and smoothing parameters of 0.35 for both demand smoothing and trend smoothing Month (t) Monthly Application Downloads Forecast for Next Month 240,000.00 1 240,000 240,000.00 2 250,080 396,000.00 3 325,000 507,481.00 4 370.000 654,863.00 5 420.000 795,661.00 6 509,000 937,180.00 Trend 50,000.00 50,000.00 87,100.12 95,633.16 113,745.31 123,213.89 129,620.66 (Round your answers to 2 decimal places.) Complete the table above, filling in the Forecast for next month and Trend" columns, using double exponential smoothing a (Round your answers to 2 decimal places) Month 7's forecast is b 1,265,766 39
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
