Dataset of 100 unique values for a Fashion and Beauty startup company, with different variables that has effect on the profit, revenue and the overall welfare and deficiencies of the business. The purpose of the analysis is to demonstrate the effect of these variables to understanding key inventory metrics, e.g., product type, price, lead times, stock levels etc
There are varieties of variables that will impact the outcome of this analysis:
Product Type
• Skin Care
• Hair Care
• Cosmetics
Price
Availability: availability of Products
Revenue Generated: process of creating sales of products
Stock Levels: level of stock required for effective control of goods.
Lead Times: the amount of time when a company has all necessary resources on hand to manufacture a product and when it finally completes the manufacturing process.
Location: cities where manufacture of different product types listed above in India
• Mumbai
• Kolkata
• Delhi
• Bangalore
• Chennai
Production Volumes: volumes or quantity of products produced
Manufacturing Cost: cost of production
Inspection Results: quality check to verify if the product meets the required standard
• Pending
• Fail
• Pass
Defect Rate
Transportation Mode: different means of transportation mode to get products delivered
• Road
• Air
• Sea
• Rail
Total Cost: overall cost
The objective of the analysis is to analyze the effect of variables relevance for operations and logistics roles; to demonstrate understanding of key inventory metrics.
The analysis seeks to answer the following questions:
Cost Analysis
- The costliest products to produce
- How manufacturing cost relate to selling price
Supply Chain Analysis
- The average lead times of different product type
- Are there correlation between defects rates and inspection results
Logistics Chain Analysis
- How different transportation mode affect total cost
- How different routes also affect total cost
Quality Analysis
- How do average defect rates correlate with inspection result and manufacturing costs
Production Analysis
- Are production volume aligned with market demands
Performance Insight
- Revenue generated from different location
- Revenue by product type
- Revenue contribution percentage from different location
- Profit from different location
- Profit by product type
- Profit contribution percentage from different location
- Revenue generated and their profit margin