Cornerstone Exercise 12.4 (Algorithmic)

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 $51,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 90 percent of capacity and incurred the following actual activity and resource costs.

  • Lease cost: $56,000
  • Salaries: $321,300
  • Parts and supplies: $1,074,900

Required:

1. Please prepare flexible budget formula for the welding activity using welding hours as the driver.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"