Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started