Question

Company XYZ has two fixed price contracts for two different clients. The company has enough capacity for both contracts but is uncertain whether they will be profitable.

Data as follows:

Customer                                  AAA                BBB

Component Type                         A999                B999

Contract Value($)                       $27,000            $100,000

Contract Quantity                      1,000 unit          2,000 units

Material cost/unit                        $15                  $20

Molding time/batch                     5 hours            7.5 hours         

Batch Size                                 100 units          50 units

Annual Budgeted overheads as follows:

Activity                                    Cost Driver                 Cost driver       Cost

                      volume/year   pool

Molding                                    Molding hours                2,000                $150,000

Inspection                                 Batches                        150                  $75,000

Production Mgmt                       Contracts                      20                    $125,000   

Calculate the activity-based costs and profits for each contract.

Answer 1

Answer:

• All workings from part of the answer
• Workings:

Working		AAA	BBB
A	No.of units	1000	2000
B	Batch size	100	50
C=A/B	No. of batches	10	40
D	Molding time per batch	5	7.5
E=C*D	Total Molding hours	50	300

• Calculation of Activity rate as per ABC Method:

Activity	Cost driver	Cost driver	Cost	Activity rate per cost driver
		[A]	[B]	[B/C]
Molding	Molding Hours	2000	$150000	$75.00 per moulding hours
Inspection	Batches	150	$75000	$500.00 per batch
Product management	Contracts	20	$125000	$6250.00 per contract

• Overhead cost as per ABC for AAA:

Activity	Activity Rate per cost driver	No.of cost driver	Cost Allocated
	[A]	[B]	[A*B]
Molding	$ 75.00 per molding hours	50 Molding Hours	$3750.00
Inspection	$500.00 per batch	10 Batches	$5000.00
Production Management	$6250.00 per contract	1 Contract	$6250.00
		Total Overhead Cost Allocated	$15000.00

• Overhead cost as per ABC for BBB:

Activity	Cost Allocated	No. of Cost Driver	Cost Allocated
	[A]	[B]	[A*B]
Molding	$75.00 per molding hours	300 Molding Hours	$22500.00
Inspection		40 Batches	$20000.00
Product Management	$6250.00 per Contract	1 Contract	$6250.00
		Total Overhead Cost Allocated	$48750.00

• Total Cost and Profits:

Working		AAA	BBB
A	Contract Value	$27000.00	$100000.00
B = Material Cost per unit * Units	MAterial Cost	$15000.00	$40000.00
C[Allocated above]	Overheads allocated as per ABC	$15000.00	$48750.00
D=A-B-C	Profit (Loss) for Contract	$(3000.00)	$11250.00