Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

World Class Internal Audit Tales From My Journey

Authors: Norman Marks

1st Edition

1500791962, 978-1500791964

More Books

Students also viewed these Accounting questions

Question

1. Which position would you take?

Answered: 1 week ago