Chapter 4: ABC Costing, ABM, and Just-In-Time — Practice Problems and Exam prep
Exam prep and study logistics
- One week before the first exam; students also have professional admissions tasks over the next three weeks.
- Advice: take things one day at a time; plan ahead using a planner; identify due dates across classes; aim to break study into bite-sized pieces.
- Exam review materials were posted yesterday; start studying now.
- Today: finish Chapter 4; class review on Thursday.
- If you want to start earlier, do a little each day rather than waiting until the last minute.
- Brightspace (Two Hour) access demo will show you where materials live; Brightspace Gradebook contains exam seat assignments.
- Exams are in-class, in this classroom; next Tuesday at 11:00 AM (not accounting 200 timing).
- Exam review session hosted by ASAB tomorrow night at 17:00 (session details: location Session 102; cost $10; packet provided; detailed review).
- Wiley Chapter Quiz: 10 questions; mostly multiple choice with a few fill-in; covers Chapters 1, 2, and 4.
- Point of the quizzes: low-stakes self-check; total 5 quizzes; one quiz is dropped at the end of the semester; each quiz is 10 points.
- Open-notes allowed, but the quiz is timed: 60 minutes to complete.
- Opens today; due Thursday by midnight; will be accessed via Brightspace > content > Wiley chapter quizzes > Quiz 1; timed 60 minutes.
- Academic integrity assignment due tonight (before midnight); access via Brightspace.
- Tomorrow: Emma hosts lab review session at 04:00; lab quiz for Chapter 2/Chapter 4 due tomorrow night.
- Thursday: exam review in class; Wiley Chapter 4 homework due; then the quiz.
- Prep guidance: complete Chapter 4 homework first, then take the quiz to gauge study needs.
- Next Tuesday: first exam covers Chapters 1, 2, and 4; detailed breakdown discussed in Thursday review.
- If you have questions, raise them in class.
Exam review packet and in-class strategy
- In-class exam review will use an exam review packet; preceptors will pass it out today.
- Do the first four pages (workout problems) before Thursday’s class to identify where you get stuck.
- Watching me solve problems during class can make solutions look easy; attempting problems on your own first is crucial to understanding.
- If you need help, raise your hand for page one copies or to get additional support.
- Brightspace quick walkthrough: Chapter 4 Wiley quiz under Content, Quiz One; open today; due Thursday; 60-minute timer.
- Academic integrity assignment and seat map are posted under Content/Exam Info and Review; exam seat assignments visible in Gradebook; seat map helps plan Thursday seating.
- Exam materials include a topic list and additional practice questions/solutions for more practice.
Chapter 4 overview: Activity-Based Costing (ABC) and ABM concepts
Chapter 4 focuses on activity-based costing (ABC), which allocates overhead by multiple activity cost pools rather than a single overhead rate.
Key idea: break total overhead into multiple pools, each with its own cost driver that measures usage of that activity.
Cost driver examples: machine hours, setups, inspections, labor hours, etc.
Process similarity to Chapter 2 (predetermined overhead rate, POR) but with multiple pools and drivers.
Step 1 (ABC): identify overhead pools (cost buckets) and assign a driver to each pool.
Step 2 (ABC): estimate overhead per pool and the expected usage of the driver for each pool.
Step 3 (ABC): calculate the rate for each pool as
ext{Rate}i = rac{ ext{Estimated Overhead}i}{ ext{Estimated Usage}_i}Step 4 (ABC): apply the rates to actual usage of each driver by each product to allocate overhead from each pool:
- Then sum the allocated overhead from all pools to obtain total overhead applied to the product line:
ext{Total Overhead Assigned}{j} = igg(rac{ ext{OH}{i}}{ ext{Usage}i}igg) imes ext{Usage}{ij} ext{ summed over all pools } i
- Then sum the allocated overhead from all pools to obtain total overhead applied to the product line:
Comparison with traditional costing (POR): in traditional costing, a single POR is used with a single driver (often direct labor hours) to allocate overhead.
Benefits of ABC and ABM:
- More accurate product costing by tying overhead to actual activities consumed by products.
- Greater cost control and better decision making once you understand which activities drive costs.
- Ability to identify value-added vs nonvalue-added activities; aim to reduce nonvalue-added activity costs without harming value to the customer.
Value-added vs nonvalue-added activities (customer perspective):
- Value-added: activities the customer cares about (e.g., design, functionality, quality, aesthetics).
- Nonvalue-added: activities that are necessary for running the business or manufacturing but do not add perceived customer value (e.g., excessive moving/inspections, storeroom handling, inventory storage).
Activity-Based Management (ABM): broader framework that includes ABC costing and the identification/elimination of nonvalue-added activities to improve efficiency and profitability.
Limitations of ABC/ABM:
- Expensive and time-consuming to implement; requires gathering detailed data on activities and drivers.
- In real-world settings, benefits scale with complexity of product lines and overhead size.
When to use ABC:
- Many distinct product lines with different manufacturing processes.
- Overhead constitutes a large portion of total product cost.
Just-in-Time (JIT) vs Push (traditional) manufacturing:
- Push: produce a lot of units in advance, rely on demand to sell them; can lead to high finished-goods/inventory and cash flow issues.
- Pull / Just-in-Time: produce only as needed to fulfill orders; aims to minimize inventory and free cash, reduce obsolescence risk, and improve quality.
- Prerequisites for JIT: dependable suppliers, zero-defect quality via total quality control, and well-tuned processes.
- Benefits of JIT: reduced inventories (raw materials, WIP, finished goods), improved cash flow, reduced obsolescence risk, better product quality, reduced rework, and smoother flow in manufacturing.
Practical implications: JIT is industry-dependent; not all environments fit perfectly, but when feasible, it improves efficiency and cash management.
Specific numerical example: ABC vs traditional costing (Excel practice problem)
Context: two products (car wheels and truck wheels); determine overhead allocation under traditional costing (POR) and ABC.
Given data (from the example in the transcript):
- Product mix: Car wheels = 40{,}000; Truck wheels = 10{,}000.
- Direct labor hours per wheel: Car wheel = 1 hour; Truck wheel = 3 hours.
- Total estimated overhead costs (two-product problem): $770{,}000.
Traditional costing (POR using direct labor hours):
- Total estimated direct labor hours:
- Car: 40{,}000 imes 1 = 40{,}000 hours
- Truck: 10{,}000 imes 3 = 30{,}000 hours
- Total DLH = 40{,}000 + 30{,}000 = 70{,}000 hours
- POR:
POR = rac{ ext{Total Overhead}}{ ext{Total DLH}} = rac{770{,}000}{70{,}000} = 11 ext{ per DLH} - Actual usage (given for the actual period):
- Car DLH = 40{,}500
- Truck DLH = 30{,}200
- Overhead allocated (applied) by product:
- Actual overhead (for the period):
- Comparison (under/overapplied):
- Using the numbers in the transcript, the example notes show the actual vs applied resulting in under/overapplied as:
- This particular value reflects the data used in that portion of the walkthrough; the essential point is that actual vs allocated can yield under- or over-applied overhead.
ABC costing (three cost pools with drivers): Setup, Assembly, Inspection
- Data (as described):
- Cost pools and drivers (example values given in the walkthrough):
- Setup: Estimated overhead = $220{,}000; Estimated number of setups = 1{,}000; Driver = setups
- Assembly: Estimated overhead = $280{,}000; Estimated labor hours = 70{,}000; Driver = labor hours
- Inspection: Estimated overhead = $270{,}000; Estimated inspections = 1{,}200; Driver = inspections
- Calculated ABC rates:
- Setup rate: ext{Rate}_{ ext{setup}} = rac{220{,}000}{1{,}000} = 220 ext{ per setup}
- Assembly rate: ext{Rate}_{ ext{assembly}} = rac{280{,}000}{70{,}000} = 4 ext{ per labor hour}
- Inspection rate: ext{Rate}_{ ext{inspection}} = rac{270{,}000}{1{,}200} = 225 ext{ per inspection}
- Using actual usage data (as provided in the problem): the transcript shows the next step as plugging in the actual usage for each product and using the same rates to allocate costs across the three pools; the example then computes the total overhead assigned under ABC for each product, arriving at a higher allocation to the more complex product (truck wheels) in line with its greater consumption of activities.
- Final ABC results (as described in the walkthrough): ABC allocation leads to a larger share of overhead going to truck wheels than to car wheels, reflecting greater use of setups, labor hours, and inspections by the truck wheel product.
- After calculating ABC allocations, total ABC overhead is compared to actual overhead to determine over- or under-applied OH; the walkthrough provides an explicit example where the actual overhead is $762{,}000 and the ABC-applied total is $761{,}400, yielding underapplied overhead of $600. The key concept: ABC can yield a more accurate distribution of overhead across products when multiple activity drivers are involved.
Practical Excel notes from the problem walkthrough
- Use cell references (e.g., $B$1, etc.) so changes to inputs propagate to results.
- Use formulas to perform calculations (e.g., multiplication, division) and then copy them down using the fill handle to apply to multiple rows/products.
- In ABC, after computing rates, you apply the rates to each product’s usage of each driver, then sum to obtain total overhead per product.
- When actual vs applied are compared, set up a clear calculation for under/over-applied OH and the corresponding journal entry as needed in practice.
- Practice problem resources are available in Brightspace: Chapter 4 in-class practice problems Excel spreadsheet; there is also a video walkthrough available at 03:30 in Brightspace chapter four practice problems video for step-by-step Excel guidance.
Key takeaways and connections to broader topics
- ABC vs POR:
- POR uses a single overhead rate based on one cost driver; easier but often less accurate when overhead is driven by multiple activities.
- ABC uses multiple cost pools and cost drivers, yielding more precise product costing by assigning overhead according to actual activity consumption.
- ABM and decision-making:
- Identifies value-added vs nonvalue-added activities to drive process improvements and cost reduction.
- Encourages analysis of which activities to streamline or eliminate to improve profitability without harming customer-perceived value.
- Value-added vs nonvalue-added activities:
- Value-added: activities customers care about (design, quality, aesthetics, proper assembly).
- Nonvalue-added: activities customers don’t directly perceive but are sometimes necessary; aim to reduce or eliminate where possible.
- Just-in-Time (JIT) implications:
- Reduces inventory levels; improves cash flow; reduces inventory obsolescence risk; requires dependable suppliers and strong quality control.
- Industry suitability varies; benefits include better production flow and cost management when conditions allow.
- Exam and study strategy tips from today’s session:
- Start early with the weekly plan; break study into daily chunks; use the planner to track due dates.
- Use Brightspace to locate materials (quiz, exam seats, seat map, review handouts).
- Practice with Excel-based problems to build comfort with formulas, cell references, and scenario analysis.
- Watch the optional slower video walkthroughs to reinforce step-by-step problem-solving.
Quick formulas you should memorize for Chapter 4 (ABC and ABM)
- Traditional costing (POR):
POR = rac{ ext{Estimated Overhead}}{ ext{Estimated Driver Usage}} - ABC rates for each activity pool i:
Ratei = rac{ ext{Estimated Overhead}i}{ ext{Estimated Usage}_i} - Overhead allocated to product j from ABC:
OHj = igg( ext{Usage}{j, i=1} imes Rate1igg) + igg( ext{Usage}{j, i=2} imes Rate2igg) + \cdots or compactly, OHj = rac{OH1}{Usage1} imes Usage{j1} + rac{OH2}{Usage2} imes Usage{j2} + rac{OH3}{Usage3} imes Usage_{j3} + \cdots - Total overhead allocated across products:
OH{ ext{total}} = igg( ext{sum of } OHj ext{ over all products } jigg) - Over/under-applied overhead:
- Practical notes for solver practice:
- Always build from driver usage data per product; ensure the units line up with the driver definition (e.g., hours, setups, inspections).
- Use cell references for inputs so you can run what-if analyses quickly.
- In Excel, drag formulas to propagate calculations across products and pools; use SUM to total multiple components.