$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

ITECH1100 Understanding The Digital Revolution

tag 0 Download4 Pages / 781 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Book Zone.Your spreadsheet should be configured such that the working hours, hourly rates, and fixed and utility costs can be varied easily.Document your findings in your ePortfolio page (approximately 100 words).
Obtaining Books
Throughout the day, customers come to Book Zone to buy books, and occasionally to sell them.When people bring in books to sell to Book Zone, the staff member on duty will review the books and make an offer for each one individually.Currently, the process for determining how much the book shop will pay for a book is entirely subjective.
Staff members offer an amount per book based on the quality of the book, and how popular they think it is, and how they are feeling at the time.The sale amount is always simply double the amount paid and is set at the same time - if Book Zone pays $3.00 for a book, they will put it on sale with a marked price of $6.00.

(Book Zone does not deal in rare or antique books)
For several months, staff have been keeping track of the date and time, quality, publication year and amount paid for each book in a spreadsheet. This spreadsheet is available for download on Moodle.
 
Task 2 - Sales team offers
Using Excel, process the history of purchases spreadsheet and use appropriate charts to visualize:How the prices paid differed for each staff member; and How the prices paid have changed over time Describe your findings in your ePortfolio (approximately 250 words), and attach the Excel file to your page.
Process automation
Alexa and Bertha want to improve the consistency of how they pay for and price books.They'd like to standardize on three standard price offers, and have designed the following process to determine how to allocate them, including the option of rejecting the book altogether.The staff have already agreed on how to determine whether a book is terrible, poor, or good. Book purchase Customer 

Task 3 - Automation
Using Excel, create a spreadsheet page that automates the above process, allowing a member of the team to enter whether the book is hardcover, its publication year, and its condition, and receive a price to offer.Ensure that you include enough text and formatting to make your spreadsheet usable by a member of the Book Zone team, or by a University lecturer.
Your spreadsheet should be configured such that the Low, Medium and High prices can be varied easily.Describe how you automated the process (approx 150 words), and attach your Excel file to your ePortfolio.
 
Task 4 - Price setting
Using Excel and the historical data you have available, determine sets of prices which meet the objectives of the following scenarios: Scenario one: Total offer prices are approximately the same as for the historical data
Scenario two: Assuming all books purchased are sold, allow all staff to draw the same wage as Cassandra.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 4 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Understanding The Digital Revolution. Retrieved from https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/average-working.html.

My Assignment Help (2021) Understanding The Digital Revolution [Online]. Available from: https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/average-working.html
[Accessed 21 April 2021].

My Assignment Help. 'Understanding The Digital Revolution' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/average-working.html> accessed 21 April 2021.

My Assignment Help. Understanding The Digital Revolution [Internet]. My Assignment Help. 2021 [cited 21 April 2021]. Available from: https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/average-working.html.


For years, MyAssignmenthelp.com has been operating as one of the cheap assignment help providers in the USA. We are one of the best college paper writing services that keep service price minimal. We do not let the affordability of our service to hamper the standard of our work. We have separate teams of experts to provide report writing help . At MyAssigenmnthelp.com, we believe in earning credibility, so students can pay for assignments only after getting satisfied solutions. Tough assignments bother you? Trust us with your project. You will not regret paying us to write assignments for you.

Latest Other Samples

PED222 Property Law

Download : 0 | Pages : 7

Answer: On a submission to the Australian Law Reform commission upon the Native Title Act it has been under an objective of amending the results of prior inequities towards the advancement and protection of the Aboriginal persons and Torres Strait Islanders (Acts, 2011). It also undertakes to make certain that they are provided with complete identity as to their rights and interests along with the preservation of their culture. The aim of the ...

Read More arrow

BN223 Cyber Security Principles

Download : 0 | Pages : 11

Answer: Cybercrime is one of the growing threats for most of the organizations in today’s world. There are different kinds of issues such as unethical hacking by the hackers form the outside world such as financial manipulations, tax frauds as well as defamation of brand image for the organizations. These issues can often cause the large organizations to pay hefty fines as well as facing ethical dilemmas. In the following report such da...

Read More arrow

BN223 Cyber Security Principles

Download : 0 | Pages : 11

Answer: Cybercrime is one of the growing threats for most of the organizations in today’s world. There are different kinds of issues such as unethical hacking by the hackers form the outside world such as financial manipulations, tax frauds as well as defamation of brand image for the organizations. These issues can often cause the large organizations to pay hefty fines as well as facing ethical dilemmas. In the following report such da...

Read More arrow

BSBPMG522 Undertake Project Work

Download : 0 | Pages : 6

Answer: Project management can be defined as the systematic procedure of initiating, planning, executing, controlling and concluding a project with a team of professionals to achieve set goals within a stipulated perios of time. According to Kerzner and Kerzner (2017), the primary challenge of managing a project is to critically address the requisites of the project within the constrained time limits. In addition to this, additional constraint...

Read More arrow

PUBH6006 Community Health And Disease Prevention

Download : 0 | Pages : 8

Answer: Community Health and Disease Prevention The goal of the Emergency plan is primarily aimed at minimising the morbidity and mortality which is usually a result of an outbreak of Ebola. The reduction can be minimised by the limitation of the spread of the disease using proper healthcare services, funds, education and unification of the various communities.  Action and Possible Empowerment The action is aimed at prevention of outbr...

Read More arrow
Next

Save Time & improve Grade

Just share requirement and get customized Solution.

watch
question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here

1,657,348

Orders

4.9/5

Overall Rating

5,122

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

203 Order Completed

97% Response Time

Richard Alpert

PhD in Psychology

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2109 Order Completed

99% Response Time

Emma Zhong

Ph.D in Project Management with Specialization in Project Communications Management

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1692 Order Completed

98% Response Time

Alfred Dodd

PhD in Computer and Information Science with specialization in Database

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 4/5

248 Order Completed

100% Response Time

Lloyd Bernabe

MSc in Accounting

London, United Kingdom

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Amazing support and great work from the expert! Again thank you guys so much for all the help!

flag

User Id: 673036 - 21 Apr 2021

Australia

student rating student rating student rating student rating student rating

well prepared project. got some minor editing and got the full marks. will use it again .

flag

User Id: 610828 - 21 Apr 2021

Australia

student rating student rating student rating student rating student rating

good job and consider the need the of the assignment .good job and consider the need the of the assignment .good job and consider the need the of the assignment .good job and consider the need the of the assignment .good job and consider the need the...

flag

User Id: 618488 - 21 Apr 2021

Australia

student rating student rating student rating student rating student rating

received 72 marks this is first assignment which i have received above 70 i have given so many assignment after this i received a good marks. but expected is 75 above as i had paid too much money.

flag

User Id: 431633 - 21 Apr 2021

Australia

student rating student rating student rating student rating student rating

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?