ITECH1100 Understanding The Digital Revolution

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.

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.

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

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:

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