Budgeting & Finance- Healthcare. Please provide formula(s) as work needs to be t
ID: 2784474 • Letter: B
Question
Budgeting & Finance- Healthcare. Please provide formula(s) as work needs to be transferred to excel.
Cost Behavior: Problem 6
1. The following information has been provided by the Pharmacy for the third quarter of the year:
Revenue
$1,300,000
Fixed cost
140,000
Variable cost
480,000
Fixed administrative expenses
120,000
Variable administrative expenses
80,000
Fixed selling expenses
60,000
Variable selling expense
150,000
Required:
What is the pharmacy’s contribution margin for the quarter? Use Excel or Sheets to show your work.
Revenue
$1,300,000
Fixed cost
140,000
Variable cost
480,000
Fixed administrative expenses
120,000
Variable administrative expenses
80,000
Fixed selling expenses
60,000
Variable selling expense
150,000
Explanation / Answer
Particulars Amt Revenue 1,300,000.00 Less: Variable cost 480,000.00 Less: Variable administrative expenses 80,000.00 Less: Variable selling expense 150,000.00 Contribution margin 590,000.00
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.