Data visualization and analysis purposes

Assignment Help Other Subject
Reference no: EM132205035

Understanding the Digital Revolution

Assignment 1 - Paperback Planet

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.

The following course learning outcomes are assessed by completing this assessment:

Learning Outcomes
A1. Prepare a basic solution to a business problem;
A2. Select appropriate IT solutions for business functions;
A3. Apply business information software for data visualization and analysis purposes.
S1. Write basic programming logic;
S3. Interpret and construct representations of business data flow and processes;
K8. Outline the basic principles of programming.

Assessment Details

Paperback Planet is a small second-hand book shop, run by a team of three staff members: Amanda, Bakari, and Conrad.

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.

Hours of operation
Most of the time, each team member works separate shifts:

Amanda works 9:00 AM to 12:30 PM, Monday, Tuesday and Wednesday; Bakari works 9:00 AM to 12:30 PM, Thursday, Friday and Saturday; and Conrad works 12:30 PM to 5:30 PM, Monday to Friday.

The shop runs from 9:00 AM to 5:30 PM each day, except Saturday when it closes at 12:30. It is closed entirely on Sundays.

Costs

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

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

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

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.

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 Paperback Planet 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 Conrad.

Describe the strategy you used to find appropriate prices for each scenario (approximately 150 words). Ensure that the Low price is less than the Medium price, and both are less than the High price.

Optional task 5

Reimplement Task 1 and Task 3 using either Python or HTML+JavaScript.

Write a brief overview of how to run your solution, and attach a zip file containing your code to your ePortfolio page.

There are no partial marks awarded for this bonus task - you must complete all features to attain the bonus marks.

Attachment:- Required_Data_File.zip

Verified Expert

In this assignment we have have studied the case study and after analysis case study I have create the report and create the all business operations by using excel.Excel is a strong tool which provide the automation and here I have solve 4 task and calculate the actual salary of the employee

Reference no: EM132205035

Questions Cloud

Keep employees informed of planning project process : What communication tools would you use as the Strategic Project Manager to keep employees informed of the planning project process? Why?
Discuss role of quality and risk management to health care : Review quality and risk management tools and strategies. Respond to at least two of your classmates' postings
What areas could still be developed : What do you think are the most persuasive elements of your presentation? What areas could still be developed?
Define risk management : Define risk management, the components of a risk management program, and how the risk management process can reduce organizational risk
Data visualization and analysis purposes : How the prices paid differed for each staff member - create a spreadsheet page that automates the above process, allowing a member of the team
Pseudocode or very detailed instructions : In your favorite language, pseudocode or very detailed instructions, provide a Wgram that will take an infinite amount of inputs and output the minimum value
How worldview influence your adherence to academic integrity : What temptations might doctoral students encounter that would challenge their ethics? How does your worldview influence your adherence to academic integrity
Access the data type is called autonumber : In access the data type is called "AutoNumber" in SQLServer it is called an identity field, Oracle is it called a "sequence". What do they do?
Brokers own websites becoming less relevant in the market : Why are brokers' own websites becoming less relevant in the market?

Reviews

Write a Review

 

Other Subject Questions & Answers

  Emphasize order of operations

Normal 0 false false false EN-US X-NONE X-NONE Emphasize order of operations

  Create an awareness of domestic violence as a problem

Consider some movements that are not too old as well, such as movements to reform drunk-driving policies, to create an awareness of domestic violence as a problem, to provide access for handicapped persons, or to change laws to prevent discriminat..

  Diversity of hispanic americans

Explain the problems created by the diversity of Hispanic Americans.

  Compare and contrast the two types of english colonies

Compare and contrast the two types of English colonies in the Chesapeake (Jamestown/Virginia, 1607+), and New England (Plymouth, 1620+, and Massachusetts Bay, 1629+).

  Discuss about the environmental analysis

Create a 1,050-word strategic plan for your place of employment or a company with which you are familiar.

  How national political agenda dictate wider planning issues

Energy and Environmental Planning issues in America. How national political agenda dictate wider planning issues in these areas.

  Interview four candidates for a job

A personnel manager is to interview four candidates for a job. These are ranked 1, 2, 3, and  4 in order of preference and will be interviewed in random order.

  Summarize the factors that affect the impact of teratogens

Define the word teratogen and summarize the factors that affect the impact of teratogens on prenatal development. Give at least 2 examples and discuss the evidence supporting the harmful impact of each

  What is biggest difference you can make in world with degree

What is the biggest difference you can make in the world with your degree. hat would you do with it and why. Please write 200-250 words about this.

  Discuss at least two effects on us citizens

Discuss at least two effects on U.S. citizens that stem from the division of power between the federal and state governments

  Did he know or did he not know about his ancestry

Question: Did he know or did he not know about his ancestry before the story's conclusion? Explain your answer thoughtfully, using quoted language from the story to effectively support your answer

  Determine which roles are the best suited

Determine which of the six (6) roles is best suited overall for working directly with residents and their families, and which is best suited for working.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd