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
Textbook Question
Chapter 3, Problem 33P
Big Mike’s, a large hardware store, has gathered data on its overhead activities and associated costs for the past 10 months. Nizam Sanjay, a member of the controller’s department, believes that overhead activities and costs should be classified into groups that have the same driver. He has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more general receiving activity, since these three activities are all driven by the number of receiving orders. The 10 months of data shown below have been gathered for the receiving activity.
Required:
- 1. Prepare a scattergraph, plotting the receiving costs against the number of purchase orders. Use the vertical axis for costs and the horizontal axis for orders.
- 2. Select two points that make the best fit, and compute a cost formula for receiving costs.
- 3. Using the high-low method, prepare a cost formula for the receiving activity.
- 4. Using the method of least squares, prepare a cost formula for the receiving activity. What is the coefficient of determination?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Schell Company manufactures automobile floor mats. It currently has two product lines, the Standard and the Deluxe. Suppose that
Schell has conducted further research into its overhead and potential cost drivers. As a result, the company has compiled the following
detailed information, breaking total overhead into three activity pools:
Activity Pools
Material handling
Quality control
Machine maintenance
Req 1
Cost Driver
Number of moves
Number of inspections
Number of machine hours
Req 2 and 3
Required:
1. Calculate the activity rates for each activity pool assuming Schell uses an ABC system.
2. Calculate the amount of overhead that Schell will assign to the Standard floor mat line.
3. Determine the amount of overhead Schell will assign to the Deluxe product line.
Complete this question by entering your answers in the tabs below.
Material Handling
Quality Control
Machine maintenance
Cost Assigned
to Pool
Activity Rate
$ 2,068.00
$ 8,640.00
$ 14,120.00
Calculate the activity rates for…
Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controller's department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows:
Month
Receiving Orders
Receiving Cost $
1
1,000
18,000
2
700
15,000
3
1,500
28,000
4
1,200
17,000
5
1,300
25,000
6
1,100
21,000
7
1,600
29,000
8
1,400
24,000
9
1,700
27,000
10
900
16,000
Assume that Tracy has used the method of least squares on the receiving data and has gotten the following results:
Intercept
3,212…
For many years, Yotsuya Company has used a manufacturing overhead rate based on direct labor hours. A new plant accountant has suggested that the company may be able to assign overhead costs to products more accurately by using an activity-based costing system. The accountant explains that by creating an overhead rate for each production activity that causes overhead costs, the resulting product costs will reflect an accurate measure of overhead cost. The direct material cost is P120 per unit. The budgeted hours is 8,030 direct labor hours. The accountant has identified activity centers to which overhead costs are assigned. The cost pool amounts for theses centers and their selected activity drivers for 2019:
Activity Centers
Costs
Activity Drivers
Materials handling
P60,000
1,200 times handled
Scheduling and setups
80,000
400 setups
Design section
10,750
100 changes
No. of parts
50,000
500 parts
P200,750
The company’s products…
Chapter 3 Solutions
Cornerstones of Cost Management (Cornerstones Series)
Ch. 3 - Why is knowledge of cost behavior important for...Ch. 3 - How does the length of the time horizon affect the...Ch. 3 - Prob. 3DQCh. 3 - What is the relationship between flexible...Ch. 3 - What is the relationship between committed...Ch. 3 - Describe the difference between a variable cost...Ch. 3 - Why do mixed costs pose a problem when it comes to...Ch. 3 - Why is a scattergraph a good first step in...Ch. 3 - What are the advantages of the scatterplot method...Ch. 3 - Prob. 10DQ
Ch. 3 - What is meant by the best-fitting line? Is the...Ch. 3 - When is multiple regression required to explain...Ch. 3 - Explain the meaning of the learning curve. How do...Ch. 3 - Assume you are the manager responsible for...Ch. 3 - Some firms assign mixed costs to either the fixed...Ch. 3 - Callies Gym is a complete fitness center. Owner...Ch. 3 - Corazon Manufacturing Company has a purchasing...Ch. 3 - Darnell Poston, owner of Poston Manufacturing,...Ch. 3 - Dohini Manufacturing Company had the following 12...Ch. 3 - Refer to Cornerstone Exercise 3.4 for data on...Ch. 3 - The controller for Dohini Manufacturing Company...Ch. 3 - Prob. 7CECh. 3 - State Universitys football team just received a...Ch. 3 - Classify the following costs of activity inputs as...Ch. 3 - SmokeCity, Inc., manufactures barbeque smokers....Ch. 3 - Cashion Company produces chemical mixtures for...Ch. 3 - For the following activities and their associated...Ch. 3 - Prob. 13ECh. 3 - Vargas, Inc., produces industrial machinery....Ch. 3 - Penny Davis runs the Shear Beauty Salon near a...Ch. 3 - Shirrell Blackthorn is the accountant for several...Ch. 3 - Deepa Dalal opened a free-standing radiology...Ch. 3 - Prob. 18ECh. 3 - The controller of the South Charleston plant of...Ch. 3 - Lassiter Company used the method of least squares...Ch. 3 - Sweet Dreams Bakery was started five years ago by...Ch. 3 - Ginnian and Fitch, a regional accounting firm,...Ch. 3 - Bordner Company manufactures HVAC (heating,...Ch. 3 - Sharon Glessing, controller for Janson Company,...Ch. 3 - The graphs below represent cost behavior patterns...Ch. 3 - Starling Co. manufactures one product with a...Ch. 3 - Alard Manufacturing Company has a billing...Ch. 3 - Prob. 28ECh. 3 - Prob. 29ECh. 3 - Natur-Gro, Inc., manufactures composters. Based on...Ch. 3 - Rolertyme Company manufactures roller skates. With...Ch. 3 - St. Teresas Medical Center (STMC) offers a number...Ch. 3 - Big Mikes, a large hardware store, has gathered...Ch. 3 - Kimball Company has developed the following cost...Ch. 3 - The management of Wheeler Company has decided to...Ch. 3 - DeMarco Company is developing a cost formula for...Ch. 3 - Weber Valley Regional Hospital has collected data...Ch. 3 - Friendly Bank is attempting to determine the cost...Ch. 3 - Randy Harris, controller, has been given the...Ch. 3 - The Lockit Company manufactures door knobs for...Ch. 3 - Harriman Industries manufactures engines for the...Ch. 3 - Thames Assurance Company sells a variety of life...
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
- Thayne Company has 30 clerks that work in its Accounts Payable Department. A study revealed the following activities and the relative time demanded by each activity: Required: Classify the four activities as value-added or non-value-added, and calculate the clerical cost of each activity. For non-value-added activities, indicate why they are non-value-added.arrow_forwardThe 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 140,000 Hand-made finishing Packaging and delivery 44,250 The…arrow_forwardPinnacle Inc. has decided to switch from a traditional overhead allocation system to an ABC system. So far, the firm’s managers have decided that Pinnacle needs six different activity cost pools, including one for assembling products. When selecting a driver for this cost pool, Pinnacle’s managers should be sure to select _______ A. the activity that appears to play the greatest role in determining the firm’s product assembly costs. B. the activity that appears to play the greatest role in determining how many units the firm assembles in a given period. C. the product that appears to account for the majority of the costs in the product assembly pool. D. the product that has the highest per-unit assembly cost.arrow_forward
- Scattergraph, High–Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controller's department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows: Month Receiving Orders Receiving Cost ($) 1 1,000 27,000 2 700 22,500 3 1,500 42,000 4 1,200 25,500 5 1,300 37,500 6 1,100 31,500 7 1,600 43,500 8 1,400 36,000 9 1,700 40,500 10 900 24,000 Required: 1. On your own paper, prepare a scattergraph based on the 10…arrow_forward(Appendix 3A) Method of Least Squares Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controller's department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows: Month Receiving Orders Receiving Cost 1 1,000 $18,000 2 700 15,000 3 1,500 28,000 4 1,200 17,000 5 1,300 25,000 6 1,100 21,000 7 1,600 29,000 8 1,400 24,000 9 1,700 27,000 10 900 16,000 Suppose that Tracy has gathered two more months of data: Month Receiving Orders Receiving Cost…arrow_forwardCut It Up, Inc., is a manufacturer of wooden cutting boards that are sold through a chain of kitchen stores. For years, the company has allocated overhead based on total machine hours. A recent assessment of overhead costs has shown that these costs are now in excess of 40 percent of the company’s total costs. As an attempt to better control overhead, Cut It Up is adopting an activity-based costing system. Each cutting board goes through the following processes:a. Cutting—Boards are selected from inventory and are cut to the required width and length. Imperfections in boards (such as knots or cracks) are identified and removed.b. Assembly—Cut wooden pieces are laid out on clamps, a layer of glue is applied to each piece, and the glued pieces are clamped together until the glue sets.c. Shaping—Once the glue has set, the boards are sent to the shaping process, where they are cut into unique shapes.d. Sanding—After being shaped, the cutting boards must be sanded smooth.e. Finishing—Sanded…arrow_forward
- The cost accountant for M. Company wants to determine the cost of factory overhead. Based on observation and discussions with plant workers, you feel that five accounts are most relevant. Two are fixed- supervisory salaries and depreciation- and the remaining three are variable. Indirect labor is primarily used to move materials and varies with a number of moves. The largest component of utilities is electricity to run production machinery; which is driven by machine hours. Purchasing seems to be driven by the number of purchase orders. The accounts and their balances for the past six months are shown below: Indirect Plant and Labor Supervisory Equipment Cost Utilities Purchasing Salaries Depreciation July $14,250 $12,000 $38,200 $20,000 $6,500 Aug 15,800 10,600 35,400 23,000…arrow_forwardGoulburn, Incorporated produces parts for heavy equipment used in mining and construction. The plant that produces one part common to many vehicles is highly automated, so all labor is considered part of factory overhead. The plant manager, who has just been promoted, would like to understand how overhead costs fluctuate in order to improve planning and budgets. After discussions with both financial and operations members of the plant staff, there is general agreement that the best cost driver for overhead is machine-hours. Monthly data were collected from the most recent two years on machine-hours and overhead. More months of data were available, but a process change had taken place about 30 months earlier, so the staff believed any data from before that time would be misleading. The data are shown in the following table: Month Machine-Hours Factory Overhead 1 39,300 $ 527,100 2 37,300 416,500 3 30,100 365,800 4 42,400 498,200 5 50,600 590,700 6 45,500 503,400 7…arrow_forwardGoulburn, Incorporated produces parts for heavy equipment used in mining and construction. The plant that produces one part common to many vehicles is highly automated, so all labor is considered part of factory overhead. The plant manager, who has just been promoted, would like to understand how overhead costs fluctuate in order to improve planning and budgets. After discussions with both financial and operations members of the plant staff, there is general agreement that the best cost driver for overhead is machine-hours. Monthly data were collected from the most recent two years on machine-hours and overhead. More months of data were available, but a process change had taken place about 30 months earlier, so the staff believed any data from before that time would be misleading. The data are shown in the following table: Month 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Machine-Hours 40,300 38,300 31,100 43,400 51,600 46,500 43,400 63,100 37,300 54,700 53,700 37,300 60,900 59,900…arrow_forward
- The cost accountant of L. Rosales, Inc. is considering to use the ABC system in determining the cost of its products. At present, the company uses the traditional costing systems wherein factory overhead costs are allocated based on direct labor hours. This cost accountant believes that the present system may be providing misleading cost information, hence, the plan to change to ABC system. For the coming period, the company is planning to use 5,000 direct labor hours, and its total budgeted factory overhead amounts to P 90,000, broken down as follows: Activity Cost Driver Budgeted Activity Budgeted Cost Sets up cost Number of set ups 40 P 20,000 Production monitoring Number of batches 20 40,000 Quality control Number of inspections 1,000 30,000 Total overhead costs…arrow_forwardThe cost accountant of L. Rosales, Inc. is considering to use the ABC system in determining the cost of its products. At present, the company uses the traditional costing systems wherein factory overhead costs are allocated based on direct labor hours. This cost accountant believes that the present system may be providing misleading cost information, hence, the plan to change to ABC system. For the coming period, the company is planning to use 5,000 direct labor hours, and its total budgeted factory overhead amounts to P 90,000, broken down as follows: Activity Cost Driver Budgeted Activity Budgeted Cost Sets up cost Number of set ups 40 P 20,000 Production monitoring Number of batches 20 40,000 Quality control Number of inspections 1,000 30,000 Total overhead…arrow_forwardEcco Ltd is engaged in the manufacture of components for the computer hardware industry. The factory consists of three production departments, A, B and C and a number of service departments. The costing system uses a single production overhead absorption rate expressed as a percentage of direct labour cost. A newly qualified accountant has just joined the company and has expressed a view that departmental overhead absorption rates would result in more accurate job costs. With this in mind, she has produced the following budgeted information for the next year. The budgeted production overheads in each department are after the allocation of service department costs. (a) State with reasons, whether you agree with the view that ‘departmental overhead absorption rates would result in more accurate job costs’ and outline why a company would calculate predetermined annual overhead absorption rates as opposed to rates calculated from actual weekly or monthly activity and expenditure. (b) (i)…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
Cost Classifications - Managerial Accounting- Fixed Costs Variable Costs Direct & Indirect Costs; Author: Accounting Instruction, Help, & How To;https://www.youtube.com/watch?v=QQd1_gEF1yM;License: Standard Youtube License