Question

1 Approved Answer

Posted on Sep 04, 2024

Compute the doctor's pay according to the following rules: Base Charge: Hours in the consultation multiplied by the doctor's hourly rate. Emergency Surcharge: For consultations

image text in transcribed

Compute the doctor's pay according to the following rules: Base Charge: Hours in the consultation multiplied by the doctor's hourly rate. Emergency Surcharge: For consultations that begin on or after 12 PM on Friday or any time either Saturday or Sunday, the Emergency Surcharge is $150. Add to Base Charge Vain Man Surcharge: For men older than 50 who have either Cosmetology or Cosmetic Surgery Consultations, the surcharge 20% of Base charge. Add to Base Charge Mid Day Discount: For consultations that start at 10 AM and up to (not including) 2 PM the surcharge is 10% of Base Charge. Subtract from Base Charge. Minimum Adj Charge: For all people 70 or older, the minimun adjusted pay is $60; for all other people the minimum adjusted pay is $100. Totals Consult Base Charge Emergency Vain Man Surcharge Surcharge Mid Day Discount Minimum Adjusted Adjusted Charge Charge Dr Last Dr First Name Name Dr Speciality Fletcher Alexandra Substance Abuse Cline Juan Brain Surgery Fletcher Alexandra Substance Abuse Chapas Jodi Cosmetic Surgery Chapas Jodi Cosmetology Fletcher Alexandra Aversion Therapy Chapas Jodi Cosmetic Surgery Fletcher Alexandra Aversion Therapy Lopez Jared Cosmetology Hadyka Thaisy Substance Abuse Shuemaker Barbara Phrenology Chapas Jodi Cosmetic Surgery Shuemaker Barbara Phrenology Hadyka Thaisy Substance Abuse Shuemaker Barbara Phrenology Shuemaker Barbara Phrenology Chapas Jodi Cosmetic Surgery Hadyka Thaisy Substance Abuse Cline Juan Brain Surgery Shuemaker Barbara Phrenology Shuemaker Barbara Phrenology Financial1 Financial2 Patient Patient Extended State Consult Dr Rate Gender Age Coverage Resident Date Time In Time Out Hours $75.00 F 92 Yes Yes 01-Oct-98 10:15 AM 12:15 PM $275.00 M 78 Yes Yes 01-Oct-98 1:00 PM 3:00 PM $75.00 F 78 Yes Yes 01-Oct-98 2:00 PM 5:00 PM $105.00 M 51 Yes Yes 01-Oct-98 8:45 AM 10:30 AM $105.00 M 50 No Yes 01-Oct-98 9:15 AM 10:45 AM $75.00 F 72 Yes Yes 01-Oct-98 12:00 PM 12:45 PM $105.00 M 90 No No 01-Oct-98 12:00 PM 12:30 PM $75.00 F 85 Yes Yes 01-Oct-98 12:30 PM 1:00 PM $45.00 M 37 No Yes 01-Oct-98 12:30 PM 2:45 PM $40.00 F 50 No Yes 01-Oct-98 1:00 AM 4:30 AM $75.00 M 101 No Yes 02-Oct-98 8:45 AM 9:00 AM $105.00 M 61 No Yes 02-Oct-98 9:30 AM 10:15 AM $75.00 M 50 No No 02-Oct-98 9:45 PM 11:15 PM $40.00 M 50 No No 02-Oct-98 10:15 AM 12:30 PM $75.00 M 37 No Yes 02-Oct-98 11:30 AM 1:00 PM $75.00 M 49 Yes Yes 02-Oct-98 11:30 AM 12:15 PM $105.00 M 52 Yes Yes 02-Oct-98 1:00 PM 4:00 PM $40.00 M 67 Yes No 02-Oct-98 1:30 PM 2:00 PM $275.00 M 50 No Yes 03-Oct-98 8:15 AM 9:15 AM $75.00 M 67 Yes No 03-Oct-98 8:15 AM 10:30 AM $75.00 F 44 Yes No 03-Oct-98 8:15 AM 9:00 AM GoalSeek1 GoalSeek2 GoalSeek3 SolverProblem1 SolverProblem2 SolverProblem Data Questions Rules + Compute the doctor's pay according to the following rules: Base Charge: Hours in the consultation multiplied by the doctor's hourly rate. Emergency Surcharge: For consultations that begin on or after 12 PM on Friday or any time either Saturday or Sunday, the Emergency Surcharge is $150. Add to Base Charge Vain Man Surcharge: For men older than 50 who have either Cosmetology or Cosmetic Surgery Consultations, the surcharge 20% of Base charge. Add to Base Charge Mid Day Discount: For consultations that start at 10 AM and up to (not including) 2 PM the surcharge is 10% of Base Charge. Subtract from Base Charge. Minimum Adj Charge: For all people 70 or older, the minimun adjusted pay is $60; for all other people the minimum adjusted pay is $100. Totals Consult Base Charge Emergency Vain Man Surcharge Surcharge Mid Day Discount Minimum Adjusted Adjusted Charge Charge Dr Last Dr First Name Name Dr Speciality Fletcher Alexandra Substance Abuse Cline Juan Brain Surgery Fletcher Alexandra Substance Abuse Chapas Jodi Cosmetic Surgery Chapas Jodi Cosmetology Fletcher Alexandra Aversion Therapy Chapas Jodi Cosmetic Surgery Fletcher Alexandra Aversion Therapy Lopez Jared Cosmetology Hadyka Thaisy Substance Abuse Shuemaker Barbara Phrenology Chapas Jodi Cosmetic Surgery Shuemaker Barbara Phrenology Hadyka Thaisy Substance Abuse Shuemaker Barbara Phrenology Shuemaker Barbara Phrenology Chapas Jodi Cosmetic Surgery Hadyka Thaisy Substance Abuse Cline Juan Brain Surgery Shuemaker Barbara Phrenology Shuemaker Barbara Phrenology Financial1 Financial2 Patient Patient Extended State Consult Dr Rate Gender Age Coverage Resident Date Time In Time Out Hours $75.00 F 92 Yes Yes 01-Oct-98 10:15 AM 12:15 PM $275.00 M 78 Yes Yes 01-Oct-98 1:00 PM 3:00 PM $75.00 F 78 Yes Yes 01-Oct-98 2:00 PM 5:00 PM $105.00 M 51 Yes Yes 01-Oct-98 8:45 AM 10:30 AM $105.00 M 50 No Yes 01-Oct-98 9:15 AM 10:45 AM $75.00 F 72 Yes Yes 01-Oct-98 12:00 PM 12:45 PM $105.00 M 90 No No 01-Oct-98 12:00 PM 12:30 PM $75.00 F 85 Yes Yes 01-Oct-98 12:30 PM 1:00 PM $45.00 M 37 No Yes 01-Oct-98 12:30 PM 2:45 PM $40.00 F 50 No Yes 01-Oct-98 1:00 AM 4:30 AM $75.00 M 101 No Yes 02-Oct-98 8:45 AM 9:00 AM $105.00 M 61 No Yes 02-Oct-98 9:30 AM 10:15 AM $75.00 M 50 No No 02-Oct-98 9:45 PM 11:15 PM $40.00 M 50 No No 02-Oct-98 10:15 AM 12:30 PM $75.00 M 37 No Yes 02-Oct-98 11:30 AM 1:00 PM $75.00 M 49 Yes Yes 02-Oct-98 11:30 AM 12:15 PM $105.00 M 52 Yes Yes 02-Oct-98 1:00 PM 4:00 PM $40.00 M 67 Yes No 02-Oct-98 1:30 PM 2:00 PM $275.00 M 50 No Yes 03-Oct-98 8:15 AM 9:15 AM $75.00 M 67 Yes No 03-Oct-98 8:15 AM 10:30 AM $75.00 F 44 Yes No 03-Oct-98 8:15 AM 9:00 AM GoalSeek1 GoalSeek2 GoalSeek3 SolverProblem1 SolverProblem2 SolverProblem Data Questions Rules +