Question: 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
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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!