Develop a sales forecasting system for a new car dealership

Use a spreadsheet program to develop a sales forecasting system for a new car dealership that can estimate monthly sales for each make and model based on historical sales data and various parameters. Suggestion: Assume that this month’s sales will be the same as the sales for this month last year except for adjustments due to the cost of gas andeach make of car’s miles per gallon. You can further refine the model to take into account change in interest rates for new cars or other parameters you wish to include. Document the assumptions you make in building your model.

Solution: