The controller of the South Charleston plant of Ravinia, Inc., monitored activities associated with materials handling costs. The high and low levels of resource usage occurred in September and March for three different resources associated with materials handling. The number of moves is the driver. The total costs of the three resources and the activity output, as measured by moves for the two different levels, are presented as follows:
Required:
- 1. Determine the cost behavior formula of each resource. Use the high-low method to assess the fixed and variable components.
- 2. Using your knowledge of cost behavior, predict the cost of each item for an activity output level of 9,000 moves.
- 3. Construct a cost formula that can be used to predict the total cost of the three resources combined. Using this formula, predict the total materials handling cost if activity output is 9,000 moves. In general, when can cost formulas be combined to form a single cost formula?
1.
Calculate the cost behavior formula of each resource use the high to low method to assess the fixed cost and variable components.
Explanation of Solution
High-low method: In the high-low method, the semi variable-cost approximation is calculated by using the exact data points. The high and low activity levels are selected from the data set that is available.
Calculate the cost behavior formula of each resource use the high to low method to assess the variable components.
Calculate variable cost per unit for fuel and oil forklift:
Therefore, variable cost per unit for forklift depreciation is $0 per unit.
Calculate fixed cost:
Note: Number of moves and total cost taken from high cost and high units.
Therefore, total fixed cost is $1,800.
Therefore, variable cost per unit for indirect labor is $4.50 per unit.
Calculate variable cost per unit for fuel and oil forklift:
Note: Number of moves and total cost taken from high cost and high units.
Therefore, total fixed cost is $45,000.
Calculate variable cost per unit for fuel and oil forklift:
Therefore, variable cost per unit for fuel and oil forklift is $0.76 per unit.
Calculate fixed cost.
Note: Number of moves and total cost taken from high cost and high units.
Therefore, total fixed cost is $0.
2.
Predict the cost of each item for an activity output level of 9,000 moves using the knowledge of cost behavior.
Explanation of Solution
Predict the cost of each item for an activity output level of 9,000 moves using the knowledge of cost behavior.
Calculate total cost for forklift depreciation.
Therefore, total cost for forklift depreciation is $1,800.
Calculate total cost for indirect labor.
Therefore, total cost for direct labor is $85,500.
Calculate total cost for fuel and oil for forklift.
Therefore, total cost for fuel and oil for forklift is $6,840.
3.
Construct the cost formula to predict the total cost of the three resources combined, using the formula predict the total material handling cost, if the activity output is 9,000 moves.
Explanation of Solution
Cost equation for material handling cost.
Calculate total cost for material handling if activity output is 9,000 moves.
Therefore, total cost for material handling is $94,140.
Want to see more full solutions like this?
Chapter 3 Solutions
CORNERSTONES OF COST MANAGEMENT
- The management of Wheeler Company has decided to develop cost formulas for its major overhead activities. Wheeler uses a highly automated manufacturing process, and power costs are a significant manufacturing cost. Cost analysts have decided that power costs are mixed; thus, they must be broken into their fixed and variable elements so that the cost behavior of the power usage activity can be properly described. Machine hours have been selected as the activity driver for power costs. The following data for the past eight quarters have been collected: Required: 1. Prepare a scattergraph by plotting power costs against machine hours. Does the scatter-graph show a linear relationship between machine hours and power cost? 2. Using the high and low points, compute a power cost formula. 3. Use the method of least squares to compute a power cost formula. Evaluate the coefficient of determination. 4. Rerun the regression and drop the point (20,000; 26,000) as an outlier. Compare the results from this regression to those for the regression in Requirement 3. Which is better?arrow_forwardYoung Company is beginning operations and is considering three alternatives to allocate manufacturing overhead to individual units produced. Young can use a plantwide rate, departmental rates, or activity-based costing. Young will produce many types of products in its single plant, and not all products will be processed through all departments. In which one of the following independent situations would reported net income for the first year be the same regardless of which overhead allocation method had been selected? a. All production costs approach those costs that were budgeted. b. The sales mix does not vary from the mix that was budgeted. c. All manufacturing overhead is a fixed cost. d. All ending inventory balances are zero.arrow_forwardLonsdale Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated budgeted activity costs and activity bases are as follows: Corporate records were obtained to estimate the amount of activity to be used by the two products. The estimated activity-base usage quantities and units produced follow: a. Determine the activity rate for each activity. b. Use the activity rates in (a) to determine the total and per-unit activity costs associated with each product. Round to the nearest cent.arrow_forward
- The controller for Muir Companys Salem plant is analyzing overhead in order to determine appropriate drivers for use in flexible budgeting. She decided to concentrate on the past 12 months since that time period was one in which there was little important change in technology, product lines, and so on. Data on overhead costs, number of machine hours, number of setups, and number of purchase orders are in the following table. Required: 1. Calculate an overhead rate based on machine hours using the total overhead cost and total machine hours. (Round the overhead rate to the nearest cent and predicted overhead to the nearest dollar.) Use this rate to predict overhead for each of the 12 months. 2. Run a regression equation using only machine hours as the independent variable. Prepare a flexible budget for overhead for the 12 months using the results of this regression equation. (Round the intercept and x-coefficient to the nearest cent and predicted overhead to the nearest dollar.) Is this flexible budget better than the budget in Requirement 1? Why or why not?arrow_forwardSilven Company has identified the following overhead activities, costs, and activity drivers for the coming year: Silven produces two models of cell phones with the following expected activity demands: 1. Determine the total overhead assigned to each product using the four activity drivers. 2. Determine the total overhead assigned to each model using the two most expensive activities. The costs of the two relatively inexpensive activities are allocated to the two expensive activities in proportion to their costs. 3. Using ABC as the benchmark, calculate the percentage error and comment on the accuracy of the reduced system. Explain why this approach may be desirable.arrow_forwardPatterson Company produces wafers for integrated circuits. Data for the most recent year are provided: aCalculated using number of dies as the single unit-level driver. bCalculated by multiplying the consumption ratio of each product by the cost of each activity. Required: 1. Using the five most expensive activities, calculate the overhead cost assigned to each product. Assume that the costs of the other activities are assigned in proportion to the cost of the five activities. 2. Calculate the error relative to the fully specified ABC product cost and comment on the outcome. 3. What if activities 1, 2, 5, and 8 each had a cost of 650,000 and the remaining activities had a cost of 50,000? Calculate the cost assigned to Wafer A by a fully specified ABC system and then by an approximately relevant ABC approach. Comment on the implications for the approximately relevant approach.arrow_forward
- Larsen, Inc., produces two types of electronic parts and has provided the following data: There are four activities: machining, setting up, testing, and purchasing. Required: 1. Calculate the activity consumption ratios for each product. 2. Calculate the consumption ratios for the plantwide rate (direct labor hours). When compared with the activity ratios, what can you say about the relative accuracy of a plantwide rate? Which product is undercosted? 3. What if the machine hours were used for the plantwide rate? Would this remove the cost distortion of a plantwide rate?arrow_forwardPelder Products Company manufactures two types of engineering diagnostic equipment used in construction. The two products are based upon different technologies, X-ray and ultrasound, but are manufactured in the same factory. Pelder has computed the manufacturing cost of the X-ray and ultrasound products by adding together direct materials, direct labor, and overhead cost applied based on the number of direct labor hours. The factory has three overhead departments that support the single production line that makes both products. Budgeted overhead spending for the departments is as follows: Pelders budgeted manufacturing activities and costs for the period are as follows: The budgeted cost to manufacture one ultrasound machine using the activity-based costing method is: a. 225. b. 264. c. 293. d. 305.arrow_forwardAnderson Company has the following departmental manufacturing structure for one of its products: After some study, the production manager of Anderson recommended the following revised cellular manufacturing approach: Required: 1. Calculate the total time it takes to produce a batch of 20 units using Andersons traditional departmental structure. 2. Using cellular manufacturing, how much time is saved producing the same batch of 20 units? Assuming the cell operates continuously, what is the production rate? Which process controls this production rate? 3. What if the processing times of molding, welding, and assembly are all reduced to six minutes each? What is the production rate now, and how long will it take to produce a batch of 20 units?arrow_forward
- Big Mikes, 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 controllers 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?arrow_forwardPinter Company had the following environmental activities and product information: 1. Environmental activity costs 2. Driver data 3. Other production data Required: 1. Calculate the activity rates that will be used to assign environmental costs to products. 2. Determine the unit environmental and unit costs of each product using ABC. 3. What if the design costs increased to 360,000 and the cost of toxic waste decreased to 750,000? Assume that Solvent Y uses 6,000 out of 12,000 design hours. Also assume that waste is cut by 50 percent and that Solvent Y is responsible for 14,250 of 15,000 pounds of toxic waste. What is the new environmental cost for Solvent Y?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
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning