Assignment 2 581

.pdf

School

Central Michigan University *

*We aren’t endorsed by this school

Course

581

Subject

Marketing

Date

Feb 20, 2024

Type

pdf

Pages

10

Uploaded by KidZebraMaster825

Report
1. Cycle Time Distribution Analysis The histogram suggests a right-skewed distribution, indicating that most delivery processes are completed within a shorter timeframe, with a concentration of data on the lower end of the scale. However, the presence of a long tail to the right hints at occasional delays, pointing to a subset of processes that are less efficient. The statistical values provide further insights: a kurtosis value of -0.1005 suggests a flatter distribution with fewer outliers than a normal distribution, while the mean and median values, 3.9733 and 4 respectively, corroborate the skewness seen in the histogram. The skewness value of -0.5039, which unusually suggests a left skew, may imply a discrepancy or an atypical aspect of the distribution not immediately apparent from the histogram. Finally, a standard deviation of 1.7044 indicates moderate variability in cycle times. These metrics combined reflect a system that operates effectively in general but also reveal inefficiencies that, if addressed, could enhance operational reliability and customer satisfaction. 2. Sales and Profit Distribution by Sub-category Analysis
Analysis Sales vs Subcategory: The data shows sales information across different sub-categories. The highest sale that is not an outlier is 1252.7 units, while the lowest sale not considered an outlier is 27.41 units. Outliers in sales are points that are much higher or lower than most of the other sales numbers; for example, some sales are as high as 2025, 2405, and 9893 units. In the boxplot image, each sub-category, like Accessories, Appliances, and so on, has a box that shows the middle range of sales. The line in the middle of the box is the median, which is the middle sale value. Outliers are shown as dots; these are sales that are unusually high or low compared to other sales in the same sub-category. For example, in 'Copiers', you can see a few high sales that stand out from the rest. These are much higher than most sales in 'Copiers' and are marked as outliers. This could mean that a few copiers sold a lot more than others. Overall, the boxplot shows that some sub-categories have a wide range of sales, with some very high or very low sales compared to the median. This information could help a business understand which products sell consistently and which ones have more varied sales.
Profit vs SubCategory: The information given tells us about the profits for different categories of products sold. Accessories, Art, and Envelopes have small losses or profits at the lowest end, while categories like Appliances, Binders, and Machines sometimes show much bigger losses. On the flip side, products like Copiers can bring in the most profit, with the highest recorded profit being around 8399 units. Looking at the range of profits across all categories, we can see that selling Machines and Copiers can be quite unpredictable – sometimes they can lose a lot of money, and other times they can make a lot. Meanwhile, selling items like Paper and Labels is more consistent, with profits not changing too much. In summary, this data helps a business to see which products have stable earnings and which ones have the potential for high rewards but also high risks. Understanding this can help the business make better choices about what products to focus on or what strategies to change. 3. Sales and Profit Distribution by Customer Segment Analysis
Sales vs Segment: The boxplot shows the lowest and highest sales for three different customer groups: Consumer, Corporate, and Home Office. For the Consumer group, the lowest sales figure is a loss of about 6599 units, and the highest sales figure is a gain of about 4946 units. For the Corporate group, the range is from a loss of about 2929 units to a gain of about 8399 units. The Home Office group's sales range from a loss of about 1143 units to a gain of about 3919 units. When we look at these numbers, we see that the Corporate group has the potential for the highest sales, but also a significant risk of loss. The Consumer group has the lowest potential sales gain, but its biggest loss is the largest among the three groups. The Home Office group has the smallest range of sales, meaning their sales are more consistent compared to the other two groups. This information is useful for understanding which group brings in the most sales and which group has the most stable sales. It can help a business decide where to focus their efforts and how to manage the risks of selling to each group.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help