MANAGERIAL ACCOUNTING-CONNECT >CUSTOM<
17th Edition
ISBN: 9781265133627
Author: Garrison
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 7.A, Problem 4P
PROBLEM 7A-4 Time-Driven Activity-Based Costing LO 7-6, LO 7-7
Stahl Company is conducting a time-driven activity-based costing study in its Shipping Department. To aid the study, the company provided the following data regarding its Shipping Department and the customers served by the department:
Customer L | Customer M | Customer N | All Customers |
|
Number of line items picked | .. 280 | 160 | 90 | 335,000 |
Number of boxes packaged | .. 50 |
20 | 15 | 46,800 |
Number of deliveries loaded | .. 6 | 2 | 10 | 12,100 |
Required:
- Using the customer cost analysis shown in Exhibit 7A-2 as your guide, compute the following:
- The cost per minute of the resource supplied in the Shipping Department.
- The time-driven activity rate for each of Stahl's three activities.
- The total labor costs consumed by Customer L. Customer M. and Customer N.
- Using the capacity analysis shown in Exhibit 7A-3 as your guide, compute the following:
- The used capacity in minutes.
- The unused capacity in minutes.
- The unused capacity in number of employees. (Do not round your answer to a whole number.)
- The impact on expenses of matching capacity with demand. (Be sure to round your potential adjustment in the number of employees to a whole number.)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Problem 1. Mahinahon Company would like to institute an activity-based costing system to price products. The company's Purchasing Department incurs costs of P550,000 per year and has six employees.
Purchasing has determined the three major activities that occur during the year.
Activity
Allocation
Measure
# of People
Total Cost
Issuing purchase orders
# of purchase orders
1
P285,000
Reviewing receiving reports
# of receiving reports
2
P190,000
Making phone calls
# of phone calls
3
P220,000
During the year, 50,000 phone calls were made in the department; 15,000 purchase orders were issued;
and 10,000 shipments were received. Product A required 200 phone calls, 150 receiving reports, and
50 purchase orders. Product B required 350 phone calls, 400 receiving reports, and 100 purchase
orders.
1Determine the amount of purchasing department cost that should be assigned to each
of these products.
1.2. Determine purchasing department cost per…
MTI makes three types of lawn tractors: M3100, M4100, and M6100. In the past, it allocated overhead to products using machine-hours.
Last year, the company produced 8,000 units of M3100, 17,500 units of M4100, and 10,000 units of M6100 and had the following
revenues and costs:
Sales revenue
Direct costs
Direct materials
Direct labor
Variable overhead
Setting up machines
Processing sales orders
Warehousing
Operating machines
Shipping
Contribution margin
Plant administration
Gross profit
MTI
Activity
Setting up machines
Processing sales orders
Warehousing
Operating machines.
Income Statement
M3100
$ 9,400,000
3,300,000
610,000
M4100
$ 15,700,000
Cost Driver
Production runs
4, 800, 800
860, 000
M6100
$ 14,200,000
Sales orders received
Units held in inventory
Machine-hours
3,100,000
1,730, 000
MTI's controller has heard about activity-based costing and puts together an employee team to recommend cost allocation bases. The
employee team recommends the following.
M3100
9
170
90
6, 200
Total…
I Problem 5-65
Customer-Profitability Analy-
sis, Activity-Based Costing
(LO 5-9)
Fresno Fiber Optics, Inc. manufactures fiber optic cables for the computer and telecommunications
industries. At the request of the company vice president of marketing, the cost management staff has
recently completed a customer-profitability study. The following activity-based costing information was
the basis for the analysis.
1. Operating income, Trace
Telecom: $7,000
Chapter 5 ActivtyBased Costing and Management
225
Customer-Related Activities
Cost Driver Base
Cost Driver Rate
Sales activity
Sales visits
$1,000
Order taking
Purchese orders
200
Units handied.
Special handing -
Special shipping
50
Shipments
500
Cost-driver data for two of Fresno's customers for the most recent year are
Customer-Related Activities
Trace Telecom
Caltex Computer
8 visits
6 vists
Sales activity.
Order taking
15 orders
20 orders
Special handing.
800 units handled.
600 unts handled
Special shipping
18 shipments
20 shipments…
Chapter 7 Solutions
MANAGERIAL ACCOUNTING-CONNECT >CUSTOM<
Ch. 7.A - EXERCISE 7A-1 Time-Driven Activity-Based Costing...Ch. 7.A -
EXERCISE 7A-2 Time-Driven Activity-Based Costing...Ch. 7.A - EXERCISE 7A-3 Time-Driven Activity-Based Costing...Ch. 7.A - PROBLEM 7A-4 Time-Driven Activity-Based Costing LO...Ch. 7.A - PROBLEM 7A-5 Time-Driven Activity-Based Costing LO...Ch. 7 - Prob. 1QCh. 7 - Prob. 2QCh. 7 - Prob. 3QCh. 7 - What are unit-level, batch-level, product-level,...Ch. 7 - What types of costs should not be assigned to...
Ch. 7 - What are the two stages off allocation in...Ch. 7 - Why is the first stage of the allocation process...Ch. 7 - When activity-based costing is used, why do...Ch. 7 - Prob. 9QCh. 7 - Why is the form of activity-based costing...Ch. 7 - The Excel worksheet form that appears below is to...Ch. 7 - Prob. 2AECh. 7 - The Excel worksheet form that appears below is to...Ch. 7 - Prob. 1F15Ch. 7 - Prob. 2F15Ch. 7 - Prob. 3F15Ch. 7 - Prob. 4F15Ch. 7 - Prob. 5F15Ch. 7 - Prob. 6F15Ch. 7 - Prob. 7F15Ch. 7 - Prob. 8F15Ch. 7 - Prob. 9F15Ch. 7 - Prob. 10F15Ch. 7 - Prob. 11F15Ch. 7 - Prob. 12F15Ch. 7 - Prob. 13F15Ch. 7 - Prob. 14F15Ch. 7 - Prob. 15F15Ch. 7 - Prob. 1ECh. 7 - Prob. 2ECh. 7 - Prob. 3ECh. 7 - Prob. 4ECh. 7 - Prob. 5ECh. 7 - Prob. 6ECh. 7 - EXERCISE 7-7 First-Stage Allocations LO7-2
The...Ch. 7 - Prob. 8ECh. 7 - Prob. 9ECh. 7 - Prob. 10ECh. 7 - Prob. 11ECh. 7 - Prob. 12ECh. 7 - EXERCISE 7-13 Computing ABC Product Costs LO7-3,...Ch. 7 - Prob. 14ECh. 7 - Prob. 15ECh. 7 - Prob. 16PCh. 7 - Prob. 17PCh. 7 - Prob. 18PCh. 7 - Prob. 19PCh. 7 -
PROBLEM 7-20 Evaluating the Profitability of...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Part 3: Activity-Based Costing Similarly, Mr. Suncat has a couple of questions for you regarding the activity-based costing method. He has provided the following additional information: Cost Pools Initial customer meeting Purchasing ingredients Cost Drivers Number of hours spent with customer Number of purchase requisitions Direct Labor hours Estimated Overhead $15,000 $15,000 $40,000 $70,000 3. Custom Wedding Cake Expected Use of Cost Drivers 4.5 hours $10,000 1000 requisitions 5.5 hours 9.5 hours Expected Use of Cost Driver: Basic Wedding Cake 0.75 hour Making and baking the wedding cakes Decorating the wedding cakes Final customer Direct Labor hours Number of meeting and cake wedding cakes delivery a. Explain the difference between a job-order costing system and an activity-based costing system. 4200 150 requisitions 1.25 hour 1.75 hours Expected Use of Cost Driver Multi-Layer Wedding Cake 1.25 hours 1500 cakes 300 requisitions 2 hours 3 hours Expected Use of Cost 1700 cakes Driver…arrow_forwardProblem 2 Milky Corporation has provided the following data from its activity-based costing accounting system: Activity Cost Pools Designing products Setting up batches Assembling products Total Cost P1,372,448 P33,300 P126,160 Total Activity 7,798 product design hours 740 batch set-ups 6,640 assembly hours The activity rate for the "designing products" activity cost pool is answer must be in nearest peso A The activity rate for the "setting up batches" activity cost pool is answer should be in nearest peso A The activity rate for the "assembling products" activity cost pool is answer must be in nearest peso Aarrow_forwardQuestion 4.1 For its overhead costs, the wholesale distributor Janz Company uses activity-based costing. In terms of the company's annual overhead costs and its activity-based costing system the following data has been provided: Overhead Costs: Wages and salaries $380,000 Non-wage expenses 90,000 Total $470,000 Distribution of Resource Consumption: Activity Cost Pools Filling Orders Product Support Other Total Wages and salaries 20% 65% 15% 100% Non-wage expenses 25% 15% 60% 100% The "Other" activity cost pool consists of the costs of idle capacity and organization-sustaining costs. Shown below is the amount of activity for the year: Activity Cost Pool Filling orders Product support Annual Activity 3,100 orders 32 products Not applicable Other Instructions: Compute the activity rates for the Filling Orders and Product Support activity cost pools.arrow_forward
- Please Answer part 4. Part 1-3 answers Part 1 Computation of Cost Allocation Rate for each activity: Activity Costs Base usage Allocation rate Material Handling 160,000 20,000 8 Packaging 390,000 2,000 195 Quality Assurance 112,000 1,600 70 Total 662,000 Part 2 Activity Usage of All Activities: Activity Commercial Travel Total Material Handling 8700 4450 13,150 Packaging 900 300 1,200 Quality Assurance 270 370 640 Allocation of Cost basis Usage: Activity Commercial Travel Material Handling 69,600 35600 (Activity Usage * Cost Allocation Rate) (8,700 * 8) (4450 * 8) Packaging 175,500 58500 Quality Assurance 18,900 25900 Total 264,000 120000 Units Produced 3,000 20000 Cost Per Unit 88 6 Part 3 Particulars Commercial Travel Usage of…arrow_forwardAllacating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price $650 per unit Cost of goods sold 390 Gross profit $260 per unit In addition, the company incurs selling and administrative expenses of $220,070. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related to its three major nonmanufacturing activities: customer service, sales order processing, and advertising support. The advertising support is in the form of advertisements that are placed by Shrute Inc. to support the retailer's sale of Shrute copiers to consumers. The budgeted activity costs and activity bases associated with these activities are: Budgeted Activity Activity Activity Base Cost Customer service $41,850 Number of service requests Sales order processing 18,720 Number…arrow_forwardAssume a company’s activity-based costing system includes three activities with the following activity rates: Activity Cost Pool Activity Rate Travel $ 2 per mile driven Deliveries $ 50 per delivery Customer service $ 22 per phone call Two of the company’s many customers include Customer A and Customer B. These two customers consumed the company’s activities as follows: Total Expected Activity Customer A Customer B Travel (number of miles driven) 340 250 Deliveries (number of deliveries) 15 5 Customer service (number of phone calls) 20 12 How much cost would be assigned from the Travel activity to Customer A?arrow_forward
- llocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price $710 per unit Cost of goods sold (430) Gross profit $280 per unit In addition, the company incurs selling and administrative expenses of $219,700. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related to its three major nonmanufacturing activities: customer service, sales order processing, and advertising support. The advertising support is in the form of advertisements that are placed by Shrute Inc. to support the retailer's sale of Shrute copiers to consumers. The budgeted activity costs and activity bases associated with these activities are: Activity Budgeted Activity Cost Activity Base Customer service $44,100 Number of service requests Sales…arrow_forwardCost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow. UnitsProduced TotalLumberCost TotalUtilitiesCost Total MachineDepreciationCost 6,000 shelves $72,000 $7,900 $135,000 12,000 shelves 144,000 14,800 135,000 24,000 shelves 288,000 28,600 135,000 30,000 shelves 360,000 35,500 135,000 2. For each cost, determine the fixed portion of the cost, and the per-unit variable cost. If there is no amount or an amount is zero, enter "0". Recall that, for N = Number of Units Produced, Total Costs = (Variable Cost Per Unit x N) + Fixed Cost. Complete the following table with your answers. Round variable portion of cost (per unit) answers to two decimal places. Cost Fixed Portionof Cost Variable Portionof Cost (per Unit) Lumber $fill in the blank…arrow_forwardActivity-based costing: selling and administrative expenses Jungle Junior Company manufactures and sells outdoor play equipment. Jungle Junior uses activity-based costing to determine the cost of the sales order processing and the customer return activity. The sales order processing activity has an activity rate of 20 per sales order, and the customer return activity has an activity rate of 100 per return. Jungle Junior sold 2,500 swing sets, which consisted of 750 orders and 80 returns. Determine (A) the total and (B) the per-unit sales order processing and customer return activity cost for swing sets.arrow_forward
- Activity-based costing in an insurance company Umbrella Insurance Company carries three major lines of insurance: auto, workers' compensation, and homeowners. The company has prepared the following report for 20Y2: Management is concerned that the administrative expenses may make some of the insurance lines unprofitable. However, the administrative expenses have not been allocated to the insurance lines. The controller has suggested that the administrative expenses could be assigned to the insurance lines using activity-based costing. The administrative expenses are comprised of five activities. The activities and their rates are as follows: Activity-base usage data for each line of insurance were retrieved from the corporate records and are shown below. a.Complete the product profitability report through the administrative activities. b.Determine the underwriting income as a percent of premium revenue. C.Determine the Operating income as a percent of premium revenue, rounded to one decimal place. d.Interpret the report.arrow_forwardWrappers Tape makes two products: Simple and Removable. It estimates it will produce 369,991 units of Simple and 146,100 of Removable, and the overhead for each of its cost pools is as follows: It has also estimated the activities for each cost driver as follows: Â How much is the overhead allocated to each unit of Simple and Removable?arrow_forward(Appendix 3A) Separating Fixed and Variable Costs, Service Setting Louise McDermott, controller for the Galvin plant of Veromar Inc., wanted to determine the cost behavior of moving materials throughout the plant. She accumulated the following data on the number of moves (from 100 to 800 in increments of 100) and the total cost of moving materials at those levels of moves: Required: 1. Prepare a scattergraph based on these data. Use cost for the vertical axis and number of moves for the horizontal axis. Based on an examination of the scattergraph, does there appear to be a linear relationship between the total cost of moving materials and the number of moves? 2. Compute the cost formula for moving materials by using the high-low method. Calculate the predicted cost for a month with 550 moves by using the high-low formula. (Note: Round the answer for the variable rate to three decimal places and the answer for total fixed cost and total cost to the nearest dollar.) 3. CONCEPTUAL CONNECTION Compute the cost formula for moving materials using the method of least squares. (Note: For the method of least squares, round the variable rate to two decimal places and total fixed cost and total cost to the nearest dollar.) Using the regression cost formula, what is the predicted cost for a month with 550 moves? What does the coefficient of determination tell you about the cost formula computed by regression? 4. CONCEPTUAL CONNECTION Evaluate the cost formula using the least squares coefficients. Could it be improved? Try dropping the third data point (300, 3,400), and rerun the regression.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Cost Accounting - Definition, Purpose, Types, How it Works?; Author: WallStreetMojo;https://www.youtube.com/watch?v=AwrwUf8vYEY;License: Standard YouTube License, CC-BY