John and Michael know that to be successful they need to properly staff their company and order the right amount of materials, and to do so, a new forecast method is needed. While they have used a simple forecast up to this point, they no longer believe that method will work for them and the company. They are now coming to you for help in selecting the right forecasting method and to develop an initial forecast.
research and select a relatively new company for which you use as a benchmark. After researching your selected company, come up with a recommendation, for them, on which type of forecasting method they should use and why. Based on the recommendation, you must create a spreadsheet with a 12-month forecast highlighting the key factors used in its development. Your spreadsheet may also contain assumptions that support your argument.
you must submit a spreadsheet consisting of 1,200-1,500 words in which you recommend a specific method of forecasting for your selected company. For full-credit, you must address the following in your spreadsheet:
· Research and select a relatively new company.
· Explain the various methods of forecasting to develop an aggregate forecast.
· Explain which type of forecasting method the company should use and why.
· Create a spreadsheet with a 12-month forecast highlighting the key factors used in its development.
· Explain why you chose the method that you did.
· Provide some assumptions that support your argument.
The attached excel file with all model templates provided. You can use this for forecasting. Just pick oneAll models (1).xlsx