Managerial Accounting: Creating Value in a Dynamic Business Environment
12th Edition
ISBN: 9781260417074
Author: HILTON, Ronald
Publisher: MCGRAW-HILL HIGHER EDUCATION
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 6, Problem 41P
(Note: Instructors who wish to cover all three cost-estimation methods with the same data set may assign this problem in conjunction with the next one.) Martha’s Vineyard Marine Supply is a wholesaler for a large variety of boating and fishing equipment. The company’s controller, Mathew Knight, has recently completed a cost study of the firm’s material-handling department in which he used work measurement to quantify the department’s activity. The control factor unit used in the work-measurement study was hundreds of pounds of equipment unloaded or loaded at the company’s loading dock. Knight compiled the following data.
Required:
- 1. Draw a scatter diagram of the cost data for the material-handling department.
- 2. Visually fit a cost line to the scatter diagram.
- 3. Estimate the variable and fixed components of the department’s cost behavior pattern using the visually fit cost line.
- 4. Using your estimate from requirement (3), specify an equation to express the department’s cost behavior.
- 5. Estimate the material-handling department’s cost behavior using the high-low method. Use an equation to express the results of this estimation method.
- 6. Write a brief memo to the company’s president explaining why the cost estimates developed in requirements (4) and (5) differ.
- 7. Predict the company’s material-handling costs for a month when 2,300 units of activity are recorded. Use each of your cost equations to make the prediction. Which prediction would you prefer to use? Why?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Warren Furniture produces three models of desk chairs: Basic, Ergo, and Exec. The cost system at the Warren production facility
allocates overhead cost on the basis of direct labor hours. The company is considering updating its cost system to an activity-based
costing system and is interested in understanding the effects. A study team composed of the production facility's finance and
operations groups has identified three overhead cost pools along with appropriate cost drivers for each pool.
Cost Pools
Assembly
Setup
Quality assurance
Costs
$ 2,925,000
1,023,000
642,000
Activity Drivers
Direct labor-hours
Number of setups
Number of tests
The plans for production for the next year and the budgeted direct costs and activity by product line are as follows:
Direct costs (material and labor)
Basic
$ 1,006,800
Direct labor-hours
25,200
Products
Ergo
$ 1,143,000
12,000
Exec
$ 868,800
Machine-hours
29,200
17,200
Number of setups
Number of tests
Number of units produced
48
140
7,200
72
100…
Data Master is a computer software consulting company. Its three major functional areas are computer programming, information systems consulting, and software training. Cynthia Moore, a pricing analyst in the Accounting Department, has been asked to develop total costs for the functional areas. These costs will be used as a guide in pricing a new contract. In computing these costs, Moore is considering three different methods of allocating overhead costs-the direct method, the step method, and the reciprocal method. Moore assembled the following data on overhead from its two service departments, the Information Systems Department and the Facilities Department.
Service Departments
User Departments
Info Systems
Facilities
Computer Program
Consult
Training
Total
Budgeted Overhead
$
50,000
$
25,000
$
75,000
$
110,000
$
85,000
$
345,000
Info Systems (hrs.)
400
1,100
600
900
3,000
Facilities (Square feet)
200,000…
Data Master is a computer software consulting company. Its three major functional areas are computer programming, information systems consulting, and
software training. Cynthia Moore, a pricing analyst in the Accounting Department, has been asked to develop total costs for the functional areas. These costs
will be used as a guide in pricing a new contract. In computing these costs, Moore is considering three different methods of allocating overhead costs: the
direct method, the step method, and the reciprocal method. Moore assembled the following data on overhead from its two service departments, the
Information Systems Department and the Facilities Department.
Service Departments
User Departments
Info Systems Facilities Computer Program Consulting
$ 50,000
$110,000
600
$25,000
400
$75,000
1,100
400,000
200,000
600,000
information systems are allocated on the basis of hours of computer usage; facilities are allocated on the basis of floor space.
Required:
Allocate the service…
Chapter 6 Solutions
Managerial Accounting: Creating Value in a Dynamic Business Environment
Ch. 6 - Describe the importance of cost behavior patterns...Ch. 6 - Define the following terms, and explain the...Ch. 6 - Suggest an appropriate activity base (or cost...Ch. 6 - Draw a simple graph of each of the following types...Ch. 6 - Explain the impact of an increase in the level of...Ch. 6 - Explain why a manufacturers cost of supervising...Ch. 6 - Explain the impact of an increase in the level of...Ch. 6 - Prob. 8RQCh. 6 - Indicate which of the following descriptions is...Ch. 6 - Prob. 10RQ
Ch. 6 - What is meant by a learning curve? Explain its...Ch. 6 - Suggest an appropriate independent variable to use...Ch. 6 - What is an outlier? List some possible causes of...Ch. 6 - Explain the cost estimation problem caused by...Ch. 6 - Describe the visual-fit method of cost estimation....Ch. 6 - What is the chief drawback of the high-low method...Ch. 6 - Explain the meaning of the term least squares in...Ch. 6 - Prob. 18RQCh. 6 - Prob. 19RQCh. 6 - List several possible cost drivers that could be...Ch. 6 - Prob. 21RQCh. 6 - Prob. 22ECh. 6 - The behavior of the annual maintenance and repair...Ch. 6 - WMEJ is an independent television station run by a...Ch. 6 - Jonathan Macintosh is a highly successful...Ch. 6 - Jonathan Macintosh is a highly successful...Ch. 6 - The Iowa City Veterinary Laboratory performs a...Ch. 6 - Chillicothe Meat Company produces one of the best...Ch. 6 - Rio Bus Tours has incurred the following bus...Ch. 6 - Prob. 31ECh. 6 - Prob. 32ECh. 6 - Prob. 33ECh. 6 - Gator Beach Marts, a chain of convenience grocery...Ch. 6 - For each of the cost items described below, choose...Ch. 6 - The following selected data were taken from the...Ch. 6 - Antioch Extraction, which mines ore in Montana,...Ch. 6 - Nations Capital Fitness, Inc. operates a chain of...Ch. 6 - The Allegheny School of Music has hired you as a...Ch. 6 - Prob. 40PCh. 6 - (Note: Instructors who wish to cover all three...Ch. 6 - Refer to the original data in the preceding...Ch. 6 - Shortly after being hired as an analyst with...Ch. 6 - The controller of Chittenango Chain Company...Ch. 6 - Dana Rand owns a catering company that prepares...Ch. 6 - Prob. 48PCh. 6 - Earth and Artistry, Inc. provides commercial...Ch. 6 - Prob. 51CCh. 6 - Refer to the data and accompanying information in...
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
- A company manufactures luxury watches made with high-end design materials. The company uses a traditional costing system in assigning overhead costs to the products on the basis of direct labour hours. However, the Production Manager seeks to replace the existing system with the Activity-based Costing (ABC) system to keep control over costs and offer more competitive pricing. After reviewing the existing costing system and interviewing the company’s personnel in relevant departments, the accountant compiled a report highlighting resources and costs involved in manufacturing watches per month: The following table lists out the overhead cost: Activity cost pool Overhead cost (£) Additional Notes Job-order set up 33,000 Procurement and placement 360,000 Installation of winding system 195,000 An auto winding system is fitted with every watch Quality inspection (machine) 60,000 Quality inspection (manual) 21,000 Finishing…arrow_forwardDeedee Tech Sdn Bhd (DTSB) involves in the production of computer appliances. There are two producing departments in DTSB: assembly, and quality control. For the purpose of overhead allocation, the assembly department applies machine hours, while quality control department uses direct labour hours. However, if the plant-wide rate is applied, DTSB would use machine hours for the cost driver. The information below is related to the overhead costs of DTSB for the year 2021: Assembly Quality Control Total Estimated overhead RM250,000 RM130,000 RM380,000 Estimated machine hour 21,000 hours 3,000 hours 24,000 hours Estimated direct labour hour 20,000 hours 80,000 hours REQUIRED: (a) Calculate the predetermined overhead rate using:…arrow_forwardArklan Production is upgrading its manufacturing process from a manual process to a highly automated system. Management believes that the new system will result in greater efficiencies and a better finished product. Arklan is also working on a plan to downsize staff after the implementation of the new system. Arklan has used a traditional absorption costing system to calculate unit product costs for external financial reporting. In the past, Arklan has allocated its manufacturing overhead costs using a predetermined plant-wide overhead rate based on direct labor hours. The controller realizes that the new system may require changing the overhead allocation process. Management plans to take the opportunity to reconsider other improvements to the costing system. Identify and explain three benefits of using departmental overhead rates to allocate overhead costs. Explain the difference between absorption costing and variable costing. Identify which is more suitable for internal…arrow_forward
- Jane’s Cookhouse is a popular restaurant located in a scenic setting. The owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern to conduct an ABC study. The intern, in consultation with the owner, identified three major activities. The intern then completed the first-stage allocations of costs to the activity cost pools, using data from last month’s operations. The results appear below: Activity Cost Pool Activity Measure Total Cost Total Activity Serving a party of diners Number of parties served $ 16,585 5,350 parties Serving a diner Number of diners served $ 107,010 13,050 diners Serving a drink Number of drinks ordered $ 35,310 10,700 drinks The above costs include all of the costs of the restaurant except for organization-sustaining costs such as rent, property taxes, and top-management salaries. A group of diners who ask to sit at the same table are counted as a party. Some costs, such as the…arrow_forwardAs you learned in the previous chapters, Current Designs has two main product lines-composite kayaks, which are handmade and very labor-intensive, and rotomolded kayaks, which require less labor but employ more expensive equipment. Current Designs' controller, Diane Buswell, is now evaluating several different methods of assigning overhead to these products. It is important to ensure that costs are appropriately assigned to the company's products. At the same time, the system that is used must not be so complex that its costs are greater than its benefits. Diane has decided to use the following activities and costs to evaluate the methods of assigning overhead. Activities Designing new models Creating and testing prototypes Creating molds for kayaks Cost $124,000 144,000 182,000 Operating oven for the rotomolded kayaks 41,000 Operating the vacuum line for the composite kayaks 28,000 Supervising production employees 168,000 Curing time (the time that is needed for the chemical processes…arrow_forwardHazelnut Corporation manufactures lawn ornaments. It currently has two product lines, the basic and the luxury. Hazelnut has a total of $143,484 in overhead. The company has identified the following information about its overhead activity pools and the two product lines: Quantity or Amount Consumed by Basic Activity Pools Materials handling Quality control Machine maintenance Cost Driver Number of moves Number of inspections Number of machine hours Required 1 Complete this question by entering your answers in the tabs below. Basic Model Luxury Model Required 2 Required 3 Required 4 Required: 1. Suppose Hazelnut used a traditional costing system with machine hours as the cost driver. Determine the amount of overhead assigned to each product line. 2. Calculate the activity rates for each activity pool in Hazelnut's ABC system. 3. Calculate the amount of overhead that Hazelnut will assign to the basic line if it uses an ABC system. 4. Determine the amount of overhead Hazelnut will assign…arrow_forward
- Gibson Manufacturing produces two keyboards, one for laptop computers and the other for desktop computers. The production process is automated, and the company has found activity-based costing useful in assigning overhead costs to its products. The company has identified five major activities involved in producing the keyboards. Activity Materials receiving & handling Production setup Assembly Quality inspection Packing and shipping Activity measures for the two kinds of keyboards follow: Laptops Desktops Required Allocation Base Cost of material Number of setups Number of parts Inspection time Number of orders Labor Cost $ 1,190 1,080 Material Number of Number of Cost $ 5,600 7,500 Setups 31 11 Parts 47 28 Allocation Rate 2% of material cost $ 113.00 per setup $ 5.00 per part $ 1.30 per minute $ 12.00 per order Number of Inspection Time Orders 6,800 minutes 5,200 minutes 67 22 a. Compute the cost per unit of laptop and desktop keyboards, assuming that Gibson made 210 units of each…arrow_forwardDurban Metal Products, Limited, of the Republic of South Africa makes speclalty metal parts used In applications ranging from the cutting edges of bulldozer blades to replacement parts for Land Rovers. The company uses an activity-based costing system for Internal decislon-making purposes. The company has four actlvity cost pools as listed below: Activity Rate $ 17.70 per direct labor-hour $ 358.08 per customer order $ 78.08 per testing hour $ 1,492.00 per sales call Activity Cost Pool Order size Activity Measure Number of direct labor-hours Customer orders Number of custoner orders Product testing Selling Number of testing hours Number of sales calls The managing director of the company would like Information concerning the cost of a recently completed order for heavy- duty traller axles. The order requlred 100 direct labor-hours, 17 hours of product testing, and 5 sales calls. Required: What Is the total overhead cost assigned to the order for heavy-duty traller axles? Activity Cost…arrow_forwardCain Components manufactures and distributes various plumbing products used in homes and other buildings. Over time, the production staff has noticed that products they considered easy to make were difficult to sell at margins considered reasonable, while products that seemed to take a lot of staff time were selling well despite recent price increases. A summer intern has suggested that the cost system might be providing misleading information. The controller decided that a good summer project for the intern would be to develop, in one self-contained area of the plant, an alternative cost system with which to compare the current system. The intern identified the following cost pools and, after discussion with some plant personnel, appropriate cost drivers for each pool. There were: Cost Pools Costs Activity Drivers Receiving $ 600,000 Direct material cost Manufacturing 5,500,000 Machine-hours Machine setup 900,000 Production runs Shipping 1,000,000 Units shipped…arrow_forward
- Cain Components manufactures and distributes various plumbing products used in homes and other buildings. Over time, the production staff has noticed that products they considered easy to make were difficult to sell at margins considered reasonable, while products that seemed to take a lot of staff time were selling well despite recent price increases. A summer intern has suggested that the cost system might be providing misleading information. The controller decided that a good summer project for the intern would be to develop, in one self-contained area of the plant, an alternative cost system with which to compare the current system. The intern identified the following cost pools and, after discussion with some plant personnel, appropriate cost drivers for each pool. There were: Cost Pools Costs Activity Drivers Receiving $ 600,000 Direct material cost Manufacturing 5,500,000 Machine-hours Machine setup 900,000 Production runs Shipping 1,000,000 Units shipped…arrow_forwardCain Components manufactures and distributes various plumbing products used in homes and other buildings. Over time, the production staff has noticed that products they considered easy to make were difficult to sell at margins considered reasonable, while products that seemed to take a lot of staff time were selling well despite recent price increases. A summer intern has suggested that the cost system might be providing misleading information. The controller decided that a good summer project for the intern would be to develop, in one self-contained area of the plant, an alternative cost system with which to compare the current system. The intern identified the following cost pools and, after discussion with some plant personnel, appropriate cost drivers for each pool. There were: Cost Pools Costs Activity Drivers Receiving $ 600,000 Direct material cost Manufacturing 5,500,000 Machine-hours Machine setup 900,000 Production runs Shipping 1,000,000 Units shipped…arrow_forwardRandy Harris, controller, has been given the charge to implement an advanced cost management system. As part of this process, he needs to identify activity drivers for the activities of the firm. During the past four months, Randy has spent considerable effort identifying activities, their associated costs, and possible drivers for the activities costs. Initially, Randy made his selections based on his own judgment using his experience and input from employees who perform the activities. Later, he used regression analysis to confirm his judgment. Randy prefers to use one driver per activity, provided that an R2 of at least 80 percent can be produced. Otherwise, multiple drivers will be used, based on evidence provided by multiple regression analysis. For example, the activity of inspecting finished goods produced an R2 of less than 80 percent for any single activity driver. Randy believes, however, that a satisfactory cost formula can be developed using two activity drivers: the number of batches and the number of inspection hours. Data collected for a 14-month period are as follows: Required: 1. Calculate the cost formula for inspection costs using the two drivers, inspection hours and number of batches. Are both activity drivers useful? What does the R2 indicate about the formula? 2. Using the formula developed in Requirement 1, calculate the inspection cost when 300 inspection hours are used and 30 batches are produced. Prepare a 90 percent confidence interval for this prediction.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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Elements of cost | Direct and Indirect: Material, Labor, & Expenses; Author: Educationleaves;https://www.youtube.com/watch?v=UFBaj6AHjHQ;License: Standard youtube license