AIN3701 Assignment 2 (COMPLETE ANSWERS) 2025 (721274) - DUE 13 June 2025 ;100% trusted, comprehensive and complete reliable solution with clear explanation

AIN3701 Assignment 2 (COMPLETE ANSWERS) 2025 (721274) - DUE 13 June 2025 ;100% trusted, comprehensive and complete reliable solution with clear explanation 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