Tuesday, June 4, 2024
Home Business & Economics Forecasting & Simulation

# Forecasting & Simulation

Articles about forecasting and simulation with Excel.

### Use Common-Age Excel Charts to Compare and Forecast Performance for the Same Number of...

In the early lives of new products or new stores, managers often are anxious to track and improve sales performance. To do so, it's...

### Find Leading Indicators Using Automated Cross Correlations in Excel, Part 2

In Part 1 of this discussion about automated cross correlations, I explained how to set up  the cross-correlation Data Table shown below, in columns...

### Find Leading Indicators Using Automated Cross Correlations in Excel, Part 1

It all seems so simple... To improve your forecasts of sales or other measures, you simply need to find leading indicators...measures that are highly correlated...

### How to Reproduce Your Excel Work Across Many Categories, Part 2 of 3

As I explained in Part 1 of this series, Excel users often need to apply many instances of data to one model or forecast, list...

### How to Reproduce Your Excel Work Across Many Categories, Part 1 of 3

A member of an Excel forum recently asked how to solve a problem that many Excel users face in various forms. In his particular case,...

### How to Create a Rolling Forecast of Seasonal Sales in Excel

The Excel chart below shows the typical saw-tooth pattern of seasonal sales. Seasonal sales have about the same pattern every year, every week, or both. In...

### How to Audit and Improve Excel Business Plans

A client, who's a business-finance consultant, recently was hired to improve the financial forecast for a major startup company. He recently sent me the...

### Highlight Normal Results in Line Charts to Make Exceptional Results Stand Out

Line charts that show trends in performance are the most useful type of chart that management reports can contain. All managers want good performance to...

### How to Create Monte Carlo Models and Forecasts Using Excel Data Tables

(Download the workbook.) (This is the second of two articles about normal distributions. The first article is, How to Return Random Numbers from a Normal...

### How to Return Random Numbers from a Normal Distribution for Your Excel Forecasts

(This is the first of two articles about normal distributions. The second article is, How to Create Monte Carlo Models and Forecasts Using Excel Data...