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 $15,000 per year per unit • Six welding employees each paid a salary of $58,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 95 percent of capacity and incurred the following actual activity and resource costs. • Lease cost: $60,000 • Salaries: $365,400 • Parts and supplies: $1,134,200 Required: 1. Prepare a flexible budget formula for the welding activity using welding hours as the driver. Welding cost  =  $fill in the blank e95687f99006fa4_1  +  $fill in the blank e95687f99006fa4_2 X 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 select "U" , select "F", if it is Favorable and select "NA" if there is no variance.   Foy Company Activity-Based Performance Report Activity Actual Cost Budgeted Cost (95% level) Budget Variance Variance Welding:         Fixed cost $fill in the blank a4aea3fd4fda032_1 $fill in the blank a4aea3fd4fda032_2 $fill in the blank a4aea3fd4fda032_3   Variable cost fill in the blank a4aea3fd4fda032_5 fill in the blank a4aea3fd4fda032_6 fill in the blank a4aea3fd4fda032_7   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  =  $fill in the blank 914756009074fc7_1  +  $fill in the blank 914756009074fc7_2 X

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

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 $15,000 per year per unit

• Six welding employees each paid a salary of $58,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 95 percent of capacity and incurred the following actual activity and resource costs.

• Lease cost: $60,000

• Salaries: $365,400

• Parts and supplies: $1,134,200

Required:

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

Welding cost  =  $fill in the blank e95687f99006fa4_1  +  $fill in the blank e95687f99006fa4_2 X

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 select "U" , select "F", if it is Favorable and select "NA" if there is no variance.

 
Foy Company
Activity-Based Performance Report
Activity Actual Cost Budgeted Cost (95% level) Budget Variance Variance
Welding:        
Fixed cost $fill in the blank a4aea3fd4fda032_1 $fill in the blank a4aea3fd4fda032_2 $fill in the blank a4aea3fd4fda032_3  
Variable cost fill in the blank a4aea3fd4fda032_5 fill in the blank a4aea3fd4fda032_6 fill in the blank a4aea3fd4fda032_7  

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  =  $fill in the blank 914756009074fc7_1  +  $fill in the blank 914756009074fc7_2 X
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Industry analysis: Project management in construction industry
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education