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

ACCT5011: Accounting Systems in the Digital Age

Practical Assignment Guide, Semester 1, 2025

Due Date for Submission: Thursday 17^th 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:

1. 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?
2. 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