For this individual assignment, you will use skills acquired through practical laboratory exercises to automate a business process, and to visualize the impact of the automation.
Fiction Life is a small second-hand book shop, run by a team of three sta? members: Albert, Bernita, and Chris.
For this assignment, you will complete the following set of tasks using Excel, and build an ePortfolio page to describe your work.
Calculates the projected annual outgoing costs of running Fiction Life.
Throughout the day, customers come to Fiction Life to buy books, and occasionally to sell them.
When people bring in books to sell to Fiction Life, the sta? member on duty will review the books and make an o?er 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 Fiction Life pays $3.00 for a book, they will put it on sale with a marked price of $6.00.
(Fiction Life does not deal in rare or antique books)
For several months, sta? 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.
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
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 Fiction Life team, or by a University lecturer.
Your spreadsheet should be configured such that the Low, Medium and High prices can be varied easily.
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 Chris.
Write a brief overview of how to run your solution.
It is possible to attain full marks for this assignment without completing this challenge task.
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/case-of-fiction-life.html.
"Understanding The Digital Revolution." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/case-of-fiction-life.html.
My Assignment Help (2021) Understanding The Digital Revolution [Online]. Available from: https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/case-of-fiction-life.html
[Accessed 06 March 2021].
My Assignment Help. 'Understanding The Digital Revolution' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/case-of-fiction-life.html> accessed 06 March 2021.
My Assignment Help. Understanding The Digital Revolution [Internet]. My Assignment Help. 2021 [cited 06 March 2021]. Available from: https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/case-of-fiction-life.html.
The law assignment help experts at MyAssignmenthelp.com are real subject matter experts and have helped millions of students in Australia with top-notch academic assignment assistance. They have obtained their law degrees from the top-rated law schools in the country and possess in-depth knowledge of the law to help you create 100% accurate and plagiarism-free assignment for all your assessments. Each expert is highly skilled in catering to the students' needs with the utmost efficiency.
Answer: Introduction The important and criticality of technology in business and organizations around the world is unquestionable. Various technologies and solutions exists for different sectors of industries and the choice of these technologies and solutions are based on the type of operations the business is into. Also, the information systems as well as information management systems have long been in use in multiple industries (Rhyous, 20...Read More
Answer: Introduction System Design of any project, be it a construction project or software development, defines every element of the entire system in such a way that the modules and components of the system, the architecture, the different interfaces involved in the component and all the data integrated in the system is thoroughly defined. The concept of System Design revolves around the systematic approach behind an entire construction of a...Read More
Answer: The main focus was on the processing of the lifecycle of the activity. The lifecycle of an activity states the fact that the navigation in between the phases are stated in this section. The stage consists of the 6 phases namely the onCreate() , onStart() , onResume() , onPause() , onStop() , and onDestroy(). This week also focuses on the functioning of the dialog window with the help of the activity that is used. This week is also conc...Read More
Answer: Part 1 The project charter document is developed using the case study project of ‘Development of Mobile Application and Website for Globex-I Crop Project’. The main purpose of the report is to provide the stakeholders with information aligning with the development of the improved communication and development. The information would be transferred about the project expected budget, schedule, timeline, and other requirements...Read More
Answer: Sydney Smart Office Design: Network Design Figure 1: Network design of the Sydney Office (Source: Created by Author) This is the main network design for the Sydney office. This office consists of many IoT device. For implementing the network one DHCP server, one remote server for IoT service, one wireless router for transmitting the network, one cable modem for connecting the router with the cloud is used. DHCP server DH...Read More
Just share requirement and get customized Solution.
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
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.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
On timely manner the assignment got submitted and I am happy with my score. All my questions and queries were answered and resolved promptly.
Very fast and good quality work. Just have to take note of some typo and grammatical errors.
the my assignment help really helps me when I got a problem in assignment and agents are really doing good job.
Awesome job is done here. The expert knew what they was doing and strived to get an excellent outcome! Great work! Thanks!