Question

In: Accounting

Sharifi Hospital bases its budgets on patient-visits. The hospital's static budget for October appears below: Budgeted...

Sharifi Hospital bases its budgets on patient-visits. The hospital's static budget for October appears below:

Budgeted number of patient-visits 7,700
Budgeted variable overhead costs:
Supplies (@$4.90 per patient-visit) $ 37,730
Laundry (@$7.90 per patient-visit) 60,830
Total variable overhead cost 98,560
Budgeted fixed overhead costs:
Wages and salaries 52,150
Occupancy costs 85,350
Total fixed overhead cost 137,500
Total budgeted overhead cost $ 236,060

The total overhead cost at an activity level of 8,400 patient-visits per month should be:

_

-
_

_
-

The management of Furrow Corporation is considering dropping product L07E. Data from the company’s budget for the upcoming year appear below:

Sales $ 830,000
Variable expenses $ 365,000
Fixed manufacturing expenses $ 291,000
Fixed selling and administrative expenses $ 166,000

In the company's accounting system all fixed expenses of the company are fully allocated to products. Further investigation has revealed that $186,000 of the fixed manufacturing expenses and $106,000 of the fixed selling and administrative expenses are avoidable if product L07E is discontinued. The financial advantage (disadvantage) for the company of eliminating this product for the upcoming year would be:

-

-

-

-

-

The following labor standards have been established for a particular product:

Standard labor-hours per unit of output 8.7 hours
Standard labor rate $ 15.60 per hour

The following data pertain to operations concerning the product for the last month:

Actual hours worked 8,600 hours
Actual total labor cost $ 131,580
Actual output 850 units

What is the labor rate variance for the month?

Solutions

Expert Solution

1.

Activity level 8,400
Variable overhead cost:
Supplies (8,400*$4.90) $41,160
Laundry (8,400*$7.90) 66,360
Total 107,520
Fixed overhead cost:
Wages and salaries 52,150
Occupancy costs 85,350
Total 137,500
Total manufacturing overhead costs $245,020

The total overhead costs at an activity level of 8,400 is $245,020

2.

Current total Total if product LO7E is dropped Net effect
Sales $830,000 $0 -$830,000
Variable expenses 365,000 0 365,000
Contribution margin 465,000 0 -465,000
Fixed manufacturing expenses 291,000 105,000 186,000
Fixed selling and administrative expenses 166,000 60,000 106,000
Total $8,000 -$165,000 -$173,000

Hence if product LO7E is dropped company will have a financial disadvantage of $173,000

3.

Labor rate variance = (Actual rate - Standard rate) * Actual hours

Labor rate variance = ($131,580/8,600 - $15.60) * 8,600

Labor rate variance = ($15.3 - $15.60) * 8,600 = $2,580 Favorable


Related Solutions

Wytch Corporation bases its budgets on machine-hours. The company's static planning budget for February appears below:...
Wytch Corporation bases its budgets on machine-hours. The company's static planning budget for February appears below: Budgeted number of machine-hours 6,000 Budgeted variable costs:    Supplies (@ $6.90 per machine-hour) $ 41,400    Power (@ $3.70 per machine-hour) 22,200 Budgeted fixed costs:    Salaries 51,600    Equipment depreciation 26,400 Total expense $ 141,600 Required: Prepare a flexible budget for 6,400 machine-hours per month.
Filkins Clinic bases its budgets on the activity measure patient-visits. During February, the clinic planned for...
Filkins Clinic bases its budgets on the activity measure patient-visits. During February, the clinic planned for 5,300 patient-visits, but the actual level of activity was 5,500 patient-visits. The clinic has provided the following data concerning the formulas it uses in its budgeting: Fixed element per month Variable element per patient-visit   Revenue $ 33.50             Personnel expenses $ 32,800         $ 10.90             Medical Supplies $ 2,800         $ 6.90             Occupancy expenses $ 7,800         $ 2.90             Administrative expenses $ 6,800         $ 0.29          ...
Flexible budgets vs static budgets What is the difference between an flexible budget and a static...
Flexible budgets vs static budgets What is the difference between an flexible budget and a static budget? What is a flexible budget? (6 senteces or more)
Lilly Inc. bases its selling and administrative expense budget on budgeted unit sales. The sales budget...
Lilly Inc. bases its selling and administrative expense budget on budgeted unit sales. The sales budget shows 3,200 units are planned to be sold in December. The variable selling and administrative expense is $3.10 per unit. The budgeted fixed selling and administrative expense is $60,800 per month, which includes depreciation of $6,720 per month. The remainder of the fixed selling and administrative expense represents current cash flows.Calculate the budgeted cash disbursements for selling and administrative expenses for December. Give your...
Panda Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 4,300...
Panda Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 4,300 client-visits, but its actual level of activity was 4,290 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for October: Data used in budgeting: Fixed element per month Variable element per client-visit Revenue - $ 37.40 Personnel expenses $ 31,500 $ 12.40 Medical supplies 2,200 7.80 Occupancy expenses 9,600 3.90 Administrative expenses 7,900 0.40...
Askland Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 3,100...
Askland Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 3,100 client-visits, buts its actual level of activity was 3,130 client-visits.  The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for October: Data used in budgeting:                                                                                                 Fixed                            Variable                                                                                            amount per                         amount per                                                                                                 month                          client-visit Revenue ……………………………………………………                               -                                   $28.80 Personnel expenses ………………………………….                                $22,100                        $ 8.60 Medical supplies ……………………………………….                                   1,300                            5.50 Occupancy expenses………………………………..                                     6,300                            1.00 Administrative expenses ………………………….                                    3,500                              .40 Total expenses …………………………………………                                $33,200                        $15.50 Actual results for October: Revenue ………………………………………………….                                 $86,454                                                                                                    Total              Fixed Portion     Personnel...
Askland Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 3,100...
Askland Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 3,100 client-visits, buts its actual level of activity was 3,130 client-visits.  The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for October: Data used in budgeting:                                                                                                 Fixed                            Variable                                                                                            amount per                         amount per                                                                                                 month                          client-visit Revenue ……………………………………………………                               -                                   $28.80 Personnel expenses ………………………………….                                $22,100                        $ 8.60 Medical supplies ……………………………………….                                   1,300                            5.50 Occupancy expenses………………………………..                                     6,300                            1.00 Administrative expenses ………………………….                                    3,500                              .40 Total expenses …………………………………………                                $33,200                        $15.50 Actual results for October: Revenue ………………………………………………….                                 $86,454                                                                                                    Total              Fixed Portion     Personnel...
Askland Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 3,100...
Askland Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 3,100 client-visits, buts its actual level of activity was 3,130 client-visits.  The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for October: Data used in budgeting:                                                                                                 Fixed                            Variable                                                                                            amount per                         amount per                                                                                                 month                          client-visit Revenue ……………………………………………………                               -                                   $28.80 Personnel expenses ………………………………….                                $22,100                        $ 8.60 Medical supplies ……………………………………….                                   1,300                            5.50 Occupancy expenses………………………………..                                     6,300                            1.00 Administrative expenses ………………………….                                    3,500                              .40 Total expenses …………………………………………                                $33,200                        $15.50 Actual results for October: Revenue ………………………………………………….                                 $86,454                                                                                                    Total              Fixed Portion     Personnel...
HammerTime is preparing their 2019 budget. They want to look at static budgets and flexible budgets...
HammerTime is preparing their 2019 budget. They want to look at static budgets and flexible budgets to determine which is best for them. They estimate sales/production will be between 2,000,000 and 4,000,000 boxes of nails per month. They want to be able to understand their budget variances as well. Question 1: Prepare some budgets in Excel for HammerTime. a) Show the static budget based on 3,000,000 units (boxes) produced. b) Show the flexible budget based on 2,000,000 units (boxes) produced....
Kaylar Clinic uses patient-visits as its measure of activity. During September, the clinic budgeted for 3,000...
Kaylar Clinic uses patient-visits as its measure of activity. During September, the clinic budgeted for 3,000 patient-visits, but its actual level of activity was 2,900 patient-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for September: Data used in budgeting:                                                  Fixed Element per Month Variable Element per Month Revenue …………………….. $0 $37.20 Personal Expenses…………. $27600 $11.30 Medical Expenses………….. $1500 $6.80 Occupancy Expenses…….... $6200 $1.70 Administrative Expenses…... $3600 $0.30 Actual results...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT