ACCT5011: Accounting Systems in the Digital Age
Practical Assignment Guide, Semester 1, 2025
Due Date for Submission: Thursday 17th April 2025 at 5.00 PM
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 365STOCKHISTORYandFORECASTING functions 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,graphsshouldalso include a trendline and formula. Predicted weekly share price figures should be shown using theFORECAST 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 firms 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 these 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 these data by flavour and by month. The company wants to monitor time to deliver by distribution centre for each year, and it wants to be able to generate sales in dollars across category and flavour by distribution centre at the year, month and date ordered levels. Finally, Just Juicey wants this data dashboard to automatically update when new data are added to the source data.
Thus, Just Juiceys 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 category and flavour by distribution centre.
- Chart #1: a stacked column chart of total sales across distribution centres and year ordered by new or existing customers.
- Chart #2: a line chart of total sales across year and month ordered by new or existing customers.
- Chart #3: a clustered column chart of total sales across year ordered and flavour by category.
- Chart #4: a clustered bar chart of average time to deliver across distribution centres by year ordered.
- Slicers where 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 full student name, student ID and student signature. Please note that this cover sheet is to besubmitted separately to your Folio Assignment MS Excel workbook.
When naming yourCover Page in MS Word, please use the following file name protocol:
Student ID_Surname_Practical_Assignment_Cover Sheet.docx.
Practical Assignment task is to be submitted with full student name and student ID. Please note your MS Excel workbook files are to besubmitted 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 onlymark the visualisations that you provide and normal late penalties as per the Unit Outline will apply if the Unit Coordinator has torequest them again. This can result in a zero mark for the assignment depending on how much time has passed.
Company Allocations for Practical Assignment
|
|
Student Id
|
Code1
|
Code2
|
Code3
|
Code4
|
C ode5
|
|
sammi1
|
21896099
|
BHP
|
FMG
|
EVN
|
BFL
|
INA
|
|
2
|
21452844
|
CBA
|
FMG
|
VGS
|
NDQ
|
CXO
|
|
3
|
21970854
|
CSL
|
FMG
|
STW
|
TAH
|
APA
|
|
4
|
21652961
|
NAB
|
FMG
|
ALL
|
CBA
|
WPR
|
|
5
|
22386478
|
WBC
|
FMG
|
AWC
|
DRR
|
IPH
|
|
6
|
22180078
|
MQG
|
CBA
|
IOZ
|
VNT
|
AUB
|
|
7
|
22501844
|
ANZ
|
AMC
|
VEA
|
TLX
|
AAA
|
|
8
|
21649154
|
WDS
|
CBA
|
MTS
|
PRU
|
APA
|
|
9
|
22256034
|
FMG
|
NAB
|
BPT
|
EVT
|
PDL
|
|
10
|
22398033
|
WES
|
FPH
|
WOW
|
HLS
|
ELD
|
|
11
|
22513962
|
WOW
|
VAS
|
ALU
|
SNZ
|
SMR
|
|
12
|
21937040
|
TLS
|
DXS
|
SQ2
|
BAP
|
MXT
|
|
13
|
21330157
|
TCL
|
ORG
|
NHC
|
CMW
|
LOV
|
|
14
|
22418847
|
GMG
|
AFI
|
TNE
|
VAP
|
APA
|
|
15
|
22080660
|
RIO
|
TLC
|
DOW
|
SUL
|
WOW
|
|
16
|
21824621
|
COL
|
AIA
|
FBU
|
VHY
|
IAF
|
|
17
|
22159803
|
STO
|
NCM
|
GMG
|
IRE
|
WOW
|
|
18
|
21633665
|
ALL
|
NAB
|
NHF
|
VEU
|
FMG
|
|
19
|
21293331
|
QBE
|
REH
|
NEC
|
CSR
|
SFR
|
|
20
|
19440077
|
WDS
|
MIN
|
NCM
|
REA
|
FMG
|
|
21
|
21795659
|
ASX
|
VCX
|
RWC
|
DHG
|
LFS
|
|
22
|
22130044
|
NCM
|
SOL
|
FLT
|
EVN
|
WOW
|
|
23
|
21984635
|
RHC
|
SGP
|
ANN
|
BRN
|
WOW
|
|
24
|
21941902
|
SHL
|
EVN
|
WOW
|
WAM
|
FMG
|
|
25
|
21624151
|
REA
|
TWE
|
PMV
|
FMG
|
PPT
|
|
26
|
22035178
|
BXB
|
NST
|
A2M
|
STO
|
WOW
|
|
27
|
20689337
|
WTC
|
GPT
|
CLW
|
PDN
|
LIC
|
|
28
|
22495730
|
CPU
|
SPK
|
CNU
|
VUK
|
ARF
|
|
29
|
21983496
|
JHX
|
QAN
|
APE
|
WOW
|
CHN
|
|
30
|
22272014
|
SCG
|
MGR
|
BKW
|
DDR
|
FMG
|
|
31
|
19793302
|
BHP
|
CBA
|
EVN
|
BFL
|
INA
|
|
32
|
21642247
|
CBA
|
EDV
|
FMG
|
NDQ
|
CXO
|
|
33
|
23125452
|
CSL
|
NAB
|
CBA
|
TAH
|
APA
|
|
34
|
21857481
|
NAB
|
CSL
|
ALL
|
CBA
|
WPR
|
|
35
|
22437392
|
WBC
|
APA
|
CBA
|
DRR
|
IPH
|
|
36
|
21418464
|
MQG
|
XRO
|
FMG
|
VNT
|
AUB
|
|
37
|
22456562
|
ANZ
|
FMG
|
VEA
|
TLX
|
AAA
|
|
38
|
21874341
|
WDS
|
TPG
|
MTS
|
PRU
|
APA
|
|
39
|
21990674
|
FMG
|
CBA
|
BPT
|
EVT
|
PDL
|
|
40
|
20448729
|
WES
|
FMG
|
ILU
|
HLS
|
ELD
|
|
41
|
20916747
|
APA
|
WBC
|
IPH
|
CSR
|
SFR
|
|
42
|
21987634
|
SUN
|
BHP
|
AMP
|
ANZ
|
CSL
|
|
43
|
22409281
|
EDV
|
CBA
|
CXO
|
CBA
|
WES
|
|
44
|
21904099
|
RMD
|
CSL
|
APA
|
IRE
|
WOW
|
|
45
|
20528906
|
COH
|
NAB
|
WPR
|
VEU
|
FMG
|
|
46
|
21906901
|
APA
|
WBC
|
IPH
|
CSR
|
SFR
|
|
47
|
21941630
|
SUN
|
BHP
|
AMP
|
ANZ
|
CSL
|
|
48
|
22329813
|
EDV
|
CBA
|
CXO
|
CBA
|
WES
|
|
49
|
22521826
|
RMD
|
CSL
|
APA
|
IRE
|
WOW
|
|
50
|
21942167
|
COH
|
NAB
|
WPR
|
VEU
|
FMG
|
|
51
|
17745505
|
APA
|
FMG
|
IPH
|
CSR
|
SFR
|
|
52
|
22660538
|
XRO
|
MQG
|
AUB
|
REA
|
FMG
|
|
53
|
21936911
|
AMC
|
ANZ
|
AAA
|
DHG
|
LFS
|
|
54
|
21887789
|
TPG
|
WDS
|
APA
|
MGF
|
SYA
|
|
55
|
22007410
|
IAG
|
FMG
|
PDL
|
BRN
|
WOW
|
|
56
|
21740073
|
FPH
|
WES
|
ELD
|
WAM
|
FMG
|
|
57
|
21543816
|
VAS
|
WOW
|
SMR
|
FMG
|
PPT
|
|
58
|
22431048
|
DXS
|
TLS
|
MXT
|
ETHI
|
WOW
|
|
59
|
19623535
|
ORG
|
TCL
|
LOV
|
PDN
|
LIC
|
|
60
|
13957157
|
AFI
|
GMG
|
APA
|
VUK
|
ARF
|
|
61
|
20941587
|
BHP
|
FMG
|
EVN
|
BFL
|
INA |