Reference no: EM132918094

Question - Using the information above, create the simple budget for the clinic in Microsoft Excel. Note that the budget should be based on annual amounts.

At the end of the first year of operations, the following was observed:

There were 215 patient visits per month for Medicare patients.

There were 140 patient visits per month for self-pay patients.

The average charge (reimbursement) per visit was $70 for Medicare patients.

The average charge (reimbursement) per visit was $90 for self-pay patients.

Salaries and wages were $165,000 for the year.

Rent was $2,800 per month.

Supplies costs were $20 per patient visit regardless of payer.