Explore BrainMass
Share

# activity-based costing data

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

The New Millenium Manufacturing Company produces two products. One is a millenium surf kit. The other product is a professional surf-board (short board) used in world class surfing competition. Most of the sales come from the millenium surf product, but recently sales of professional boards have been increasing. The following information relates to the products for the most recent fiscal year:
Millenium Surf Kit Professional Board
Sales (units) 1,500 500
Selling price per unit \$980 \$650
Direct labor hours required to produce one unit 6 9
Machine hours required to produce one unit 5 8
Direct material costs per unit \$212 \$265
Direct labor costs per unit \$85 \$85
Management is concerned about the current system's effectiveness in allocating overhead and in computing the production costs of the two products. Consequently, Millenium Manufacturing hires a consultant to analyze the overhead costs and assist the company in creating an activity-based costing system. The consultant breaks down the total overhead costs into four categories and measured the activity levels for those same categories as shown below:
Cost Pool
Description Cost Driver
Millenium Surf Kit
Level of Activity Professional Board
Level of Activity Total Costs
Incurred
Equipment Machine hours 7,500 4,000 \$90,000
Material Orders Number of orders 150 475 33,000
Machine Setups Number of setups 70 216 30,600
Quality Control Direct labor hours 5 25 58,000
Total \$211,600
Required:
1. Calculate the manufacturing overhead rate based on labor hours and machine hours (two separate computations).
2. Determine the cost to manufacturing one unit of each model using two different traditional approaches; direct labor hours and machine hours.
3. Determine the cost to manufacturing one unit of each model using the activity-based costing data presented above.
4. Is the millenium surf kit as profitable as the company may think it is based on its present system?
5. What should Millenium Manufacturing Company do to improve its profitability?

© BrainMass Inc. brainmass.com October 25, 2018, 1:33 am ad1c9bdddf

#### Solution Summary

Calculate the manufacturing overhead rate based on labor hours and machine hours in this case.

\$2.19

## Chapter 8: Activity-Based Costing: A Tool to Aid Decision Making

Please refer to the attached word document. The following exercises need to be addressed:

Exercise 8-10

Problem 8-14

Problem 8-18

Thanks.

---

356
Chapter 8 Activity-Based Costing: A Tool to Aid Decision Making
EXERCISE 8-10 Comprehensive Activity-Based Costing Exercise
Silicon Optics has supplied the following data for use in its activity-based costing system:
Wages and salaries .
Other overhead costs .
Total overhead costs .
\$350,000 200,000
\$550,000
Activity Cost Pool
Volume .
Order processing .
Customer support .
Other .
Activity Measure
Number of direct labor-hours Number of orders
Number of customers
These costs are not allocated to products or customers
Total Activity 10,000 DLHs
500 orders 100 customers
Not applicable
Volume
Wages and salaries 30%
Other overhead costs 25%
Distribution of Resource Consumption Across Activity Cost Pools
Order Customer
Processing Support
35% 25%
15% 20%
Other 10% 40%
Total 100% 100%
During the year, Silicon Optics completed an order for a special optical switch for a new cus¬tomer, Indus Telecom. This customer did not order any other products during the year. Data con¬cerning that order follow:
Data Concerning the Indus Telecom Order
Selling price \$295 per unit
Units ordered 100 units
Direct materials \$264 per unit
Direct labor-hours 0.5 DLH per unit
Direct labor rate \$25 per DLH
Required:
1. Using Exhibit 8-4 as a guide, prepare a report showing the first-stage allocations of overhead costs to the activity cost pools.
2. Using Exhibit 8-5 as a guide, compute the activity rates for the activity cost pools.
3. Using Exhibit 8-8 as a guide, prepare a report showing the overhead costs for the order from Indus Telecom. Do not include customer support costs at this point in the analysis.
4. Using Exhibit 8-9 as a guide, prepare a report showing the product margin for the order and the customer margin for Indus Telecom.

Chapter 8 Activity-Based Costing: A Tool to Aid Decision Making
PROBLEM 8-14 Activity-Based Costing and Bidding on Jobs Denny Asbestos Removal Company is in the business of removing potentially toxic asbestos insu¬lation and related products from buildings. The company's estimator has been involved in a long¬simmering dispute with the on-site work supervisors. The on-site supervisors claim that the estimator does not take enough care in distinguishing between routine work such as removal of asbestos insulation around heating pipes in older homes and nonroutine work such as removing asbestos-contaminated ceiling plaster in industrial buildings. The on-site supervisors believe that nonroutine work is far more expensive than routine work and should bear higher customer charges. The estimator sums up his position in this way: "My job is to measure the area to be cleared of asbestos. As directed by top management, I simply multiply the square footage by \$4,000 per thou¬sand square feet to determine the bid price. Since our average cost is only \$3,000 per thousand square feet, that leaves enough cushion to take care of the additional costs of nonroutine work that shows up. Besides, it is difficult to know what is routine or not routine until you actually start tear¬ing things apart."
Partly to shed light on this controversy, the company initiated an activity-based costing study of all of its costs. Data from the activity-based costing system follow:

Activity cost Pool
Job size .
Estimating and job setup .
Working on nonroutine jobs .
Other (costs of idle capacity and organization-
sustaining costs) .

Activity Measure Thousands of square feet Number of jobs
Number of nonroutine jobs Not applicable; these
costs are not allocated to jobs

Total Activity
500 thousand square feet 200 jobs*
25 nonroutine jobs

*The total number of jobs includes non routine jobs as well as routine jobs. Nonroutine jobs as well as routine jobs require estimating and setup work.

Chapter 8 Activity-Based Costing: A Tool to Aid Decision Making

359

Wages and salaries .
Disposal fees , .
Equipment depreciation .
On-site supplies .
Office expenses .
Licensing and insurance .
Total cost. .

\$ 200,000 600,000 80,000 60,000 190,000 370,000
\$1,500,000

Other 15%
0% 10% 10% 20% 10%
Job Size
Wages and salaries 40%
Disposal fees 70%
Equipment depreciation 50%
On-site supplies 55%
Office expenses 10%
Licensing and insurance 50%

Distribution of Resource Consumption Across Activity Cost Pools
Estimating Working on
and Nonroutine
Job Setup Jobs
10% 35%
0% 30%
0% 40%
15% 20%
40% 30%
0% 40%

Total 100% 100% 100% 100% 100% 100%

Required:
1. Using Exhibit 8-4 as a guide, perform the first-stage allocation of costs to the activity cost pools.
2. Using Exhibit 8-5 as a guide, compute the activity rates for the activity cost pools.
3. Using the activity rates you have computed, determine the total cost and the average cost per thousand square feet of each of the following jobs according to the activity-based costing system.
a. A routine 2,000-square-foot asbestos removal job. b. A routine 4,000-square-foot asbestos removal job.
e. A nonroutine 2,000-square-foot asbestos removal job.
4. Given the results you obtained in (3) above, do you agree with the estimator that the com¬pany's present policy for bidding on jobs is adequate?
PROBLEM 8-18 (Appendix 8A) Activity Rates and Activity-Based Management
Chefs de Vitesse SA is a French company that provides passenger and crew meals to airlines oper¬ating out of the two international airports of Paris-Orly and Charles de Gaulle (CDG). The oper¬ations at Orly and CDG are managed separately, and top management believes that greater sharing information between the two operations should lead to improvements in operations.
To better compare the two operations, an activity-based costing system has been designed with the active participation of the managers at both Orly and CDG. The activity-based costing system is based on the following activity cost pools and activity measures:

Activity Cost Pool
Meal preparation .
Flight-related activities .
Customer service .
Other (costs of idle capacity and
organization-sustaining costs) .

Activity Measure Number of meals Number of flights Number of customers
Not applicable

Meal Prep. Customer Related Customer Service
Cooks and delivery personnel wages â?¬2.63 â?¬ 135.50 â?¬ 0
Kitchen supplies . 0.19 0.00 0
Chef salaries 0.18 12.00 10,500
Equipment depreciation . 0.05 0.00 0
Administrative wages and salaries . 0.00 9.65 8,765
Building costs , . 0.00 0.00 0
Total cost . â?¬ 3.05 â?¬157.15 â?¬19,265

362
Chapter 8 Activity-Based Costing: A Tool to Aid Decision Making
The operation at CDG airport serves 500,000 meals annually on 4,000 flights for 8 different airlines. (Each airline is considered one customer.) The annual cost of running the CDG airport op¬eration, excluding only the costs of raw materials for meals, totals â?¬2,650,000. (The currency in France is the euro, denoted here by â?¬.)
Annual Cost of the COG Operation
Cooks and delivery personnel wages .
Kitchen supplies .
Chef salaries .
Equipment depreciation .
Administrative wages and salaries .
Building costs .
Total cost .
â?¬ 1,800,000 100,000 200,000 50,000 180,000 320,000
â?¬ 2,650,000
To help determine the activity rates, employees were interviewed and asked how they divided their time among the four major activities. The results of the interviews at CDG are displayed below:
Distribution of Resource Consumption Across Activity Cost Pools
at the COG Operation
Flight Customer Related Service
25% 0%
0% 0%
15% 40%
0% 0%
25% 45%
0% 0%
Cooks and delivery personnel wages
Kitchen supplies .
Chef salaries .
Equipment depreciation .
Administrative wages and salaries .
Building costs .
Meal
Preparation 70% 90% 35% 70%
0% 0%
Other
5% 10% 10% 30% 30%
100%
Total 100% 100% 100% 100% 100% 100%
Required:
1. Using Exhibit 8A-I as a guide, perform the first-stage allocation of costs to the activity cost pools.
2. Using Exhibit 8A-2 as a guide, compute the activity rates for the activity cost pools.
3. The Orly operation has already concluded its activity-based costing study and has reported the following costs of carrying out activities at Orly:

Comparing the activity rates for the CDG operation you computed in (2) above to the activity rates for Orly, do you have any suggestions for the top management of Chefs de Vitesse SA?
---

View Full Posting Details