In: Finance
Using the same graph (in BOLD) for all question please answer and show work for the following
Review the walk-in data presented below. Taxes are assumed to be 30%.
Revenues (10,000 visits) 500,000 $
Wages and benefits 210,000 $
Rent 5,000 $
Depreciation 32,000 $
Utilities 2,500 $
Medical supplies 50,000 $
Administrative supplies 20,000
1. Construct a projected P&L statements at volume levels of
10,000 units. What would be the total fixed costs for a volume of
10,000 units?   
Choice: $189,000
Choice: $249,500
Choice: $257,500
Choice: $275,500
2.Construct a projected P&L statements at volume levels of
11,000 units. What is the taxable income for a volume of 11,000
units?   
Choice: $180,500
Choice: $100,000
Choice: $116,500
Choice: $223,500
3. Construct a projected P&L statements at volume levels of
12,000 units. What is the profit for a volume of 12,000
units?
Choice: $105,350
Choice: $135,000
Choice: $186,550
Choice: $211,800
(1)-The total fixed costs for a volume of 10,000 units
| 
 Amount ($)  | 
 Amount ($)  | 
|
| 
 Revenue (10,000 Visits x $50 per visit)  | 
 500,000  | 
|
| 
 Variable Costs  | 
||
| 
 Medical Supplies  | 
 50,000  | 
|
| 
 Administrative Supplies  | 
 20,000  | 
 70,000  | 
| 
 Fixed Costs  | 
||
| 
 Wages and Benefits  | 
 210,000  | 
|
| 
 Rent  | 
 5,000  | 
|
| 
 Depreciation  | 
 32,000  | 
|
| 
 Utilities  | 
 2,500  | 
 249,500  | 
| 
 Taxable Income  | 
 180,500  | 
|
| 
 Less: Tax at 30%  | 
 54,150  | 
|
| 
 Net Income  | 
 126,350  | 
|
Therefore, the The total fixed costs for a volume of 10,000 units = $249,500
(2)- The taxable income for a volume of 11,000 units
Selling Price per visits = $50 per visit [$500,000 / 10,000]
Variable cost per visit = $7.00 per visit [$70,000 / 10,000]
| 
 Amount ($)  | 
 Amount ($)  | 
|
| 
 Revenue (11,000 Visits x $50 per visit)  | 
 550,000  | 
|
| 
 Less: Variable cost [11,000 x $7]  | 
 77,000  | 
|
| 
 Less: Fixed Costs  | 
 249,500  | 
|
| 
 Taxable Income  | 
 223,500  | 
|
“Therefore, The taxable income for a volume of 11,000 units = $223,500”
(3)- The profit for a volume of 12,000 units
| 
 Amount ($)  | 
 Amount ($)  | 
|
| 
 Revenue (12,000 Visits x $50 per visit)  | 
 600,000  | 
|
| 
 Less: Variable cost [12,000 x $7]  | 
 84,000  | 
|
| 
 Less: Fixed Costs  | 
 249,500  | 
|
| 
 Taxable Income  | 
 266,500  | 
|
| 
 Less: Tax at 30%  | 
 79,950  | 
|
| 
 Net Profit  | 
 186,550  | 
|
“The profit for a volume of 12,000 units = $186,550”