please show working for #4&5

question 4&5

from the internet can contain Viruses. Unless you need to edit, it's safer to stay in Protected View Seard Clinic Enable Editing 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 Patient-visits 2,000 2.400 Revenue ($58.100) $116,200 $142080 Expense: Personnel expenses ($30,400-$17.40) 65,200 74,250 Medical supplies ($1,300 $9.600) 20,500 24,670 Occupancy expense ($9,000+$1900) 12,800 14,020 Administrative expenses (56,200+80.300) 6.800 6,860 Total expense 105,300 119,800 Net operating income $10.900 $22280 Prepare the clinic's flexible budget performance report for December. Label each variance as favorable (F) or unfavorable (U). Seard Clinic For the Month Ended December 31 Activity Flexible Revenue and Variances Budget Spending Varances Planning Budget 2,000 $116,200 Actual Results Variances 2,400 $142,080 Patient-visits Revenue (558.100) Expense: Personnel expenses ($30,400+$17.409) Medical supplies ($1,300-$9.600) Occupancy expense 65,200 74,250 20,500 24,670 12.800 14.020 Enable Editing w the Internet can contain viruses. Unless you need to edit, it's safe to stay in Protected View WURD Occupancy expense (59,000-$1.90) 12,800 Administrative expenses (56,200+$0.300) 6,800 Total expense 105,300 Net operating income $10.900 14,020 6,860 119,800 $22.280 TripleDouble Ins 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 $299,800 COGS $286,500 101.480 Salaries and Wages Office Expenses 99,680 80,100 58,960 101,360 82,400 59,850 78,421 61,300 Search o Ri e ant Focus la Team Exercise 3 (Chapter 10) - Protected ViewSaved to this PC- File Home Insert 0 PROTECTED VIEW Be care Design Layout References Mailings Review View Help -les from the Internet can contain vies. 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 Plan Budget Flexible Budget Actual Results Reven $296,500 $299,800 $286,500 COGS 99.680 Salaries and Wapes 80,100 101.480 78.421 58.960 101,360 82,400 59,850 49.210 $6,980 Office Expenses Other Expenses Net Operating Income 61,300 49,000 44,185 $8,760 1. How much is the Spending Variance for COGS? Is it favorable or unfavorable? Awwer $120 L) 2. How much is the Revenue Spending Varance 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: 5890 2 of 255 words Type here to search Droot- can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing 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: 5890 4. How much is the Spending Variance for Other Expenses? Is it favorable or unfavorable? (Answer $5,025 F) 5. How much is the Activity Variance for Salaries and Wages? Is it favorable or unfavorable? (Answer $2,300 U) DFocus Search o B e B * 9 thin Seard Clinic 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 Patient-visits 2,000 2,400 Revenue ($58.100) $116,200 $142,080 Expense: Personnel expenses ($30,400+$17.40) 65,200 74,250 Medical supplies ($1,300+$9.600) 20.500 24,670 Occupancy expense ($9,000+$1.909) 12,800 14,020 Administrative expenses ($6,200+50.300) 6.800 6.860 Total expense s 105.300 119,800 Net operating income $10.900 $22.280 Prepare the clinic's flexible budget performance report for December. Label cach variance as favorable (F) or unfavorable (U) Seard Clinic For the Month Ended December 31 Revenue and Activity Flexible Spending Variances Budget Variances Actual Results Variances Planning Budget 2,000 $116,200 2,400 $142,080 Patient-visits Revenue (558.100) Expense: Personnel expenses ($30,400+$17.409) Medical supplies ($1,300-59.600) 74,250 65,200 20,500 24,670 en contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Administrative expenses ($6,200 $0.30q) Total expense Net operating income 6.800 105,300 $10.900 6,860 119.800 $22.280 Prepare the clinic's flexible budget performance report for December. Label each variance as favorable (F) or unfavorable (U). Seard Clinic For the Month Ended December 31 Revenue and Activity Flexible Spending Variances Budget Variances Actual Results Variances Planning Budget 2,000 $116,200 2,400 $142,080 65,200 74,250 20,500 24,670 Patient-visits Revenue ($58.100) Expense: Personnel expenses ($30,400+$17.400) Medical supplies ($1,300+$9.609) Occupancy expense ($9,000+$1.909) Administrative expenses (56,200+50.300) Total expense Net operating income 12,800 14,020 6,800 105,300 6,860 119,800 $22.280 $10.900 TripleDouble, Inc The following information is related to TripleDouble, Inc.'s budgets and actual performance for the last period. Actual Results Planning Budget Flexible Budget Revenue $296,500 $286,500 101,480 78,421 COGS Salaries and Wages Office Expenses Other Expenses Net Operating Income 99,680 80,100 58,960 49,000 $8,760 $299,800 101,360 82,400 59,850 49,210 $6,980 61,300 44,185 $1,114 Layout References Mailings Review View Help om the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing 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: 5890 U) 4. How much is the Spending Variance for Other Expenses? Is it favorable or unfavorable? (Answer: $5,025 F) 5. How much is the Activity Variance for Salaries and Wages? Is it favorable or unfavorable? (Answer: $2,300 U)