* Use What if Analysis on EXCEL to get the correct answer *

*Please show the data table row and column numbers used on EXCEL to explain how you got the answer*

A1 Name Box 2 Surgery Patient fee Surgery Cost Gross profit $500.00 $325.00 $175.00 4 5 6 50.00 $ 25,000.00 $ 16,250.00 $ 8,750.00 Number of procedures Total Patient fee Total Surgery Cost Estimated net profit 9 10 12 ANSWER WILL LOOK LIKE: One-Variable Data Table: Input:Fees-- Output: 1. Total Fee, 2. Gross Profit, 3. Estimated Net Profit Total Patient fee $22,500.00 $25,000.00 $27,500.00 30,000.00 $32,500.00 $35,000.00 $37,500.00 $40,000.00 $42,500.00 Gross Profit $125.00 $175.00 $225.00 275.00 $325.00 $375.00 S425.00 $475.00 $525.00 Estimated net profit 6,250.00 $8,750.00 $11,250.00 $13,750.00 16,250.00 $18,750.00 21,250.00 $23,750.00 $26,250.00 450 500 550 600 650 700 750 800 850 Two-Variable Data Table: Input:1. Fees 2. Surgery Cost-- Output: 1 Estimated Net Profit 275 $8,750.00 $11,250.00 $13,750.00 $16,250.00 $18,750.00 21,250.00 $23,750.00 $26,250.00 $28,750.00 300 325 350 375 400 $7,500.00 $10,000.00 $12,500.00 15,000.00 $17,500.00 $20,000.00 $22,500.00 $25,000.00 $27,500.00 $6,250.00 $5,000.00 3,750.00 $2,500.00 $8,750.00 $7,500.00 $6,250.00 $5,000.00 $11,250.00 $10,000.00 $8,750.00 7,500.00 $13,750.00 $12,500.00 $11,250.00 $10,000.00 16,250.00 $15,000.00$13,750.00 $12,500.00 $18,750.00 $17,500.00 $16,250.00 $15,000.00 $21,250.00 $20,000.00 $18,750.00 $17,500.00 $23,750.00 $22,500.00 $21,250.00 $20,000.00 $26,250.00 25,000.00 $23,750.00 $22,500.00 450 500 550 600 650 700 750 800 850 A1 Name Box 2 Surgery Patient fee Surgery Cost Gross profit $500.00 $325.00 $175.00 4 5 6 50.00 $ 25,000.00 $ 16,250.00 $ 8,750.00 Number of procedures Total Patient fee Total Surgery Cost Estimated net profit 9 10 12 ANSWER WILL LOOK LIKE: One-Variable Data Table: Input:Fees-- Output: 1. Total Fee, 2. Gross Profit, 3. Estimated Net Profit Total Patient fee $22,500.00 $25,000.00 $27,500.00 30,000.00 $32,500.00 $35,000.00 $37,500.00 $40,000.00 $42,500.00 Gross Profit $125.00 $175.00 $225.00 275.00 $325.00 $375.00 S425.00 $475.00 $525.00 Estimated net profit 6,250.00 $8,750.00 $11,250.00 $13,750.00 16,250.00 $18,750.00 21,250.00 $23,750.00 $26,250.00 450 500 550 600 650 700 750 800 850 Two-Variable Data Table: Input:1. Fees 2. Surgery Cost-- Output: 1 Estimated Net Profit 275 $8,750.00 $11,250.00 $13,750.00 $16,250.00 $18,750.00 21,250.00 $23,750.00 $26,250.00 $28,750.00 300 325 350 375 400 $7,500.00 $10,000.00 $12,500.00 15,000.00 $17,500.00 $20,000.00 $22,500.00 $25,000.00 $27,500.00 $6,250.00 $5,000.00 3,750.00 $2,500.00 $8,750.00 $7,500.00 $6,250.00 $5,000.00 $11,250.00 $10,000.00 $8,750.00 7,500.00 $13,750.00 $12,500.00 $11,250.00 $10,000.00 16,250.00 $15,000.00$13,750.00 $12,500.00 $18,750.00 $17,500.00 $16,250.00 $15,000.00 $21,250.00 $20,000.00 $18,750.00 $17,500.00 $23,750.00 $22,500.00 $21,250.00 $20,000.00 $26,250.00 25,000.00 $23,750.00 $22,500.00 450 500 550 600 650 700 750 800 850