Question
please use excel to solve this question: Dr. Molar is trying make $4,000 per day profit in her dental practice, working an 8-hour day. She
please use excel to solve this question:
Dr. Molar is trying make $4,000 per day profit in her dental practice, working an 8-hour day. She needs to schedule 3x as many exams per day as treatment appointments to keep the patient flow. Exams are billed at $145 take 20 minutes of her time and 20 minutes of her assistant's time. Treatment appointments are billed at $725 take 40 minutes of her time and 60 minutes of her assistant's time. Assume that all the billed amounts are collected. The assistant makes $30/hr. Exams use $10 in materials. Treatment appointments have lab expenses of $50 and use $20 in materials. Build a model to help Dr. Molar reach her profit goals.
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