Question: Week 9-3 Assignment - Accounts Receivable Report Started: Jun 2 at 12:30pm Quiz Instructions PURPOSE: This assignment provides practice in understanding and calculating statistics for

Week 9-3 Assignment - Accounts Receivable Report Started: Jun 2 at 12:30pmQuiz Instructions

PURPOSE: This assignment provides practice in understanding and calculating statistics for healthcare operations such as an accounts receivable report. Accounts receivable reporting is part of a healthcare organization's financial management processes.

TASKS:

Click "Take the Quiz" to get started.
Print out assignment and do problems on paper first, then come back and add your answers and work to this assignment in Canvas.
Review the example exercise before completing this assignment. You may also want to review how to calculate a percent changeLinks to an external site. or how to round decimalsLinks to an external site..
The last question will ask you to upload a screenshot of your notes page showing your work for each problem.
Note: You must submit your work to get credit for this assignment.

Question 11 pts

Use the table below to answer the following questions.

Patient	Date of Service	Current	30 Days	60 Days	90 Days or Over	Account Total
Black, Tom	5/10/xx	349.00				349.00
Blue, Sky	4/5/xx		1780.90			1780.90
Brown, Sue	1/13/xx				650.45	650.45
Brunette, Kim	2/8/xx				1326.93	1326.93
Barrett, April	1/5/xx				50.00	50.00
Bennet, Lyn	3/17/xx			2840.66		2840.66
Bin, Adagio	4/12/xx		725.00			725.00
Bonnet, Red	2/14/xx				400.00	878.90
Bromett, Carl	1/26/xx				110.00	110.00
Buckley, Ed	5/4/xx	911.11				911.11
Total:		$1,260.11	$2,505.90	$2,840.66	$2,537.38	$9,144.05

Based on the dates of service, which month is considered thirty days aged?

Flag question: Question 2Question 21 pts

Which month is considered sixty days aged?

Flag question: Question 3Question 31 pts

Which months are considered ninety days aged and over?

Flag question: Question 4Question 41 pts

How many accounts are considered ninety days and over?

Flag question: Question 5Question 51 pts

How many accounts will the collector need to review if an account sort of 90 days or over is used?

Flag question: Question 6Question 61 pts

What percentage of the total are accounts sixty days aged?

Include the % in your response.

Flag question: Question 7Question 71 pts

What percentage of the total are accounts ninety days and over aged?

Flag question: Question 8Question 81 pts

If the total gross charges for the practice for the last three months is $30,000; what should the outstanding A/R be for this practice?

Provide the range as outlined in the lecture.

Flag question: Question 9Question 91 pts

The total gross charges for the practice for the last three months are $30,000.

What is the current A/R ratio? (use monthly average charges to calculate)

Round to one decimal place and include a leading zero.

Flag question: Question 10Question 101 pts

Use the table below to answer the following questions.

Financial Class	Patient	Date of Service	Charge	Payment	Adjustment	Balance
01 - Medicare	Reed, Tom	5/2/xx	489.23	360.00	69.50	59.73
	Smith, Kevin	3/24/xx	1489.78	1289.40	122.00	78.38
	Archer, Ed	1/14/xx	196.58			196.58
	Fanta, Peg	12/31/xx	875.56	640.00		235.56
	Vince, Noelle	11/27/xx	1289.00	1200.00	89.00	0.00
Subtotal			$4, 340.15	$3,489.40	$280.50	$570.25

02-Medicaid	Marvin, Sue	11/20/xx	523.40	340.21	183.19	123.18
	Kent, Jean	1/5/xx	566.50	368.23		75.10
Subtotal			$1,089.90	$708.44	$183.19	$198.28

03 - CHAMPUS	Jaspar, Jen	8/15/xx	878.90	818.90	25.00	35.00
	Munillo, Jack	7/20/xx	1356.50			1356.50
Subtotal			$2,235.40	$818.90	$25.00	$1,391.50

Grand Total			$7,665.45	$5,016.74	$488.69	$2,160.03

What percentage of all Medicare was paid?