ACC 360 Topic 6 activity-based recosting worksheet example

Cost Accounting Grand Canyon University Free custom sample in 24 to 48h

This ACC 360 Topic 6 sample paper is an activity-based recosting worksheet for a plastics plant making high-volume bins and low-volume electronics housings. It belongs to GCU ACC 360, Cost Accounting, the course listed as ACC-360 in the Grand Canyon University BS in Accounting. It starts from the current $30 machine-hour rate, which gives $4.50 a bin and $6.00 a housing. The $600,000 pool is split into machine operation at $15 an hour, setups at $3,000 each and inspection at $80 an hour. Recharged, bins carry $2.95 and housings $24.60, with a check row proving $600,000. The worksheet tests each driver, recomputes margins and draws pricing and setup actions.

CourseACC 360 Cost Accounting
TopicTopic 6
Paper typeActivity-based recosting worksheet
LengthAbout 950 words, 2 pages
FormatAPA 7 student paper
SchoolGrand Canyon University (GCU)
ProgramBS in Accounting
UpdatedSeptember 2026

Free sample paper for ACC 360 Topic 6

1

From $6.00 to $24.60 a Housing: An Activity-Based Recosting Worksheet for Cascade Molded Products

[Author Name]

Colangelo College of Business, Grand Canyon University

ACC-360: Cost Accounting

Topic 6 Assignment

[Instructor Name]

[Date]

The organization, setting and figures below are a composite written as a model document. No real employer, client, colleague or patient is described.

What this page is doingThe title gives the size of the change for the low-volume product, which is the finding the recosting exists to reveal. Cascade Molded Products and all figures are illustrative composites.
2

From $6.00 to $24.60 a Housing: An Activity-Based Recosting Worksheet for Cascade Molded Products

Starting From the Current Figures

Cascade Molded Products, a composite plastics plant, makes two products on the same injection molding machines: high-volume storage bins and low-volume electronics housings. It applies $600,000 of annual overhead on machine hours at a plantwide rate of $30. The worksheet starts from those current figures so that the change can be measured against them. All figures are illustrative.

Table 1

Overhead Under the Plantwide Rate

Current method: plantwide rateStorage binsElectronics housingsTotal
Units produced120,00010,000
Machine hours18,0002,00020,000
Overhead at $30 a machine hour$540,000$60,000$600,000
Overhead per unit$4.50$6.00

Splitting the Pool by Activity

The $600,000 is not one kind of cost. Interviews with the plant manager and the general ledger detail split it into three activities, each with a driver that measures how much of the activity a product uses.

Table 2

Activity Pools, Drivers and Rates

Activity poolCostDriverDriver totalRate
Machine operation$300,000Machine hours20,000$15 an hour
Setups180,000Setups60$3,000 a setup
Inspection120,000Inspection hours1,500$80 an hour
Total$600,000

Charging Each Product for What It Uses

Each product is charged for its use of each activity at that activity's rate. Table 3 shows the result and a check row confirming that the two products together still carry exactly $600,000.

Table 3

Overhead Recharged by Activity

ActivityBins: driver useBins: costHousings: driver useHousings: cost
Machine operation18,000 hours$270,0002,000 hours$30,000
Setups20 setups60,00040 setups120,000
Inspection300 hours24,0001,200 hours96,000
Total overhead$354,000$246,000
Per unit$2.95$24.60
Check: $354,000 + $246,000$600,000

What Changed and Why

Bins' overhead falls from $4.50 to $2.95 a unit; housings' rises from $6.00 to $24.60. The total is unchanged. What moved is the placement, and the reason is setups and inspection. Housings are made in small runs of about 250 units, each needing a mold change and a first-article inspection, and their tight tolerances call for frequent in-process inspection. Bins run in long runs of 6,000. Under the plantwide rate, setups and inspection were spread by machine hours, and bins, which use 90% of machine hours, carried 90% of those costs even though housings cause most of them.

This is the pattern activity-based costing was developed to expose: when overhead includes costs driven by batches and product complexity rather than by volume, a volume-based rate shifts cost from low-volume, complex products to high-volume, simple ones (Cooper & Kaplan, 1988).

What Happens to Product Margins

The recosting changes which product appears profitable. Table 4 sets unit margins under both methods beside illustrative selling prices and direct costs.

Table 4

Unit Margins Under Both Methods

Per unitBinsHousings
Selling price$11.00$38.00
Direct materials and labor5.4014.00
Overhead, plantwide rate4.506.00
Margin, plantwide rate1.1018.00
Overhead, activity-based2.9524.60
Margin, activity-based2.65(0.60)
Total margin, plantwide rate$132,000$180,000
Total margin, activity-based$318,000($6,000)

Reading the Margins

Under the plantwide rate, housings looked like the star product, earning $18.00 a unit against bins' $1.10. Under activity-based costing, housings lose about 60 cents a unit and bins earn $2.65. Total plant margin is $312,000 either way, since total overhead has not changed; the recosting only reassigns it. That check matters, because it confirms that no cost was lost or double counted in the split. Both methods sum to $312,000 across the two products.

The setup rate also becomes a tool. At $3,000 a setup, a housing run of 250 units carries $12 of setup cost per unit. If the customer accepted runs of 500, setup cost per unit would fall to $6, and housings would return to a positive margin, before counting the cost of holding the extra inventory between orders. Before the recosting, no one at Cascade could have put a number on that conversation.

Testing Each Driver

A driver is useful only if the pool's cost actually moves with it. Machine operation: power and machine maintenance rise with machine hours, and depreciation is reasonably spread by them; the driver fits. Setups: the pool is the setup crew's wages and mold handling equipment, and the crew's time is almost entirely spent on changeovers, so the number of setups tracks the cost well. One caution is that a complex mold takes longer to change than a simple one; if setup times vary widely, setup hours would be a better driver than setup counts. Inspection: the pool is two quality technicians and their gauges, and their time is logged by product, so inspection hours are a direct measure of use.

Where drivers are harder to measure, time-driven activity-based costing estimates the time each activity takes per transaction and applies a cost per minute of capacity, which is simpler to maintain than surveying staff about how they spend their time (Kaplan & Anderson, 2004). For Cascade's three pools, the drivers are already recorded, so no estimates are needed.

What the Plant Should Do With the Result

Housings have been priced on an overhead cost of $6.00 a unit. At $24.60, some housing contracts may be earning little or nothing, while bins have been carrying costs they do not cause and may be priced above what the market requires. Three actions follow. Review housing prices and contracts against the revised cost. Look for ways to reduce the setups housings require, such as longer runs or quicker mold changes, since the setup rate, not the product itself, drives most of the cost. And use the revised bin cost when bidding on large bin contracts, where the plant may have been losing business to competitors with more accurate costs. Activity-based costs are estimates for decision making and should be updated when volumes or processes change (Datar & Rajan, 2021).

References

Cooper, R., & Kaplan, R. S. (1988). Measure costs right: Make the right decisions. Harvard Business Review, 66(5), 96-103.

Datar, S. M., & Rajan, M. V. (2021). Horngren's cost accounting: A managerial emphasis (17th ed.). Pearson.

Kaplan, R. S., & Anderson, S. R. (2004). Time-driven activity-based costing. Harvard Business Review, 82(11), 131-138.

ACC 360 Topic 6 instructions, in plain terms

The Topic 6 instructions in ACC-360 ask students to apply activity-based costing and compare it with a traditional allocation. Weak submissions present activity rates without the current figures to compare. The assignment rewards worksheets that begin with the current method, split overhead into activity pools with drivers and rates, charge each product for its use of each activity and prove that the total is unchanged. Students should explain why costs moved between products, test whether each driver actually moves with its pool's cost, show the effect on product margins and recommend actions based on the results.

How the ACC-360 Topic 6 example is put together

The finished worksheet starts from the plant's current figures so the change can be measured against them. At $30 per machine hour, bins absorb $540,000 of the illustrative overhead and housings $60,000, which is $4.50 per bin and $6.00 per housing. The worksheet then splits the pool. Machine operation, $300,000, goes on machine hours at $15. Setups, $180,000, go on 60 setups at $3,000 each, and the housings need 40 of them. Inspection, $120,000, goes on 1,500 inspection hours at $80, of which the housings use 1,200. Recharged, bins carry $354,000, or $2.95 a unit, and housings $246,000, or $24.60. The two totals still sum to $600,000, which the worksheet shows in a check row. Each pool carries a short test of whether its driver moves with its cost.

ACC 360 Topic 6 rubric: what Excellent looks like

Faculty grading the recosting worksheet reward a measured change. Excellent worksheets show per-unit overhead before and after and a check row proving total overhead is unchanged. Credit goes to explaining that setups and inspection, driven by batches and complexity, had been spread by volume. The rubric values testing each driver against its pool. The highest level recomputes margins, finds that the apparent star product loses money and uses the setup rate to frame a run-size discussion. Worksheets whose recharged totals do not sum to the original pool usually lose marks.

Common ACC 360 Topic 6 mistakes, and how to avoid them

A worksheet that explains activity pools and drivers but leaves both products at their old costs has shown the vocabulary and not the effect, and it earns little. Pools built without naming their contents cannot be defended, since a reader has no way to judge whether setup cost really follows the number of setups. Worksheets whose recharged totals do not return to $600,000 have made an arithmetic error that undermines every per-unit figure. Choosing units produced as the driver for setups or inspection rebuilds the old volume-based answer under a new name. Papers that report the new total per product line but never convert it to cost per unit leave the reader without the figure a pricing discussion would use. Recommending price changes inside the worksheet, before the costing has been reviewed, runs ahead of the evidence.

Get an ACC-360 Topic 6 example written to your instructions

Send the ACC-360 Topic 6 instructions, the rubric in your classroom and the product and activity data your case supplies. A custom example is drafted to those criteria, with the current charge reproduced, pools named by contents, rates derived, both products recharged with a check row and each driver tested, delivered in 24 to 48 hours. The first one comes free.

More ACC 360 papers and BS in Accounting samples

ACC 360 Topic 6 questions, answered

Why does the housing's cost rise so sharply?

Because it consumes setups and inspection far out of proportion to its volume. The housings make up under a tenth of the units and need two-thirds of the setups and four-fifths of the inspection hours. A machine-hour rate spread those costs by running time, where the housings use little, so their overhead looked like the bins'. The recharge moves the costs to where the activity actually happened.

How many activity pools are enough?

Enough to capture the activities that products consume in clearly different proportions, and rarely more at this level. Three pools here separate running time, setups and inspection, which is where the two products differ. Splitting further, into material handling or engineering changes, adds work and matters only if those activities also vary sharply between products. The worksheet should say why the pools stop where they do.

Does the total overhead change under activity costing?

No. The plant spends the same $600,000 whichever way it is charged, and the check row exists to prove that. What changes is each product's share, and therefore each product's reported cost. If a recharged total comes out different from the original pool, an error has crept into a rate or a driver count, and it should be found before any per-unit figure is used.

Where can I find a free ACC 360 Topic 6 sample paper?

Everything is above: the current figures, the activity pools, charging each product, what changed and why, product margins, reading them, testing each driver and what the plant should do. Send your plant data for a free worked worksheet.

Why does housing cost rise in ACC 360 Topic 6?

Housings run in small batches needing 40 of 60 setups and 1,200 of 1,500 inspection hours, costs the machine-hour rate had spread mostly onto bins.