1.
1.2:
Summary of Findings:
1. Overall Growth:
○ The total sales have consistently increased year over year, from $484,247 in
2013 to $733,947 in 2016, resulting in a 51.5% growth over the four years.
○ The total sales across all regions amounted to $2,297,201.
2. Regional Performance:
○ West Region is the top-performing region with total sales of $725,458,
contributing 31.6% of total sales.
○ East Region follows with $678,781 (29.5% share).
○ Central and South regions contributed $501,240 (21.8%) and $391,722 (17%),
respectively.
3. Product Category Insights:
○ Technology: This is the best-performing category, generating $815,200,
representing 35.5% of total sales.
○ Office Supplies and Furniture contributed $731,507 (31.8%) and $750,494
(32.7%), respectively.
4. Yearly Trends:
○ The Central region showed steady growth, with sales peaking in 2015-2016.
○ The East and West regions demonstrated consistent growth, with significant
increases in 2016.
○ The South region had fluctuating sales, with a notable dip in 2014.
2.2
Key Insights
1. Sales
● Top-Performing Subcategory: Technology is the leader in sales, contributing $819,199.
The East region has the highest sales within this subcategory, generating $261,336.
● Furniture Weakness in Central Region: Furniture sales in the Central region are
relatively low at $164,529, and the profit is negative (-3,138.47), indicating a potential
issue with pricing, demand, or operational costs.
2. Quantity
● Office Supplies Dominate Quantity: Office Supplies recorded the highest total
quantity sold across all regions (23,165 units), with the West region leading at 7,348
units.
● Low Quantities in Technology (South): The South region sold only 1,054 units of
Technology, the lowest quantity among all regions for this subcategory.
3. Profit
● Technology Drives Profit: Technology generated the highest total profit of $141,320,
with the East region contributing $46,718, the highest profit across all subcategories
and regions.
● Profitability Issues in Furniture (Central): Furniture in the Central region incurred a
loss of $-3,138, suggesting operational inefficiencies or pricing challenges.
4. Discount
● High Discounts on Furniture (Central): The Central region has the highest average
discount of 0.303 on Furniture, which may explain the negative profit.
● Low Discounts in Office Supplies (West): Office Supplies in the West region had the
lowest average discount of 0.092, yet generated a strong profit of $54,353, indicating
effective pricing strategies.
5. Preparation Time
● Longest Preparation Time for Office Supplies (Central): The Central region reported
the longest average preparation time of 4.12 days for Office Supplies, which might
impact customer satisfaction.
● Efficient Preparation for Technology (East): The East region has the shortest
average preparation time for Technology at 3.86 days, which aligns with its strong
performance in sales and profit.
3.2
Gross profit margins in the central region experienced a rapid increase from 2013 to 2015 (24%
to 42%). However, also experienced a massive decline towards 2016 with GPM being just 15%.
Gross profit margins in the east region declined from 2013 to 2016 (31% to 24%)
Gross profit margins in the south region experienced a steady increase from 2013-2016 (28% to
36%)
Gross profit margins in the west region experienced a steady increase from 2013-2016 (21% to
31%)
