Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please do in Excel ECU Dental Clinics offers the following three basic dental services: Variable costs include the labor costs of the dental hygienists and
please do in Excel
ECU Dental Clinics offers the following three basic dental services: Variable costs include the labor costs of the dental hygienists and dentist. Fixed costs of $300,000 per year include building and equipment costs, marketing costs, and the cost of administration. ECU Dental is subject to a 30% tax rate on income. A cleaning "unit" is a routine teeth cleaning that takes about 45 minutes. A filling "unit" is the work done to fill one or more cavities in one session. A capping "unit" is the work done to put a crown on one tooth. If more than one tooth is crowned in a session, then the clinic counts each tooth as a unit (e.g., putting crowns on two teeth counts as two units). 1. Given this information, how much will ECU Dental earn each year after taxes? 2. Assuming the given sales mix is the same at what sales revenue does ECU Dental breakeven? 3. Assuming the given sales mix, at what sales revenue will ECU Dental earn $140,000 per year after taxes? 4. ECU Dental is considering becoming more specialized in cleanings and fillings. What would be the company's revenues per year if the number of cleanings increased to 12,000 per year and the number of fillings increased to 1,000 per year while the ramber of cappings dropped to zero. With this change in product mix, the company would increase its fixed costs to $400,000 per year. What would be the effect of this change in product mix on the clinic's earnings after taxes per year? If the clinic's managers seek to maximize the clinic's after tax earnings would this change be a good idea 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