Please show work and show formula for missing cells

Glassboro Insurance Company enters into a surplus share treaty with Waterford Re. Glassboro retains a line of 15,000- the treaty contains 10 lines and provides for a maximum cession of $150,000. How would the following policies and losses be shared? Glassboro Insurance Company Vaterford Re - The Reinsurance Total Policy A Amount of Insurance Percentage of insurance alloc Premiums Losses 30,000 100% 700 8,000 0 0.00% 0 0 Policy B Amount of Insurance Percentage of insurance alloc Premiums Losses 90,000 100% 1000 10,000 0 0.00% 0 0 Policy C Amount of Insurance Percentage of insurance alloc Premiums Losses 90,000 100% 1000 60.000 0 0.004 0 0 Policy D Amount of Insurance Percentage of insuranoe alloc Premiums Losses 300,000 100% 20000 100.000 0 0.004 0 0 Policy E Amount of Insurance Percentage of insurance alloc Premiums Losses 300,000 100% 20000 200.000 0 0.0074 0 0 Glassboro Insurance Company enters into a surplus share treaty with Waterford Re. Glassboro retains a line of 15,000- the treaty contains 10 lines and provides for a maximum cession of $150,000. How would the following policies and losses be shared? Glassboro Insurance Company Vaterford Re - The Reinsurance Total Policy A Amount of Insurance Percentage of insurance alloc Premiums Losses 30,000 100% 700 8,000 0 0.00% 0 0 Policy B Amount of Insurance Percentage of insurance alloc Premiums Losses 90,000 100% 1000 10,000 0 0.00% 0 0 Policy C Amount of Insurance Percentage of insurance alloc Premiums Losses 90,000 100% 1000 60.000 0 0.004 0 0 Policy D Amount of Insurance Percentage of insuranoe alloc Premiums Losses 300,000 100% 20000 100.000 0 0.004 0 0 Policy E Amount of Insurance Percentage of insurance alloc Premiums Losses 300,000 100% 20000 200.000 0 0.0074 0 0