Intercompany cost allocation in SD

Hello,

we have a Holding with company code 001 und two companies 002 and 003.

The Holding collects costs of Management in a cost center. Example: at the end of the year $ 10,000. The holding company would like to bill this cost to the companies with a margin of 5 %. The costs are divided according to proportions, 40 % for company code 002 and 60 % for 003.

An invoice should be issued to the companies with automatically calculated amounts ideally.

Example:

Invoice to Company 002 $ 4,200

Invoice to Company 003 $ 6,300

Is there a way to solve this nicely? Currently this is solved manually in Excel.

Thank you very much