Reduce GP Percentage Evenly For Two Departments

When we sell things here at a 'sale' price there is always an argument as to who's department needs to give the discount off.

Each job we do has a labour time and an hourly labour rate.

Each part has a profit in it.

So if something is normally £100 but we are going so sell it for £80 we need tio split the £20 reduction evenly to both departments based on the GP each department has in the sale.

See attached : GP Reduction per department.xlsx‎