Understanding the Digital Revolution: Shirt City

Running head: UNDERSTANDING THE DIGITAL REVOLUTION: SHIRT CITY
Understanding the Digital Revolution: Shirt City
Name of the Student
Name of the University
Authors note

1UNDERSTANDING THE DIGITAL REVOLUTION: SHIRT CITY
Task 0
Shirt City which is the manufacturer of shirts and specializes in designing custom
made and one-of-a-kind shirts sells their products against the requests through their online
store. Three employees of which Celestine deals with the orders, sales and delivery. On the
other hand, other two employees Amy and Bhavneet work together in the manufacture
section. In the event that the client affirms their request, Amy and Bhavneet fabricate the
arranged items, and Celestine sorts out the delivery of the projects.
Task 1
In the following section the cost for the three employees along with the replacement
worker for four days is also considered while calculating the totals operational cost for Shirt
City. Along this lines the annual operating cost for the business also includes the Annual
utility cost of $ 3,120 and the insurance cost of $9100. According to the provided
information Amy works (3*7.5) 22.5 hours in a week (working on Mondays, Tuesdays and
Wednesdays), Bhavneet works 15 hours in a week(works on Thursdays and Fridays) and
Celestine works 22.5 hours every week.
Name
of the
Staff
Days’
work on
Week
ly
work
ing
days
Worki
ng
time
(in
hours)
Total
workin
g
hours
weekly
Extra
Hours
working
every
week
Total
Workin
g hours
every
week
Hourly
Rate
w
ee
kl
y
p
a
y
a
bl
e
Ye
arl
y
pa
yb
le
Amy Monday,
Tuesday
and
Wednesd
ay
3 7.5 22.5 3 25.5 $
26.00
$
6
6
3.
0
$
34,
47
6.0
0

2UNDERSTANDING THE DIGITAL REVOLUTION: SHIRT CITY
0
Bhavn
eet
Thursda
y, Friday
and
Saturday 3 7.5 22.5 0 22.5
$
26.00
$
5
8
5.
0
0
$
30,
42
0.0
0
Celesti
ne
Monday
to
Friday 5 4.5 22.5 3 25.5
$
24.00
$
6
1
2.
0
0
$
31,
82
4.0
0
Replac
ement
worker 73.5
$
39.00
$
2,
8
6
6.
5
0
$
11,
46
6.0
0
Fixed
Costs
Insura
nce
Cost
for
Busine
ss
$
9,1
00.
00
Utility
Cost
(Every
Month
)
$
260.00
$
3,1
20.
00
Total
Operat
ing
Cost
$
1,2
0,4
06.
00
Task 2
From the given excel sheet the frequency of the quote values among different ranges
are depicted in the following chart.