Bibitor LLC Inventory Tracking or Auditing

About the CompanyAbout Bibitor

Bibitor, LLC is a retail wine and spirits company, with 79 or 80 locations (depending on the year-end) within the fictional state of Lincoln. Depending on the year-end, sales can range from 420-450 million dollars and cost of goods sold can range from 300-350 million dollars. The total number of records in the dataset is 15 million. This includes sales transactions (12.5 to 13 million records) purchase transactions (2.3 to 2.5 million records) and inventory.

Source: https://www.hubae.org/dat...

Executive Questions

Which vendor has the largest freight cost?

Inventory Tracking / Audit

I) Which inventory items in EndInvDec were not present in BegInvDec?

II) Which items existed both at the beginning and end of the period?

III) How many inventory items were carried over from beginning to end?

IV) What percentage of inventory at the end was already present at the beginning?

Tools used:

Python Spyder IDE (Language)

ZIP file password is ': "DACOfficial"

Use Python programming services or app to view the attached zip file

Results:

Vendor #2651 has incurred $3176.81 in freight cost

The rest of the result can be found in the attached file named "Bibitor Business Work zip"