Skip to content

The FIFO Cost Calculator is a program designed to calculate the cost of revenue in sales transactions using the FIFO (First-In, First-Out) method. It efficiently computes the cost of goods sold based on purchase transactions.

Notifications You must be signed in to change notification settings

Krzych0409/FIFO_Cost_Calculator

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

FIFO Cost Calculator

The FIFO Cost Calculator is a program designed to calculate the cost of revenue in sales transactions using the FIFO (First-In, First-Out) method. It efficiently computes the cost of goods sold based on purchase transactions.

Table of contents

Key Features

FIFO Method: Utilizes the First-In, First-Out method to determine the cost of goods sold in sales transactions.

Usage

  • Manually input transaction data in an excel file or load data from an external source, such as a CSV file. launch_purchases.png launch_sales.png
  • In the "launch_data" sheet, provide initial configuration data. launch_data.png
  • Run the program to obtain accurate cost of revenue figures.

INFO

  • The volume can be a float number
  • The name of a given company in purchase and sale transactions must be the same. The letter case does not matter

WARNING

  • The transaction currency for buying and selling must be the same for a given company
  • If the Excel file name is different from the one in the project, change the 'excel_name' variable in the Python file
  • When adding a purchase transaction, enter the purchase volume in the 'Unrealized volume' column
  • In the configuration sheet 'launch_data,' you cannot move cells. You can only change values

Integration with Excel

The FIFO Cost Calculator seamlessly integrates with Excel, allowing users to conveniently input and manage transactions using Excel files. Simply open the Excel file, manually enter transactions, and let the program handle the rest.

Requirements

Project Status

The FIFO Cost Calculator is actively maintained and open to contributions. Feel free to raise issues or contribute to its development.

About

The FIFO Cost Calculator is a program designed to calculate the cost of revenue in sales transactions using the FIFO (First-In, First-Out) method. It efficiently computes the cost of goods sold based on purchase transactions.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages