Question: Use one variable and two variable data table to produce following model in excel. you have to use the one-variable and two variable data tables

Use one variable and two variable data table to produce following model in excel. you have to use the one-variable and two variable data tables to get your values.

**(In data tab - what-if analysis -> Data Table)**

Total Fees = Patient Fee * Number of procedures Total Costs = Surgery Cost * Number of procedures Estimated profit = Total Fees - Total Costs

Your excel file should look like the following: Please show steps on *EXCEL* and include the formulas to add on EXCEL

Use one variable and two variable data table to produce following model

Estimate of Profits -Surgery Patient fee Sugery cost Number of procedures 650.00 180.00 50 One-Variable Data Table: Patient Fee Total fees 450$22,500 $ 500 $25,000 550 $27,500 $ 600 $30,000$ 650 $32,500$ 700 $35,000$ 750 $37,500 800 $ 40,000 $ Estimated profit 13,500 16,000 18,500 21,000 23,500 26,000 28,500 31,000 Total fees Total costs Estimated profit 32,500.00 $9,000.00 23,500.00 Two-Variable Data Table: Patient Fee and Surgery Cost 40 45 50 60 450 $10,800$ 500 12,800 $ 550 $ 14,800 $ 600 $16,800 650 $18,800 700 $ 20,800 750 22,800 $ 800 $24,800 $ 12,150 13,500 $14,850 16,200 14,400 16,000 $17,600 19,200 16,650 18,500 $20,350 22,200 18,900 21,000 $23,100 25,200 21,150 $ 23,50025,850 $ 28,200 23,400 26,000 $28,600 31,200 25,650 $ 28,50031,350 34,200 27,900 31,000$ 34,100 $ 37,200

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!