Question

Estimate the flexible budget Calculate the revenue variance, volume variance, price variance Calculate the profit variance,...

  1. Estimate the flexible budget
  2. Calculate the revenue variance, volume variance, price variance
  3. Calculate the profit variance, revenue variance and cost variance
  4. Explain what results show with respect to the profit and revenue variances

Static

Actual

Patient Visits

1,000

900

Net Patient Revenue

$10,000

$9,100

Variable Costs

$6,000

$5,580

Contribution Margin

$4,000

$3,520

Fixed Costs

$3,000

$2,900

Operating Income

$1,000

$620

Homework Answers

Answer #1

Computation of flexible budget :

Budgeted Actual Variance
Patient visit 900 900
Net patient revenue 9000 9100 100 (favourable)
Variable cost 5400 5580 180(unfavorable)
Contribution margin 3600 3520 80(unfavorable)
Fixed cost 3000 2900 100(favourable)
Operating income 600 620 20(favourable)

Revenue variance:

Actual revenue - static budget revenue

9100 - 10000

900 ( unfavorable)

Volume variance:

standard price ( actual quantity - standard quantity)

10(900 - 1000)

1000 ( unfavorable)

Price variance:

Actual quantity ( actual price - standard price)

900 ( 10.11 - 10 )

100 (favourable)

profit variance:

Actual profit - budgeted profit

620 - 600

20 ( favourable)

Cost variance:

standard cost - actual cost

8400 - 8480

80 ( unfavorable)

If you are benefited from the solution then please like,if disliked then please specify the reason in the comments.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
. Calculate Revenue Variances. Use variance analysis to calculate the price variance for each DRG, volume...
. Calculate Revenue Variances. Use variance analysis to calculate the price variance for each DRG, volume variance for each DRG and the budget revenue variance between the planned budgeted gross revenue and the net revenue (actual reimbursement received for services). Create a spreadsheet that shows each calculation and a summary that explains your results. Assume that the following information is known about the budget for Anywhere Hospital: Planned budget: Budgeted patient volume:           500 Budgeted patient mix:               DRG 1                                    50%      DRG 2                                    30%      DRG...
ames Manufacturing had the following information available for July: Actual Results Flexible Budget Variance Flexible Budget...
ames Manufacturing had the following information available for July: Actual Results Flexible Budget Variance Flexible Budget Sales Activity Variance Master Budget Units 12,000 ? 3,000 U ? Sales revenue ? $ 16,800 F ? ? ? Less: Variable manufacturing costs $ 88,500 $ 92,000 ? $ 111,000 Variable marketing and administrative ? $ 5,500 U ? $ 6,200 F $ 33,000 Contribution margin $ 52,000 ? ? $ 6,300 U ? What was James’s master budget contribution margin?
True Or False 1- Fixed costs should not be included in a flexible budget because they...
True Or False 1- Fixed costs should not be included in a flexible budget because they do not change when the level of activity changes. (       ) 2-To help assess how well a manager has controlled costs, actual costs should be compared to what the costs should have been for the actual level of activity. (       ) 3-The activity variance for revenue is favorable if the actual revenue for the period exceeds the revenue in the static planning budget. (      ...
You are given the following static budget report: Budget            Actual              Variance Unit Sales  &nbsp
You are given the following static budget report: Budget            Actual              Variance Unit Sales                                           10,000               15,000             5,000 F Variable Expenses:     Commissions                                  $30,000 $33,000 $3,000 U     Advertising                                      $1,000 $1,200 $200 U     Travel                                              $10,000 $11,000 $1,000 U     Samples                                          $2,500 $2,300 $200 F Total Variable                                     $43,500 47,500 $4,000 U Fixed Expenses     Rent                                                 $5,000 $5,000 0     Salaries – Sales                               $2,000 $2,000 0     Salaries – Office                              $1,200 $1,200 0     Depreciation                                    $1,500 $1,500 0 Total Fixed                                          $9,700 $9,700             0 Total Expenses $53,200 $57,200 $4,000 U Prepare a flexible budget analysis and explain whether you believe that costs were controlled.  How do the results of...
Actual Results Flexible Budget Variance Flexible Budget Sales Activity Variance Master Budget Units 13,000 ? 2000U...
Actual Results Flexible Budget Variance Flexible Budget Sales Activity Variance Master Budget Units 13,000 ? 2000U ? Sales revenue ? 13,000F ? ? ? Less: <Variable mfg. Costs> $87,750 $91,000 ? $105,000 <Variable mktg/adm.costs> ? $3,250U ? $4,000F 30,000 Contribution margin $52,000 ? ? $6,000U ? What is the master budget contribution margin? Select one: A. $52,000. B. $45,000. C. $47,500. D. $39,000.
A clinic uses patient-visits as its measure of activity. During July, the clinic budgeted for 2,700...
A clinic uses patient-visits as its measure of activity. During July, the clinic budgeted for 2,700 patient-visits, but its actual level of activity was 3,200 patient-visits. The clinic uses the following revenue and cost formulas in its budgeting, where q is the number of patient-visits: Revenue: $49.60q Personnel expenses: $31,200 + $15.10q Medical supplies: $700 + $9.60q Occupancy expenses: $10,000 + $2.00q Administrative expenses: $7,000 + $0.20q The clinic reported the following actual results for July: Revenue $165,680 Personnel expenses...
1. Prepare a flexible budget performance report for JulyJuly. 2. What was the effect on New...
1. Prepare a flexible budget performance report for JulyJuly. 2. What was the effect on New BostonNew Boston​'s operating income of selling 2 comma 0002,000 units more than the static budget level of​ sales? 3. What is New BostonNew Boston​'s static budget variance for operating​ income? 4. Explain why the flexible budget performance report provides more useful information to New BostonNew Boston​'s managers than the simple static budget variance. What insights can New BostonNew Boston​'s managers draw from this performance​...
1) A budget prepared at a single volume of activity is referred to as a: A)...
1) A budget prepared at a single volume of activity is referred to as a: A) Strategic budget. B) Standard budget. C) Static budget. D) Flexible budget. Answer:  ___________ 2) Select the incorrect statement regarding flexible budgets. A) Flexible budgets often show the estimated revenues and costs at multiple volume levels. B) A flexible budget is used to compare actual to budgeted amounts. C) A flexible budget is also known as a master budget. D) Standard prices and costs are used...
Following is the static budget and actual results of Yoga Inc. for the month of April...
Following is the static budget and actual results of Yoga Inc. for the month of April 20X4. The management is pleased with the income higher than budgeted. However they understand that significant increase in units sold renders the comparison of actual results and the static budget unfair. Required: You are required to prepare a flexible budget at actual level of output and calculate flexible budget variances. Actual Static Units 40,000 30,000 Revenue 236,000 180,000 Variable Costs: Material 76,000 60,000 Labor...
planning budget actual results variance patient visits 2600 2700 revenue 52.90 q 137540 145190 7650 F...
planning budget actual results variance patient visits 2600 2700 revenue 52.90 q 137540 145190 7650 F expense personnel expense (35,100+17.40q) 80340 79710 730 F medical supplies (1,000+ 6.40q) 17740 18660 920 U occupancy expenses (9,700+2.30q) 15780 16680 1000 U administrative expenses (5,200 + .30q) 5980 5880 100 F total expense 119840 120830 1090 U net operating income 17800 24360 6560 F Complete a flexible budget performance report for Janice Inc. Label each variance as favorable (F) or unfavorable (U). What...