Forecasting - The best approach

Hello everybody,

We're an arts start-up and trying to forecast revenue versus expenses using different types of revenue or expense models.

On the revenue side, we have the following variables:

Venue seat size
Ticket cost
Occupancy rate

On the expense side, we have different types of expenses:

Fixed expenses:

This could be two types of fixed expenses: venue rental expense or lease expense.

Operating expenses:

There are various way we could operate: having contractors, employees, etc.


What's the best way to do revenue versus expense forecasting based on different models? Thanks.

Anvah.

I guess my question is - what's the best way. For example, when I did some preliminary work on this, I did the following:

1. Create a table with different possibilities

Ticket Price Occupancy Venue Size
5 20% 80
10 50% 100
15 75% 140
20 90% 200

2. I then did a self join on this to get all combinations and permutations in a new table. So this created a new table with all combinations of ticket price, occupancy, and venue size.

3. After, I created a pivot on that and do analysis.

Is there an easier way than this? Explaining this process to others in a team is challenging. Thanks.