Hire an Excel Expert

Assignment Assume that you are working at Turkish Airlines and your Manager asks from you an Excel file where he can see the Network profitability of THY. He especially asks from you to do it in VBA so that he can use the same macro to re-calculate the data if any information changes in some of the routes. Your job is to write a VBA code where all the calculations are done and written into the Excel Sheet Show your abilities in VBA and impress you manager! Required: 1. Create a flow chart for each procedure 2. Write the Pseudo code for each procedure 3. Get the corresponding data from other worksheets (with aircraft names) and print it to the blue highlighted parts in the “Summary” sheet. Use Arrays to store the data. Do this for: Frequencies and Passenger Numbers (Passengers / after spill) for each Flight Type 4. Calculate the following Costs and Revenues - Read the input data from the excel file and Print the output to the summary sheet to the yellow highlighted cells. 5. Total network aircraft trip cost = Sum of Aircraft trip cost based on number of frequencies Total network passenger costs = Sum of Passenger costs based on passenger numbers Total network passenger revenues = Sum of Passenger revenues 5. Explain all the steps you have taken in your code by adding “Comments!” 6. Show the Name of the Aircraft Type in a Message Box, which has the operating ratio higher than 100% by using loops and color that cell in red.