Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Submit your Excel spreadsheet to the View/Complete link below Sales Mix Decision Dr. Massy, who specializes in internal medicine, wants to analyze his sales mix

Submit your Excel spreadsheet to the View/Complete link belowimage text in transcribed

Sales Mix Decision Dr. Massy, who specializes in internal medicine, wants to analyze his sales mix to find out how the time of his physician assistant, Consuela Ortiz, can be used to generate the highest operating income. Ortiz sees patients in Dr. Massy's office, consults with patients over the telephone, and conducts one daily weight-loss support group attended by up to 50 patients. Statistics for the three services are as follows: Maximum number of patient billings per day Hours per billing Billing rate Variable costs Office Visits Phone Calls 20 40 Weight-Loss Support Group 50 .25 $50 $25 .10 $25 $12 1.0 $10 $5 Ortiz works seven hours a day. Required 1. Determine the best sales mix. Rank the services offered in order of their profitability. 2. Based on the ranking in I, how much time should Ortiz spend on each service in a day? (Hint: Remember to consider the maximum number of patient billings per day.) What would be the daily total contribution margin generated by Ortiz? 3. Dr. Massy believes the ranking is incorrect. He knows that the daily 60-minute meeting of the weightloss support group has 50 patients and should continue to be offered. If the new ranking for the services is (1) weight-loss support group, (2) phone calls, and (3) office visits, how much time should Ortiz spend on each service in a day? What would be the total contribution margin generated by Ortiz, assuming the weight-loss support group has the maximum number of patient billings? 4. Manager Insight: Which ranking would you recommend? What additional amount of total contribution margin would be generated if your recommendation is accepted

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

Managerial Accounting

Authors: James Jiambalvo

7th Edition

1119577721, 978-1119577720

More Books

Students also viewed these Accounting questions

Question

1. What does this mean for me?

Answered: 1 week ago