Question

In: Accounting

The Spurling Brigade Company produces custom widgets for its customers. The company uses an activity-based costing...

  1. The Spurling Brigade Company produces custom widgets for its customers. The company uses an activity-based costing system for its overhead costs. The company has provided the following data from its activity-based costing system.


    Activity Cost Pool         Total Cost       Total Activity

       Assembling……….....          $101,574        16,200 machine hours

       Job Support…………               32,724            1,800 jobs

       Customer support…...                 5,472 320 clients

       Other……………….              100,000 Not applicable                                        

    Total………………. $239,770
      
    The "Other" activity cost pool consists of costs of idle capacity & organization-sustaining costs. One particular customer, Vandal Inc., requested 32 jobs during the year for a total of 100 units, requiring a total of 192 machine hours. Each unit requires $0.40 in direct materials and $1.60 in direct labor. The customer was charged $2,200 for these jobs.
    Round off all calculations to the nearest whole cent.

  2. A. Using ABC, compute the activity rate for the Assembling dept.

B. Using the same information for #10, compute the activity rate for Job Support.

C. Using the information for #10, compute the activity rate for Customer support.

D. Compute the total overhead cost charged to Vandal. Round to 2 decimal places.

E. Now compute the customer (gross) margin for Vandal Inc. rounding to 2 decimal places. Give as positive or negative number.

F. What is the (product) cost for Spurling to produce one unit for Vandal under ABC? Round to 2 decimal places. Give as positive number.

G. If Spurling used traditional costing instead of ABC and allocates based on machine hours, what would be the customer margin for Vandal Inc.? Give as positive or negative number. Round to 2 decimal places

Solutions

Expert Solution

Activity Cost Pool Total Cost Total Activity Activity Rate
a Assembling 101,574 16200 $              6.27
b Job Support 32,724 1800 $           18.18
c Customer support 5,472 320 $           17.10
100 Units
Direct Material $                40.00
Direct Labour $              160.00
Assembling $          1,203.84
Job Support $              581.76
Customer support $                17.10
(D) Total Overhead Cost $          2,002.70
Price charged to customer $          2,200.00
(E)Gross Margin $              197.30

Related Solutions

Bronco Company uses normal costing in its​ job-costing system. The company produces custom bikes for toddlers....
Bronco Company uses normal costing in its​ job-costing system. The company produces custom bikes for toddlers. The beginning balances​ (December 1) and ending balances​ (as of December​ 30) in their inventory accounts are as​ follows: Beginning Balance 12/1 Ending Balance 12/30 Material Control $ 1,500 $ 7,900 Work-in-process control 6,100 8,400 Manufacturing Department Overhead Control -- 97,500 Finished Goods Control 3,800 18,800 Additional information​ follows: a. Direct materials purchased during December were $65,700. b. Cost of goods manufactured for December...
Bramble Company uses normal costing in its​ job-costing system. The company produces custom bikes for toddlers....
Bramble Company uses normal costing in its​ job-costing system. The company produces custom bikes for toddlers. The beginning balances​ (December 1) and ending balances​ (as of December​ 30) in their inventory accounts are as​ follows: Beginning Balance 12/1 Ending Balance 12/30 Material Control $ 1,800 $ 8,200 Work-in-process control 6,400 8,700 Manufacturing Department Overhead Control -- 92,500 Finished Goods Control 4,100 19,100 Additional information​ follows: a. Direct materials purchased during December were $66,000. b. Cost of goods manufactured for December...
A company uses activity-based costing to determine the costs of its three products: A, B, and...
A company uses activity-based costing to determine the costs of its three products: A, B, and C. The budgeted cost and activity for each of the company's three activity cost pools are shown in the following table: Budgeted Activity Activity Cost Pool Budgeted Cost Product A Product B Product C Activity 1 $ 85,000 7,500 10,500 21,500 Activity 2 $ 60,000 8,500 16,500 9,500 Activity 3 $ 112,000 4,000 2,500 3,125 How much overhead will be assigned to Product B...
A company uses activity-based costing to determine the costs of its three products: A, B, and...
A company uses activity-based costing to determine the costs of its three products: A, B, and C. The budgeted cost and activity for each of the company's three activity cost pools are shown in the following table: A company uses activity-based costing to determine the costs of its three products: A, B, and C. The budgeted cost and activity for each of the company's three activity cost pools are shown in the following table: Budgeted Activity Activity Cost Pool Budgeted...
A company uses activity-based costing to determine the costs of its three products: A, B, and...
A company uses activity-based costing to determine the costs of its three products: A, B, and C. The budgeted cost and activity for each of the company's three activity cost pools are shown in the following table: Budgeted Activity Activity Cost Pool Budgeted Cost Product A Product B Product C Activity 1 $ 75,000 6,500 9,500 20,500 Activity 2 $ 50,000 7,500 15,500 8,500 Activity 3 $ 92,000 3,000 1,500 2,125 How much overhead will be assigned to Product B...
Job Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing...
Job Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Heitger identified three overhead activities and related drivers. Budgeted information for the year is as follows: Activity Cost Driver Amount of Driver Materials handling $101,200 Number of moves 4,000 Engineering 142,400 Number of change orders 8,000 Other overhead 358,800 Direct labor hours 52,000 Heitger worked on four jobs in July. Data are as follows: Job 13-43 Job 13-44 Job...
Job Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing...
Job Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Heitger identified three overhead activities and related drivers. Budgeted information for the year is as follows: Activity Cost Driver Amount of Driver Materials handling $54,250 Number of moves 2,500 Engineering 120,700 Number of change orders 8,500 Other overhead 148,500 Direct labor hours 45,000 Heitger worked on four jobs in July. Data are as follows: Job 13-43 Job 13-44 Job...
Plaid Manufacturing Co. produces two products: G1 and M1. The company uses an activity based costing...
Plaid Manufacturing Co. produces two products: G1 and M1. The company uses an activity based costing system. The following are the activities, budgeted total cost and cost drivers per activity for the year 20x9: Activity Budgeted Cost Cost Base Cost Base Volume Assembly $861050 # of DL hours 36332 Inspection $669581 # of units 20525 Plaid Manufacturing has budgeted to produce 3,000 units of G1. G1 requires 17790 hours of direct labour. What is the overhead cost per unit for...
SCS Co. uses activity-based costing in their manufacturing process. The company produces two products, ABC and...
SCS Co. uses activity-based costing in their manufacturing process. The company produces two products, ABC and XYZ. SCS has provided their costing department the following information from this year’s budget relating to the production of these two products: ABC XYZ Units to be produced 4,000 6,000 Machine-hours expected 100 200 Direct labor-hours expected 200 300 Materials handling (number of moves) 60 70 Machine setups (number of setups) 20 15 The following costs are expected to be incurred throughout the year,...
1.) A company uses activity-based costing to determine the costs of its three products: A, B,...
1.) A company uses activity-based costing to determine the costs of its three products: A, B, and C. The budgeted cost and activity for each of the company's three activity cost pools are shown in the following table: Budgeted Activity Activity Cost Pool Budgeted Cost Product A Product B Product C Activity 1 $ 81,000 7,100 10,100 21,100 Activity 2 $ 56,000 8,100 16,100 9,100 Activity 3 $ 104,000 3,600 2,100 2,725 How much overhead will be assigned to Product...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT