Managerial Accounting

Use the data in the Excel file provided to forecast the demand of a particular product using various methods and time periods as noted below. NOTE: YOU MUST SHOW ALL YOUR WORK IN THE EXCEL FILE. MAKE SURE YOUR ANSWERS APPEAR IN THE WORKSHEET THAT IS NAMED “TEMPLATE.” YOU CAN CREATE NEW WORKSHEETS OR SHOW ADDITIONAL WORK IN THE WORKSHEET PROVIDED.

a. Prepare a time-series plot of the data. Does the data appear to have a trend or seasonality?

b. Use the naïve method to forecast the demand for the last three months of 2016.

c. Use the moving average method with 4 periods, i.e., MA(4), to forecast the monthly demand for January 2016 through December 2016.

d. Use the exponential smoothing method with a=0.4 to forecast the monthly demand for January 2016 through December 2016. Use the actual demand observed in January 2015 as your initial forecast for January 2015 (That is, start the model in January 2015.

e. Fit a trend line to the data provided for January 2015 to December 2015. Using the equation of the trend line you found, forecast the monthly demand for January 2016 through December 2016.

f. Compute the MAD for each method, that is, the Naïve, MA(4), ES(0.4), and the trend line during January 2016 to September 2016.

g. Choose one of the time-series methods you analyzed thus far which will provide you the most reliable estimate and why? What are the demand forecasts for the last three months of 2016 if this method is used?

You can leave a response, or trackback from your own site.


6 Responses to “Managerial Accounting”

  1. CI/CD says:

    669794 734364However, what about the conclusion? Are you certain concerning the supply? 474605

  2. 563156 508340If running proves to be a difficulty then it could be wise to uncover alternative exercises such as circuit training, weight training, swimming or cycling. 809710

  3. 350878 598986Highest quality fella toasts, or toasts. will most certainly be given birth to product or service ? from the party therefore supposed to become surprising, humorous coupled with enlightening likewise. best man speaches 789310

  4. 64253 471288You produced some 1st rate factors there. I seemed on the internet for the difficulty and located many people will go along with together together with your site. 612823

  5. 280737 849942Im often to blogging and i in actual fact respect your content. The piece has in fact peaks my interest. Im going to bookmark your content material and preserve checking for brand new info. 584326

  6. 59087 604634Aw, it was a quite good post. In idea I would like to devote writing such as this furthermore,?C spending time and specific function to produce a great write-up?- nonetheless so what can I say?- I waste time alot and never at all appear to obtain one thing completed. 795924

Leave a Reply

Powered by WordPress | Designed by: buy backlinks | Thanks to webdesign berlin, House Plans and voucher codes