Digital Revolution Impact Analysis for Sock Life - ITECH1100

This assignment analyzes the impact of the digital revolution on Sock Life, a business operated by employees Anne, Benjamin, and Cheryl. The student uses Microsoft Excel to analyze sales data, calculate operational costs, and automate business processes. The assignment includes creating charts to visualize order frequency, quote amounts, and profit by day and product size. The student automates the quotation process using the AVERAGEIFS formula and creates a table to automate production decisions based on employee availability and sock popularity. The analysis provides insights into sales trends, profit margins, and operational efficiency, demonstrating the practical application of data analysis and automation techniques in a business context. The student's work showcases the use of Excel formulas and data visualization to improve business decision-making. The assignment covers cost analysis, data visualization, and process automation, demonstrating the use of data analysis tools for business improvement.

Running head: DIGITAL REVOLUTION FOR SOCK LIFE
Digital revolution for Sock Life
Name of the Student
Name of the University
Authors note

1DIGITAL REVOLUTION FOR SOCK LIFE
Task 0
For Sock Life, the business is operated by the employees Anne, Benjamin, and
Cheryl. Anne and Benjamin are skilled employees and work together in order to manufacture
socks. Cheryl is part time employee who is responsible for managing orders, sales and
delivery. Following is the table that depicts the detail of the shift timings for the different
employees.
Nam
e Days
Day
Coun
t
Shift
hours
Overtime for
social Presence
Total
Shift
Hour
Ann
e
Mondays, Tuesdays and
Wednesdays; 3 7.5 3 25.5
0
Benj
amin Thursdays and Fridays 2 7.5 15
0
Cher
yle
Mondays, Tuesdays, Wednesdays,
Thursdays, Fridays and Saturdays 6 4.5 3 30
Task 1
The above depicted table is extended in order to find out the total amount of
operational cost. In order to find out the cost, employee payable/week, utility cost is
considered. The below table depicts the total cost for the business.
Name Days
Da
y
Co
unt
Shif
t
hou
rs
Overtime
for social
Presence
Total
Shift
Hour
Ho
urly
Pay
Pa
yW
eek
Yea
rly
Pay
Anne
Mondays, Tuesdays and
Wednesdays; 3 7.5 3 25.5
$
26.0
0
$
663
.00
$
34,4
76.0
0
0
$
-
$
-
Benjam Thursdays and Fridays 2 7.5 15 $ $ $

2DIGITAL REVOLUTION FOR SOCK LIFE
in
26.0
0
390
.00
20,2
80.0
0
0
$
-
$
-
Cheryle
Mondays, Tuesdays,
Wednesdays,Thursdays,
Fridays and Saturdays 6 4.5 3 30
$
24.0
0
$
720
.00
$
37,4
40.0
0
$
-
REPLACE
MENT
WORKE
R 70.5
$
39.0
0
$2,
749
.50
$
10,9
98.0
0
UTILITY
COST
$
3,12
0.00
$
3,12
0.00
INSURA
NCE
COST
$9,
100
.00
$
9,10
0.00
ANNUAL
COST
$1,1
5,41
4.00
From the above table, it is clear that, for the four weeks of a replacement worker the
payable is $10998. After including all the utility, insurance, and payable the operational cost
is summed up to $1,15,414.
Task 2
From, the provided sales data, different charts are created to find out the different
insights. At first the frequency of orders for different price range is generated and the
following plot is created using the “Frequency” Formula.

3DIGITAL REVOLUTION FOR SOCK LIFE
Cunt of Orders
0
10
20
30
40
50
60
70
4
68
51
16
5
0
5 3 3 3 3
20-90
90-160
160-230
230-300
300-370
370-440
440-510
510-580
580-650
650-720
720-790
From the chart it is clear that maximum number of socks are ordered with in the price
range $90-160. In the price range $370-440 there are no orders are placed by the customers.
In the next part the sum of the quote amount is compared by different weekdays. For
that following chart is created.
Mon Tue Wed Thu Fri
0
2000
4000
6000
8000
10000
12000
6958.7
9803.6
8473.7
6381.1 5760.1
Sum of Quote amount by Days
From the above chart, it is clear that maximum amount of quote is done on Tuesday
and minimum amount of quote is done on Friday.

4DIGITAL REVOLUTION FOR SOCK LIFE
In the next chart, the profit is compared by the days.
Mon T ue W e d T hu F ri
0
1000
2000
3000
4000
5000
6000
7000
8000
5144.5
7333.3
6063.3
4038.5
3503.4
Sum of Profi t by Days
Total
Here, it can be stated from the above chart that maximum amount of profit is
generated from the orders that are received on Tuesdays.
In the last insight, the profit from different sized products are plotted.
L M S XL XS XXL
4085.9
3472.8 3476.9
4867.5
6804.9
3375
Sum of Profit by Size
According to the available sales data, the XS sized products generated maximum
amount of profit for the organization. The total profit is $6804.9. minimum profit is
recorded against the XXL sized products that summed up to $3375.

5DIGITAL REVOLUTION FOR SOCK LIFE
Task 3
The quotation process is cumbersome tasks due to multiple size and material
combination for the products, thus using the “averageifs” formula on the quote price column
and created table options, the quote process is automated.
SOCK
MATERIAL Cotton
SOCK SIZE M
QUOTE 71
As depicted in the above table, the employees will be able to select the size and
material options from the blue marked cell. In the green marked cell, it will automatically
generate the estimated quote value depending on the combination. In this table “IFERROR”
formula is also used.
Task 4
In this task, the production decision is automated depending on the employee’s
selection of availability and popularity of the sock. The following table is also available in the
accompanied excel sheet.
SELECT PPULARITY OF SOCK NOT-POPULAR
AVAILABILITY NOT IN STOCK
PRODUCTION STATUS DO NOT START
SOCK MATERIAL Cotton
SOCK SIZE M

6DIGITAL REVOLUTION FOR SOCK LIFE
QUOTE 71