University Assignment: ITECH1100 - Uniform Zone Digital Revolution

This assignment solution addresses the ITECH1100 "Understanding the Digital Revolution" assignment, focusing on the fictional business "Uniform Zone." The solution utilizes Microsoft Excel to analyze operational costs, visualize business data through charts and graphs (including sum of quotes and profit by day), and automate a business process. The tasks include calculating total operational costs, analyzing quotes and profit, and implementing automation using Excel functions like AVERAGEIFS and nested IF statements. The solution provides insights into data analysis, business process automation, and the application of Excel for data visualization and problem-solving in a business context, specifically addressing material, size, and quote data for uniform production and stock status.

Running head: UNDERSTANDING THE DIGITAL REVOLUTION: UNIFORM ZONE
ITECH1100 Understanding the Digital Revolution: Uniform Zone
Name of the student
Name of the University
Authors note

1UNDERSTANDING THE DIGITAL REVOLUTION: UNIFORM ZONE
Task 0
Uniform Zone receives their online order from online platform. Uniform Zone is
mainly concerned with manufacturing of uniforms. There are 3 members who acts as the
internal stakeholders to the business organization. Anna and Bertha are the stakeholders who
are responsible for the manufacturing department. Charlyn is responsible for managing of the
orders that are received. Managing orders, sales and delivering of the products are the main
responsibilities of Charlyn.
St
aff
Working
Days
D
a
ys
Ti
m
e
ev
er
y
da
y
(in
ho
ur
s)
Weekly
Shift
Hours
Extr
a
Hour
s
Total
Working
(week)
Total
working
hours
yearly
An
na
Monday,
Tuesday and
Wednesday 3 7.5 22.5 3 25.5 1326
Be
rth
a
Thursday,
Friday 2 7.5 15 0 15 780
Ch
arl
yn
Monday to
Friday 5 4.5 22.5 3 25.5 1326

2UNDERSTANDING THE DIGITAL REVOLUTION: UNIFORM ZONE
Task 1
Calculation of the total operational cost is the main concern of the project. For
calculating the total operational cost, the aspects that are taken into consideration includes
payables that are to be made to Anne, Bertha and Charlyn. The cost that will be required for
the replacement workers are also taken into consideration. Cost related to insurance, utility
costa are also taken into consideration for the calculation of the total operational cost. This
will be on annual basis.
Sta
ff
Working
Days
D
a
y
s
Time
every
day (in
hours)
Week
ly
Shift
Hour
s
Ext
ra
Ho
urs
Total
Worki
ng
(week)
Em
ploy
ee
cost
Wee
kly
Paya
ble
Yea
rly
Pay
able
An
na
Monday,
Tuesday
and
Wednesda
y 3 7.5 22.5 3 25.5
$
26.0
0
$
663.
00
$
34,4
76.0
0
Ber
tha
Thursday,
Friday 2 7.5 15 0 15
$
26.0
0
$
390.
00
$
20,2
80.0
0
Ch
arly
n
Monday
to Friday 5 4.5 22.5 3 25.5
$
24.0
0
$
612.
00
$
31,8
24.0
0
Replacement
worker 66
$
39.0
0
$
2,57
4.00
$
10,2
96.0
0
Utili
ty
Cost
$
3,12
0.00

3UNDERSTANDING THE DIGITAL REVOLUTION: UNIFORM ZONE
Insu
ranc
e
Cost
$
9,10
0.00
Tota
l
cost
$
1,09,
096.
00
From the above calculated table it can be stated that the total cost required as the
operational cost for Uniform Zone is $ 1,09,096.
Task 2
For having a better understanding of the entire business process uses of graphs and
charts will be used.
Mon
Tue
Wed
Thu
Fri
0 1000 2000 3000 4000 5000 6000 7000 8000 9000
Sum of Quote amount by Day
From the above graph, it can be stated that Tuesday has the highest number of quotes.
The lowest number of quote registered is in the day of Friday. Tuesday have had the quote of
8543.6. Whereas the number of quotes marked on Friday was 4901.7.

4UNDERSTANDING THE DIGITAL REVOLUTION: UNIFORM ZONE
Mon
Tue
Wed
Thu
Fri
0 1000 2000 3000 4000 5000 6000 7000
Sum of Profit by Day
The maximum sum of profit that was gained is in the day of Tuesday itself. The total
profit in that day is $ 6394.6. Whereas the lowest profit earned was in the day of Friday. The
profit was of $ 3113.4.
Cotton Leather Silk Tweed Wool
0
50
100
150
200
250
300
350
53.0246376811594
143.657777777778
328.865384615385
135.8
87.6448979591837
Average of Profi t by Material
From the above graph it can be stated that the products made of Silk has the highest
average profit. The average profit that is gained is $328.865.
Task 3
For implementing automation the main aspect that will be taken into consideration
for Uniform Zone is the excel sheet that is used for the calculation process which will help in

5UNDERSTANDING THE DIGITAL REVOLUTION: UNIFORM ZONE
generation of the data that includes data regarding the material of the uniform, size and the
variables that helps in data calculation. Options of selecting the quality of the material, size of
the materials are also stated. “AVERAGEIFS” is used for quoting of data.
Select Material for
Uniform Tweed
Select Size of Uniform S
Quote for Uniform 169
Task 4
The main advantages that will be received includes the fact that with the help of
nested if, multiple conditions can be taken into consideration and in case of disadvantages,
excess complexity of the codes is the main issue.
Select Material for Tweed

6UNDERSTANDING THE DIGITAL REVOLUTION: UNIFORM ZONE
Uniform
Select Size of Uniform S
Quote for Uniform 169
Select Popularity Popular
Select Stock Status Stock Available
Production Decision
DO NOT START
PRODUCTION

7UNDERSTANDING THE DIGITAL REVOLUTION: UNIFORM ZONE