UNDERSTANDING DIGITAL REVOLUTION.

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

UNDERSTANDING DIGITAL REVOLUTION
1
Task 0
The following task is about setting up an e-portfolio of staffs of Tuxedo City which is
manufacturer of creating custom suits of clothing. The task is here done with the help of
excel sheets and data. According to the staff’s working days, shift and timings the total yearly
time of works has been calculated using simple mathematic calculation in excel. The figure 1
shows the data of Andrea, Bethany and Cassandra’s shift timing, day and total work in hour
yearly.
Figure 1: E-portfolio
Source: created by author
Task 1
This is task is the extended version of the Task 0 where the rate of the satffs also iven
with the monthly utility cost, rent and insurance, and replacement of any worker if they are
unable to present. Only 4 weeks in a year is allowed for paid leave for andrea, bethany and
cassandra. The task is about calculating the total operating cost of he company to run the
manufacturing with the estimated expenses. The calculation is done on the basis of the staff’s
rate multiplying with the total hours working in year. Also, the monthility utilty cost
ismultiplied by 12 to get yearly cost with the working expenses of any replacement work.

UNDERSTANDING DIGITAL REVOLUTION
2
Later all the yearly expenses are summed up in excel to obtain the final and otal cost of the
operation in manufacturing.
Figure 2: Operating cost
Source: created by author
Task 2
Task is to develop the graphical representation on the given data set of quote date,
material, size, quote amount, manufacturing cost with finding out which staffs work on which
date. The day is fetched by the date in excel and the according to the day the rule and formula
is decided that who worked on that day. Also the pivot chart is used for the visualization. The
visualizations are the changes in the quote and manufacturing according to the time period
that is date. Also, the second visualization was about the differentiation of the quote and
manufacturing according to the staff members. The quote is amount is summed in the value
field of the pivot chat and the sorting and grouping is done in the axis field of the pivot chart.
Later the first visualization is shown in two different line chart one is showing the changes in
terms of manufacturing and other is showing in terms of quote. Second image is a pie chart to
show the better distribution of the amount.