| University | University of Waikato (UOW) |
| Subject | ACCTN203 Management Accounting |
ACCTN203 Assignment Brief
Individual Excel Exercise #1
The assignment is worth 7.5% of the total paper mark. It is due on 10 August 2025, 9:00 PM. Late submissions will be penalised according to the guidelines specified in the paper outline.
Scenario
You work as a management accountant for an airline company. Your role includes performance evaluation and reporting on key performance indicators, and conducting ad-hoc analysis to support management decision-making. Your line manager (Levi Ackerman) has asked you to assess airline on-time performance and build a model to identify factors that influence arrival delays.
Data.xlsx includes information on the following variables, and each row represents a flight:
- ArrDelay – Difference between scheduled and actual arrival time in minutes. Early arrivals show negative numbers.
- DepDelay – Difference between scheduled and actual departure time in minutes. Early departures show negative numbers.
- TaxiOut – Taxi-out time in minutes (i.e., time from when the aircraft leaves the departure gate till it takes off).
- TaxiIn – Taxi-in time in minutes (i.e., time from when the aircraft lands until it arrives at the arrival gate).
- AirTime – Flight time in minutes.
- Distance – Distance between airports in miles.
- WeatherDelay – Extreme or hazardous weather conditions causing delays on arrival. Coded 1 for ‘Yes’ and 0 for ‘No’.
- LateAircraftDelay – Late arrival of the same aircraft at a previous airport, causing delays on arrival. Coded 1 for ‘Yes’ and 0 for ‘No’.
Complete Part 1 and Part 2 of the requirements directly on Data.xlsx. Complete Part 3 of the requirements on Email.docx. Submit both the Excel workbook and Word document to Moodle.
Requirement
Part 1 – Complete in the Part 1 sheet of the Excel workbook.
(a) Column C (Dep_Indicator) should show a departure delay indicator that returns 1 if the aircraft departure time is delayed by 15 minutes or more, and 0 otherwise. Column D (Arr_Indicator) should show an arrival delay indicator that returns 1 if the aircraft arrival time is delayed by 15 minutes or more, and 0 otherwise. Write Excel formulas in Cell C2 and Cell D2 to achieve this and auto-fill down the columns. (8 marks)
(b) Delays that are 15 minutes or more are considered major delays. Write Excel formulas in Cell G3 and Cell G4 to return the total number of departure delays and the total number of major arrival delays, respectively. (6 marks)
(c) Write Excel formulas in Cell H3 and Cell H4 to calculate the proportion of flights with major delays in departure and major delays in arrival, respectively. (6 marks)
Note: No hard-coding of values. Try using the COUNT() function as the denominator. Can try prompting GenAI tools for more guidance if needed.
(d) Write Excel formulas in Cell I3 and Cell I4 to calculate the average delay time for major departure delays and major arrival delays, respectively. (8 marks)
Note: Try the AVERAGEIF() function. Can try prompting GenAI tools for more guidance if needed.
Part 2 – Complete in the Part 2 sheet of the Excel workbook. Include all the output on this page and present your answers in an easy-to-follow manner.
(a) Create a scatter plot that shows the relation between ArrDelay and DepDelay. Format your graph as appropriate and describe what pattern you see in the graph created. (12 marks)
(b) Run correlation analysis on all variables. Use conditional formatting to highlight any moderate and strong relations. (15 marks)
(c) Using the data provided, form the most appropriate regression model that can be used to identify factors that influence arrival delay. (20 marks)
Part 3 – Complete in the Word document template
Write an email to Levi that provides an overview of your analysis findings, including insights on airline on-time performance and factors that influence arrival delay time. Briefly describe the goodness-of-fit and direction effect of variable(s) that are statistically significant in your final regression model. (25 marks)
Note: Maximum 250 words for the email with no minimum word count. Format and structure as a professional business email. Proofread thoroughly.
Stuck! Do not Know Assessment Answers?
Hire NZ Native Experts 24/7.
ACCTN203 management accounting assignments like this one can be tricky, especially when you have to work with Excel formulas, charts, and regression analysis together. Many students get stuck while using functions like AVERAGEIF, building models, or explaining results clearly in the email part. If you’re facing something similar, you can take support through management accounting assignment help from NZ Assignment Help, where work is done in a simple and structured way. You can also look at UOW assignment samples to understand how everything is presented, and then use assignment help if you need a customised, plagiarism-free solution.
- MGMT902 Enterprise and Information Systems Assignment 3: Agentic AI Change Management Report for an NZX-Listed Company | AIS
- BBIS 5101 Introduction to Object Oriented Programming Assignment 3: C# Windows Forms Campus Facilities Issue Register
- STE404 Foundations of Sterilising Practice Assessment 2 2026: Microbial Resistance, Spaulding Classification and Tikanga Māori | Open Polytechnic
- STE404 Foundations of Sterilising Practice Assessment 1 2026: Hand Hygiene, PPE and Breaking the Chain of Infection | Open Polytechnic
- BBIM708 Machine Learning and AI Assessment 2 Portfolio 2026: Supervised and Unsupervised Algorithms, Grid Search, Random Search and K-Fold Cross-Validation | NZSE
- MHSC8.002 Health and Wellness in Aotearoa Assessment 2: Impact of Colonisation on Health, Māori Health Outcomes and Te Tiriti o Waitangi | EIT
- BBIM601 Business Intelligence Assessment 2 Project 2026: RetailCo BI Application, Hotel Booking and Cardiovascular Disease Reports | NZSE
- MXO3042Y1 NCEA Level 3 Critical Path Analysis Assessment (AS 91576): Quiz Evening Report | Te Kura
- LAWCOMM 785 Patent Practice Assignment 2026: Letter of Advice on Challenging eVTOL Patent Applications in NZ and Australia | University of Auckland
- MGMT902 Enterprise and Information Systems Assignment 2: Cyber Security Governance and ICT Strategy Report | AIS


