際際滷

際際滷Share a Scribd company logo
1
Price Categories (Rolling 12 Months)
Sales
$5.1M
$7.9M
$5.1M
$2.8M
$1.2M
$5.3M
$7.8M
$4.9M
$2.4M
$1.3M
$65K
$5.8M
$8.2M
$4.4M
$2.3M
$1.4M
$1.1M
$-
$1,000,000
$2,000,000
$3,000,000
$4,000,000
$5,000,000
$6,000,000
$7,000,000
$8,000,000
$9,000,000
Cat 1 Cat 2 Cat 3 Cat 4 Cat 5 Custom
Sales
Last 25 - 36 Months Last 13-24 Months Last 12 Months
 Overall Sales Increased YOY: +2.9% (+142K) when comparing 2nd Quarter 2022 to 2nd Quarter 2021; Custom PCs comprised 357.6K in 2022
Q1
 Drivers of 2nd Quarter YOY Performance Increase: Much of the highest sales increases occurred in Category 1, Corporate Services, Tech
Companies, East area, North California, etc.; The $230 in sales of custom PCs was a substantial factor
 Custom PCs Increased in Share of Sales: Custom PCs had 7% share (298.4K) in 2nd Quarter 2022 compared to 5.2% share (276.2k) in 2nd
Quarter 2022; Sales of Custom PCs increased by 38.7K quarter over quarter
 Total Custom PC Metrics Since the Beginning of 2017: $1.1 million in sales and 5.2K sales orders since the beginning of 2019
 Category 1s Consistent Incline: Based on current trajectories, category 1 could continue to grow because of products released in the last 2
years and recent performances in Tech Companies, K-12, and Rental Properties
Quarterly Product Dashboard | 2022 2nd Quarter: Overview
Computers 2nd Quarter 2020 2nd Quarter 2021 2nd Quarter 2022
Laptops Only $5,391,794 Sales YOY Change: -2.7% $5,419,464 Sales YOY Change: +.5% $5,230,238 Sales YOY Change: -3.5%
Workstations Only -- -- $46,684 Sales -- $393,060 Sales YOY Change: +742%
ALL $5,391,794 Sales YOY Change: -2.7% $5,466,148 Sales YOY Change: +1.4% $5,230,238 Sales YOY Change: +2.9%
2
Top 30 Laptops in Last 12 Months
Sales
$960K
$780K
$581K
$530K
$506K
$466K
$431K
$408K
$373K
$338K
$304K $295K $280K
$260K $251K
$222K $212K $203K $186K
0%
5%
10%
15%
20%
25%
30%
35%
40%
45%
50%
$0
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
Comulative
SQ
Yards
%
Sales
Sep-2020 - Aug-2022 (SQ Yards Shipped) Sep-2020 - Aug-2022 (Cumulative % Total)
Quarterly Product Dashboard | Top 30 Laptops
 Insignia Up 5 Positions: This high position growth is due to strong performances in Corporate Services, Rental Properties, and Manufacturing
sub-segments along with the South and East areas
 Remarkable Down 3 Positions: Sales for this product were gradually declining since the beginning of 2021
 Imperial Up 3 Positions: This high position growth is due to strong performances in Corporate Services, Telecommunications, and Financial
Institutions sub-segments along with higher relative performance in the West area
 Impact Down 4 Positions: Sales for this product were gradually declining since the beginning of 2021
 High # of Price Category 1 & 2 Products in Top 30: Out of the top 30 products, 7 are in Category 1 and 12 are in Category 2
Gained
More Than 1
Position vs. 3
Months Ago
Dropped
More Than 1
Position vs 3
Months Ago
 Category 1
 Category 2
 Category 3
 Category 4
 Category 5
3
All Laptops Launched in Last 24 Months
Sales
$0
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
$1,400,000
$1,600,000
$1,800,000
$2,000,000
Month
1
Month
2
Month
3
Month
4
Month
5
Month
6
Month
7
Month
8
Month
9
Month
10
Month
11
Month
12
Month
13
Month
14
Month
15
Month
16
Month
17
Month
18
Month
19
Month
20
Month
21
Month
22
Month
23
Month
24
Sales
EMERALD
AFFLUENCE
OPULENT
GRANDE
EXQUISITE
REGENCY
OBSIDIAN
RADIANCE
ENTICE
CELESTIAL
CONTINENTAL
STERLING
LUXE
Quarterly Product Dashboard | New Laptops
 Emerald had the Highest Sales at Month 22 out of all Laptops Launched Since 2015: This products success is largely
driven by its higher than average performance in the Corporate Services, Computer Software, and Higher Education sub-
segments compared to other products launched since Jun-2017; Emerald surpasses Prestige at its 22nd month after launch.
 Alex is 4th Best Performing Global Product at Month 9 After Launch: Apex has comparable a sales performance to Virtuosity
& Caliber; since 2015, it has been the 4th best performing global product at month 9 after launch; much higher share % of sales
in Corporate Services & Computer Software sub-segments than other products launched since 2019
Emerald
15 Products
$15.1M Margins
Affluence
5 Products
$4.7 Margins
Magenta
Imperial
Elegant
Aqua
Apex
7 Products
$1.5 Margins
4
Top 10 Sub-Markets by Sales (Rolling 12 Month Changes)
Sales
Quarterly Product Dashboard | Sub-Markets & Categories
 Categories 2 Experienced High Sales Increases in Tech Companies Over the Last Few Years: When it comes to this category, there was a significant increase in sales to
Tesla and Apple in recent years
 Categories 3 Experienced High Sales Declines in Higher Education Over the Last Few Years: There were a relatively even distribution of job names in each rolling 12
month timeframe according to our data, indicating that this decline wasnt due to just a couple of customers leaving; many of the declining products in these categories and sub-
segment are more than 5 years old, which may indicate the need for more products that are specifically targeted to this sub-segment
5
Top 10 Sub-Markets by Sales (Rolling 12 Month Changes)
Sales
Quarterly Product Dashboard | Sub-Markets & Areas
 Financial Institutions Declining in Sales in East Area: This decline is primarily due to the sales declines of custom PCs
 Corporate Services Declining in West Area: Category 3 had a uniquely significant sales decrease in these areas over the last 2 years
 Rental Propertys Sales Spike in the East Area: This sales spike is largely due to orders by Amazon
6
Affect of Workstations on Total Sales per Key Market
Sales
[CELLRANGE]
[CELLRANGE] [CELLRANGE]
[CELLRANGE] [CELLRANGE] [CELLRANGE]
[CELLRANGE] [CELLRANGE]
[CELLRANGE]
[CELLRANGE] [CELLRANGE] [CELLRANGE]
[CELLRANGE] [CELLRANGE]
[CELLRANGE] [CELLRANGE]
[CELLRANGE]
[CELLRANGE]
[CELLRANGE] [CELLRANGE]
$0
$2,000,000
$4,000,000
$6,000,000
$8,000,000
$10,000,000
$12,000,000
$14,000,000
Corp (Last 25 -
36 Months)
Corp (Last 13-
24 Months)
Corp (Last 12
Months)
Education (Last
25 - 36 Months)
Education (Last
13-24 Months)
Education (Last
12 Months)
Hospitality (Last
25 - 36 Months)
Hospitality (Last
13-24 Months)
Hospitality (Last
12 Months)
Healthcare (Last
25 - 36 Months)
Healthcare (Last
13-24 Months)
Healthcare (Last
12 Months)
Sales
Carpet Ceramic
Quarterly Product Dashboard | Key Market Trends & Workstations
 Percentage of Workstations was Highest in the Healthcare Segment: 10.2% of sales in the Healthcare segment were workstations in the last 12 months and it is
growingthis indicates a significant and previously untapped demand; in the next 12 months, if sales of workstations continue at the same trajectory, that Workstation
share % could almost double as laptops decline in the Healthcare segment; the average workstations sales share % of all markets was 4.8% in the last 12 months
 The Sales Increase of Workstations is Offsetting the Sales Decrease of Laptops in Corporate Offices: Although the sales of laptops is decreasing, this segment had an
overall sales increase in the last year because of the addition of workstations to the product portfolio
 Healthcare and Hospitality Segments Experienced the Highest Sales Decreases in the Last 12 Months: Healthcare decreased 3.3% overallprimarily because of sales
decreases in the Senior Living and Medical Office Buildings sub-segments; Hospitality had the steepest % decrease in the last year at 20.7% overalllargely because of a
significant sales decrease in the Lodging/Public Places sub-segment
Current 12
Month Time
Frame vs
Prior 12
Month Time
Frame
All: +3.4%
Workstations Only: -0.9%
All: -0.2%
Workstations Only: -4.2%
All: -16.4%
Workstations Only: -20.7%
All: -3.3%
Workstations Only: -12.5%
7
Product Life Cycle Trends & Category Forecasts
Sales
Quarterly Product Dashboard | Product Life Cycles (Laptops Only)
 Impact of Laptops with the Highest Sales Decreases in the Decline Phase in the Last 12 Months: Radiance and Aptitude had $460K in sales decreases in the last year; that
decrease comprised 19% of sales lost out of all products in the Decline phase; Emeralds decline trajectory slowed in the last 12 months in % and #, compared to the last 5 years
 Products with the Most Sales Growth in the Last 12 Months (Growth and Maturity Phases): Insignia, Imperial, and Alliance had a $890K sales growth in the last 12 months
 Expected Sales in 2022 from Upcoming Products Launched in 2022: The average of the sales of products launched in their launch years in the last 3 years was approximate $520K
 The Expected Impact of Workstations on Sales in 2022: Workstations is expected to add significant sales to overall sales growth in 2022; Workstations had $870K in sales in the last
12 months due to increasing MOM and QOQ growth; that number is expected to be significantly higher in the next 12 months
 Margin Forecasts in 2022: The overall profit margin percentage may increase by 0.3% and overall margin dollars may increase by $8.2 million, based on past and current trajectories;
profit margin dollars will likely increase the most in category 2 and decrease the most in category 4
 Upcoming Laptops That Will Offset Decline: Apex and Aqua are expected to offset much of the sales decline of older models
Product Life Cycle
Phase Transitions
May Stop Growth:
Affluence, Opulent
Just Entered
Maturity:
Regency, Obsidian
May Begin Decline:
Zephyr, Allure
Just Started
Decline:
Topia, Lavish
2.7M
$1.4M
$1.2M
$150K
(3,000,000) (2,000,000) (1,000,000) - 1,000,000 2,000,000
Decline Phase
Growth Phase
Maturity Phase
Rebound Phase
Sales Changes in Last 12 Months
$43.2M
$83.M
$59.5M
$31.6M
$21.6M
$13.1M
$45.8M
$89.9M
$53.3M
$23.8M $24.4M
$10.M
$-
$10,000,000
$20,000,000
$30,000,000
$40,000,000
$50,000,000
$60,000,000
$70,000,000
$80,000,000
$90,000,000
$100,000,000
Cat 1 Cat 2 Cat 3 Cat 4 Cat 5 Custom
Profit
Margins
$
Category Forecasts
Jul-2020 to Jun-2021 Jul-2021 to Jun-2022 Jul-2022 to Jun-2023 (Forecast)
-$2.2M

More Related Content

Mock Data Insight Presentation v5.pptx

  • 1. 1 Price Categories (Rolling 12 Months) Sales $5.1M $7.9M $5.1M $2.8M $1.2M $5.3M $7.8M $4.9M $2.4M $1.3M $65K $5.8M $8.2M $4.4M $2.3M $1.4M $1.1M $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 Cat 1 Cat 2 Cat 3 Cat 4 Cat 5 Custom Sales Last 25 - 36 Months Last 13-24 Months Last 12 Months Overall Sales Increased YOY: +2.9% (+142K) when comparing 2nd Quarter 2022 to 2nd Quarter 2021; Custom PCs comprised 357.6K in 2022 Q1 Drivers of 2nd Quarter YOY Performance Increase: Much of the highest sales increases occurred in Category 1, Corporate Services, Tech Companies, East area, North California, etc.; The $230 in sales of custom PCs was a substantial factor Custom PCs Increased in Share of Sales: Custom PCs had 7% share (298.4K) in 2nd Quarter 2022 compared to 5.2% share (276.2k) in 2nd Quarter 2022; Sales of Custom PCs increased by 38.7K quarter over quarter Total Custom PC Metrics Since the Beginning of 2017: $1.1 million in sales and 5.2K sales orders since the beginning of 2019 Category 1s Consistent Incline: Based on current trajectories, category 1 could continue to grow because of products released in the last 2 years and recent performances in Tech Companies, K-12, and Rental Properties Quarterly Product Dashboard | 2022 2nd Quarter: Overview Computers 2nd Quarter 2020 2nd Quarter 2021 2nd Quarter 2022 Laptops Only $5,391,794 Sales YOY Change: -2.7% $5,419,464 Sales YOY Change: +.5% $5,230,238 Sales YOY Change: -3.5% Workstations Only -- -- $46,684 Sales -- $393,060 Sales YOY Change: +742% ALL $5,391,794 Sales YOY Change: -2.7% $5,466,148 Sales YOY Change: +1.4% $5,230,238 Sales YOY Change: +2.9%
  • 2. 2 Top 30 Laptops in Last 12 Months Sales $960K $780K $581K $530K $506K $466K $431K $408K $373K $338K $304K $295K $280K $260K $251K $222K $212K $203K $186K 0% 5% 10% 15% 20% 25% 30% 35% 40% 45% 50% $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 Comulative SQ Yards % Sales Sep-2020 - Aug-2022 (SQ Yards Shipped) Sep-2020 - Aug-2022 (Cumulative % Total) Quarterly Product Dashboard | Top 30 Laptops Insignia Up 5 Positions: This high position growth is due to strong performances in Corporate Services, Rental Properties, and Manufacturing sub-segments along with the South and East areas Remarkable Down 3 Positions: Sales for this product were gradually declining since the beginning of 2021 Imperial Up 3 Positions: This high position growth is due to strong performances in Corporate Services, Telecommunications, and Financial Institutions sub-segments along with higher relative performance in the West area Impact Down 4 Positions: Sales for this product were gradually declining since the beginning of 2021 High # of Price Category 1 & 2 Products in Top 30: Out of the top 30 products, 7 are in Category 1 and 12 are in Category 2 Gained More Than 1 Position vs. 3 Months Ago Dropped More Than 1 Position vs 3 Months Ago Category 1 Category 2 Category 3 Category 4 Category 5
  • 3. 3 All Laptops Launched in Last 24 Months Sales $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 $1,800,000 $2,000,000 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Month 13 Month 14 Month 15 Month 16 Month 17 Month 18 Month 19 Month 20 Month 21 Month 22 Month 23 Month 24 Sales EMERALD AFFLUENCE OPULENT GRANDE EXQUISITE REGENCY OBSIDIAN RADIANCE ENTICE CELESTIAL CONTINENTAL STERLING LUXE Quarterly Product Dashboard | New Laptops Emerald had the Highest Sales at Month 22 out of all Laptops Launched Since 2015: This products success is largely driven by its higher than average performance in the Corporate Services, Computer Software, and Higher Education sub- segments compared to other products launched since Jun-2017; Emerald surpasses Prestige at its 22nd month after launch. Alex is 4th Best Performing Global Product at Month 9 After Launch: Apex has comparable a sales performance to Virtuosity & Caliber; since 2015, it has been the 4th best performing global product at month 9 after launch; much higher share % of sales in Corporate Services & Computer Software sub-segments than other products launched since 2019 Emerald 15 Products $15.1M Margins Affluence 5 Products $4.7 Margins Magenta Imperial Elegant Aqua Apex 7 Products $1.5 Margins
  • 4. 4 Top 10 Sub-Markets by Sales (Rolling 12 Month Changes) Sales Quarterly Product Dashboard | Sub-Markets & Categories Categories 2 Experienced High Sales Increases in Tech Companies Over the Last Few Years: When it comes to this category, there was a significant increase in sales to Tesla and Apple in recent years Categories 3 Experienced High Sales Declines in Higher Education Over the Last Few Years: There were a relatively even distribution of job names in each rolling 12 month timeframe according to our data, indicating that this decline wasnt due to just a couple of customers leaving; many of the declining products in these categories and sub- segment are more than 5 years old, which may indicate the need for more products that are specifically targeted to this sub-segment
  • 5. 5 Top 10 Sub-Markets by Sales (Rolling 12 Month Changes) Sales Quarterly Product Dashboard | Sub-Markets & Areas Financial Institutions Declining in Sales in East Area: This decline is primarily due to the sales declines of custom PCs Corporate Services Declining in West Area: Category 3 had a uniquely significant sales decrease in these areas over the last 2 years Rental Propertys Sales Spike in the East Area: This sales spike is largely due to orders by Amazon
  • 6. 6 Affect of Workstations on Total Sales per Key Market Sales [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 Corp (Last 25 - 36 Months) Corp (Last 13- 24 Months) Corp (Last 12 Months) Education (Last 25 - 36 Months) Education (Last 13-24 Months) Education (Last 12 Months) Hospitality (Last 25 - 36 Months) Hospitality (Last 13-24 Months) Hospitality (Last 12 Months) Healthcare (Last 25 - 36 Months) Healthcare (Last 13-24 Months) Healthcare (Last 12 Months) Sales Carpet Ceramic Quarterly Product Dashboard | Key Market Trends & Workstations Percentage of Workstations was Highest in the Healthcare Segment: 10.2% of sales in the Healthcare segment were workstations in the last 12 months and it is growingthis indicates a significant and previously untapped demand; in the next 12 months, if sales of workstations continue at the same trajectory, that Workstation share % could almost double as laptops decline in the Healthcare segment; the average workstations sales share % of all markets was 4.8% in the last 12 months The Sales Increase of Workstations is Offsetting the Sales Decrease of Laptops in Corporate Offices: Although the sales of laptops is decreasing, this segment had an overall sales increase in the last year because of the addition of workstations to the product portfolio Healthcare and Hospitality Segments Experienced the Highest Sales Decreases in the Last 12 Months: Healthcare decreased 3.3% overallprimarily because of sales decreases in the Senior Living and Medical Office Buildings sub-segments; Hospitality had the steepest % decrease in the last year at 20.7% overalllargely because of a significant sales decrease in the Lodging/Public Places sub-segment Current 12 Month Time Frame vs Prior 12 Month Time Frame All: +3.4% Workstations Only: -0.9% All: -0.2% Workstations Only: -4.2% All: -16.4% Workstations Only: -20.7% All: -3.3% Workstations Only: -12.5%
  • 7. 7 Product Life Cycle Trends & Category Forecasts Sales Quarterly Product Dashboard | Product Life Cycles (Laptops Only) Impact of Laptops with the Highest Sales Decreases in the Decline Phase in the Last 12 Months: Radiance and Aptitude had $460K in sales decreases in the last year; that decrease comprised 19% of sales lost out of all products in the Decline phase; Emeralds decline trajectory slowed in the last 12 months in % and #, compared to the last 5 years Products with the Most Sales Growth in the Last 12 Months (Growth and Maturity Phases): Insignia, Imperial, and Alliance had a $890K sales growth in the last 12 months Expected Sales in 2022 from Upcoming Products Launched in 2022: The average of the sales of products launched in their launch years in the last 3 years was approximate $520K The Expected Impact of Workstations on Sales in 2022: Workstations is expected to add significant sales to overall sales growth in 2022; Workstations had $870K in sales in the last 12 months due to increasing MOM and QOQ growth; that number is expected to be significantly higher in the next 12 months Margin Forecasts in 2022: The overall profit margin percentage may increase by 0.3% and overall margin dollars may increase by $8.2 million, based on past and current trajectories; profit margin dollars will likely increase the most in category 2 and decrease the most in category 4 Upcoming Laptops That Will Offset Decline: Apex and Aqua are expected to offset much of the sales decline of older models Product Life Cycle Phase Transitions May Stop Growth: Affluence, Opulent Just Entered Maturity: Regency, Obsidian May Begin Decline: Zephyr, Allure Just Started Decline: Topia, Lavish 2.7M $1.4M $1.2M $150K (3,000,000) (2,000,000) (1,000,000) - 1,000,000 2,000,000 Decline Phase Growth Phase Maturity Phase Rebound Phase Sales Changes in Last 12 Months $43.2M $83.M $59.5M $31.6M $21.6M $13.1M $45.8M $89.9M $53.3M $23.8M $24.4M $10.M $- $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 $80,000,000 $90,000,000 $100,000,000 Cat 1 Cat 2 Cat 3 Cat 4 Cat 5 Custom Profit Margins $ Category Forecasts Jul-2020 to Jun-2021 Jul-2021 to Jun-2022 Jul-2022 to Jun-2023 (Forecast) -$2.2M

Editor's Notes

  • #8: Services Data Not Included