Matching Buy and Sell Quantities


This is a logic based assignment.

There are two tables : Buy and Sell having details of product bought and sold respectively.

Logic is required to match the quantities in Buy table with those in Sell table based on qty and earliest sold dates.(First in First Out)

A third table is to be generated which is called Matched after matching the buy and sell quantities as per the earliest sold dates.

The format of these tables is shown in the Excel file and the logic for matching is

described in the word file [url removed, login to view]

2 Sets of logic are required:

1. When all these 3 tables exist in normal Excel or Csv file and the output also is in Excel or Csv file

2. When all these 3 tables exist as Postgres tables.

This is required to be done in C# or VB.Net preferably, but any other smart solution could also be considered.

Please read the Word Document and check the table format carefully to understand the logic clearly first,

if in doubt please ask questions before bidding.


Skills: .NET, C Programming, PHP

See more: to buy and sell, matching logic, buy and sell on, a buy, matching buy sell, buy+++, buy buy, sell/buy, QUANTITIES, postgres, buy, excel required csv, word document assignment, php excel read, word csv, php output csv, matching excel file, php table excel, check assignment, excel table word, matching excel, output tables php, php read doc file, check output, pending buy sell

About the Employer:
( 0 reviews ) Pune, India

Project ID: #210852