Question

Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget...

Activity-Based Flexible Budgeting

Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity:

  • Four welding units, with a lease cost of $14,000 per year per unit
  • Six welding employees each paid a salary of $45,000 per year (A total of 12,000 welding hours are supplied by the six workers.)
  • Welding supplies: $400 per job
  • Welding hours: 4 hours used per job

During the year, the activity operated at 80 percent of capacity and incurred the following actual activity and resource costs.

  • Lease cost: $56,000
  • Salaries: $283,500
  • Parts and supplies: $955,500

Required:

1. Prepare a flexible budget formula for the welding activity using welding hours as the driver.

Welding cost = $ + $ X


Hide

2. Prepare a performance report for the welding activity. In the last column of Foy Company Activity-Based Performance Report, if variance amount is unfavorable enter "U" , enter "F", if it is Favorable and enter "NA" if there is no variance.

   

Foy Company

Activity-Based Performance Report

Activity

Actual Cost

Budgeted Cost (80% level)

Budget Variance

Variance

Welding:

   

   

   

   

Fixed cost

$  

$  

$  

  

Variable cost

  

  

  

  

3. What if welders were hired through outsourcing and paid $30 per hour (the welding equipment is provided by Foy)? Repeat Requirement 1 for the outsourcing case.

Welding cost = $ + $ X

Homework Answers

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
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: • Four welding units, with a lease cost of $12,000 per year per unit • Six welding employees each paid a salary of $52,000 per year (A total of 9,000 welding hours are supplied by the six workers.) • Welding supplies: $300 per job • Welding hours: 3 hours used per job...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: Four welding units, with a lease cost of $14,000 per year per unit Six welding employees each paid a salary of $55,000 per year (A total of 12,000 welding hours are supplied by the six workers.) Welding supplies: $400 per job Welding hours: 4 hours used per job During the year, the...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per unit produced: Direct materials $7.20 Direct labor 1.54 Variable overhead:   Supplies 0.23   Maintenance 0.19   Power 0.18 Budgeted fixed overhead costs per month include supervision of $98,000, depreciation of $76,000, and other overhead of $245,000. In March, Nashler Company produced 160,000 units and had the following actual costs: Direct materials $1,148,000 Direct labor 252,900 Supplies 37,300 Maintenance 30,340 Power 28,730 Supervision 99,400 Depreciation 76,000 Other...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per unit produced: Direct materials $7.20 Direct labor 1.54 Variable overhead:   Supplies 0.23   Maintenance 0.19   Power 0.18 Budgeted fixed overhead costs per month include supervision of $98,000, depreciation of $76,000, and other overhead of $245,000. In March, Nashler Company produced 170,000 units and had the following actual costs: Direct materials $1,220,000 Direct labor 268,300 Supplies 39,600 Maintenance 32,240 Power 30,520 Supervision 99,500 Depreciation 76,000 Other...
Ray Company provided the following excerpts from its Production Department’s flexible budget performance report. Required: Complete...
Ray Company provided the following excerpts from its Production Department’s flexible budget performance report. Required: Complete the Production Department’s Flexible Budget Performance Report. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values. Round "rate per hour" answers to 2 decimal places.) Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Results Spending Variances Flexible Budget...
Ray Company provided the following excerpts from its Production Department’s flexible budget performance report. (Round "rate...
Ray Company provided the following excerpts from its Production Department’s flexible budget performance report. (Round "rate per hour" answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Required: Complete the Production Department’s Flexible Budget Performance Report. Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Results Spending Variances Flexible Budget...
Flexible Budget In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a...
Flexible Budget In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 300,000 units of the standard model and 120,000 units of the deluxe model during the coming year. The standard model requires 0.05 direct labor hour per unit, and the deluxe model requires 0.08. The controller has developed the following cost formulas...
Birkner Corporation's flexible budget performance report for last month shows that actual indirect materials cost, a...
Birkner Corporation's flexible budget performance report for last month shows that actual indirect materials cost, a variable cost, was $30,444 and that the spending variance for indirect materials cost was $8,142 favorable. During that month, the company worked 17,700 machine-hours. Budgeted activity for the month had been 18,200 machine-hours. The cost formula per machine-hour for indirect materials cost must have been closest to: Kerekes Manufacturing Corporation has prepared the following overhead budget for next month. Activity level 2,400 machine-hours Variable...
Ray Company provided the following excerpts from its Production Department’s flexible budget performance report. (Round "rate...
Ray Company provided the following excerpts from its Production Department’s flexible budget performance report. (Round "rate per hour" answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Results Spending Variances Flexible Budget Activity Variances Planning Budget Labor-hours (q) 9,570 9,090 Direct...
Ray Company provided the following excerpts from its Production Department’s flexible budget performance report. (Round "rate...
Ray Company provided the following excerpts from its Production Department’s flexible budget performance report. (Round "rate per hour" answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Results Spending Variances Flexible Budget Activity Variances Planning Budget Labor-hours (q) 9,600 9,120 Direct...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT