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
Avatar
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
537
11
 This report includes the necessary analyzes according to some characteristics of the people who made and participated in the job…
Supplier_Insights
589
14
 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
703
20
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
884
35
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
1,700
205
                                     What-If Analysis…
Women Volleyball Teams_2018
1,350
35
This template covers women volleyball players' information of 16 countries in 2018.   Template is consisted of 4 sheets: -Cover…
See All