$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 Download2 Pages / 452 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

For this assignment, you will use skills acquired through practical laboratory exercises to automate a business process, and to visualize the impact of the automation.

Costs

Alfred and Bernita are the semi-retired co-owners of the bookshop, and do not take a salary.

Celestine, however, is a part-time employee, with total employment costs of $22 per hour. Celestine is also entitled to four weeks of paid annual leave, during which a casual replacement is required at a cost of $33 per hour.

Fixed costs such as rent and insurance are $2900 per year, and utilities costs are $140 per month.

Task 1 - Costs of operating the business

Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Book Box.

Your spreadsheet should be configured such that the working hours, hourly rates, and fixed and utility costs can be varied easily.

Task 2 - Sales team offers

Using Excel, process the history of purchases spreadsheet and use appropriate charts to visualize:

 How the prices paid di?ered for each sta? 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

Alfred and Bernita want to improve the consistency of how they pay for and price books.

They'd like to standardize on three standard price o?ers, and have designed the following process to determine how to allocate them, including the option of rejecting the book altogether.

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 Box 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 o?er prices are approximately the same as for the historical data 

 Scenario two: Assuming all books purchased are sold, allow all sta? to draw the same wage as Celestine.

Describe the strategy you used to find appropriate prices for each scenario

Cite This Work

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

My Assignment Help. (2020). Understanding The Digital Revolution. Retrieved from https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/costs-of-operating-the-business.html.

My Assignment Help (2020) Understanding The Digital Revolution [Online]. Available from: https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/costs-of-operating-the-business.html
[Accessed 05 August 2021].

My Assignment Help. 'Understanding The Digital Revolution' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/costs-of-operating-the-business.html> accessed 05 August 2021.

My Assignment Help. Understanding The Digital Revolution [Internet]. My Assignment Help. 2020 [cited 05 August 2021]. Available from: https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/costs-of-operating-the-business.html.


Are you looking for help with rhetorical analysis essay? Ask the top writers from MyAssignmenthelp.com to help you write a college essay. You can also ask our writers ‘grade my paper’ if you want to see how well the pre-written paper fare. Our writers will rate your paper and fill in the areas where your paper lacks. We also have the best plagiarism checker tools in the UK that you can use to scan your documents and remove traces of unintentional piracy.

Latest It Write Up Samples

INFO5301 Information Security Management

Download : 1 | Pages : 9

Answers: Introduction With the advancement of technologies, IT applications are used by several users at their workplaces. The use of computer systems, internet, online databases and smart phones has become so common. These techniques provide various benefits to its users but some issues of security and privacy are encountered that are known as computer security breaches. There are several news and articles available on internet regarding sec...

Read More arrow Tags: Australia Brisbane Management Law James Cook University Masters in Business Administration 

ITC560 Internet Of Things

Download : 0 | Pages : 5

Answer: Introduction Wireless communication technology transfers information or data without any wires or physical devices.  Wireless video doorbell intercom system is a type of intercom system along with video calling. It is the advanced version of the wired video doorbell system. It allows people to talk to the delivery executives without opening the door. This report discusses about the video doorbell intercom system that is wireless...

Read More arrow

INFS 5092 IT Stakeholder Engagement

Download : 1 | Pages : 12

Answer: Introduction: TIF program has considered various possibilities in their program so that they can able to move forward and initiate positively to this. The stakeholders are closely connected to this and they are providing their best support to the program and as they are trying to bring improvement from each source so there are various disputes that get generated from this entire thing and it needs to solve by the implementation of pow...

Read More arrow Tags: Australia Lawnton economic University of New South Wales Masters in Business Administration 

INFO6030 Systems Analysis And Design

Download : 0 | Pages : 11

Answer: Introduction: My Health Record is an Australian based web application that is aimed to help the common people from not going to the hospital rather than bringing all the doctors virtually where patients can communicate with doctors about their problems and get help immediately. In case of emergency, they can tell the doctors about their problems and they can take necessary steps to avoid any bad from happening. It is also aimed to hav...

Read More arrow Tags: Australia Melbourne Management University of Melbourne Masters in Business Administration 

ITC548 System Analysis

Download : 1 | Pages : 5

Answer: Introduction The Telehealth project announced by Australian Government in 2013 was a helpful hand for healthcare department. One of the projects in Telehealth project is After-hours Urgent Care Telehealth, which has been funded, and analysis of this project is done in this report. The After-hours Urgent Care Telehealth project is for emergencies in rural areas and providing support to nearest hospitals via videoconferencing and thus d...

Read More arrow
Next

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

callback request mobile
Have any Query?