Question

Pixel Studio, Inc., is a small company that creates computer-generated animations for films and television. Much of the company’s work consists of short commercials for television, but the company also does realistic computer animations for special effects in movies.

The young founders of the company have become increasingly concerned with the economics of the business—particularly since many competitors have sprung up recently in the local area. To help understand the company’s cost structure, an activity-based costing system has been designed. Three major activities are carried out in the company: animation concept, animation production, and contract administration. The animation concept activity is carried out at the contract proposal stage when the company bids on projects. This is an intensive activity that involves individuals from all parts of the company in creating story boards and prototype stills to be shown to the prospective client. Once a project is accepted by the client, the animation goes into production and contract administration begins. Almost all of the work involved in animation production is done by the technical staff, whereas the administrative staff is largely responsible for contract administration. The activity cost pools and their activity measures are listed below:

Activity Cost Pool	Activity Measure	Activity Rate
Animation concept	Number of proposals	$	5,400	per proposal
Animation production	Minutes of completed animation	$	8,100	per minute
Contract administration	Number of contracts	$	7,600	per contract

These activity rates include all of the company’s costs, except for its organization-sustaining costs and idle capacity costs. There are no direct labor or direct materials costs.

Preliminary analysis using these activity rates has indicated that the local commercial segment of the market may be unprofitable. This segment is highly competitive. Producers of local commercials may ask three or four companies like Pixel Studio to bid, which results in an unusually low ratio of accepted contracts to bids. Furthermore, the animation sequences tend to be much shorter for local commercials than for other work. Since animation work is billed at fairly standard rates according to the running time of the completed animation, this means that the revenues from these short projects tend to be below average. Data concerning activity in the local commercial market appear below:

Activity Measure	Local Commercials
Number of proposals	15
Minutes of completed animation	12
Number of contracts	7

The total sales from the 7 contracts for local commercials was $250,000.

Required:

1. Calculate the cost of serving the local commercial market.

2. Calculate the margin earned serving the local commercial market. (Remember, this company has no direct materials or direct labor costs.)

Calculate the cost of serving the local commercial market.

	Cost of serving

Calculate the margin earned serving the local commercial market. (Remember, this company has no direct materials or direct labor costs.)

	Profitability Analysis Costs: 0 $0

• Animation concept
• Animation production
• Contract administration
• Margin
• Sales

Answer 1

Answers:

1. Calculate the cost of serving the local commercial market:

Activity Cost Pool (A)	Activity Measure (B)	Local Commercials (C )	Activity Rate (D)	Total cost (C*D)
Animation Concept	Number of proposals	15	$ 5,400	81,000
Animation Production	Minutes of completed animation	12	$ 8,100	97,200
Contract Administration	Number of contracts	7	$ 7,600	53,200
Total Cost of Servicing the local commercial market ( in $)				2,31,400

2 Calculate the margin earned serving the local commercial market:

Particulars		Amount (in $)
Revenue		2,50,000
Less:
Cost of Animation Concept	81,000
Cost of Animation Production	97,200
Cost of Contract Administration	53,200
Cost of Direct Materials	0
Cost of Direct Labour	0
Total Costs		2,31,400
Margin Earned ( Revenue - Total Costs)		18, 600