Skip to content
Historical Metrics: Retrieve historical sales value, sales volume, revenue, unit price, and unit cost for the lowest-performing division.Contribution Analysis: Indicate the percentage contribution of each product to the aforementioned metrics.
Visualize the company’s portfolio based on margin, price, and division categoriesProducts with low sales face the risk of discontinuation, making it essential for factory managers to proactively anticipate these changes when developing production plans. Present a list of high-risk products along with their respective divisions.
Product Line Discontinuation
Sales Target Accomplishment
Write a script that calculates and displays division sales targets for each year, assuming the initial value represents Year 1 and increases by 10% each subsequent year.
Display the sales target achievement and deviation for each division for every year.
Product Discontinuation
For divisions falling short of targets in 2024, query the following to aid in decision-making regarding discontinuation.
Select * from product_prep
Product Categorization Table
The VP for Commercial wants to generate relevant product classifications to better understand the company’s portfolio and make comparisions. Generate a table categorizing products by price, sales, margin, division, and factory with a maximum of 3 buckets each. Also append total value, volume, and revenue data.
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.