New

Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
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 2 Pages / 452 Words tag 11-11-2020
  • Course Code: ITECH1100
  • University: Federation University
    icon

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

  • Country: Australia

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

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 2 pages

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 11 August 2022].

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 11 August 2022.

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


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?