Rosemonth Hill Health Center 

1 answer below »

Assignment:Prepare and submit two stepdown spreadsheets for this case to determine the cost per visit as follows:

Tutor: Healthcare Finance Experience

See attached

1.By allocating the cost of nursing, social services, laboratory, record-keeping, administration and rent, utilities and cleaning to the Pediatrics, Family Planning, Adult Medicine, Nursing, Mental Health, Social Services, Community Health, and Dental Services Department. To check your work for accuracy you should find that the cost per visit to Adult Medicine is a surprising $47.51 given its $11.00 fee

.

2.For this somewhat more realistic stepdown analysis, treat the laboratory and social service departments as separate cost centers. Here the social service department charges separately regardless of where it offers services while the laboratory charges on an hourly basis. To check your work for accuracy you should find that the cost per hour for the Laboratory is $8.77 (Well, it was 1975 after all!).Document Preview:

Assignment: Prepare and submit two stepdown spreadsheets for this case to determine the cost per visit as follows: By allocating the cost of nursing, social services, laboratory, record-keeping, administration and rent, utilities and cleaning to the Pediatrics, Family Planning, Adult Medicine, Nursing, Mental Health, Social Services, Community Health, and Dental Services Department. To check your work for accuracy you should find that the cost per visit to Adult Medicine is a surprising $47.51 given its $11.00 fee . For this somewhat more realistic stepdown analysis, treat the laboratory and social service departments as separate cost centers. Here the social service department charges separately regardless of where it offers services while the laboratory charges on an hourly basis. To check your work for accuracy you should find that the cost per hour for the Laboratory is $8.77 (Well, it was 1975 after all!). Use the following Exhibit to calculate the above: Separate in two spreadsheets: Exhibit 1 Financial Statements for 1975Balance SheetAs of December 31,1975AssetsLiabilities and Fund BalancesCash30,934Accounts Payable32,754Accounts Receivable8,800Accrued wages3,466Inventory40,540Total Current36,220Total Current80,274Bank Loan27,550Furniture & Equipment21,700Total Liabilities63,770Less: AccumulatedDepreciation8,788Fund Balances:Total fixed12,912Designated by board for25,000Special Outreach ProjectTotal Assets93,186Purchases of new equip.3,000Undesignated1,416Total Fund balances29,416Total Liabilities and FundBalances93,186Income Statement1975Revenue from patient fees345,450Other revenue5,000Total Revenue350,450ExpensesProgram services235,000Utilities10,000Laboratory25,000General and Administrative92,000Total Expenses362,000Surplus…