please show working
Seard Clinic uses patient.visits as its measure of activity. The clinic has provided the following report Seard Clinic For the Month Ended December 31 Planning Budget Actual Results Patent-visits 2,000 2.400 Revenue ($58.100) S116,200 $142,080 Expense Personnel expenses (530400+$17.400) 65,200 74,250 Medical supplies ($1,300+9600) 20,500 24,670 Occupancy expense ($9,000-$1.904) 12,800 14,020 Administrative expenses (56,200-50.300) 0.800 6,860 Total expense 105,100 119,800 Net operating income $10.900 $22.280 Prepare the clinic's flexible budget performance report for December Label each variance as favorable unfavorable (U) or planning Seard Clinic For the Month Ended December 31 Activity Flexible Revenue and Variances Budget Spending Varances Variances Budget 2,000 $116.200 Actual Results 2.400 $142,080 Patient-visits Revenue ($58.100) Expense: Personnel expenses ($30,400+$17.40) Medical supplies (51,300+$9.609) Occupancy expense 65,200 74,250 20.500 24,670 295 words Focus D Michael Athin Erlediting Vanances Vans Team Exercise (Chapter 10) . Protected View - Seved to this PC ch e Home insert Design Layout References Mailings Review View Help PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, 's sale to stay in Protected View Planning Acu F leule Badet Variances Belt Patient-visits 2,000 Revenue (558.100) $116,200 Expense Personnel expenses (530.400+$1740) 65,200 Medical supplies ($1,300 $9.600) 20,500 Occupancy expense (59,000 $1.909) 12,800 Administrative expenses (56.200+$0.300) 6.800 Total expense 105,300 Net operating income $10.909 Acta Results 2.400 $102,080 74,250 24,670 14,020 6,860 119.800 $22.289 Maling Review View Help Be carefullies from the Internet can contain viruses. Unless you need to edit it's sales to stay in Protected View TripleDouble, Inc Enable Editing The following information is related to TripleDouble, Inc.'s budgets and actual performance for the last period Planning Budget Flexible Actual Results Budget Revenue $296,500 COGS $299,800 101,360 $286,500 101,480 Salaries and Wages Office Expenses Other Expenses Net Operating Income 99,680 80,100 58.960 49,000 $8,760 82,400 59,850 49,210 $6,980 78,421 61,300 44,185 $1,114 1. How much is the Spending Variance for COGS? Is it favorable or unfavorable? (Answer: $120 ) 2. How much is the Revenue Spending Variance for Revenue? Is it favorable or unfavorable? (Answer. $13,300 U) 3. How much is the Activity Variance for Office Expenses? Is it favorable or unfavorable? (Answer: $890 D.Focus Saved to this PC- Design Layout References Mailings Review View Help les from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Michael Athin & Share Enable Editing Seard Clinic uses patient-visits as its measure of activity. The clinic has provided the following report Actual Results 2.400 $142,080 Seard Clinic For the Month Ended December 31 Planning Budget Patient-visits 2,000 Revenue ($58.100) $116,200 Expense: Personnel expenses ($30,400+$17.40) 65,200 Medical supplies ($1,300+39.60) 20,500 Occupancy expense ($9,000+$1.909) 12,800 Administrative expenses (56,200+50.300) 6.800 Total expense 105,300 Net operating income $10.900 74,250 24,670 14,020 6,860 119.800 $22.280 Prepare the clinic's flexible budget performance report for December Label each variance as favorable () or unfavorable (U). Seard Clinic For the Month Ended December 31 Activity Flexible Revenue and Variances Budget Spending Variances Actual Results Planning Budget 2,000 $116,200 Variances 2,400 $142,080 Patient-visits Revenue ($58.10) Expense: Personnel expenses ($30,400+$17.40) Medical supplies ($1,300+$9.609) Occupancy expense ($9,000-$1.900) 65,200 74,250 20,500 24,670 12,800 14,020 TW Review View Help Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing 12,800 14,020 Occupancy expense ($9,000+$1909) Administrative expenses ($6,200+$0 300) Total expense Net operating income 6,800 105,300 $10.900 6,860 119.800 $22.280 Triple Double Inc The following information is related to TripleDouble, Inc.'s budgets and actual performance for the last period Planning Budget Flexible Budget Actual Results Revenue $296,500 $299,800 COGS Salaries and Wages Office Expenses 99,680 80,100 58,960 101,360 82,400 59,850 $286,500 101,480 78,421 61,300 Focus Team Exercise 3 (Chapter 10) - Protected View - Saved to this PC - Michael Arhin 1 Design Layout References Mailings Review View Help careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing The following information is related to TripleDouble, Inc.'s budgets and actual performance for the last period Planning Budget Flexible Budget Actual Results Revenue $296,500 $299,800 101,360 $286,500 101,480 78,421 80,100 COGS Salaries and Wages Office Expenses Other Expenses Net Operating Income 61,300 49,000 82,400 59,850 49,210 $6,980 $8,760 44,185 $1,114 1. How much is the Spending Variance for COGS? Is it favorable or unfavorable? (Answer: 5120 U) 2. How much is the Revenue Spending Variance for Revenue? Is it favorable or unfavorable? (Answer $13,300 U) 3. How much is the Activity Variance for Office Expenses? Is it favorable or unfavorable? Answer: 8890 U)
