Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Securities Trader Qualification Examination Series 57 Study Guide

Authors: Philip Martin Mccaulay

1st Edition

979-8363665240

More Books

Students also viewed these Finance questions

Question

Which months of this year 5 Mondays ?

Answered: 1 week ago

Question

Define Leap year?

Answered: 1 week ago

Question

Prepare a short profile of Lucy Clifford ?

Answered: 1 week ago

Question

Prepare a short profile of Rosa parks?

Answered: 1 week ago