Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN: 9781305970663
Author: Don R. Hansen, Maryanne M. Mowen
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 11, Problem 11E
Assign the customer-related activity costs to each customer type using activity rates. Now calculate the profitability of each customer category. As a manager, how would you use this information?
Emery Company sells small machine parts to heavy equipment manufacturers for an average price of $1.05 per part. There are two types of customers: those who place small, frequent orders and those who place larger, less frequent orders. Each time an order is placed and processed, a setup is required. Scheduling is also needed to coordinate the many different orders that come in and place demands on the plant’s manufacturing resources. Emery also inspects a sample of the products each time a batch is produced to ensure that the customer’s specifications have been met Inspection takes essentially the same time regardless of the type of part being produced. Emery’s Cost Accounting Department has provided the following budgeted data for customer-related activities and costs (the amounts expected for the coming year):
Required:
- 1. Assign the customer-related activity costs to each category of customers in proportion to the sales revenue earned by each customer type. Calculate the profitability of each customer type. Discuss the problems with this measure of customer profitability.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Match each of the following cost items with the value chain business function where you would expect the cost to be incurred:
Cost Item
1. Labor time to repair products under warranty
2. Radio commercials
3. Labor costs of delivering customer orders
4. Testing of competitor's product
5. Direct manufacturing labor costs
6. Development of order tracking system for online sales
7. Design cost of new product brochures
8. Hours spent designing childproof bottles
9. Training costs for representatives to staff the customer call center
10. Installation of robotics equipment in manufacturing plant
Business Function
Suppose that Stillwater Designs has two classes of distributors: JIT distributors and non-JIT distributors. The JIT distributor places small, frequent orders, and the non-JIT distributor
tends to place larger, less frequent orders. Both types of distributors are buying the same product. Stillwater Designs provides the following information about customer-related
activities and costs for the most recent quarter:
Sales orders
Sales calls
Service calls
Average order size
Manufacturing cost/unit
Customer costs:
Processing sales orders
Selling goods
Servicing goods
Sales (in units)
Sales
Allocation
Ordering costs
Selling costs
Service costs
Total
9.23
per unit
JIT
$
JIT
Distributors
$3,180,000
1,120,000
1,050,000
$5,350,000
Total
1. Calculate the total revenues per distributor category, and assign the customer costs to each distributor type by using revenues as the allocation base. Selling price for one unit is
$150. Round calculations to the nearest dollar.
650,000
97,500,000
2,675,000…
Retail companies with today’s online, as well as in-store sales have a lot of data to keep track of!
Keeping track of sales, costs, and profits daily is essential to making the most of a business. This exercise illustrates how to use the skills presented in this Module to generate the data needed daily by a retail company.
Create the following calculated columns.
a) In I4, and J4, use a VLOOKUP function that will look up the Product Price and Product
Cost based on the Product Sold column which lists an ID number. [Hint: The Product Table
sheet lists the Price and Cost] If any error messages appear, check the Range Lookup.
b) In K4, use a formula to calculate Profit. Hint: Profit =(Product Price-Product
Cost)*Units Sold
Format columns I, J, and K as currency with two decimal places.
Make a copy of the Sales sheet and rename it Online Sales by Date. Place this sheet to the right of the Sales sheet. Answer the following question by filtering the data accordingly.
a) What was the…
Chapter 11 Solutions
Cornerstones of Cost Management (Cornerstones Series)
Ch. 11 - What does it mean to obtain a competitive...Ch. 11 - What is customer value? How is customer value...Ch. 11 - Prob. 3DQCh. 11 - What are organizational and operational...Ch. 11 - What is the difference between a structural cost...Ch. 11 - What is value-chain analysis? What role does it...Ch. 11 - Prob. 7DQCh. 11 - What are the three viewpoints of product life...Ch. 11 - What are the four stages of the marketing life...Ch. 11 - Prob. 10DQ
Ch. 11 - What are the four stages of the consumption life...Ch. 11 - Life-cycle cost reduction is best achieved during...Ch. 11 - Prob. 13DQCh. 11 - Prob. 14DQCh. 11 - Prob. 15DQCh. 11 - Woodruff Company is currently producing a...Ch. 11 - Ventana Company is a car window repair and...Ch. 11 - Deeds Company sells custom-made machine parts to...Ch. 11 - Kagle design engineers are in the process of...Ch. 11 - Hepworth Company has implemented a JIT system and...Ch. 11 - Keith Golding has decided to purchase a personal...Ch. 11 - Prob. 7ECh. 11 - Classify the following cost drivers as structural,...Ch. 11 - Prob. 9ECh. 11 - Prob. 10ECh. 11 - Assign the customer-related activity costs to each...Ch. 11 - The following series of statements or phrases are...Ch. 11 - Assume that a company has recently switched to JIT...Ch. 11 - Prob. 14ECh. 11 - Potter Company has installed a JIT purchasing and...Ch. 11 - Potter Company has installed a JIT purchasing and...Ch. 11 - Potter Company has installed a JIT purchasing and...Ch. 11 - Prob. 18ECh. 11 - Which of the following is a true statement about...Ch. 11 - Prob. 20ECh. 11 - This year, Hassell Company will ship 4,000,000...Ch. 11 - Prob. 22ECh. 11 - The second stage of customer-based activity-based...Ch. 11 - Evans, Inc., has a unit-based costing system....Ch. 11 - Cortalo, Inc., manufactures riding lawn mowers....Ch. 11 - Moss Manufacturing produces several types of...Ch. 11 - Maxwell Company produces a variety of kitchen...Ch. 11 - Prob. 28PCh. 11 - Nico Parts, Inc., produces electronic products...Ch. 11 - Jolene Askew, manager of Feagan Company, has...Ch. 11 - Homer Manufacturing produces different models of...Ch. 11 - Mott Company recently implemented a JIT...Ch. 11 - Southward Company has implemented a JIT flexible...Ch. 11 - Prob. 34P
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
- Assume you are the warehouse manager for Vinnies Vinyls, a multi-location business specializing in vinyl records. Vinniess operates under a cost-based transfer structure and the warehouse supplies all stores with the records. The stores can purchase records only from the warehouse, and the warehouse can only sell to Vinnies stores. The manager of the West store has some concerns relating to the stores financial performance and has asked for your help analyzing transfer costs. After calculating the operating income in dollars and the operating income percent, analyze the following financial information to determine costs that may need further investigation. (Hint: it may be helpful to perform a vertical analysis.)arrow_forwardDiscuss how, as warehouse manager for Vinnies Vinyls, you view the different rate of allocated costs the warehouse is being charged compared to the West store. Describe the implications of this. What steps could you take to solve this discrepancy? What alternatives would you consider, assuming management is willing to consider making changes in the rate?arrow_forwardVVH Training is a company that provides expert training sessions on how to run your business and make it profitable. They offer these training sessions in their offices and offer catering services during the sessions. You have been hired to complete a profitability analysis and you decided to start by completing a cost analysis of the business, in order to figure out for each training sessions, what costs are fixed and what costs are variable. You were able to gather the following information about the associated costs: Instructor: $11,000 per session Training Material: $2,500 per session and $35 per attendee Catering Services: Food: $75 per attendee Setup/cleanup: $25 per attendee Fixed fee: $5,000 per training session The catering company has also offered VVH Training a 1,000$ discount per session, if they are willing to leave their brochures on the dinner table as a form of advertising. VVH has accepted the offer saying that it is a no-brainer Required: plot a…arrow_forward
- You are the warehouse manager for a multi-location business specializing in old style vinyl records. The company operates under a cost-based transfer structure and the warehouse supplies all stores with the records. The stores can purchase records only from the warehouse, and the warehouse can only sell to the stores. The manager of the West store has concerns relating to the store’s financial performance and has asked for help analyzing transfer costs. After calculating the operating income in dollars and the operating income percent, analyze the following financial information to determine costs that may need further investigation. It may be helpful to perform a vertical analysis (i.e., perform a vertical analysis). warehouse west store sales $18,920 $43,860 cost of goods sold 9,082 21,053 gross profit $9,838 $22,807 selling expenses 860 2,752 Wges expenses 4,730 15,351 costs allocated from corporate 2,838 4,386 total expenses $8,428 $22,489 operating…arrow_forwardThe success of a business depends on many things. For example, you are the senior manager of the ABC Hypermarket, Explain Mr. Said, the new manager how to understand the customers and the competition. In addition also explain control costs and how to price their products and services. Explain Mr. Said about Markup & Margin with the following situations. Required: (a) Situation 1: Calculating OMR amount of markup and percent markup on cost. Signature" jeans cost, OMR 1800. Signature" jeans selling price OMR 2300. (b) Situation 2: Calculating selling price based on following information. Lamp cost, OMR200. 40% markup on selling price (c) Situation 3: Calculating cost based on following information Tennis racket selling price OMR 800 40% markup on costarrow_forwardThe following is a financial information from MayPagAsaPa Company: Additional information:The company purchase office supplies from big manufacturers and distributes among different segments. Cost of goods sold and shipping expenses are both variable. 1.Prepare a new contribution format segmented income statement. 2.Analyze your requirement #1. What points that might help to improve the company’s performance would you bring to management’s attention? 3.Compare your output with Requirement 1 with the information above. List the items you think that is an error/disadvantage/weakness of the given data.arrow_forward
- Cost drivers and functions. The representative cost drivers in the right column of this table are randomized so they do not match the list of functions in the left column. Representative Cost Driver A Number of imvoices sent B. Number of purchase orders C. Number of units manufactured D. Number of computers on the network E Number of employees hired F. Number of bills received from vendors G. Number of pallets moved Function 1. Accounts payable 2. Recruiting 3. Network Maintenance 4. Production 5. Purchasing 6. Warehousing 1. Billing 1. Match each function with its representative cost driver. 2 Give a second example of a cost driver for each function.arrow_forwardell Computer incurs the following costs: LOADING... (Click the icon to view the costs.) Requirement Classify each of the cost items (a-h) into one of the business functions of the value chain. Cost Item Value Chain Business Function a. Utility costs for the plant assembling the Latitude computer line of products b. Distribution costs for shipping the Latitude line of products to a retail chain c. Payment to David Newbury Designs for design of the XPS 2-in-1 laptop d. Salary of computer scientist working on the next generation of servers e. Cost of Dell employees' visit to a major customer to demonstrate Dell'sarrow_forwardHoward Cooper, the president of Thornton Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 42,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Thornton charges customers $79 per hour, the firm can achieve 48,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the…arrow_forward
- Match each of the following cost items with the value chain business function where you would expect the cost to be incurred: Cost Item 1. Purchase of raw materials 2. Advertising 3. Salary of research scientists 4. Delivery expenses 5. Reengineering of product assembly process 6. Replacement labor expense for warranty repairs 7. Manufacturing supplies 8. Sales salaries 9. Purchase of CAD (computer-aided design) software 10. Salary of website manager Business Functionarrow_forwardSilver Lining Inc. has a balanced scorecard with a strategy map that shows that delivery time and the number of erroneous shipments are expected to affect the company’s ability to satisfy the customer. Further, the strategy map for the balanced scorecard shows that the hours from ordered to delivered affects the percentage of customers who shop again, and the number of erroneous shipments affects the online customer satisfaction rating. The following information is also available: The company’s target hours from ordered to delivered is 40. Every hour over the ordered-to-delivered target results in a 0.5% decrease in the percentage of customers who shop again. The company’s target number of erroneous shipments per year is no more than 65. Every error over the erroneous shipments target results in a 0.05 point decrease in the online customer satisfaction rating and an added future financial loss of $500. The company estimates that for every 1% decrease in the percentage of customers who…arrow_forwardCost Classification Match each cost to the appropriate cost behavior pattern shown in graphs (a) through (l). Any graph can fit two or more patterns. The cost of lumber used to manufacture wooden kitchen tables. The cost of order fillers in a warehouse. When demand increases significantly, the number of order fillers is increased, and when demand falls off significantly, the number is decreased. The salary of the plant’s quality control inspector, who inspects each batch of products. The cost of water and sewer service to the manufacturing plant. The local municipality charges a fixed rate per gallon for usage up to 10,000 gallons and a higher charge per gallon for usage above that point. The cost of an internet connection of $23 per month. The cost of an internet connection of $10 per month plus $2 per hour of usage above 10 hours. The cost to make copies of a given document at a printing shop, where the per-copy charge is reduced for customers who make more than…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 Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Principles 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
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
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