Hi..all

Pls help me

I need a excel format which calculate total income to company and payment to supplier.

Following is the details:-
TOTAL SALES : 129,818.40


GRILLED CHICKEN SALES: 18,551.25


GRILLED CHICKEN QTY: 1,455.00


COMMISSION @ 20% i.e Total sales -Grilled chicken sales *20%

AED 1/- FOR EACH QTY OF GRILLED CHICKEN TO BE DEDUCT FROM THE PAYMENT TO SUPPLIER i.e 1455*1

so. supplier payment is :-(total sales-grilled chicken sales-commission)+(Grilled chicken sale-1455)