ITECH1100 Project: Digital Revolution & Tuxedo City Automation

This project focuses on automating business processes for Tuxedo City, a small clothing manufacturer, using Microsoft Excel. The tasks include calculating annual employee costs, visualizing manufacturing changes over time, and creating a dynamic spreadsheet for generating quotes based on material and size inputs. The solution uses Excel functions like CONCATENATE and data validation to streamline operations, determine material popularity based on stock levels, and automate quote generation for staff members. The project also involves setting up an ePortfolio page to showcase the work and its impact.

Running head: DIGITAL REVOLUTION
Digital Revolution
Name of the Student
Name of the University
Author Note

1
Digital Revolution
Table of Contents
Task 1:........................................................................................................................................2
Task 2:........................................................................................................................................3
Task 3:........................................................................................................................................4
Task 4:........................................................................................................................................5
Bibliography:..............................................................................................................................7

2
Digital Revolution
Task 1:
This task is associated with calculating the annual cost of the Tuxedo City. Tuxedo
City is a small clothing manufacturer company especially for one-of-a-kind tuxedos. They
have mainly three employee named Agnes, Bertha and Cli . Agnes works 7.5 hours onff
Mondays, Tuesdays and Wednesdays; Bertha works 7.5 hours on Thursdays and Fridays; and
Cli works 4.5 hours every weekday. Additionally, Agnes and Cli share accountability forff ff
managing the Tuxedo City social media presence, with Agnes working one extra hour in the
evenings on Monday, Tuesday and Wednesday, and Cli doing the same on Thursday,ff
Friday and Saturday.
Annual cost
Employeess TYPE
Cost/
hour
Working
Days
working
hour/we
ek
Extra
hour/we
ek
total
working
hour/we
ek
Annu
al
cost
Agnes
skille
d 26
Mondays,
Tuesdays
and
Wednesd
ays 21.5 3 24.5 33124
Bertha
skille
d 26
Thursdays
and
Fridays 14.5 0 14.5 19604
Cliff
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($)
1096
42

3
Digital Revolution
Task 2:
The visualization attached below shows the comparison of the manufacturing change over
time.
CottonL
CottonS
CottonXS
LeatherL
LeatherS
LeatherXS
SilkM
SilkXL
SilkXXL
TweedS
TweedXS
WoolM
WoolXL
WoolXXL
0
100
200
300
400
500
600
Average of Quote amount
StdDev of Quote amount
Row Labels Average of Quote amount StdDev of Quote amount
CottonL 80.45714286 10.95442942
CottonM 79.375 4.795161252
CottonS 85.45 20.03796397
CottonXL 83.10909091 11.37931936
CottonXS 64.95 16.60878738
CottonXXL 90.3 15.55634919
LeatherL 204.4 44.37824435
LeatherM 188.0833333 43.65961139
LeatherS 151.65 58.80592374
LeatherXL 213.15 46.91560812
LeatherXS 159.6052632 41.25506667
LeatherXXL 205.22 68.50929864
SilkM 294.75 43.06280297
SilkS 416.2166667 181.1587858
SilkXL 527.6 349.3107499
SilkXS 382.9818182 163.1496173
SilkXXL 347.3 #DIV/0!
TweedL 325.5666667 26.67589424
TweedS 233.25 9.828784258
TweedXL 232.3 #DIV/0!
TweedXS 195 13.5764502
WoolL 129.2 19.43456971
WoolM 112.8625 27.10734943
WoolS 124.7666667 36.44156281

4
Digital Revolution
WoolXL 150.9230769 21.34444322
WoolXS 124.2083333 41.50878239
WoolXXL 169.22 31.97189043
Task 3:
The historical data is shown, through a spreadsheet that allows a member of the Tuxedo City
team to enter the tuxedo material and size, and gives a quote amount.
To be used by staff members
Material Size
Tweed S
Automatic display to staff
members
Quote Amount(in $)
233.25
Material dropdown
list
Size
list
Row
Labels Average of Quote amount
Cotton L CottonL 80.45714286
Leather M CottonM 79.375
Silk S CottonS 85.45
Tweed XL CottonXL 83.10909091
Wool XS CottonXS 64.95
XXL CottonXXL 90.3
LeatherL 204.4
LeatherM 188.0833333
LeatherS 151.65
LeatherXL 213.15
LeatherXS 159.6052632
LeatherXXL 205.22
SilkM 294.75
SilkS 416.2166667
SilkXL 527.6
SilkXS 382.9818182
SilkXXL 347.3

5
Digital Revolution
TweedL 325.5666667
TweedS 233.25
TweedXL 232.3
TweedXS 195
WoolL 129.2
WoolM 112.8625
WoolS 124.7666667
WoolXL 150.9230769
WoolXS 124.2083333
WoolXXL 169.22
Task 4:
The spreadsheet allows to choose the material and size from the given data set. The
staffs will be able to input the material and size and according to the popularity the
manufacturing will be initiated. In order to extract the data from given data set,
CONCATENATE function is used and later the duplicated are removed. The unique values
are then linked into the data validation form. In order to define the popularity, it has been
assumed that the count of the stock must be over 10.
To be used by Staff members
Material Size Quote Acceptance
Silk S Accepted
Automatic Display to Staff Members
Popularity Quote Amount(in $) Stock Status Manufacture Item
Unpopular 416.2166667 Not in Stock Start Manufacture
Row Labels Average of Quote amount
CottonL 80.45714286
CottonM 79.375
CottonS 85.45
CottonXL 83.10909091
CottonXS 64.95
CottonXXL 90.3

6
Digital Revolution
LeatherL 204.4
LeatherM 188.0833333
LeatherS 151.65
LeatherXL 213.15
LeatherXS 159.6052632
LeatherXXL 205.22
SilkM 294.75
SilkS 416.2166667
SilkXL 527.6
SilkXS 382.9818182
SilkXXL 347.3
TweedL 325.5666667
TweedS 233.25
TweedXL 232.3
TweedXS 195
WoolL 129.2
WoolM 112.8625
WoolS 124.7666667
WoolXL 150.9230769
WoolXS 124.2083333
WoolXXL 169.22

7
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.