Bibitor LLC Inventory and Insight Analysis

BIBITOR LLC VENDOR AND INVENTORY INSIGHT ANALYSIS

Client Task Brief:

-> Objective:

Identify and monitor vendor, brand and location activity to help the

company priotize supplier relationships and optimize inventory value. Download

the attached zip file.

-> Tasks:

1. Market Priority Summary:

a) Analyze store-level inventory, focus on stores with activity levels

between 1 and 5 units on hand

b) Highlight total pricing differences and overall value per store.

Ensure the ouput includes: Store name, On-Hand inventory, Total price

difference and Total inventory price

2. Top 5 Brands Analysis:

a) Identify the top 5 brands based on the average calculated cost(Calc_MAC).

Only include brands with positive calculated MAC

b) For each brand, report: Brand name, Sum of Calculated MAC, Item Description

3. Inventory Value by City:

a) Determine the top 25 ciites with the highest inventory value. for each city

include: City name and total inventory value

4. Combine Dashboard Output:

Combine the top 5 brands and inventory value by city insights into a

single view or summary. Ensure filters or parameters can support deeper

exploration by brand, city and store if needed.

-> Business Question:

Which stores, brands, and cities represent the highest-value inventory

opportunities and require priortized attention from the supply chain and vendor

management teams?

Tools used:

Python Spyder IDE

Microsoft Excel

Dataset Files Used (from Bibitor):

BegInvFINAL12312016.csv

EndInvFINAL12312016.csv

2017PurchasePricesDec.csv

Purchases12312016.csv

SalesFINAL12312016.csv

InvoicePurchases12312016.csv

These files contain historical inventory records, transaction-level sales and purchases, pricing data, and vendor

references.

Details of workflow can be found in the .py file attached

---

Key Analytical Outputs (File Names):

Output FileDescription

market_priority_summary.csvSummary of stores with 1–5 units on hand, showing total price difference and inventory value

top5_brands_analysis.csvTop 5 brands by calculated moving average cost (MAC), with descriptions

inventory_value_by_city.csvTop 25 cities by total end inventory value

combined_dashboard_output.xlsxCombined Excel dashboard with separate sheets for brand and city insights

Unable to upload input datasets due to high upload size even after zipping it.