AIN3701 Assignment 2 (COMPLETE ANSWERS) Semester 1 2025 - DUE 13 June 2025; 100% correct solutions and explanations.

AIN3701 Assignment 2 (COMPLETE ANSWERS) Semester 1 2025 - DUE 13 June 2025; 100% correct solutions and explanations. SkyHigh Airlines Company background SkyHigh Airlines is a rapidly growing domestic airline that provides affordable and reliable flights across South Africa and neighbouring countries. With a focus on customer service and operational efficiency, the airline has gained a strong reputation in the market. SkyHigh Airlines offers flights from Johannesburg to three major destinations: � Cape Town � Durban � Windhoek To accommodate different types of passengers, SkyHigh Airlines has two pricing categories: � Adult ticket pricing: Full fare for passengers 12 and above. Child ticket pricing: Discounted fare for passengers under 12. Booking procedure Customers book their flights through the SkyHigh Airlines call centre, where their bookings are handled by a call centre agent. Once the booking details are confirmed, customers have three payment options: � Electronic Funds Transfer (EFT) – Customers can make a direct bank transfer. � Credit Card – Payments can be made immediately using a credit card. � Cash Payment on the Day of Flight – Customers can choose to pay in cash at the SkyHigh Airlines kiosk before boarding their flight. Recently, the airline has undergone an external audit, revealing potential discrepancies in ticket revenue records. Internal audits, however, have not confirmed these discrepancies, leading to a directive for a full recalculation of all ticket sales for the month of February 2025. QUESTION 1 E-Mail from Rassie Bavuma (CFO of SkyHigh Airlines) Dear Student, I hope this email finds you well. My name is Rassie Bavuma, the Chief Financial Officer at SkyHigh Airlines. I am reaching out to you because we have encountered a serious issue that requires your expertise. As you know, we recently underwent an external audit, and the auditors raised concerns about discrepancies in a sample of our ticket sales revenue. Our internal audit team also conducted a review but found no discrepancies. This contradiction has left our leadership team concerned, and they have instructed us to conduct a full recalculation of ticket sales for February 2025 to verify accuracy. The external auditors suspect that some bookings may have been misclassified, leading to incorrect revenue calculations. To resolve this, we need you to develop a VBA (Visual Basic for Applications) solution in Excel that will: • Identify and highlight rows where discrepancies exist. • Generate an additional column labeled "Correct Revenue" and another labeled "Price Difference" to indicate inconsistencies. • Ensure that the recalculations run automatically at the click of a button. My colleague, Bridgette Jacobs (Chief Information Officer), also requested that you create a function procedure for calculating ticket revenue so that it can be reused across different departments. She mentioned that all pricing rules should be clearly coded as constants within the function. For your reference, please find attached Annexure A, which provides the ticket pricing details for the three destinations and passenger categories. Lastly, if you come across any unusual patterns or findings in the data, please document them so that we can discuss them with the external auditors. Thank you for your assistance—I know this is an urgent request, and I appreciate your expertise in resolving this issue. Best regards, Rassie Bavuma Chief Financial Officer (CFO) Annexure A: Ticket pricing details Destination Adult Price (ZAR) Child Price (ZAR) Cape Town 1 800 1 350 Durban 1 500 1 125 Windhoek 3 500 2 625 REQUIRED: Marks (a) Please download the Excel file called Bookings_Feb_. Perform all coding in this workbook. When done, save the workbook as yourstudentnumber_Surname_Q (macro enabled workbook), for example: _VanStaden_Q. Code the required function procedure based on the instructions in the email from Rassie Bavuma using Visual Basic for Applications (VBA). Make sure your coding complies with coding best practices. No marks will be awarded for coding functions and commands not covered in AIN2601 and AIN3701. Therefore, refrain from using arrays and collections. 15 (b) Continue working in your Excel workbook you created in TASK (a) above. Remember to save the workbook as yourstudentnumber_Surname_Q (macro enabled workbook), for example: _VanStaden_Q Code the sub-procedure required by the e-mail from Rassie Bavuma using Visual Basic for Applications (VBA). Make sure your coding complies with coding best practices. Important: When testing your sub-procedure, you must encounter an overflow error when processing ticket sales with high values. • Do not correct the overflow error in this section. • Submit your code with the overflow error present, as you will analyse and resolve it in Question 1 (c). No marks will be awarded for coding functions and commands not covered in AIN2601 and AIN3701. Therefore, refrain from using arrays and collections. 20