Customers’ Orders Book by gillani77
Created by: gillani77

 

In this article we will learn about how to prepare customer order book in Microsoft Excel 2013.

Customer’s order book used to calculate profit gain, profit percentage etc. information about the customers.

Let’s take an example to understand how we can prepare the Customers order book.
 
img1
 
img2
 
In this table we can see the whole sale price and today’s price, according to these amount we can return the todays fix gain. In this report today’s fix gain amount will be equals to =1-(todays rate/whole sale rate).

Partial Result for Dubai
 
img3
 
In this table we can return the customer’s amount status such as profit percent, profit gain, fee, partial cost, bank charges, volume and transactions.

Profit percentage will be = (Volume/Profit Gain)*100

Partial cost will be = ((Fee+Volume)/100)*0.19

Bank Charges will be = (Profit Gain + Fee)-Partial Cost

Partial Result for Dubai
 
img4
 
In this table we can return the customer’s amount status such as profit percent, profit gain, fee, partial cost, bank charges, volume and transactions.

Profit percentage will be = (Volume/Profit Gain)*100
 
 

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube