Excel Instructions: - Complete each question in MS Excel on a separate worksheet in the sequence of the assignment questions. - Ensure that the relevant question number is clearly visible on the MS Excel sheet. - If required to indicate different scenarios of an MS Excel sheet, each scenario must be on a different sheet. - Make use of cell and absolute cell referencing in your calculations. - Ensure that your answer fits on A4 MS Excel sheets. Use the print screen option. QUESTION 1 Lendlela Group ZA (LGZA) is a pharmaceutical group that comprises of a chain of retail pharmacies and manufactures an extensive range of branded and generic prescription drugs. These drugs are distributed through the group's own pharmacy and other pharmacies, hospitais and convenience stores. Summary extract from the Consolidated Financial Statements: Eighty percent of LGZA's total revenue is derived from credit sales. The group's credit policy states the following: - Credit limits are set for each debtor based on the debtor's credit rating. Sales to debtors may not exceed their credit limits: and - Total exposure to a single debtor may not exceed 4% of the total oustanding receivables balance. Duting the 2023 financial year, one of LGZA's debtors, Yakho Ltd., was liquidated. LGZA received R0.40 from the liquidators and the balance of R1.5 million was written off. Yakho had a credit limit of R2 Million. Credit losses amounted to R41 429000 in 2023 (2022. R47 980 000). The following represents some of the ratio's, percentages and calculations for the South African pharmaceutical industry: 4 Required: Critically evaluate the credit policy of LGZA by analysing and providing insight on sales, credit losses, credit limit and receivables collection period