AutoSave OFF Home Insert Paste V A1 X 14 November 15 December 16 Total 17 18 19 20 21 22 23 24 25 26 Ready B 155 Draw Page Layout Formulas Data Calibri (Body) I U V V Payment Amounts 11 V fx Calculating Cost to Charge Ratio A B 1 Calculating Cost to Charge Ratio 2 3 Month 4 January 5 February 6 March 7 April 8 May 9 June 10 July 11 August 12 September 13 October Deductibles A^ A A V Estimated Cost Per Radiology Review C Billing Amounts & RVU View Total Charges $254,125.25 $458,532.25 $225,226.32 $450,568.64 $262,175.58 $495,220.36 $405,172.85 $652,558.21 $521,143.36 $652,022.25 $442,031.54 $602,589.36 $458,215.63 $615,852.10 $455,228.96 $599,252.52 $399,198.74 $600,587.59 $397,217.96 $568,223.39 $402,202.54 $585,223.14 $489,196.54 $547,239.48 $4,711,135.27 $6,827,869.29 X Workbook to complete Module 3 activities (1) Wrap Text Merge & Center D Cost to Charge Ratio MS-DRG Weights General $ % V E Cost to Charge Calculations .0 .00 .00 0 F Conditional Format Cell Formatting as Table Styles G Reimbursement Rates H DXN Denial Rates Insert Delete Format v + I WEX APO Sort & Filter El J III V Find & Select I Share K 4 Ideas Comments Sensitivity L + 167%