Warehouse and Carrier Analysis in Supply Chain

Introduction

This repository contains SQL queries for analyzing performance and optimizing operations in a logistics company's supply chain. The queries provide insights into carrier performance, cost efficiency, shipment volume, warehouse capacity allocation, and storage costs. By leveraging these analyses, the company can streamline operations, enhance efficiency, and reduce costs.

Queries Overview

Identify Top Performing Carriers for Each Service Level

This query identifies the top-performing carriers based on service level performance, including total orders, late orders, on-time orders, and on-time delivery percentage.

Identify the Most Cost-Effective Carrier

This query identifies the most cost-effective carrier based on total cost, total orders, total throughput time, and cost efficiency.

Performance of Carriers Based on Shipment Volume and Market Share

This query analyzes the performance of carriers based on shipment volume and market dominance.

Optimizing Warehouse Capacity Allocation

This query optimizes warehouse capacity allocation by calculating the utilization rate of each warehouse.

Analyzing Storage Cost on Warehouses

This query analyzes the storage cost on warehouses by calculating the number of products, total capacity, and total storage cost for each warehouse.

How to Use

1. Ensure you have access to the company's database and SQL server.
2. Copy and paste each SQL query into your SQL client.
3. Run the queries to retrieve insights and optimize operations in the supply chain.

By leveraging these queries, the logistics company can gain valuable insights, optimize operations, and improve overall performance in its supply chain.