Help with healthcare finance homework?

profileAnn29T
hcad_dropbox_2.xlsx

Sheet1

Service Variable Cost per Service Annual Direct Fixed Cost Annual Number of Variable
Basic examination $5 $50,000 3,000
Advanced examination $7 30,000 1,500
Therapy Session $10 40,000 500
A.      What is the fee schedule for these services, assuming that the goal is to cover only the variable and fixed cost?
assume that the audiology dept is allocated 100,000 in total overhead by the clinic, and the dept director has allocated 50,000 of this amount to the three services listed above. What is the fee schedule assuming that the overhead cost must be covered?
C. Assume that these services must make a combined profit of 25,000. Now what is the fee schedule?

Sheet2

Most common test one-price package test A test B test C
disposable syringe $3.00 $3.00 $3.00
Blood vial $0.50 $0.50 $0.50
Forms $0.15 $0.15 $0.15
Reagents $0.80 $0.60 $1.20
Sterile Bandage $0.10 $0.10 $0.10
Breakage/losses $0.05 $0.05 $0.05
A.      As a starting point, what is the price of the combined test assuming marginal cost pricing?
A.      Assume that Allied wants a contribution margin of $ per test. What price must be set to achieve this goal?
A.      Allied estimated that, of the combined test will be conducted during the first year. The annual allocation of direct fixed and overhead cost totals, $40, 000. What prices must be set to cover full cost? What price must be set to produce a profit of $20,000 on the combined test?