Purchase Solution

Forecasting Monthly Sales on a Month by Month Basis

Not what you're looking for?

Ask Custom Question

I am trying to develop a model using Excel (data table perhaps) that can be used to forecast monthly sales on a month-by-month basis based on previous monthly data starting with January of year 7. The sales history is attached.

Purchase this Solution

Solution Summary

This solution opens with a short discussion on available forecasting methods and chooses the best methods based on information and data given in the problem. The solution then shows detailed computations on forecasting monthly sales using the trend projection and the seasonal index method, using Excel.

Solution Preview

Dear Student:

Please open the attached Excel file and continue to read the following additional remarks.

There are several forecasting methods. It depends on the situation, which would be the best method to use, as each case is different, and often doing forecasts using several methods would be advisable. The best forecasting method could be verified using MAD (mean absolute deviation), but to calculate this we would need the forecasted sales from years 1 to 6, which are not given in the assignment, as in this case the data given in the assignment includes only actual monthly sales numbers. To increase the accuracy of our forecast, we would want to use a more ...

Purchase this Solution


Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Operations Management

This quiz tests a student's knowledge about Operations Management