Dr. Jones has asked you to make the monthly Claim Status Summary report. He wishes you to include insurance company number, the patient number and name, procedure date, procedure code and description, the fee, the date the claim was filed, amount of the claim, amount of reimbursement, and amount remaining unpaid. He wishes you to group data by insurance company number, with subtotals by company and grand totals for each numeric field. When you create report, ensure to include mock-up report and report analysis form.