Reference no: EM132282923

Teresa Miller is responsible for demand planning at BIOCNG Enterprises. As part of her planning activities, she must develop a demand forecast for the next four quarters. She will then use her demand forecast to plan and manage the company’s production schedules. Teresa has the following historical demand (sales) figures available to her. She will have to present her demand analysis and forecast to the company’s planning team. Consequently, she will want to have both graphical and table summaries of her findings, together with some measure of forecast accuracy. Question: 1. Your role is to provide assistance to Teresa and help her prepare a forecast for the next four quarters (quarters 3 and 4 of 2020 and quarters 1 and 2 of 2021). As part of the analysis, your report should identify an appropriate forecasting technique, develop a forecasting model, use the forecasting model to generate forecasts for the historical quarters as well as for the planning quarters, and provide an assessment for the forecasting model’s accuracy. You are to prepare a spreadsheet analysis and copy and paste it into an Appendix to a one to two-page report that provides Teresa Miller with the rationale for a forecasting model, a forecast for both the historical period, and the next four quarters as outlined in the problem, along with an assessment of the accuracy. Ensure that the spreadsheet is structured for Teresa to easily understand your analysis (i.e., use titles and organization of your exhibit – it may need to be presented in several exhibits as well.)