Exercise 4-1 (Part Level Submission) Wilkins Inc. has two types of handbags: standard and custom. The controller has decided to use a plantwide overhead rate based on direct labor costs. The president has heard of activity-based costing and wants to s

profileFin-Acc-Boss
 (Not rated)
 (Not rated)
Chat

Exercise 4-1 (Part Level Submission)

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Wilkins Inc. has two types of handbags: standard and custom. The controller has decided to use a plantwide overhead rate based on direct labor costs. The president has heard of activity-based costing and wants to see how the results would differ if this system were used. Two activity cost pools were developed: machining and machine setup. Presented below is information related to the company’s operations.

  

Standard

 

Custom

Direct labor costs

 

$40,800

 

$111,000

Machine hours

 

1,230

 

1,340

Setup hours

 

100

 

380


Total estimated overhead costs are $304,000. Overhead cost allocated to the machining activity cost pool is $197,700, and $106,300 is allocated to the machine setup activity cost pool.

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

(a)

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Compute the overhead rate using the traditional (plantwide) approach. (Round answers to 2 decimal places, e.g. 12.25%.)

Predetermined overhead rate

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 % of direct labor cost

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

(b)

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Compute the overhead rates using the activity-based costing approach. (Round answers to 2 decimal places, e.g. $12.25.)

Machining

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 per machine hour

Machine setup

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 per setup hour

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

(c)

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Determine the difference in allocation between the two approaches. (Round answers to 0 decimal places, e.g. $1,225.)

Traditional costing

  

Standard

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

Custom

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

  

Activity-based costing

  

Standard

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

Custom

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Exercise 4-2 (Part Level Submission)

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Ayala Inc. has conducted the following analysis related to its product lines, using a traditional costing system (volume-based) and an activity-based costing system. Both the traditional and the activity-based costing systems include direct materials and direct labor costs.

    

Total Costs

Products

 

Sales Revenue

 

Traditional

 

ABC

Product 540X

 

$208,800

 

$56,940

 

$46,460

Product 137Y

 

163,300

 

53,560

 

40,360

Product 249S

 

93,790

 

15,450

 

39,130

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

(a)

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

For each product line, compute operating income using the traditional costing system.

Product 540X

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

Product 137Y

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

Product 249S

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

(b)

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

For each product line, compute operating income using the activity-based costing system.

Product 540X

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

Product 137Y

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

Product 249S

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

(c)

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Using the following formula, compute the percentage difference in operating income for each of the product lines of Ayala: [Operating Income (ABC) – Operating Income (traditional cost)] ÷ Operating Income (traditional cost). (Round answers to 2 decimal places, e.g. 12.25%. If difference is negative enter with either a - sign or in parenthesis, e.g. -12.25% or (12.25))

Product 540X

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 %

Product 137Y

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 %

Product 249S

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 %

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Exercise 4-3 (Part Level Submission)

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

American Fabrics has budgeted overhead costs of $1,077,120. It has allocated overhead on a plantwide basis to its two products (wool and cotton) using direct labor hours which are estimated to be 489,600 for the current year. The company has decided to experiment with activity-based costing and has created two activity cost pools and related activity cost drivers. These two cost pools are: cutting (cost driver is machine hours) and design (cost driver is number of setups). Overhead allocated to the cutting cost pool is $391,680 and $685,440 is allocated to the design cost pool. Additional information related to these pools is as follows.

  

Wool

 

Cotton

 

Total

Machine hours

 

108,800

 

108,800

 

217,600

Number of setups

 

1,088

 

544

 

1,632

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

(a)

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Calculate the overhead rate using activity based costing and then calculate if the traditional approach were used. (Round answers to 2 decimal places, e.g. $12.25.)

Overhead rates for activity-based costing

   

Cutting

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 per machine hour

Design

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 per setup

 

   

Overhead rates using the traditional approach

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 per direct labor hour

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

(b)

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

(1) Determine the amount of overhead allocated to the wool product line and the cotton product line using activity-based costing.

  

Wool product line

Cotton product line

Overhead Allocated

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]


(2) What amount of overhead would be allocated to the wool and cotton product lines using the traditional approach, assuming direct labor hours were incurred evenly between the wool and cotton?

  

Wool product line

 

Cotton product line

Overhead Allocated

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Exercise 4-5 (Part Level Submission)

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Shady Lady sells window coverings (shades, blinds, and awnings) to both commercial and residential customers. The following information relates to its budgeted operations for the current year.

    

Commercial

   

Residential

Revenues

   

$298,600

   

$477,500

 

Direct material costs

 

$29,000

   

$50,500

   

Direct labor costs

 

114,000

   

298,000

   

Overhead costs

 

81,800

 

224,800

 

149,200

 

497,700

 

Operating income (loss)

   

$73,800

   

($20,200

)


The controller, Peggy Kingman, is concerned about the residential product line. She cannot understand why this line is not more profitable given that the installations of window coverings are less complex for residential customers. In addition, the residential client base resides in close proximity to the company office, so travel costs are not as expensive on a per client visit for residential customers. As a result, she has decided to take a closer look at the overhead costs assigned to the two product lines to determine whether a more accurate product costing model can be developed. Here are the three activity cost pools and related information she developed:

Activity Cost Pools

 

Estimated Overhead

 

Cost Drivers

Scheduling and travel

 

$106,800

 

Hours of travel

Setup time

 

74,760

 

Number of setups

Supervision

 

49,440

 

Direct labor cost

 

Expected Use of Cost Drivers per Product

  

Commercial

 

Residential

Scheduling and travel

 

1,070

 

535

Setup time

 

420

 

300

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

(a)

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Compute the activity-based overhead rates for each of the three cost pools. (Round the supervision overhead rate to 2 decimal places, e.g. 12% and all other answers to 2 decimal places, e.g. $12.25.)

  

Overhead Rate

 

Scheduling and travel

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

Setup time

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

Supervision

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

%

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

(b)

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Determine the overhead cost assigned to each product line. (Round Overhead Rate to 2 decimal places, 15.25 and final answers to 0 decimal places, e.g. $2,512.)

  

Commercial

 

Residential

Scheduling and travel

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

Setup time

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

Supervision

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

Total assigned costs

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

(c)

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

Compute the operating income for each product line, using the activity-based overhead rates. (Round answers to 0 decimal places, e.g. $2,512.)

  

Commercial

 

Residential

Operating income

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

$http://edugen.wileyplus.com/edugen/art2/common/pixel.gif[removed]

 

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

http://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 
 

 

    • 9 years ago
    Exercise 4-1 (Part Level Submission) Wilkins Inc. has two types of handbags: standard and custom. The controller has decided to use a plantwide overhead rate based on direct labor costs. The president has heard of activity-based costing and wants to s
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      fine.docx