Automated Solutions for Sock Life Employees using Excel

Running head: SOCK LIFE
SOCK LIFE
Name of the Student
Name of the University
Author Note

Running head: SOCK LIFE
Task 0:
In this assignment the automated solutions for the employees of a company names as Sock
life is produced by using Excel. The Sock life is known to be a small company that produces
cloths and mainly specialized for creation of custom one of a kind socks and the products are
sold through an online store. The team members of Sock Life are Anne, Benjamin and
Cheryl. Anne and Benjamin are mainly specialized for manufacturing socks and Cheryl
specialized for managing sales, orders and delivery.
Name Working days in the
week
Working hours(on
weekly basis)
Additional Working
hours(in week)
Anne Monday, Tuesday and
Wednesday
22.5 3
Benjami
n
Thursday and Friday 15 0
Cheryl Every weekday 22.5 3
Task 1:
The annual cost for operation is calculated in excel including the annual salary of the
employees using suitable formulas as given below. For calculating annual salary of
employees the weekly wage is multiplied by 52.
Name Working
days in a
week
Total
Working
hours(per
week)
Additional
Working
hours(per
week)
Total
Working
hours (per
week)
Hour
ly
rates(
in $)
Annu
al
cost(i
n $)

Running head: SOCK LIFE
Anne Monday,
Tuesday and
Wednesday
22.5 3 25.5 26 3447
6
Benjamin Thursday and
Friday
15 0 15 26 2028
0
Cheryl Every
weekday
22.5 3 25.5 24 3182
4
Employee as
replacement
of Cheryl
66 39 1029
6
Fixed cost in
a year(in $)
9100
Utility cost
in a year(in
$)
3120
Total
Outgoing
cost in a
year(in $)
109096
Thus as calculated by excel the total outgoing cost of the Sock life is $109096.
Task 2: