Please show formulas used to solve, Thank you

Function; SUM; Formula; Multiply; cell Refencing Chapter 15.3b. Using Excel to perform Materiality planning PROBLEM Mobile Security, (MS!) has been an audit Of Le LLP for thepast 12 MSI isa small, publicly traded aviation based in Cleveland, Ohio, Where it manufactures high-tech unmanned aerial vehicles (LJAV), also as drones, and Other surveillance and MS"S products are primarily used by the military and scientific research institutions, but there is growing demand for UAVS for commercial and recreational use. MSI must go through an extensive bidding process for large government Of the nature Of government and military product designs, both the facilities and records Of MSI must be highly secured. The auditors have decided on planning materiality Of5% ofpre-tax income. fiscal year-end is June 30. The auditors are nearing the final wrapp St*S Of the audit for the ended June 30, 2026. The following table Shows final financial information for all four quarters Of fiscal year end June student work Aa Required: input into cellssh.ded in yellow in this template mathematical formulas with cell references to the problem and work areas as indicated. Calculate planning materiality for MSI based on results from the first two quarters and estimates for the 11 15 17 20 22 last two a u arters. Pre-Tax In e First quarter pre-taxincome Second quarter pre-tax income Third quarter pre-tax income estimate Fourth quarter pre-tax income estimate Estimate Of planning materiality Material it planning Materi i go, 2026. Total Total eS Pretax i corn e 1 St Qu 2nd Quarter 2,790,000 3rd Quarter 2,240,000 4 th Quarter