Question
In: Accounting
Problem 2 (LO3, LO4) Product and Customer Profitability Analysis PWC Systems, Inc., makes jet skis and...
Problem 2 (LO3, LO4)
Product and Customer Profitability Analysis
PWC Systems, Inc., makes jet skis and other personal watercraft for sale through specialty sporting goods stores. The company has a standard jet ski model, but also makes custom-designed models. Management has designed an activity-based costing system with the following activity cost pools activity rates:
Activity Cost Pool Activity Rates
Supporting manufacturing $22 per direct labour-hour
Order processing $212 per order
Custom design processing $243 per custom design
Customer service $307 per customer
Management would like an analysis of the profitability of a particular customer, Wave Rider, which has ordered the following products over the last 12 months:
Standard Customer
Model Design
Number of jet skis 16 3
Number of orders 2 3
Number of custom designs 0 3
Direct labour-hours per jet ski 24.5 28.0
Selling price per jet ski $10,600 $13,200
Direct materials cost per jet ski $7,950 $9,240
The company's direct labour rate is $24 per hour.
Required:
Using the company's activity-based costing system, compute the customer margin of Wave Rider.
Problem 3 (LO2, LO3)
Activity-Based Costing and Bidding on Jobs
Vance Asbestos Removal Company removes potentially toxic asbestos insulation 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 adequately distinguish between routine work such as removal of asbestos insulation around heating pipes in older homes and non-routine work such as removing asbestos-contaminated ceiling plaster in industrial buildings. The on-site supervisors believe that non-routine 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 metres by $4,000 per thousand square metres to determine the bid price. Since our average cost is only $3,000 per thousand square metres, that leaves enough cushion to take care of the additional costs of non-routine work that shows up. Besides, it is difficult to know what is routine or not routine until you actually start tearing things apart."
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 Activity Measure Total Activity
Removing asbestos Thousands of square metres 500,000 m2
Estimating and job setup Number of jobs 200 jobs*
Working on non-routine jobs Number of non-routine jobs 25 non-routine jobs
Other (costs of idle capacity and
organization-sustaining costs) Not applicable; these costs are
not allocated to jobs
*The total number of jobs includes non-routine jobs as well as routine jobs. Non-routine jobs as well as routine jobs require estimating and setup work.
Wages and salaries $200,000
Disposal fees 600,000
Equipment depreciation 80,000
On-site supplies 60,000
Office expenses 190,000
Licensing and insurance 370,000
Total cost $1,500,000
Distribution of Resource Consumption
across Activity Cost Pools
Estimating Working on
Removing and Job Non-routine
Asbestos Setup Jobs OtherTotal
Wages and salaries 40% 10% 35% 15% 100%
Disposal fees 70% 0% 30% 0% 100%
Equipment depreciation 50% 0% 40% 10% 100%
On-site supplies 55% 15% 20% 10% 100%
Office expenses 10% 40% 30% 20% 100%
Licensing and insurance 50% 0% 40% 10% 100%
Required:
- Perform the first-stage allocation of costs to the activity cost pools.
- Compute the activity rates for the activity cost pools.
- Using the activity rates you have computed, determine the total
cost and the average cost per thousand square metres of each of the
following jobs according to the activity-based costing system.
- A routine 2,000-square-metre asbestos removal job.
- A routine 4,000-square-metre asbestos removal job.
- A non-routine 2,000-square-metre asbestos removal job.
- Given the results you obtained in (3) above, do you agree with the estimator that the company's present policy for bidding on jobs is adequate?
Solutions
Expert Solution
| Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Due to character limit I am attaching the
image. |
| PWC Systems, Inc., | |||
| Workings | Standard Model | Customer Design | Note |
| Number of jet skis | 16.00 | 3.00 | A |
| Direct labor-hours per jet ski | 24.50 | 28.00 | B |
| Total Direct labor-hours | 392.00 | 84.00 | C=A*B |
| Direct labor rate | 24.00 | 24.00 | D |
| Direct labor cost per unit | 588.00 | 672.00 | E=B*D |
| F | G | H=F*G |
|
J=F*I |
|
||||||
| Standard Model | Customer Design | ||||||||||
| Activity cost pool | Activity Measure | ABC Rates | Activity used | Cost assigned | Activity used | Cost assigned | |||||
| Supporting manufacturing | Direct Labor Hour | 22.00 | 392.00 | 8,624.00 | 84.00 | 1,848.00 | |||||
| Order processing | Number of orders | 212.00 | 2.00 | 424.00 | 3.00 | 636.00 | |||||
| Custom design processing | Number of custom design | 243.00 | - | - | 3.00 | 729.00 | |||||
| Customer service | Number of customer | 307.00 | 1.00 | 307.00 | 1.00 | 307.00 | |||||
| Total Cost assigned | 9,355.00 | 3,520.00 | K | ||||||||
| Units produced | 16.00 | 3.00 | L | ||||||||
| Costs per unit | 584.69 | 1,173.33 | M=K/L | ||||||||
| Direct materials cost | 7,950.00 | 9,240.00 | |||||||||
| Direct labor cost | 588.00 |
|
672.00 | See E | |||||||
| Total Costs per unit | 9,122.69 | 11,085.33 | N | ||||||||
| Selling price per jet ski | 10,600.00 | 13,200.00 | O | ||||||||
| Customer margin | 1,477.31 | 2,114.67 | P=O-N |
| Vance Asbestos | |||||||||||
| Costs | Amount | Removing | Job Setup | Non Routine | Other | Total | Removing | Job Setup | Non Routine | Other | Total |
| Wages & Salaries | 200,000.00 | 40% | 10% | 35% | 15% | 100% | 80,000.00 | 20,000.00 | 70,000.00 | 30,000.00 | 200,000.00 |
| Disposal fees | 600,000.00 | 70% | 0% | 30% | 0% | 100% | 420,000.00 | - | 180,000.00 | - | 600,000.00 |
| Equipment Depreciation | 80,000.00 | 50% | 0% | 40% | 10% | 100% | 40,000.00 | - | 32,000.00 | 8,000.00 | 80,000.00 |
| On-site supplies | 60,000.00 | 55% | 15% | 20% | 10% | 100% | 33,000.00 | 9,000.00 | 12,000.00 | 6,000.00 | 60,000.00 |
| Office Expenses | 190,000.00 | 10% | 40% | 30% | 20% | 100% | 19,000.00 | 76,000.00 | 57,000.00 | 38,000.00 | 190,000.00 |
| Licensing and Insurance | 370,000.00 | 50% | 0% | 40% | 10% | 100% | 185,000.00 | - | 148,000.00 | 37,000.00 | 370,000.00 |
| Total | 1,500,000.00 |
 ekkarill92 answered 2 years agoRelated SolutionsProblem 4-15 Contrasting ABC and Conventional Product Costs [LO4-2, LO4-3, LO4-4] Marine, Inc., manufactures a product...Problem 4-15 Contrasting ABC and Conventional Product Costs
[LO4-2, LO4-3, LO4-4]
Marine, Inc., manufactures a product that is available in both a
flexible and a rigid model. The company has made the rigid model
for years; the flexible model was introduced several years ago to
tap a new segment of the market. Since introduction of the flexible
model, the company’s profits have steadily declined, and management
has become concerned about the accuracy of its costing system.
Sales of the flexible...
Exercise 6-5 Product and Customer Profitability Analysis [LO6-4, LO6-5] Thermal Rising, Inc., makes paragliders for sale...Exercise 6-5 Product and Customer Profitability Analysis [LO6-4,
LO6-5]
Thermal Rising, Inc., makes paragliders for sale through
specialty sporting goods stores. The company has a standard
paraglider model, but also makes custom-designed paragliders.
Management has designed an activity-based costing system with the
following activity cost pools and activity rates:
Activity Cost
Pool
Activity Rate
Supporting
direct labor
$
26
per direct
labor-hour
Order
processing
$
284
per order
Custom design
processing
$
186
per custom
design
Customer
service
$
379...
Exercise 7-5 Product and Customer Profitability Analysis [LO7-4, LO7-5] Thermal Rising, Inc., makes paragliders for sale...Exercise 7-5 Product and Customer Profitability Analysis [LO7-4,
LO7-5]
Thermal Rising, Inc., makes paragliders for sale through
specialty sporting goods stores. The company has a standard
paraglider model, but also makes custom-designed paragliders.
Management has designed an activity-based costing system with the
following activity cost pools and activity rates:
Activity Cost Pool
Activity Rate
Supporting direct labor
$
20
per direct labor-hour
Order processing
$
194
per order
Custom design processing
$
258
per custom design
Customer service
$
422...
Exercise 7-5 Product and Customer Profitability Analysis [LO7-4, LO7-5] Thermal Rising, Inc., makes paragliders for sale...Exercise 7-5 Product and Customer Profitability Analysis [LO7-4,
LO7-5]
Thermal Rising, Inc., makes paragliders for sale through
specialty sporting goods stores. The company has a standard
paraglider model, but also makes custom-designed paragliders.
Management has designed an activity-based costing system with the
following activity cost pools and activity rates:
Activity Cost Pool
Activity Rate
Supporting direct labor
$
22
per direct labor-hour
Order processing
$
194
per order
Custom design processing
$
268
per custom design
Customer service
$
420...
Problem 4-15A Comprehensive Problem-Weighted-Average Method [LO4-2, LO4-3, LO4-4, LO4-5] Sunspot Beverages, Ltd., of Fiji makes blended...Problem 4-15A Comprehensive Problem-Weighted-Average Method
[LO4-2, LO4-3, LO4-4, LO4-5]
Sunspot Beverages, Ltd., of Fiji makes blended tropical fruit
drinks in two stages. Fruit juices are extracted from fresh fruits
and then blended in the Blending Department. The blended juices are
then bottled and packed for shipping in the Bottling Department.
The following information pertains to the operations of the
Blending Department for June.
Percent Completed
Units
Materials
Conversion
Work in process,
beginning
46,000
70%
40%
Started into
production...
Problem 10-19 Comprehensive Variance Analysis in a Hospital [LO2, LO3, LO4, LO5, LO6] Marc Goudreau, administrator...Problem 10-19 Comprehensive Variance Analysis in a Hospital
[LO2, LO3, LO4, LO5, LO6] Marc Goudreau, administrator of
Clearwater Hospital, was puzzled by the prior month ’s reports.
“Every month, it’s anyone’s guess whether the lab will show a
profit or a loss. Perhaps the only answer is to increase our lab
fees again.” “We can’t,” replied Rhoda Groves, the controller.
“There are still a lot of complaints about the last increase,
particularly from the insurance companies and government health
units....
Problem 3-18B Cost flows and Unit Product Costs in Activity-Based Costing [LO2, LO3, LO4] [The following...Problem 3-18B Cost flows and Unit Product Costs in
Activity-Based Costing [LO2, LO3, LO4]
[The following information applies to the questions
displayed below.]
Fisher Company uses activity-based costing to determine product
costs for external financial reports. At the beginning of the year,
management made the following estimates of cost and activity in the
company’s five activity cost pools:
Activity Cost Pool
Activity
Measure
Expected
Overhead Cost
Expected
Activity
Labor-related
Direct labor-hours
$
382,800
23,200
DLHs
Purchase orders
Number of orders...
Problem 4-16A Comprehensive Problem-Weighted-Average Method [LO4-2, LO4-3, LO4-4, LO4-5] Builder Products, Inc., manufactures a caulking compound...Problem 4-16A Comprehensive Problem-Weighted-Average Method
[LO4-2, LO4-3, LO4-4, LO4-5]
Builder Products, Inc., manufactures a caulking compound that
goes through three processing stages prior to completion.
Information on work in the first department, Cooking, is given
below for May:
Production
data:
Pounds in
process, May 1; materials
100% complete; conversion 90%
complete
69,000
Pounds
started into production during May
340,000
Pounds
completed and transferred out
?
Pounds
in process, May 31:
materials 80% complete;
conversion 20% complete
15,000...
Problem 4-16A Comprehensive Problem-Weighted-Average Method [LO4-2, LO4-3, LO4-4, LO4-5] Builder Products, Inc., manufactures a caulking compound...Problem 4-16A Comprehensive Problem-Weighted-Average Method
[LO4-2, LO4-3, LO4-4, LO4-5]
Builder Products, Inc., manufactures a caulking compound that
goes through three processing stages prior to completion.
Information on work in the first department, Cooking, is given
below for May:
Production
data:
Pounds in
process, May 1; materials
100% complete; conversion 90%
complete
70,000
Pounds
started into production during May
350,000
Pounds
completed and transferred out
?
Pounds
in process, May 31:
materials 70% complete;
conversion 30% complete
30,000...
Problem 4-16 Contrasting ABC and Conventional Product Costs [LO4-2, LO4-3, LO4-4] [The following information applies to...Problem 4-16 Contrasting ABC and Conventional Product Costs
[LO4-2, LO4-3, LO4-4]
[The following information applies to the questions
displayed below.]
For many years, Thomson Company manufactured a single product
called LEC 40. Then three years ago, the company automated a
portion of its plant and at the same time introduced a second
product called LEC 90 that has become increasingly popular. The LEC
90 is a more complex product, requiring 0.60 hours of direct labor
time per unit to manufacture...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|