Overview

Hi,

This spreadsheet is consisted of the following 11 (eleven) worksheets:

1 - Cover

2 - Chart

3 - Rates

4 - Assumptions

5 - Set_Up_Process

6 - Suppliers

7 - Products

8 - Customers

9 - Transactions

10 - Cash

11 - Reports

 

  • Chart sheet gives you brief information about Sausage Casings Types.

 

  • Rates worksheet gets daily rates using Power Query. Depending on National Bank of Azerbaijan's web site, user must manually enter date in source step of Power Query to refresh the rates.  Please look at attached photo.
    You may find assumptions in the assumptions worksheet
  • Chart of Setup Process step by step can be found in the form of Organizational Chart in Set_Up_Process worksheet
  • Casings Suppliers with their contact information in Suppliers Worksheet
  • Products information in Products Worksheet
  • Customers in Azerbaijan in Customers Worksheet
  • Import, Sale, Return Transactions are done in Transactions Worksheet.
  • Cash based transactions can be found in Cash Worksheet
  • Three reports (Suppliers Based, Customers Based and Products Based) are shown in Reports Worksheet.

    Unique drop-down lists like Investors, Customers, Suppliers gathered using Power Query.  Some excel functions including Sumifs, Xlookup, If, etc. used in this spreadsheet.
    Wish you good luck in your business.

Reviews Add a review
Qafur

I found this template very useful. It can be used for small-size companies to follow and control their inventory.
However, some points are subject to improvement.

More From Ilgar Zarbaliyev

Browse our top rated business templates. See All
HR INSIGHTS DASHBOARD
1,940
52
 This report includes the necessary analyzes according to some characteristics of the people who made and participated in the job…
Supplier_Insights
2,061
49
 Hello, This report is consisted of four pages. 1-Supplier Quality Metrics 2-Supplier Quality Regional 3-Top - Bottom Analysis 4-Downtime Analysis…
Sales_Analysis_Reportin Power BI
2,142
87
Hello, After participating in Enterprise DNA programs, I prepared reports on three topics in Power BI. The first report I…
What_If_Analysis_Data_Table
2,403
85
Data Table: It is a range of cells where one column consists of a series of values, called input cells…
What-If_Analysis_Goal_Seek
2,964
414
                                     What-If Analysis…
Women Volleyball Teams_2018
2,446
64
This template covers women volleyball players' information of 16 countries in 2018.   Template is consisted of 4 sheets: -Cover…
See All