1. In cell G5, enter a formula without using a function that subtracts the actual dollars billed (cell E5) from the estimated amount (cell F5) to determine the remaining amount of the estimate for general administrative services.
2. Use the Fill Handle to fill the range G6:G13 with the formula in cell G5 to include the remaining amount for the other services.
3. Format the range G6:G13 using the Comma number format and no decimal places to match the formatting in column F.

IL 2 Wrap Text General Paste B Merge Center - $ % 93 Conditional Format Formatting - Table - Style Clipboard Font Alignment Number 116 D H 1 2 $85.00 3 4 5 6 Date: Professional Therapies System Upgrade Billing rate: Project Status Report Service ID Service Description Actual Hours Actual $ Estimated $ Remaining $ Remaining % G-131 General administrative 25 2,125 $ 2,500 G-240 HIPAA compliance 100 8,500 8,000 P-255 Therapy practice evaluation 40 3,400 6,800 P-314 Strategic planning 35 2,975 5,500 P-400 New services development 84 7,140 7,400 P-245 Therapy analysis 40 3,400 7,401 F-125 New revenue generation 125 10,625 10,000 F-130 Expense reduction 95 8,075 10,000 H-305 Medical staff development 40 3,400 10,200 Total 8 9 10 Everett Hospital 11 12 13 14 Vertical (Value Axis 15 16 Average years of experience Actual Hours 18 19 20 21 22 140 120 100 Schedule Documentation Consultants Project Status