I think it looks like this...
Source |
Revenue |
Cost |
Gross Profit |
GP% |
IFE Sales |
552,157.00 |
425,160.89 |
126,996.11 |
23% |
Settlement |
1,600,000.00 |
640,000.00 |
960,000.00 |
60% |
Totals |
2,152,157.00 |
1,065,160.89 |
1,271,924.79 |
59% |
I used the last year IFE GP for the IFE sales, that could be off a little, as the total should be a little lower. I don't have time to clean it up.