Academic Writing

Closed Posted May 6, 2014 Paid on delivery
Closed Paid on delivery

Statistics - Decision Support Tools Assignment

QUESTION 3 Simulation 20 marks

Dr Catscan is an ophthalmologist who, in addition to prescribing glasses and contact lenses, performs laser surgery to correct myopia. This laser surgery is fairly easy and inexpensive to perform.

To inform the public about this procedure Dr Catscan advertises in the local paper and holds information sessions in her office one night a week at which she shows a videotape about the procedure and answers any questions potential patients might have.

The room where these meetings are held can seat 10 people, and reservations are required. The number of people attending each session varies from week to week. Dr Catscan cancels the meeting if 2 or fewer people have made reservations.

Using data from the previous year Dr Catscan determined that reservations follow this pattern:

Number of reservations 0 1 2 3 4 5 6 7 8 9 10

Probability 0.02 0.05 0.08 0.16 0.26 0.18 0.11 0.07 0.05 0.01 0.01

Using the data from last year Dr Catscan determined that 25% of the people who attended information sessions elected to have the surgery performed. Of those who do not, most cite the cost of the procedure ($2,000 per eye, $4,000 in total as almost everyone has both eyes done) as their major concern. The surgery is regarded as cosmetic so that the cost is not covered by Medicare or private hospital insurance funds.

Dr Catscan has now hired you as a consultant to analyse her financial returns from this surgery. In particular, she would like answers to the following questions, which you are going to answer by building an Excel model to simulate 20 weeks of the practice. Random numbers must be generated in Excel and used with the VLOOKUP command to determine the number of reservations,0 and there must be no data in the model itself. The same set of random numbers should be used for all three parts. An IF statement is required for part (a) to determine attendance each week, given cancellation of meetings.

(a) 10 marks

On average, how much revenue does Dr Catscan’s practice in laser surgery earn each week? If your simulation shows a fractional number of people electing surgery use such fractional values in determining revenue. Paste your model results into Word including a copy of formulas with row and column headings.

(b) 3 marks

Adjust your model to determine on average, how much revenue would be generated each week if Dr Catscan did not cancel sessions with 2 or fewer reservations? Paste results into Word.

(c) 3 marks

Dr Catscan believes that 35% of people attending the information sessions would have the surgery if she reduced the price to $1,500 per eye or $3,000 in total. Under this scenario how much revenue per week could Dr Catscan expect from laser surgery? Modify your Excel model to answer this and paste results into Word.

(d) 4 marks

Write a brief report with your recommendations to Dr Catscan on the most appropriate strategy.

Accounting Research Writing Statistics Technical Writing

Project ID: #5905704

About the project

13 proposals Remote project Active Jun 12, 2014

13 freelancers are bidding on average $128 for this job

pavi87june

A proposal has not yet been provided

$210 USD in 4 days
(299 Reviews)
7.2
JonnaNueros121

I am a professional full time academic research writer fully proficient in HARVARD, APA, MLA, Chicago and Oxford writing styles. I am competent in writing dissertations, thesis, reports, case studies, personal developm More

$150 USD in 3 days
(212 Reviews)
6.8
Sadya

Hey, If you want your assignment to be original, creative, and unique then I can assure you the high quality work enriched with creativity. My research skills are highly commendable and writing is my passion. I am very More

$168 USD in 4 days
(70 Reviews)
6.1
KomalA1

Hi, I have thoroughly read through your project description and would love to assist you with this project. I am a conscientious, honest and hard worker and I have years of experience in the writing field completed. I More

$30 USD in 1 day
(38 Reviews)
6.0
samin59

Experienced and accomplished academic writer at your service. Please contact for quality and result oriented services. Regards

$200 USD in 5 days
(94 Reviews)
6.0
coolwriter30

I am a competent academic writer, with high lead times and turnaround time, proposal writer, masters level dissertation writer, PHD level dissertation and thesis writer, PHD defense PowerPoint presentation writer, argu More

$150 USD in 3 days
(74 Reviews)
5.8
kmittal

This is a relatively smaller problem than the ones recently executed. I need a day or two. I will prefer to deliver the scans of answer since for a minor project making latex report is not worth the time.

$120 USD in 2 days
(31 Reviews)
5.8
caabdul

Greetings! Consider the job done with perfection. Thank you

$100 USD in 2 days
(33 Reviews)
5.2
camurtuza5552

Dear sir, Being a Chartered Accountant I can do this assignment related to decision making perfectly. I can use tool like Excel Add-in for Organizational management and POM - QM for windows for completing your assig More

$166 USD in 2 days
(22 Reviews)
5.2
crispwriter

A proposal has not yet been provided

$148 USD in 3 days
(26 Reviews)
5.0
OwnersPride1

I'm 100% sure I can serve my best capabilities to complete your target and work opportunities...... So, I can just say that; "I am honest for achieving your work requirements and everything wants’ trust !!! Make trus More

$157 USD in 3 days
(20 Reviews)
4.8
drevak

****************************** Consider it done...done professionally! *****************************

$130 USD in 3 days
(15 Reviews)
4.3
mathstatconsulti

We have a member of 4 Statistician and 1 Economist who are spearheading analytic solution development in Retail, CPG, Banking, insurance & Life science domain through marketing science research and econometric modellin More

$100 USD in 2 days
(5 Reviews)
3.2
bkbee3

Hi, I am new here but not new into writing. I am a professional academic writer and have worked at various platforms before. I can assure you A+ work on time. My work will be flawless in all the aspects and I am more t More

$30 USD in 1 day
(0 Reviews)
0.0
ericpereira25

Hi, The Solution can be provided IMMEDIATELY as i have the solution for the given problem, all worked out and ready. The final version can be sent immediately when the bid is approved. Solutions have been worked More

$30 USD in 0 days
(0 Reviews)
0.0