Cost calculation

[pheck1964]

Hello! As I'm quite new on Airtable, I need some help on the general approach for the following task:

I already have a table of products for my Webdesign Agency with prices per year and use this also to track by renewals.

Structure like in this photo:

Now, I want to have a table, where I can distribute the costs to my customer. I would need to assign products to customers and based on the numbers of customer assigned to a product, the cost per customer is calculated (Price of the product divided by the numbers of customers using this product = price per customer) and it should be displayed like in this Excel table I use currently:

Honestly saying, I have no idea, if such a scenario could be done with Airtable or if I should use Excel instead...

So my question: Is this possible and if yes, is there any tutorial available, where such a scenario is explained?

Thanks in advance for your help!

Cheers Peter

[TheTimeSavingCo · Accepted solution]

Hmm, getting it displayed like that would be quite difficult; if you could talk a bit about your business case perhaps we could find a workaround?  Getting the split per company and the total per customer is fairly easy though, here's a simplified example:

  

Link to base

[pheck1964]

Thanks - it brings me a big step forward!