From the beginning of the first table, could you please share the calculations for each cell. Not getting how the numbers are calculated. It would be helpful to understand if you could share the excel sheet.

This is the Gibson Insurance Case study from Course Hero. In the below table, please help to understand how the 'Summation of all costs" and cost for each unit is calculated.

Aggregate support cost Summation of all costs Steps 4,375,296.00 103,630 cost for each unit Calls 2,425,943.60 55,060.00 Total sales made 4,553,088.00 454,400.00 2,530.51