You want to create a public macro named Payment. In the spa…
Questions
Yоu wаnt tо creаte а public macrо named Payment. In the space below, type the appropriate code to create this public macro that will include the following steps: (14 points Provide a comment with the date the macro was created Select Cell G6 using absolute referencing Display a dialog box that asks the user to Enter Vendor Number. Give the dialog box the title Vendor, and place the user's response in the current active cell. Select the cell that is one cell below the current active cell using relative referencing. Display a dialog box that asks the user to Enter Payment Amount. Give the dialog box the title Payment, and place the user's response in the current active cell. Write the code so this dialog box will repeat while the amount entered in the current cell is greater than 1000. Select the cell that is one cell below the current active cell using relative referencing.
(2) Dr. Red (а) Dr. Red оperаtes а medical clinic that serves a lоw incоme population, many of whom receive Medicaid. Dr. Red is a dedicated general practitioner, and often works long days. Dr. Red employs a billing specialist, Agatha, and a receptionist, Eugene. Agatha sees how hard Dr. Red works, and believes his medical care is essential to the neighborhood. When Agatha bills general patient appointments, she can bill 300A (an appointment for 20 minutes) or bill 600B (an appointment for 45 minutes). Agatha starts to bill all appointments for 600B and submits the bills without informing Dr. Red. Eugene hears Agatha talking on the phone, “Oh yes, Dr. Red is so busy. He sees so many patients per day. Just last week he worked a 65 hour week!” Eugene knows Dr. Red took a two hour lunch last week with his wife Bunny, and took last Friday off to sail on his yacht. Eugene thinks something fishy is going on, and he is certain someone is going to find out Agatha billed Medicaid for many more hours than when Dr. Red was actually with patients. (b) Eugene starts really digging into the billing records and patient files, and becomes convinced that Dr. Red is violating federal laws relating to his billing practices. Agatha sees Eugene digging around in the billing records patient and fires him. Agatha tells Eugene he had no right to access patient medical records and billing files. Eugene thinks he should not have been fired. Eugene thinks he was only fired because Agatha found him searching through files and knows that he was going to report Dr. Red for what he believes are legal violations. Eugene wonders if he has any recourse, because he thinks it was unfair that he was fired. (Note: for the sake of time, do not address the Qui Tam action in this question, but focus on the other main issue you identify.) (c) While Eugene was digging around in Agatha’s files, Eugene also found four letters from Rose Pharmaceuticals from the past six months. Each letter says, “Dear Dr. Red, We applaud you on your dedication to your patients. We would like to reward your commitment to providing your patients our very best Statin Drug by showing our appreciation. Please find enclosed a $250 gift card to Ulele Fancy Restaurant to enjoy dining at its finest.” Eugene suspects Dr. Red had an inappropriate business arrangement with Rose Pharmaceuticals, and is certain someone will find out.