ACCT5011 Accounting Systems in the Digital Age Assignment Brief | Curtin University

ACCT5011 Assignment Brief

Please note that the Practical Assignment ACCT5011 Accounting Systems in the Digital Age is an individual assessment taskworth 30% of your total marks in the unit. Please refer to the online marking rubric for an explanation of how individual marks will be allocated for this assessment task. The assignment is to be submitted online through the Blackboard Assessment folder.

High standards of academic integrity are expected. You are referred to the URL link provided in the ACCT5011 Unit Outline (see:AcademicIntegrityWebsite)for further information on Academic Integrity and originality.

No Turnitin submission is required for the Practical Assignment file because it is not a written submission, but an original Microsoft Office 365 / Excel Assignment.

Vivas

To detect any academic misconduct, we will conduct vivas (i.e. short interviews with some students) on the assignment. Students will be randomly selected.

Interviews will be held face-to-face or using Blackboard Collaborate.

Required:

Question 1: Stock History and Forecasting Analysis(5 marks)

Using Microsoft Office / Excel 365, the STOCKHISTORY and FORECASTING functions are available:

• Create a stock history table and prepare a line graph of the weekly share price history(from 1/7/2022 to 31/3/2025)for any two (2) listed companies that you have been allocated(separate table and graphs to be shown).
• Forecast the share price for the next 6 months (i.e., 30/9/2025). Please note that, also includes a trendline and formula. Predicted weekly share price figures should be shown using the FORECAST SHEET function

Question 2: Capital Evaluation(7 marks)

Arroy Snackfoods is considering replacing a five-year-old machine that originally cost $75,000. It was being depreciated using straight-line to an expected salvage value of zero over its original 10-year life and could now be sold for $40,000. The replacement machine would cost $215,000 and have a five-year expected life. It would be depreciated using the straight-line method. The expected salvage value of this machine after 5 years is $30,000. The new machine is expected to operate much more efficiently, saving $6,000 per year in energy costs. In addition, it will eliminate one salaried position, saving another $68,000 annually. The firm's marginal tax rate is 25%, and the WACC is 9.5%.

Required:

• Set up an operating cash flow statement, and calculate the payback, discounted payback, NPV, IRR, and MIRR of the replacement project. Should the project be accepted?
• Create an NPV profile chart for the old and new machines. At what discount rate would you be indifferent between keeping the existing equipment and purchasing the new equipment?

Question 3: Data Dashboard(18 marks)

Just Juicey Pty Ltd, a fictitious company that bottles juices and smoothies in five fruit flavours (apple, grape, orange, pear, and tomato) and four vegetable flavours (beet, carrot, celery, and cucumber). Just Juices now wants to develop a data dashboard that its mid-level operations management team can use to track its sales over the most recent three years.

Specifically, Just Juicey wants to be able to track dollar sales for each of its distribution centres by year, and it wants to be able to look at this data for new and existing customers. Just Juicey also wants to be able to track its dollar sales by year for each category (juices and smoothies), and it would like to be able to look at this data by flavour and by month. The company wants to monitor the time to deliver by distribution centre for each year, and it wants to be able to generate sales in dollars across categories and flavours by distribution centre at the year, month and date ordered levels. Finally, Just Juicey wants this data dashboard to automatically update when new data is added to the source data.

Thus, Just Juice's KPIS for this dashboard are total dollar sales and average delivery times. In addition, Just Juiceys' desire to be able to specify the month ordered, year ordered, date ordered, category, flavour, distribution centre, and whether new or existing customers are displayed in various charts indicates that the company needs a dynamic and interactive data dashboard.

Using PivotTables, Pivot Charts, and Slicers to Build a Data Dashboard that includes:

• A table that shows total sales and average time to deliver across categories and flavours by distribution centre.
• Chart #1: a stacked column chart of total sales across distribution centres and years, ordered by new or existing customers.
• Chart #2: a line chart of total sales across years and months, ordered by new or existing customers.
• Chart #3: a clustered column chart of total sales across years, ordered by flavour by category.
• Chart #4: a clustered bar chart of average time to deliver across distribution centres by year, ordered.
• Slicers were required (apply to multiple charts.

Format Requirements and marking note:

The Practical Assignment task must be submitted online as one MS Excel workbook file with a separate cover page. Please note the following submission format requirements:

Cover-page is to be submitted with the full student name, student ID and student signature. Please note that this cover sheet is to be submitted separately to your Folio Assignment MS Excel workbook.

When naming your Cover Page in MS Word, please use the following file name protocol:

Student ID_Surname_Practical_Assignment_Cover Sheet.docx.

The practical Assignment task is to be submitted with the full student name and student ID. Please note that your MS Excel workbook files are to be submitted separately to your cover page.

When naming your MS Excel files, please use the following file name protocol

Student ID_Practical Assignment_Q1_Q2.xlsx

Student ID_Practical Assignment_Q3.xlsx

Please note: It is your responsibility to make sure that the above uploaded files can be successfully opened by the marker. The marker will only mark the visualisations that you provide, and normal late penalties as per the Unit Outline will apply if the Unit Coordinator has to request them again. This can result in a zero mark for the assignment depending on how much time has passed.

Company Allocations for Practical Assignment