CBA, a bicycle manufacturer, uses an activity based costing system for budgeting. CBA has identified four cost centers and their associated cost-drivers. The variable and fixed costs for each activity are listed below, along with cost-driver activity.
Cost Driver Activity
18,000 machine hours 6,000 units
Setup ￼ $12,000
$16,000 12 setups
$10,000 3,000 assembly line hours
￼￼￼CBA has developed a flexible budget for each activity based on the following activity. We assume that the manufacturer sells each unit of its product for $65.
10 12 14 2,500 3,000 3,500
Number of Setups Assembly Line Hours
(Sales in Units) 5,000
18,000 21,000 Machine Hours
6,000 7,000 Units
(1) Develop flexible budget formula for each of the activities.
(2) Calculate the budgeted total cost for all the activity level in each of the activity centers.
(3) Determine the total costs and operating incomes for the manufacturer under each of the
(4) Given the actual results in the following table, prepare a cost control performance report
comparing the flexible budget to actual results for each activity, including flexible-budget variances. Similarly prepare an overall performance report for operating income.
(Sales in Dollars) Processing Administration
Actual Activity Level
$420,00 19,000 6,500
(Sales in Units)
Flexible budget formula for each activity
Setup = 16,000 + 1,000 (i.e. 12,000/12) * per setup
Processing = 20,000 + 8.89 (i.e. 160,000 /18,000) * per machine hour
Assembly = 10,000 + 26.67 (i.e. 80,000/3,000) * per assembly line hour
Administration = 20,000 + 0.27 (i.e. 1,600/6,000) * per unit
Activity Level = 5,000
Setup = 16,000 + 1,000 * 10 = 26,000
Processing = 20,000 + 8.89 * 15,000 = 153,350
Assembly = 10,000 + 26.67 * 2,500 = 76,675
Administration = 20,000 + 0.27 * 5,000 = 21,350
Total Cost = 26,000 + 153,350 + 76,675 + 21,350 = 277,375
Activity Level = 6,000
Setup = ...
A solution to an activity based costing accounting question. Comparing actual results with flexible budget.
Activity-Based Budgeting & Flexible Budgeting
See the attached file.
a. The following information pertains to CJ Corporation:
Twenty percent of purchases are paid for in cash in the month of purchase, and the balance is paid the following month. A 2 percent discount is allowed on cash paid out at the time of purchase.
Cash is collected from customers in the following manner:
i) Prepare a summary of cash collections for the 4th quarter.
ii) Prepare a summary of cash disbursements for the 4th quarter.
b. Wetland Bhd uses a standard cost system employing the following standards for direct materials and direct labour.
Direct material: 4 gallons per can @ RM4 per gallon
Direct labour: 1 hour per can @ RM30 per hour
The following actual cost information was compiled for a job J81.
Direct material: 22,000 gallons purchased and used @ RM4.40 per gallon
Direct labour: 6,400 hours @ RM28 per hour
Production: 12,000 cans
i) Calculate the material price variance.
ii) Calculate the material usage variance.
iii) Calculate the labour rate variance.
iv) Calculate the labour efficiency variance.
c. Explain the possible reasons for the variances calculated in (b) (i) to (iv) above.View Full Posting Details