You serve as the accountant at “OfficeWorx Ltd,” a company that supplies furniture, office equipment, and technology products to both individual and corporate customers across the United States. A new CEO has recently taken the helm, expressing a keen interest in gaining a deeper understanding of the company’s performance and areas where improvements may be needed.
Following a meeting with the Chief Financial Officer (CFO), who is your immediate superior, you have received the following email:
Dear [Your Name],
I recently had an initial meeting with our new CEO, and he has expressed significant concerns about our business’s financial performance. I recall you mentioning that you’ve been enhancing your skills in data analytics within the field of accounting.
I would greatly appreciate it if you could prepare a comprehensive report that leverages data analytics using our accounting data. This report should address the following objectives:
1.) Provide a comprehensive overview of the business’s financial performance over the last three years.
2.) Identify specific areas within the business that exhibit potential for improvement.
3.) Offer well-founded recommendations on strategies to enhance these identified areas.
I kindly request that you submit this report to me by the 16th of October (Monday) at 11:59 PM AEDT. Should you have any questions or require further clarification, please do not hesitate to reach out.
Warm Regards, James Sink
The dataset necessary for the assignment can be accessed through the provided link here.
1- A word processor software such as Microsoft Word or Apple Pages for document preparation. 2- Spreadsheet software like Microsoft Excel or Apple Numbers for data analysis and
3- Data visualization software, specifically Tableau, for creating visual representations and charts based on the data.
Make sure you have these software tools installed and ready for use before you begin the assignment.
Your report to the CEO should effectively apply the principles of data analytics you’ve learned in the unit. Here are the key guidelines for preparing your report:
Cover Page: The report should begin with a cover page that includes your student details.
Structure: The structure of your report can be flexible based on how you prefer to present your analysis and information. You can use sections with headings and subheadings to organize your content effectively.
References: While you can complete this assignment without referencing academic or general sources, if you choose to refer to any materials, it’s crucial to correctly cite them in-text (e.g., Alshamari, 2023) and include a proper reference list or bibliography.
Word Count: There is no strict word limit for this report, but it’s suggested to be between 2,500 to 3,000 words in length.
Ensure that your report is well-structured, effectively communicates your analysis, and provides recommendations based on your findings. Don’t forget to adhere to proper citation and referencing guidelines if you use external sources.
While not directly marked, you are expected to upload your excel file(s) that were used in your analysis. The excel file must be uploaded in order for the word report to be graded. You also need to upload a screenshot of the cover page of your assignment to your personal MPA Pebblepad portfolio. Click here if you have not created your Pebblepad portfolio.
If you use Tableau for any data visual used in the report then please use your Tableau online account as we will refer to this as well.
If any of the files (excel, screenshot to Pebblepad, Tableau map on online student account) are missing then the student’s mark will be withheld. The files will also be checked to ensure that the student is the actual author of the files and that the data in the files matches the report. Any discrepancies will be thoroughly investigated and potentially could attract penalties.