1,438
edits
Changes
no edit summary
<languages/>
<translate>
<!--T:1-->
<!--T:3-->
<!--T:4-->
If you do not have all the available data, leave the corresponding columns blank.
<!--T:22-->
[[Special:FilePath/Sales.xlsx|Download Sample Worksheet]]
<!--T:5-->
[[Share dashboards|Share]] your information with ''Affiliates'' and ''Sellers'' by displaying only relevant information to them, while you have full access to all information.
<!--T:7-->
Sales Spreadsheet Information:
<!--T:8-->
* '''Order Date''': Date on which the sale was made
* '''Delivery Date''': Date on which the order was delivered
* '''Branch''': Affiliate which performed the sale
* '''Group''': Group to which belongs the sold product
* '''Product''': Name of the sold product
* '''Customer''': Customer name
* '''City''': City where the customer lives
* '''State''': State where the customer lives
* '''Region''': The region of the country where the customer lives
* '''Salesman''': Name of the salesperson who performed the sale
* '''Quantity''': Quantity sold of a product
* '''Price''': The price of the sold product
* '''Taxes''': The amount of taxes levied on the product sale
* '''Net Revenue''': The net value of the product sale
* '''Cost''': The value of the product purchase cost
* '''Profit''': Profit obtained from the product sale
* '''Avg Price''': The result of the price estimate divided by the quantity
* '''%Profit''': Percentage of profit on the product selling price
Analysis:
<!--T:9-->
* '''Annual Sales Informations'''
[[File:annual_sales_information.PNG|link=]]
<!--T:10-->
* '''Annual Information (Top 10)'''
[[File:annual_information.PNG|link=]]
* '''Product by Customer Analysis'''
[[File:product_customer_analysis.PNG|link=]]
<!--T:13-->
* '''Product Sales'''
[[File:product_sales.PNG|link=]]
<!--T:14-->
* '''Sales by Region'''
[[File:sales_region.PNG|link=]]
<!--T:15-->
* '''Sales by Salesman'''
[[File:sales_salesman.PNG|link=]]
<!--T:16-->
* '''Sales by State/Salesman/Product'''
[[File:sales_state_salesman_product.PNG|link=]]
<!--T:17-->
* '''Sales Summary'''
[[File:sales_sumary.PNG|link=]]
<!--T:18-->
* '''State Analysis'''
[[File:state_analysis.PNG|link=]]
<!--T:719-->Sales Spreadsheet Information* '''Annual Products Comparison'''[[File:annual_products_comparison.PNG|link=]] <!--T:20-->* '''Customer Ranking'''[[File:customer_ranking.PNG|link=]]
<!--T:821-->* '''Order DateOrders Monthly Analysis''': Date on which the sale was made* '''Delivery Date''': Date on which the order was delivered* '''Branch''': Affiliate which performed the sale* '''Group''': Group to which belongs the sold product* '''Product''': Name of the sold product* '''Customer''': Customer name* '''City''': City where the customer lives* '''State''': State where the customer lives* '''Region''': The region of the country where the customer lives* '''Salesman''': Name of the salesperson who performed the sale* '''Quantity''': Quantity sold of a product* '''Price''': The price of the sold product* '''Taxes''': The amount of taxes levied on the product sale* '''Net Revenue''': The net value of the product sale* '''Cost''': The value of the product purchase cost* '''Profit''': Profit obtained from the product sale* '''Avg Price''': The result of the price estimate divided by the quantity* '''%Profit'''[[File: Percentage of profit on the product selling priceorders_monthly_analysis.PNG|link=]]
</translate>