ITECH1100 Understanding Digital Revolution: Paperback Land Automation

This assignment focuses on automating the business processes of Paperback Land, a small second-hand book shop, using Microsoft Excel. The tasks include calculating annual costs, determining average book prices based on employee offers and book conditions, automating the book pricing process using formulas, and analyzing price data using histograms. Additionally, the assignment explores different scenarios, such as calculating staff wages and the total operation cost if all employees were paid hourly. The goal is to improve the current business process by implementing an automated system using Excel. Desklib is a valuable resource for students seeking similar solved assignments and past papers.

Running Head: UNDERSTANDING OF DIGITAL REVOLUTION
Understanding of Digital Revolution
Name of the Student
Name of the University

1UNDERSTANDING OF DIGITAL REVOLUTION
Task 1
Paperback Land is a small organization for selling and buying book. This book shop is
run by three different employees. Andrew and Bhavesh are the semi-retired co-owners of the
bookshop, and do not take a salary. Chad is a part time employee and its total employment cost is
$22 per hour. In task 1, the total annual cost is calculating for this bookshop in a excel sheet.
This sheet includes different type of working rate, working hours, fixed rate, hourly rate. All
these are calculated in the this excel sheet. Moreover, the total salary of each employee and other
operating cost is also calculated in this excel sheet.
Task 2
Paperback Land sell book, also, they buy books from their customers. The customers are
selling their old books to the shop. The staffs are checking all the books and make price for
buying the books. The book price is not fixed. Its depend many different things like book
condition, book publication year and many more things. In second task, the excel sheet is use to
calculate the average price of each employee offered on the particular book condition. Moreover,
the average price is also calculated for month wise. This is also depending on the book condition.
For calculating the average for employee wise a calculation is used which is
=AVERAGEIFS (I2:I481, E2:E481,"=Andrew", F2:F481,"=Poor"). This calculation is for
Andrew offer on poor book condition. For each employee and book condition the name and
condition will be change in the calculation. The Andrew’s average price is 1.9, 3.9, and 0.4 for
poor, good and terrible book condition. Same as Andrew, Bhavesh and Chad’s average price
offer is .9, 5.4, 0.2 and 1.6, 6.5, and 0.2.

2UNDERSTANDING OF DIGITAL REVOLUTION
Average Offer Staff Wise
Staff Poor Good Terrible
Andrew 1.920833
3.95588
2 0.4
Bhaves
h 0.982609
5.40192
3 0.2
Chad 1.666667
6.59523
8 0.217045
Same as the above calculation the month wise price calculation is =AVERAGEIFS (I1:I480,
C1:C480,"=jul", F1:F480,"=Poor"). For each calculation only the month and book condition is
changed.
Average Offer Month Wise
Mont
h Poor Good Terrible
April
1.57631
6
5.60188
7
0.24090
9
May
1.58833
3 5.64
0.25409
8
Jun
1.64634
1 5.8
0.25084
7
Jul 1.5
6.01111
1 0.2
Task 3
They use a process for their business. But they want to improve this current process.
Therefore, they create an excel sheet for automate the process. In old process, first they check the
book and its condition after that they offer a price for this book. In this task, this process is
implemented in excel sheet for automate their business process. In excel, a formula is used for
determine the book price will ,be high, medium and low or the book will be rejected. The
formula is =IF(F2="Terrible","Rejected",IF(F2="Poor","Low

3UNDERSTANDING OF DIGITAL REVOLUTION
Price",IF(F2="Good",IF(G2<2002,"Low Price",IF(H2="Paperback","Medium Price","High
Price"))))).
First the book quality is checked if it is terrible then the book will be directly reject. If not then it
will process further and check its publication date. If it is older then 15 years then it will marked
as low price. If the book is new or less then 15 years then they checked its cover. If it is hard
cover then it will marked as Medium Price and if it is hard cover then the book price will be
high.
Task 4
Provided histogram data is same as the total price offer. This task is calculating this price
in excel. Three different type of prices is calculated in this excel. Here is two different price, one
is average price and another is double price of the average. Cause they sell this book in double
price that they offer to the customer in time of buying the book. Scenario one result is below:
Condition Average Offer Price
High Price 7.577083333 15.15416667
Low Price 3.013865546 6.027731092
Medium Price 4.337037037 8.674074074
Scenario two is calculate the staff wags and the total operation cost if Andrew and
Bhavesh takes salary as Chad. The result is given bellow:
Scenario 2
Particulars
Daily Working
Hours
Total
Working
Hours
Hourly
Wages
Total
Expenses
Staff Salary
Andrew 3.3 514.8 $22.00 $11,325.60
Bhavesh 3.3 514.8 $22.00 $11,325.60
Chad 5 1300 $22.00 $28,600.00

4UNDERSTANDING OF DIGITAL REVOLUTION
Casual Staff 5 100 $33.00 $3,300.00
Total Salary $54,551.20
Rent & Insurance $2,900.00
Utilities Cost $1,680.00
ANNUAL OPERATING COST $59,131.20
Primary Operating Cost $36,480.00
% of Increase in Operating Cost 62.09%
Condition
Average of
Offer General Price
% of
Increase
in
Operatin
g Cost Revised Price
High Price 7.577083333
15.1541666
7
0.62092
1
24.5637077
9
Low Price 3.013865546
6.02773109
2
0.62092
1
9.77047622
7
Medium Price 4.337037037
8.67407407
4
0.62092
1
14.0599892
8

5UNDERSTANDING OF DIGITAL REVOLUTION
Bibliography
Dai, X. (2018). The digital revolution and governance. Routledge.
Dioguardi, F., & Mele, D. (2015). A new shape dependent drag correlation formula for non-
spherical rough particles. Experiments and results. Powder Technology, 277, 222-230.
Sharma, G. (2016). The CIEDE2000 color-difference formula. Excel spreadsheet
implementation of the CIEDE2000 color-difference formula (including test data).