Understanding Digital Revolution for Sock Spike

Running head: UNDERSTANDING DIGITAL REVOLUTION FOR SOCK SPIKE
Understanding Digital revolution for Sock Spike
Name of the Student
Name of the University
Authors note

1UNDERSTANDING DIGITAL REVOLUTION FOR SOCK SPIKE
Task 0
Sock Spike manages its online business with the help of three employees Amy,
Briony, and Cheryl. Out of this three employees Amy and Briony are skilled employees and
work together in order to manufacture socks ordered by the customers. On the other hand,
Cheryl is responsible for handling the orders, sales and delivery of the produced products.
Following table shows the weekly and annual working shifts for the employees.
Task 1
In order to find out total operational cost thus it is important to consider all the cost
that are required in the operations of the business. This includes, payable to employees,
payable to replacement worker, insurance and utility cost. For this part, the standard 5
working days are considered in order find the total operational cost that includes the payable
to the employees.
Sock
Spik
e
Staff Days
D
ay
C
ou
nt
Sh
ift
H
ou
rs
Total
workin
g
hours
weekly
Extra
Hours
working
every
week
Tot
al
Shif
t
Hou
rs
H
ou
rly
Pa
y
W
ee
kly
Pa
y
Annu
al
Paya
ble
Amy
Monday
,Tuesda
y and
Wednes
day 3 7.5 22.5 3 25.5
$
26.
00
$
663.
00
$
34,476.
00
Brion
y
Thursda
y,
Friday 2 7.5 15 0 15
$
26.
00
$
390.
00
$
20,280.
00
Chery Monday 5 4.5 22.5 3 25.5 $ $ $

2UNDERSTANDING DIGITAL REVOLUTION FOR SOCK SPIKE
l
to
Friday
24.
00 612.
00
31,824.
00
Annua
l Cost
for
Insura
nce
$
9,100.0
0
Repla
cemen
t
Work
er 66
$
39.
00
$
2,57
4.00
$
10,296.
00
Utility
Cost
$
3,120.0
0
Annual
Operati
ng Cost
$
1,09,09
6.00
Task 2
In order to find out the different insights from the available past sales data, following
a charts are generated after generating three columns which are profit, weekdays (Generating
from the date column using the “TEXT” formula in excel) and lastly the employees for the
given day.
For the first chart the count of quotes in different price ranges are plotted. Here it can
be stated that maximum number of orders are placed in the quote range $110-190.