ITECH1100 Excel Project: Automating Processes in Digital Revolution

This project focuses on automating business processes for a fictional second-hand book shop named Story Resurrection using Microsoft Excel. The project involves tasks such as representing staff salaries, analyzing employee performance based on pricing and working hours, understanding automation's impact on transaction storage, and evaluating price implications. Scenarios are explored to uncover price offerings and book purchasing strategies. The analysis includes calculating projected annual outgoing costs, configuring hours and rates, and visualizing prices offered by different staff members. The overall aim is to demonstrate the application of Excel in automating business processes and visualizing the resulting impact, with a focus on improving efficiency and decision-making within the book shop context. Desklib provides access to similar solved assignments and resources for students.

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

1UNDERSTANDING DIGITAL REVOLUTION
Table of Contents
Task 1...................................................................................................................................2
Task 2...................................................................................................................................2
Task 3...................................................................................................................................2
Task 4...................................................................................................................................2
Scenario 1........................................................................................................................2
Scenario 2........................................................................................................................2
Bibliography........................................................................................................................3

2UNDERSTANDING DIGITAL REVOLUTION
Task 1
Salary of the different staff members that is Abbey, Belle and chad can be represented by
the help of an excel sheet. It is mainly used for making the calculation for the working hour of
the staff, wages on an hourly basis for the organization. It has been assumed that the total
expense can be calculated by values which help in addition. It can be easily identified from the
total excel that Abbey, Belle, and chad has proper working hours. The total working hours from
the excel that Abbey, Belle, and chad have an average working hour and the total working hours
is estimated to be 3.3, 3.3 and 5 and 514.8, 514.8 and 1300. It has been analyzed that the overall
cost of the total salary is around are $28600 and $3300 for all the given workers which makes it
a total of $36,480.
Task 2
It has been analyzed that the employees of various organizations are dealing with
customers in a much better way. Customers make use of their own method that the payment of
books received. It has been found that chad has paid for the price of the book as per the
aggregation of various employees while comparing it with Abbey and Belle. The overall working
hour of chad is much more while comparing it with Abbey and Belle. Pricing used by chad is
much more than the pricing which is paid by Abbey and Belle for the given books is considered
to be much less. The total working hours of Abbey, Belle, and chad is expected to be valued
around 3.3, 5 and 3.3. It has been analyzed that the total working hours of chad is around 1300
hours while making a comparison with 5.14.8 working hours which is of Abbey and Belle. It has
been analyzed that the overall implication is mainly related to performance which arises due to
the working hours of each thing which helps in analyzing the final deliverable of the given

3UNDERSTANDING DIGITAL REVOLUTION
project. After establishing a proper comparison between Abbey and Belle it has been analyzed
that Abbey has the worst kind of pricing of the given books.
Task 3
With proper understanding, automation can be easily analyzed which is known to be an
important aspect. It has been analyzed that the given transaction can easily store the given
information over the given period of time. It can easily occur when the form alignment can be
tracked for most of the given records which are related to activities of the project. The total
transaction is responsible for implementation of operations development along with the time of
storage. It provides time along with data which is required for a different kind of interaction
which can take place.
Task 4
The concept of price is included in the study is helpful in providing expected outputs
which are associated with the given project. Making use of paper focus on entire kind of
calculation which is included as a result of implication of estimated results. The output is mainly
gathered by development of excel file which helps in gathering an analysis of aim which is
needed to be achieved. Prices are mainly offered by the help of employees which is sent in a
proper way for attaining the result of the given project.
Scenario 1
Study needs to be uncovered for the total prices which are offered according to with
respect to implementing the historical data which is given for the total project. Aligning various
facts is generally supplied for alignment of prices which helps in effective price profit or gain.

4UNDERSTANDING DIGITAL REVOLUTION
Scenario 2
This particular study is important for reflecting on the certain number of books which can
be purchased with the help of Abbey and Belle. Proper alignment of given orders can be done
with help of Abbey and Belle which will be supported by the salary of chad as the given price
which needs to be properly revised for material construction. It is mainly aligned for the
implication of percentage or value of operating cost which needs to be taken into account.

5UNDERSTANDING DIGITAL REVOLUTION
Bibliography
Helbing, D. (2015). What the digital revolution means for us. In Thinking Ahead-Essays on Big
Data, Digital Revolution, and Participatory Market Society (pp. 177-187). Springer,
Cham.
Karpova, O. (2018). The Three Challenges for Language Teaching: Language Competence,
Assessment Methods and Digital Revolution.
Poyner Lamberton, C., & Stephen, A. T. (2015). Taking Stock of the Digital Revolution: A
Critical Analysis and Agenda for Digital, Social Media, and Mobile Marketing Research.
Verhagen, E. A., Clarsen, B., & Bahr, R. (2014). A peek into the future of sports medicine: the
digital revolution has entered our pitch.
Zysman, J., & Kenney, M. (2016). The Next Phase in the Digital Revolution: Platforms,
Abundant Computing, Growth and Employment. The Research Institute of the Finnish
Economy.