Discount to be distributed in proportion

Hi All,

Could you kindly share with me on how I should go about indicating the formula for the attached?

A quick overview:

Bulk discount is calculated based on the figure indicated on B2.
Net is the value of Price + Bulk Discount.
Commission is calculated based on the % indicated on F21.
Final is the sum of Net + Commission.

I would like to indicate a value on cell D19, and have this discount reflected in proportion towards all the items, under Final.
For example: a discount of 200. This 200 should be distributed in proportion towards item 1 - 9.
The end result that I'm looking to get is D22 having the same value as F22.

Thank you very much in advance.

Try this in F6 and copy down to F14

=((D6)/($D$15)*$D$19+D6)*0.95

a little more clear formula:

=((D6/$D$15)*$D$19+D6)*0.95

Thank you, modytrane and kvsrinivasamurthy, very much for taking the time to help me out on this. Much appreciated!