Understanding the Digital Revolution

Running head: ITECH1100 UNDERSTANDING THE DIGITAL REVOLUTION
ITECH1100 Understanding the Digital Revolution
Assignment 1 - Uniform Revival (30364196)
Name of the Student
Name of the University
Author’s Note

1
ITECH1100 UNDERSTANDING THE DIGITAL REVOLUTION
Table of Contents
Task 0 – Setting Up....................................................................................................................2
Task 1 – Cost of Operating the Business...................................................................................2
Task 2 – Order Information........................................................................................................3
Task 3 – Price Consistency........................................................................................................5
Task 4 – Process Involvement....................................................................................................5
Bibliography...............................................................................................................................7

2
ITECH1100 UNDERSTANDING THE DIGITAL REVOLUTION
Task 0 – Setting Up
E Portfolio Page
This portfolio was all about calculating the total works being served by each of the
three members for which simple excel formulas are used. Basic multiplication and addition
formulas are used that lead to the outcome that the total working hours for Agnes is 25.5 hrs.
for Benjamin; it was 15 hrs. and for Calvin; it was 25.5 hrs. This result was derived through
calculating the working hours of every members in a week and summing them up to find total
working hours. The following table was developed using the Excel spreadsheet as attached.
Name Working days
Working
hours(in week)
Additional Working
hours( in week)
Total working
hours in week
Agnes
Monday,
Tuesday and
Wednesday 22.5 3 25.5
Benjamin
Thursday and
Friday 15 0 15
Calvin Every weekday 22.5 3 25.5
Task 1 – Cost of Operating the Business
Based on the provided information of the cost per hour for every employees, the
following calculation is being performed that can be used for calculating the annual cost of
all the three employees. The actual cost and fixed cost of the organization is being summed
for reaching at conclusion that the overall cost of the employees is $ 109096.
Name
No. of
Working days
in a week
Working
hours in a
week
Additional
working
hours in a
week
Total
working
hours in a
week
Hour
ly
rates(
in $)
Annua
l
cost(in
$)
Archie 3 22.5 3 25.5 26 34476
Barbara 2 15 0 15 26 20280
Carol 5 22.5 3 25.5 24 31824
Replaceme
nt
employee 66 39 10296