Exercise 2 (5 points) Shadyside Insurance Company manages a medical insurance program for its clients. Employees of client firms submit claims for reimbursement of medical expenses. Shadyside processes these claims, checks them to ensure that they are covered by the claimants policy, notes whether the claimant has reached any limit on coverage, computes any deductible, and issues a check for the claimants refund.

Three types of clerks work in the claims processing department: supervisors, senior clerks, and junior clerks. The supervisors are paid $42,000 per year, the senior clerks are paid $37,000 per year, and the junior clerks are paid $32,000 per year. For every 150,000 claims processed per year, Shadyside plans to use one supervisor, six junior clerks, and two senior clerks. Last year, the company processed 2 million medical claims and employed 14 supervisors, 30 senior clerks, and 83 junior clerks.

Required a. Compute the excess costs or cost savings relating to the claims processing staff. b. How would you interpret these results? What additional information would you ask for if you were determining the clerical groups processing efficiencies? * Provide your Answer in an Excel file that you create and Upload to Canvas

Please explain how you got your answers and formulas that were used in Excel. Any help here will be greatly appreciated!