ITECH1100 Suit Central: Automating Processes & Visualizing Impact

This assignment focuses on analyzing the digital revolution within the context of "Suit Central" using Microsoft Excel. The solution involves several tasks, including calculating annual employee costs based on wages and hours, identifying changes in quoting and manufacturing processes using pivot charts, creating a dynamic spreadsheet for generating quotes based on material and size inputs, and analyzing the popularity of different material sizes based on quote counts. The assignment utilizes Excel functions such as CONCATENATE, dropdown lists, and IF statements to automate processes and visualize data. The final output provides a comprehensive analysis of Suit Central's data, enabling staff members to efficiently generate quotes and manage inventory. Desklib provides access to this solution and other related assignments to support students in their learning.

Running head: UNDERSTANDING OF DIGITAL REVOLUTION
Understanding of digital revolution
Name of the Student
Name of the University
Author note

1
Understanding of digital revolution
Table of Contents
Task 1:........................................................................................................................................2
Task 2:........................................................................................................................................3
Task 3.........................................................................................................................................4
Task 4:........................................................................................................................................5
Bibliography:..............................................................................................................................9

2
Understanding of digital revolution
Task 1:
The below excel sheet showcase the annual cost according to the employees’ wages,
fixed and other costs. In order to identify the annual wages for the employee, the total
working hour per hour is identified along with the extra work per week. The total of the week
hour has been multiplied with the cost/hour and 52 in order to calculate the annual cost.
Annual cost
Employeess TYPE
Cost/
hour
Working
Days
working
hour/wee
k
Extra
hour/wee
k
total
working
hour/wee
k
Annual
cost
Augusta
skille
d 26
Mondays,
Tuesdays
and
Wednesday
s 21.5 3 24.5 33124
Bhavesh skilled 26
Thursdays
and Fridays 14.5 0 14.5 19604
Celia
Part
Time 24
every
weekday 24.5 3 27.5 34320
Replacement 39 266 10374
employee wages 97422
Fixed Cost 9100
utilities costs 3120
Total Annual
Cost($)
10964
2

3
Understanding of digital revolution
Task 2:
CottonL
CottonS
CottonXS
LeatherL
LeatherS
LeatherXS
SilkL
SilkS
SilkXS
TweedL
TweedS
TweedXXL
WoolM
WoolXL
WoolXXL
0
100
200
300
400
500
600
700
StdDev of Quote amount
Count of Quote amount
Average of Quote amount
In order to identify the aspect of quoting or manufacturing has changed over time and
how the quote amount di ered for each sta member several functions are used along withff ff
pivot chart. The pivot chart was used to identify the average and count of the material. Firstly
the material and sizes are added with the function CONCATENATE.
Row Labels Average of Quote
amount
StdDev of Quote
amount
CottonL 82.02 9.318368956
CottonM 85.41666667 6.054557512
CottonS 68.05454545 14.72143768
CottonXL 96.36 4.09243204
CottonXS 69.78181818 16.10023715
CottonXXL 89.86666667 7.398017753
LeatherL 185.5 66.64728051
LeatherM 151.7111111 47.13776205
LeatherS 151.725 60.32873141
LeatherXL 163.39 60.13110583
LeatherXS 150.5714286 48.86392476
LeatherXXL 251.9166667 19.14674037
SilkL 388.975 165.1135645
SilkM 447.48 185.8581906
SilkS 318.3 141.2157805

4
Understanding of digital revolution
SilkXL 556.35 226.9310846
SilkXS 388.1714286 145.8455543
TweedL 221.3 #DIV/0!
TweedXL 247.325 21.4030177
TweedXXL 252.3333333 25.50339847
WoolL 144 41.64001404
WoolM 131.1 20.56805776
WoolS 136.1363636 40.62098652
WoolXL 154.41 40.95907036
WoolXS 135.4117647 38.78051834
WoolXXL 182.3857143 30.24033887
Task 3
Using Excel, analyse the historical data is used to create a spreadsheet that allows a member
of the Tuxedo Oasis team to enter the tuxedo material and size, and gives a quote amount.
Material dropdown
list
Size
list
Row
Labels
Average of Quote amount
Cotton L CottonL 82.02
Leather M CottonM 85.41666667
Silk S CottonS 68.05454545
Tweed XL CottonXL 96.36
Wool XS CottonXS 69.78181818
XXL CottonXXL 89.86666667
LeatherL 185.5
LeatherM 151.7111111
LeatherS 151.725
LeatherXL 163.39
LeatherXS 150.5714286
LeatherXX
L
251.9166667
SilkL 388.975
SilkM 447.48
SilkS 318.3
SilkXL 556.35
SilkXS 388.1714286
TweedL 221.3
TweedXL 247.325
TweedXXL 252.3333333
WoolL 144
WoolM 131.1
WoolS 136.1363636

5
Understanding of digital revolution
WoolXL 154.41
WoolXS 135.4117647
WoolXXL 182.3857143
To be used by staff members
Material Size
Tweed XXL Automatic display to staff
members
Quote Amount(in $)
252.3333333
The above table shows the dropdown table which shoes the quota amount accordingly.

6
Understanding of digital revolution
Task 4:
The popularity
criteria is achieved by
the formula: IF
(B2>=10,"Popular","Unpopular")
Which set the value to popular if the count value is over 10 else it shoes unpopular. The
below tables shoes the value of the average quota amount and material sizes according to the
type and popularity.
Row Labels Count of Quote amount Popularity
CottonL 8 Unpopular
CottonM 9 Unpopular
CottonS 7 Unpopular
CottonXL 10 Popular
CottonXS 13 Popular
CottonXXL 7 Unpopular
LeatherL 6 Unpopular
LeatherM 5 Unpopular
LeatherS 10 Popular
LeatherXL 3 Unpopular
LeatherXS 19 Popular
LeatherXXL 1 Unpopular
SilkL 5 Unpopular
SilkM 4 Unpopular
SilkXL 2 Unpopular
SilkXS 9 Unpopular
SilkXXL 9 Unpopular
TweedL 2 Unpopular
TweedM 3 Unpopular
TweedS 1 Unpopular
TweedXS 1 Unpopular
TweedXXL 1 Unpopular
WoolL 1 Unpopular
WoolM 8 Unpopular
WoolS 10 Popular
WoolXL 11 Popular
WoolXS 8 Unpopular
WoolXXL 13 Popular

7
Understanding of digital revolution

8
Understanding of digital revolution
Material dropdown
list
Size list Row Labels Average of Quote
Amount
Accepted
Cotton L CottonL 82.02 Not
Accepted
Leather M CottonM 85.41666667
Silk S CottonS 68.05454545
Tweed XL CottonXL 96.36
Wool XS CottonXS 69.78181818
CottonXXL 89.86666667
LeatherL 185.5
LeatherM 151.7111111
LeatherS 151.725
LeatherXL 163.39
LeatherXS 150.5714286
LeatherXXL 251.9166667
SilkL 388.975
SilkM 447.48
SilkS 318.3
SilkXL 556.35
SilkXS 388.1714286
TweedL 221.3
TweedXL 247.325
TweedXXL 252.3333333
WoolL 144
WoolM 131.1
WoolS 136.1363636
WoolXL 154.41
WoolXS 135.4117647
WoolXXL 182.3857143

9
Understanding of digital revolution
To be used by Staffs
Material Size Quote Acceptance
Silk XL Not Accepted
Automatic Displays to Staffs
Popularity Quote Amount ($) Stock Status Manufacture Item
Unpopular 556.35 Not in Stock
Do not Start
Manufacture

10
Understanding of digital revolution
Bibliography:
Collins, A., & Halverson, R. (2018). Rethinking education in the age of technology: The
digital revolution and schooling in America. Teachers College Press.
Merritt, B. (2016). The digital revolution. Synthesis Lectures on Emerging Engineering
Technologies, 2(4), 1-109.
Pan, G., & Seow, P. S. (2016). Preparing accounting graduates for digital revolution: A
critical review of information technology competencies and skills development.
Journal of Education for Business, 91(3), 166-175.
Selwyn, N., Henderson, M., & Chao, S. H. (2015). Exploring the role of digital data in
contemporary schools and schooling—‘200,000 lines in an Excel spreadsheet’.
British Educational Research Journal, 41(5), 767-781.