Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Glenda Johnson was hired as a summer intern to conduct an activity-based costing study in the inventory control department of a medium-sized manufacturing company located

Glenda Johnson was hired as a summer intern to conduct an activity-based costing study in the inventory control department of a medium-sized manufacturing company located in Brandon, Manitoba. As a starting point, she decided to interview James Goodwin, the manager of the department, regarding the activities that are carried out in the department. Excerpts from the interview follow. Johnson: How many people work for you? Goodwin: Twelve. Johnson: What do they do? Goodwin: Six of them spend most of their time handling incoming shipments of purchased parts. They handle everything from documentation to transferring the parts to the work-in-progress (WIP) stockroom. Three others work in raw materials. After the material clears inspection, they move it into inventory and take care of the paperwork. Johnson: What determines the time required to process an incoming shipment? Does it matter if the individual components are small or large? Goodwin: Not for components. They go directly to the WIP stockroom and, unless the shipment is extremely large, it can be handled in one trip. With raw materials, though, volume can have a big effect on processing time. On average, 20% of the raw material shipments are large. Johnson: What other factors affect your departments workload? Goodwin: Well, there are three people I have not discussed yet! These three employees distribute raw materials to the manufacturing shop floor. Johnson: So, volume of raw materials must be important here. Goodwin: Well, the nature of this activity is such that volume is not much of an issue; its more the number of times materials have to be distributed. Johnson: Do you usually distribute the total amount of raw material required for a production run all at once, or does it go out in smaller quantities? Goodwin: It varies with the size of the run. On a big run, we cant distribute it all at once there would be too much raw material on the shop floor. On smaller runsand Id say thats 80% of all runswed send it out in a single trip once setup is complete. On the larger runs, materials are distributed in two trips. Johnson: What about your time? How do you spend it? Goodwin: I spend about 80% of my time supervising the work of the 12 employees and the remaining time doing administrative work not directly related to the departments activities. Johnson: How do you distribute your time across the different activities carried out in the department? Goodwin: Thats difficult to say. I have never really kept track of my time across the different activities. Perhaps I should also start logging my time. Johnson: Besides personnel, what other resources does your department consume? Goodwin: Some organizational costs that I have no control over but it works out to about $43,200 per year. For the purposes of internal planning and decision making, the company believes only in applying controllable costs at the individual decision level. Johnson: Thank you for your time. Goodwin: Youre welcome. Johnson then collected the following additional information for 2020: The annual personnel costs of the inventory control department amounted to $465,000 including Goodwins $73,400 salary. The factorys total direct labour-hours for all its products amounted to 408,000. The company received 25,000 shipments of purchased parts and 10,000 shipments of raw materials. The factorys production output of 2 million units was completed over 5,000 production runs. 1,000 units of product A were manufactured; an average production run yielded 100 units (a run size of less than 1,000 units was considered small). Each unit of product A requires four hours of direct labour in production. Product A is a complex product containing 50 different components and 50 different raw materials. On average, four shipments of each component and one shipment of each raw material were received in 2020. Required: Please do the following: 1-a. List the appropriate number of activity cost pools, all properly titled, as they pertain to the inventory control department. (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answers and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) check all that apply Incoming parts receiptsunanswered Incoming materials receiptsunanswered Distributing materials to shop floorunanswered Facility-level costunanswered Production orders

1-b. For each activity cost pool, identify an appropriate allocation base. Indicate any other alternative bases that could be used and state why you are not using them.

1-c. Assign the relevant costs to the individual cost pools.

1-d. For each activity cost pool, compute the activity cost allocation rate.

2. Assign the inventory control department costs to product A using the ABC model that you just designed.

3. Assign the inventory control department costs to product A using direct labour as an allocation base.

Complete this question by entering your answers in the tabs below.

  • Req 1B to 1D
  • Req 2
  • Req 3

Assign the inventory control department costs to product A using the ABC model that you just designed. (Round your intermediate calculations 2 decimal places and final answers to nearest whole dollar amount.)

Amount
Incoming parts receipts
Incoming materials receipts
Distributing materials to shop floor
Total cost $0
  • Req 1B to 1D
  • Req 3
  • Complete this question by entering your answers in the tabs below.

  • Req 1B to 1D
  • Req 2
  • Req 3
  • Assign the inventory control department costs to product A using direct labour as an allocation base. (Do not round intermediate calculations. Round your answers to the nearest whole dollar.)

    Inventory control costs assigned to product A
  • Req 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Cost Accounting A Managerial Emphasis

Authors: Srikant Datar, Madhav Rajan

17th Global Edition

129236307X, 9781292363073

More Books

Students also viewed these Accounting questions

Question

How is a standardized residual different from a residual?

Answered: 1 week ago