Really need help with these questions, thank you

Q- Search Sheet Oo oo Home Insert Page Layout X Cut Formulas Data Review View 9+ Share " A AY = = = 2 Wrap Text Merge Center - Copy Formal AutoSum Fill Clear Paste $ - Conditional Format Formatting as Table Call Styles i nsart Delate Format 2 Sort & Filter D27 x x B A C D E F G H I J K Question 1 McKent Clinic has a full established rate of $254.00 for visit code 73721. Provided below is a list of payers and their respective contracted rales, as well as the number of procedures performed for each payer during the current period. Number of Procedures PayerC ontracted Rate TMM S227.00 HFP $165.00 AP $138.00 CNG $143.00 DLT $225.00 $181.00 CDA $179.00 PSE $198.00 HLH $164.00 BYT $167.00 2 10 Part (a) Use the table below to calculate the contractual allowance per procedure for each payer The first row has been completed for illustration. Full Rate $254.00 Contracted Rate S227.00 Contractual Allowance $27.00 Payer TMM HFP AP CNG DLT CDA PSE HLH BYT 36 Introduction Question Question 2 Questions Question Questions Questions MDC-DAG + Ready # 3 - + 150% Q- Search Sheet 9+ Share AutoSum " A Wrap Text Merge Center * , Copy Format Paste Conditional Format Formatting as Table Call Styles i nsart Delate Format Clear Sort & Filter DOO - Home Insert Page Layout Formulas Data Review View X Cut A AY = = = 2 E D27 xv fx A B C D E F G H Part (b) Considering now the total number of procedures performed: (i) What is the total amount to be billed by the clinic to payer CNG? I J K (i) What is the total amount the clinic can expect to receive from payer CNG? (iii) What is the total amount to be billed by the clinic to payer PSE? (iv) What is the total amount the clinic can expect to receive from payer PSE? Next question Introduction Question Question 2 Questions Question Questions Questions MDC-DAG + Ready # 3 - + 150%