Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 4, Problem 4.4SE
To determine
To calculate: activity cost allocation rates for each activity.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Value engineering, target pricing, and locked-in costs. Sylvan Creations designs, manufactures, and sells modern wood sculptures. Sandra Johnson is an artist for the company. Johnson has spent much of the past month working on the design of an intricate abstract piece. Jim Chase, product development manager, likes the design. However, he wants to make sure that the sculpture can be priced competitively. Ellen Cooper, Sylvan’s cost accountant, presents Chase with the following cost data for the expected production of 75 sculptures:
BE5.5 - Using Excel to Evaluate a Make-Versus-Buy Decision
Student Work Area
PROBLEM
Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated.
Grunar Industries produces the component parts needed for its popular non-commercial-use drones. One of the key parts has become more costly to produce than first planned, however, so management is considering outsourcing that part. If the company decides not to manufacture this part, a portion of its fixed manufacturing overhead costs would continue. The costs to produce one such part internally and to purchase on part from the suppler are given here.
Complete the schedule to support the decision of whether to make or buy the part.
Relevant Costs to Make
Relevant Cost to Buy
Costs to produce internally…
Colby Company makes cases for cell phones of all sizes and types for sale through specialty retailers. The company makes a standard
model for the most recent iPhone as well as a deluxe model. Management has designed an ABC system with the following activity cost
pools and activity rates for these models:
Activity Cost Pool
Supporting manufacturing
Order processing
Customer service
Activity Rates
2 per direct labour-hour
21 per order
75 per customer
Management would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over
the last 12 months:
Standard
Model
Deluxe
Model
Number of cases
160
35
Number of orders
Direct labour-hours per case
Selling price per case
Direct materials cost per case
2
0.25
0.40
40
65
12
$
15
The company's direct labour rate is $24 per hour.
Required:
Using the company's ABC system, compute the customer margin of Cell City.
Chapter 4 Solutions
Managerial Accounting (5th Edition)
Ch. 4 - (Learning Objective 1) Cost distortion is more...Ch. 4 - (Learning Objective 2) The first step in computing...Ch. 4 - (Learning Objective 2) Activities incurred...Ch. 4 - (Learning Objective 3) Which of the following is...Ch. 4 - (Learning Objective 3) The potential benefits of...Ch. 4 - (Learning Objective 4) Lean operations are...Ch. 4 - Prob. 7QCCh. 4 - (Learning Objective 4) Concerning lean operations,...Ch. 4 - (Learning Objective 5) Which of the following is...Ch. 4 - (Learning Objective 5) Which of the following...
Ch. 4 - Understanding key terms (Learning Objectives 1, 2,...Ch. 4 - Use departmental overhead rates to allocate...Ch. 4 - Compute departmental overhead rates (Learning...Ch. 4 - Prob. 4.4SECh. 4 - Prob. 4.5SECh. 4 - Calculate a job cost using ABC (Learning Objective...Ch. 4 - Classifying costs within the cost hierarchy...Ch. 4 - Classifying costs within the cost hierarchy...Ch. 4 - Determine the usefulness of refined costing...Ch. 4 - Prob. 4.10SECh. 4 - Identifying costs as value-added or...Ch. 4 - Identify lean production characteristics (Learning...Ch. 4 - Identify the DOWNTIME activities at a manufacturer...Ch. 4 - Prob. 4.14SECh. 4 - Classifying costs of quality (Learning Objective...Ch. 4 - Quality initiative decision (Learning Objective 5)...Ch. 4 - Assess the impact of a quality initiative...Ch. 4 - Identify ethical standards violated (Learning...Ch. 4 - Compare traditional and departmental cost...Ch. 4 - Compute activity rates and apply to jobs (Learning...Ch. 4 - Apply activity cost allocation rates (Learning...Ch. 4 - Using ABC to bill clients at a service firm...Ch. 4 - Compare traditional and ABC allocations at a...Ch. 4 - Compare traditional and ABC allocations on a job...Ch. 4 - Use ABC to allocate manufacturing overhead...Ch. 4 - Continuation of E4-25A: Determine product...Ch. 4 - Prob. 4.27AECh. 4 - Classify costs and make a quality-initiative...Ch. 4 - Prob. 4.29AECh. 4 - Compare traditional and departmental cost...Ch. 4 - Prob. 4.31BECh. 4 - Prob. 4.32BECh. 4 - Prob. 4.33BECh. 4 - Compare traditional and ABC cost allocations at a...Ch. 4 - Prob. 4.35BECh. 4 - Prob. 4.36BECh. 4 - Prob. 4.37BECh. 4 - Prob. 4.38BECh. 4 - Classify costs and make a quality-initiative...Ch. 4 - Prob. 4.40BECh. 4 - Prob. 4.41APCh. 4 - Use ABC to compute full product costs (Learning...Ch. 4 - Prob. 4.43APCh. 4 - Prob. 4.44APCh. 4 - Prob. 4.45APCh. 4 - Prob. 4.46BPCh. 4 - Prob. 4.47BPCh. 4 - Comprehensive ABC implementation (Learning...Ch. 4 - Using ABC in conjunction with quality decisions...Ch. 4 - Comprehensive ABC (Learning Objectives 2 3)...Ch. 4 - Prob. 4.51SCCh. 4 - Discussion Questions 1. Explain why departmental...Ch. 4 - ABC in Real Companies Choose a company in any of...Ch. 4 - Value-Added versus Non-Value-Added at a Restaurant...Ch. 4 - Ethics involved with ABC and hazardous waste costs...
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
- Mary Jones and Jack Smart have joined forces to start M&J Food Products, a processor of packaged shredded lettuce for institutional use. Jack has years of food processing experience, and Mary has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together, with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per 5-pound bag of lettuce. They think a largely manual process will have monthly fixed cost of $50,000 and a variable cost of $2.50 per bag. They expect to sell 75,000 bags of lettuce per month. They expect to sell the shredded lettuce for $3.25 per 5-pound bag. Jack and Mary has been contacted by a vendor to consider a more mechanized process. This new process will have monthly fixed cost of $125,000 per month with a variable cost of $1.75 per bag. Based on the above…arrow_forwardMary Jones and Jack Smart have joined forces to start M&J Food Products, a processor of packaged shredded lettuce for institutional use. Jack has years of food processing experience, and Mary has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together, with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per 5-pound bag of lettuce. They think a largely manual process will have monthly fixed cost of $50,000 and a variable cost of $2.50 per bag. They expect to sell 75,000 bags of lettuce per month. They expect to sell the shredded lettuce for $3.25 per 5-pound bag. Jack and Mary has been contacted by a vendor to consider a more mechanized process. This new process will have monthly fixed cost of $125,000 per month with a variable cost of $1.75 per bag. Based on the above…arrow_forwardBE5.7 - Using Excel to Determine Profitability Given a Constrained Resource Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Rachel wants to use her knitting skills to make a little extra money so she can enjoy a theatre weekend with her besties. She’s got the pattern down for a hat, scarf, and mittens, but she realizes that her available time is limited. She should be able to sell as many of any item as she can make, but she wants to make sure she’s making the best use of her time. Cost and time information are provided here. Calculate the contribution margin per unit of the scarce resource for each item. Hat Scarf Mittens Hat Scarf Mittens Contribution margin per Time in minutes 20 30…arrow_forward
- Fitness Gym, Inc., produces two basic types of weight-lifting equipment, Model 9 and Model 14. Pertinent data are as follows: E (Click the icon to view the data.) The weight-lifting craze suggests that Fitness Gym can sell enough of either Model 9 or Model 14 to keep the plant operating at full capacity. Both products are processed through the same production departments. Read the requirements. Before determining which products to produce, let's calculate the contribution margin per unit and the contribution margin per machine hour for each machine. (Reduce the fixed manufacturing overhead to the lowest possible ratio of machine hours in order to calculate the contribution margin per machine hour. Example: 8:4 would be 2:1. Enter the amounts to the nearest cent.) Model 9 Model 14 Data Table Contribution margin per unit A В 1 Per Unit Contribution margin per machine hour Model 9 Model 14 Fitness Gym, Inc. should produce: 3 Selling price $ 125.00 $ 90.00 A. Both Model 9 and Model 14…arrow_forwardFitness Gym, Inc., produces two basic types of weight-lifting equipment, Model 9 and Model 14. Pertinent data are as follows: E (Click the icon to view the data.) The weight-lifting craze suggests that Fitness Gym can sell enough of either Model 9 or Model 14 to keep the plant operating at full capacity. Both products are processed through the same production departments. Read the requirements. Before determining which products to produce, let's calculate the contribution margin per unit and the contribution margin per machine hour for each machine. (Reduce the fixed manufacturing overhead to the lowest possible ratio of machine hours in order to calculate the contribution margin per machine hour. Example: 8:4 would be 2:1. Enter the amounts to the nearest cent.) Model 9 Model 14 i Data Table Contribution margin per unit A В C 1 Per Unit Contribution margin per machine hour 2 Model 9 Model 14 Fitness Gym, Inc. should produce: 3 Selling price $ 125.00 $ 90.00 A. Both Model 9 and Model…arrow_forwardMake a Decision: Analyze CSR initiatives at Gree Manufacturing (from Chapter 14)Obj. 5 Green Manufacturing is a traditional manufacturing company located in the midwestern United States. The company's operations manager is developing a strategy to become more CSR-oriented. In an effort to evaluate possible areas where CSR initiatives can be implemented, the manager has gathered the following data regarding three potential CSR activities: Initial Added CostVariable CostVariable SavingsRecycle and reuse production materials$ 5,000$0.10 per lb. of recycled material$0.15 per lb. of recycled materialAdd solar panels as a source of power 700,000$ 1,000 per year$ 33,000 per yearReplace assembly room light fixtures with natural light 120,000$ 180 per month$ 220 per month The recycling activity would carry on indefinitely. The solar panels would have a useful life of 30 years. The replacement of assembly room light fixtures with natural light is assumed to have an 80-year effect.a.…arrow_forward
- TechPro offers instructional courses in e-commerce website design. The company holds classes in a building that it owns. Identify each of TechPro’s costs below as (a) variable or fixed and (b) direct or indirect by selecting the appropriate dropdowns. Assume the cost object is an individual class. Variable or Fixed Direct or Indirect 1. Instructional manuals for students 2. Advertising Fixed Indirect 3. Salesperson salary 4. Sales commissions 5. Computer printer ink 6. Depreciation on classroom buildingarrow_forwardAnimPax 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 effect in movies. The young founders of the company have 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 and ABC 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 storyboards and prototype stills to be shown to the prospective client after the client has accepted a project the animation goes into production and…arrow_forwardCollege Cases sells cases for electronic devices such as phones, computers, and tablets. These cases have college logos or mascots on them and can be customized by adding such things as the customers name, initials, sport, or fraternity letters. The company buys the cases in various colors and then uses laser technology to do the customization of the letters and to add school names, logos, mascots, and so on. What are potential activity-based costing pools for College Cases, and what would be appropriate cost drivers?arrow_forward
- These questions relate to the Integrated Analytics Case: Bene Petit. Select the appropriate eBook link to open the Case Overview, Case Background, and Part 3: Managerial Decision Making. Assume that Bene Petit sells only family-sized meals and that the average price is $5.00 per serving. Variable manufacturing costs are $1.75 per serving for customer meals and $0.75 per serving for donated meals. Variable delivery expenses are $2.00 per customer delivery (with an average order size of four meals or 16 servings in each delivery). Variable delivery expenses for donated meals are $200 per delivery, with an average of 1,000 donated meals or 4,000 servings in each delivery. Other variable selling expenses are $0.30 per customer meal sold. Total fixed costs are $144,000. Assume Bene Petit plans to launch a new marketing effort to increase total sales revenue. If the marketing campaign is expected to cost $9,000, how much must total sales increase is necessary to justify the expenditure?arrow_forwardConrad Coding Institute (CCI) offers online courses in coding. One of CCI's most popular courses is the introductory course that teaches basic coding skills. CCI prices this course aggressively, because of the potential for creating demand for the more advanced (and more profitable) courses. The Introductory coding course has the following price and cost characteristics: Tuition Variable costs (instruction, support, and so on) Fixed costs (advertising, salaries, and so on) Required: 4. Suppose that fixed costs for the year are 15 percent lower than projected, whereas variable costs per swuent are 15 percent higher than projected. What would be the operating profit/loss for the Introductory coding course for the year? Complete this question by entering your answers in the tabs below. Req A Req B Operating profit Req C1 Req C2 $ 65 per student 40 per student 180,000 per year Req C3 Show lessarrow_forwardMaloney Pharmaceuticals manufacturers an over-the-counter allergy medication. The company sells both large commercial containers of 1,000 capsules to health care facilities and travel packs of 20 capsules to shops in airports, train stations, and hotels. The following information has been developed to determine if an activity-based costing system would be beneficial: LOADING... (Click the icon to view the information.) Read the requirements LOADING... . Requirement 1. Maloney's original single plantwide overhead allocation rate costing system allocated indirect costs to products at $154.88 per machine hour. Compute the total indirect costs allocated to the commercial containers and to the travel packs under the original system. Then compute the indirect cost per unit for each product. Round to two decimal places. Select the formula, and then enter the amounts to compute the indirect cost per unit for each product.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Inspection and Quality control in Manufacturing. What is quality inspection?; Author: Educationleaves;https://www.youtube.com/watch?v=Ey4MqC7Kp7g;License: Standard youtube license