fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
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.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

250 words

Error goes here

Students Who Viewed This Also Studied

8 Pages
RESEARCH ESSAY MARKING RUBRIC

Develops a unified and coherent description within paragraphs with generally adequate transitions; clear overall organization      (20-29)Develops a unified and coherent discu ...

Type

Assignment

Subject

Accounting

3 Pages
ACT101-Marketing Communication

This task will generally be assessed in terms of the following criteria:1. Effectiveness of communication: readability, grammar, spelling, neatness, completeness and presentation.2. Demonstrated compe ...

Type

Assignment

Subject

Accounting

5 Pages
Management

The objective of this essay is to provide an understanding of the implementation of AASB Conceptual Framework, AASB101 Presentation of Financial Statements and AASB102 Inventory in financial reporting ...

Type

Essay

Subject

Accounting

4 Pages
Management

Question1. Management of a company could use Sensitivity and Scenario analysis in their corporate decision makings. How their decision making could be related to capital budgeting techniques such as, ...

Type

Course Work

Subject

Accounting

ACFI3009 Accounting Theory Contemporary Issues

Question

Answered

The Scenario: You have recently transferred into the role of Senior data analyst in SuperStore Ltd. You are stationed at their head office in Sydney. SuperStore has and continues to sell office equipment at discount prices online since 2015. SuperStore offers their products exclusively online and has no shopfronts which allows for it to save on selling costs to gain a competitive advantage. Angelo is the head of sales and is interested in understanding the sales data for the products that SuperStore offers. Angelo hopes to understand what customers like to purchase, as well as which products are most profitable to SuperStore, so that he can make decisions about stock volume levels, purchase discounts and marketing campaigns. While this would have otherwise been a job for your boss, you have indicated during a previous supervision session that you are keen to take on higher responsibilities, in a bid to pave way for a promotion. As your boss in traveling abroad, he thought it an opportune time for you to complete the requested task with the assistance of the office clerk (this role in the current scenario will be played by your course lecturer). You have managed to extract the sales data from the company’s accounting information system and have put these in an excel file (Assignment 1 Excel file 2021.xlsx). You decide that using Excel is the best way for you to present the data. You are confident that the use of an Excel table will allow you to provide an appropriate interactive dashboard, various pivot tables, charts, filters and slicers when presenting your information to Angelo. Requirements: Using the dataset provided and at least 3 charts, 3 pivot tables, one filter and 4 slicers, create a one page DASHBOARD that summarises the sale of products year on year for Angelo. This submission (dashboard + 1 page summary) makes up 17 of your 20 marks for Assessment 1. You will need to convert the dataset to an Excel table and then do some work on it for the analysis: a. Format all the rows in your table to a height of 13.2. b. Add a column that contains the year extracted from the “Date”. c. Add a column that contains the month number extracted from “Date”. d. Add a column that contains the month formatted in words e.g. “Jan”, “Feb” etc. Angelo has provided the following list of data which he is interested in viewing: a. Information on the countries and regions which are most profitable and have the most sales activity; b. An insight into SuperStores most popular products and those products which generate the most profit; c. Identification of any products which may be poor performing or at risk of becoming obsolete; d. Who SuperStores’ best and worst customers are and an indication of which products they enjoy, including margins (this will help Angelo to decide what products to discount); e. A monthly analysis of sales to help Angelo with stock and distribution staff levels. Angelo would really appreciate it if this can also show him which products are more popular at different times of the year; In addition to the above request, your discussions with Angelo highlighted that he would like to extend SuperStores’ technology product offering. You decide to include an additional analysis regarding the technology category of products to help Angelo understand what customers and stores would be ideal for the new offerings. Angelo would like to see the data represented in a variety of charts and pivot tables. He would also like to be able to vary the data that is on these charts using filters and or slicers to make it as interactive as possible. In particular, he would like to be able to slice the data by some of the following categories, as appropriate for the pivot tables you have selected: a. Year b. Month c. Country d. State e. Product Category f. Sub Category Please make sure that your charts and other dashboard elements are appropriately labelled, i.e. with titles and chart labels. You need to submit the file containing your worksheet and dashboard to Blackboard for the head of sales (Angelo) to look at. Please use the Excel Files – Assessment Task 1 folder on Blackboard and please make sure that your filename contains your last name and student number. You should also send Angelo a ONE PAGE summary of your work . This should explain how to use your dashboard, why you have included the tables, charts, filters and slicers you have chosen, and highlight any specific choices you have made when categorising the above. Submit this to the folder supplied in Blackboard as well. You are required to also prepare a 500 word reflection on this task. You will find some resources for writing these in the Assessments folder. Please consider your position at the outset, during and at completion of the task, make reference to the course materials and other resources used along the way, and reflect on how this assessment task might impact your approach to data visualisation in the future. Submit this to the “Reflections: Assessment 1” folder on Blackboard.

ACFI3009 Accounting Theory Contemporary Issues

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

20 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com has gained the status of premier assignment help provider in USA. The combination of highly qualified experts, wide range of service and affordable price play a significant role behind our overwhelming popularity among the students in USA. Some of our popular writing services include Marketing assignment help, mechanical engineering assignment help, English assignment help, taxation assignment help, electrical engineering assignment help.

More ACFI3009 ACFI3009 Accounting Theory Contemporary Issues: Questions & Answers

Q

Develops a unified and coherent description within paragraphs with generally adequate transitions; clear overall organization      (20-29)Develops a unified and coherent discussion within paragraphs with generally adequate transitions; clear overall organization relates most ...

View Answer
Q

This task will generally be assessed in terms of the following criteria:1. Effectiveness of communication: readability, grammar, spelling, neatness, completeness and presentation.2. Demonstrated competency and understanding: This will be evidenced by the student's ability to be dialectical in the di ...

View Answer
Q

The objective of this essay is to provide an understanding of the implementation of AASB Conceptual Framework, AASB101 Presentation of Financial Statements and AASB102 Inventory in financial reporting and business practices in Australia. To complete this essay, you should find a 2017/2018 annua ...

View Answer
Q

Question1. Management of a company could use Sensitivity and Scenario analysis in their corporate decision makings. How their decision making could be related to capital budgeting techniques such as, Internal Rate of Return, Net Present Value etc. Explain the following concepts in relation to Capita ...

View Answer

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.

Choose Our Best Expert to Help You

expert
student rating student rating student rating student rating student rating
Joshua Byrd

I have done my PhD in Finance from Pennsylvania State University.

350 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Pope Atkins

I am a professor of Geology at James Cook University Singapore.

800 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Jaydon Key

I am a research scholar in Columbia University and am pursuing my doctorate degree in Physics.

150 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Haylie Duncan

Computer Science (MSc, Ph.D.), M.Sc. from University of Kent.

900 - Completed Orders

Hire Me

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
02 Dec 2021

English

Essay: 4 Pages, Deadline: 9 days

Very good paper, included everything and helpful. I got a grade on the essay, received a 100 on my paper. I highly recommend this website!

flag User ID: 6***89 United States

student rating student rating student rating student rating student rating
02 Dec 2021

Marketing

Assignment: 10 Pages, Deadline: 11 days

Excellent job. Very timely. Customer service was top-notch. Even my lecturer was impressed.

flag User ID: 8***83 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Assignment: 7 Pages, Deadline: 9 days

I am very happy when I get marks I feel very verry good I got good marks thank u so much for helping me

flag User ID: 5***67 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Project Management

Essay: 9 Pages, Deadline: 1 day

was a part of my programme management curs level 5 i passed it with 85% and that is soo good for me, thank you

flag User ID: 7***04 Birmingham, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Thesis: 1.8 Pages, Deadline: 6 days

Very good job I am very happy when I get marks I very very happy thank u so much for helping me

flag User ID: 5***67 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Mechanical Engineering

Programming: 6 Pages, Deadline: 15 days

was in time good experience, hope would have scored good grades. Good maintained and very much friendly service.

flag User ID: 6***39 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Essay: 6 Pages, Deadline: 5 days

excellent work thank you i will always use this website and tell and advise my friends and colleagues about you guys but there must be more discounts ...

flag User ID: 7***75 Kuwait

student rating student rating student rating student rating student rating
02 Dec 2021

HRM

Programming: 2 Pages, Deadline: 4 days

all work done well with good referencing and proper words i got a very good score for this particular course and i am happy about that. thank you so ...

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

HRM

Assignment: 3.6 Pages, Deadline: 3 days

submitted my work and the lecture acknowledge my work saying that it was good and i did a very good work.

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Assignment: 16 Pages, Deadline: 16 days

Very supporting and helpful, I am happy to express that the assignment and writing is very good and helped me to achieve good achievement in study.

flag User ID: 4***58 Malaysia

student rating student rating student rating student rating student rating
02 Dec 2021

English

Essay: 4 Pages, Deadline: 9 days

Very good paper, included everything and helpful. I got a grade on the essay, received a 100 on my paper. I highly recommend this website!

flag User ID: 6***89 United States

student rating student rating student rating student rating student rating
02 Dec 2021

Marketing

Assignment: 10 Pages, Deadline: 11 days

Excellent job. Very timely. Customer service was top-notch. Even my lecturer was impressed.

flag User ID: 8***83 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Assignment: 7 Pages, Deadline: 9 days

I am very happy when I get marks I feel very verry good I got good marks thank u so much for helping me

flag User ID: 5***67 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Project Management

Essay: 9 Pages, Deadline: 1 day

was a part of my programme management curs level 5 i passed it with 85% and that is soo good for me, thank you

flag User ID: 7***04 Birmingham, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Thesis: 1.8 Pages, Deadline: 6 days

Very good job I am very happy when I get marks I very very happy thank u so much for helping me

flag User ID: 5***67 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Mechanical Engineering

Programming: 6 Pages, Deadline: 15 days

was in time good experience, hope would have scored good grades. Good maintained and very much friendly service.

flag User ID: 6***39 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Essay: 6 Pages, Deadline: 5 days

excellent work thank you i will always use this website and tell and advise my friends and colleagues about you guys but there must be more discounts ...

flag User ID: 7***75 Kuwait

student rating student rating student rating student rating student rating
02 Dec 2021

HRM

Programming: 2 Pages, Deadline: 4 days

all work done well with good referencing and proper words i got a very good score for this particular course and i am happy about that. thank you so ...

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

HRM

Assignment: 3.6 Pages, Deadline: 3 days

submitted my work and the lecture acknowledge my work saying that it was good and i did a very good work.

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Assignment: 16 Pages, Deadline: 16 days

Very supporting and helpful, I am happy to express that the assignment and writing is very good and helped me to achieve good achievement in study.

flag User ID: 4***58 Malaysia

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

ribbon
callback request mobile
Have any Query?