Question: i need to know every step and function to insert into the exel sheet Love Your Smile Dental is a walk-in and appointment dental services
Love Your Smile Dental is a walk-in and appointment dental services company that operates as a partnership for a group of six dentists, The dentists share a common reception desk, scheduler, waiting area, and bookkeeper. Each dentist is assigned to three rooms for dental work, and they have their own dental assistant and office. Currently, the company operates in a single facility in the town of Sweetsbury. But, due to the friendly nature of the dentists and staft, and the high quality work the dentist's perform, Love Your Smile Dental has outgrowu the current facility. They would like to open a second facility to the north of Sweetsbury that will be close to many of their current northern patients as possible. In addition, they are hoping to attract new patients, since four new dentists will be joining the group. They are currently considering an area close to three towns that have a large number of existing patients and substantial populations as well. The objective of the facility location decision is to centrally locate the new facility for current patients and the existing populations. The following table gives the uumber of current patients and the population of each town, and the location coordinates where CX denotes the Xcoordinate and CY denotes the Y-coordinate for each of the three towns. a). Using the center of gravity method determine the best location for the dental facility based on the number of current patients
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
