Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

ITECH1100 Understanding The Digital Revolution

tag 0 Download 4 Pages / 777 Words tag 24-06-2021
  • Course Code: ITECH1100
  • University: Federation University
    icon

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Australia

Question:

Overview

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.

Assessment Details

Page Land is a small second-hand book shop, run by a team of three staff members: Augusta, Barnardo, and Chad.

For this assignment, you will complete the following set of tasks using Excel, and build an ePortfolio page to describe your work.

Task 0 - Setting up

Create an ePortfolio page for your assignment

Costs

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

Chad, however, is a part-time employee, with total employment costs of $22 per hour. Chad 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 Page Land.

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

Obtaining Books

Throughout the day, customers come to Page Land to buy books, and occasionally to sell them.

When people bring in books to sell to Page Land, 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. Sta? members o?er 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 Page Land pays $3.00 for a book, they will put it on sale with a marked price of $6.00.

(Page Land 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.

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

Process automation

Augusta and Barnardo 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 o?er.

Ensure that you include enough text and formatting to make your spreadsheet usable by a member of the Page Land team, or by a University lecturer.

Your spreadsheet should be configured such that the Low, Medium and High prices can be varied easily.

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

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

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

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/a-case-of-page-land.html.

My Assignment Help (2021) Understanding The Digital Revolution [Online]. Available from: https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/a-case-of-page-land.html
[Accessed 09 December 2022].

My Assignment Help. 'Understanding The Digital Revolution' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/a-case-of-page-land.html> accessed 09 December 2022.

My Assignment Help. Understanding The Digital Revolution [Internet]. My Assignment Help. 2021 [cited 09 December 2022]. Available from: https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/a-case-of-page-land.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

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

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?