Answered step by step
Verified Expert Solution
Question
1 Approved Answer
what does it mean present the total cost owed to each plan? i need report 2 and report 3 Instructions costs Employee Records Create and
what does it mean present the total cost owed to each plan? i need report 2 and report 3
Instructions costs Employee Records Create and Upload Three Reports all reports must specify your name, the due date of the report and HR65. Remember, your grade is based on content and professional appearance. Report --Sen Gescending As part of your job, you are occasionally required to reconcile insurance billing with your records. Using the information in the "costs" worksheet, assign medical and dental costs to each employee by entering the appropriate amount in the designated column in the "Employee Records" worksheet. Report 2: Sort the database in "Employee Records" by Medical plan and present the total cost owed to each plan. Sort the database in "Employee Records" by Dental plan and present the total cost owed to each plan. Report 3: > > 33 3 3 3 3 Salary Health H/Costs Dental D/Costs 43250 BlueCr Delta 52500 Kaiser DMO 59250 BlueCr Delta 27000 Kaiser DMO 27000 BlueCr Delta 27000 Kaiser DMO 35000 Kaiser DMO 41000 BlueCr Delta 82000 Kaiser Delta 72000 BlueCr Delta 29500 Kaiser Delta 59000 BlueCr Delta 31500 Kaiser DMO 32000 Kaiser DMO 62000 BlueCr DMO 54700 Kaiser Delta 40000 BlueCr Delta 36000 BlueCr DMO 89000 BlueCr Delta 95500 Kaiser DMO Legal Instructions costs Employee Records Create and Upload Three Reports all reports must specify your name, the due date of the report and HR65. Remember, your grade is based on content and professional appearance. Report --Sen Gescending As part of your job, you are occasionally required to reconcile insurance billing with your records. Using the information in the "costs" worksheet, assign medical and dental costs to each employee by entering the appropriate amount in the designated column in the "Employee Records" worksheet. Report 2: Sort the database in "Employee Records" by Medical plan and present the total cost owed to each plan. Sort the database in "Employee Records" by Dental plan and present the total cost owed to each plan. Report 3: > > 33 3 3 3 3 Salary Health H/Costs Dental D/Costs 43250 BlueCr Delta 52500 Kaiser DMO 59250 BlueCr Delta 27000 Kaiser DMO 27000 BlueCr Delta 27000 Kaiser DMO 35000 Kaiser DMO 41000 BlueCr Delta 82000 Kaiser Delta 72000 BlueCr Delta 29500 Kaiser Delta 59000 BlueCr Delta 31500 Kaiser DMO 32000 Kaiser DMO 62000 BlueCr DMO 54700 Kaiser Delta 40000 BlueCr Delta 36000 BlueCr DMO 89000 BlueCr Delta 95500 Kaiser DMO Legal 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