The Solar Panel Solutions manufactures mounting brackets. The overhead costs for manufacturing these brackets include both fixed and variable components. Management wants to analyze these costs and has collected the following data: Units Produced Direct Labor Costs (S) Overhead Costs ($) 200 2,400 3,600 500 6,000 7,500 800 9,600 11,200 100 1,200 2,100 600 7,200 8,400 Calculate the fixed and variable components of the overhead costs using the high-low method.

The Solar Panel Solutions manufactures mounting brackets. The overhead costs for manufacturing these brackets include both fixed and variable components. Management wants to analyze these costs and has collected the following data: Units Produced Direct Labor Costs (S) Overhead Costs ($) 200 2,400 3,600 500 6,000 7,500 800 9,600 11,200 100 1,200 2,100 600 7,200 8,400 Calculate the fixed and variable components of the overhead costs using the high-low method.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter4: Activity-based Costing

Section: Chapter Questions

Problem 4CE: Larsen, Inc., produces two types of electronic parts and has provided the following data: There are...

See similar textbooks

Similar questions

Carboni recently added a carbon line in addition to its aluminum line. The following are estimates to be used in determining the overhead allocation rate for ABC. What would be the predetermined rate for each cost pool?
Potterii sells its products to large box stores and recently added a retail line of products to sell directly to consumers. These estimates are to be used in determining the overhead allocation rate for ABC: What would be the predetermined rate for each cost pool?
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?
Scattergraph method Using the data in P4-2 and a piece of graph paper: 1. Plot the data points on the graph and draw a line by visual inspection, indicating the trend shown by the data points. 2. Determine the variable cost per unit and the total fixed cost from the information on the graph. 3. Determine the variable cost to be charged to the product for the year. 4. Determine the fixed cost to be charged to factory overhead for the year. 5. Do these answers agree with the answers to P4-2? Why or why not?
Which of the following costs would be classified as variable and which would be classified as fixed, if units produced is the activity base? A. Direct materials costs B. Electricity costs of 0.35 per kilowatt-hour
The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor availability, labor utilization, and product profitability: a. Develop a linear programming model of the Hartman Company problem. Solve the model to determine the optimal production quantities of products 1 and 2. b. In computing the profit contribution per unit, management does not deduct labor costs because they are considered fixed for the upcoming planning period. However, suppose that overtime can be scheduled in some of the departments. Which departments would you recommend scheduling for overtime? How much would you be willing to pay per hour of overtime in each department? c. Suppose that 10, 6, and 8 hours of overtime may be scheduled in departments A, B, and C, respectively. The cost per hour of overtime is 18 in department A, 22.50 in department B, and 12 in department C. Formulate a linear programming model that can be used to determine the optimal production quantities if overtime is made available. What are the optimal production quantities, and what is the revised total contribution to profit? How much overtime do you recommend using in each department? What is the increase in the total contribution to profit if overtime is used?
Electan Company produces two types of printers. The company uses ABC, and all activity drivers are duration drivers. Electan Company is considering using DBC and has gathered the following data to help with its decision. A. Activities with duration drivers: B. Activities with consumption ratios and costs: C. Products with cycle time and practical capacity: Required: 1. Using cycle time and practical capacity for each product, calculate the total time for all primary activities. Comment on the relationship to ABC. 2. Calculate the overhead rate that DBC uses to assign costs. Comment on the relationship to a unit-based plantwide overhead rate. 3. Use the overhead rate calculated in Requirement 2 to calculate (a) the overhead cost per unit for each product, and (b) the total overhead assigned to each product. How does this compare to the ABC assignments shown in Part B of the Information set? 4. What if the units actually produced were 10,000 for Printer A and 18,000 for Printer B. Using DBC, calculate the cost of unused capacity.
The cost behavior patterns below are lettered A through H. The vertical axes of the graphs represent total dollars of expense, and the horizontal axes represent production in units, machine hours, or direct labor hours. In each case, the zero point is at the intersection of the two axes. Each graph may be used no more than once. Required: Select the graph that matches the lettered cost described here. a. Depreciation of equipmentthe amount of depreciation charged is computed based on the number of machine hours that the equipment was operated. b. Electricity billflat fixed charge, plus a variable cost after a certain number of kilowatt hours are used. c. City water billcomputed as follows: d. Depreciation of equipmentthe amount is computed by the straight-line method. e. Rent on a factory building donated by the citythe agreement calls for a fixed fee payment, unless 200,000 labor hours are worked, in which case no rent need be paid. f. Salaries of repair workersone repair worker is needed for every 1,000 machine hours or less (i.e., 0 to 1,000 hours requires one repair worker, 1,001 to 2,000 hours requires two repair workers, etc.).
Silven 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.
The company is considering using a two-stage cost allocation system and wants to assess the effects on reported product profits. The company is considering using Engineering Hours and Users as the allocation base. Additional information follows. Toot! TiX Total Engineering hours 7,650 5,650 13,300 Users 9,500 17,100 26,600 Engineering – hour related administrative cost $ 114,380 User-related administrative cost $…
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
For each of the following costs, identify whether it is a Fixed, Variable or Both: Cost Wages of assembly-line workers Depreciation-office equipment Glue and fasteners Delivery costs Raw materials handling costs Salary of marketing manager Production run setup costs Plant utilities Electricity cost of manufacturing plant Research and development expenses Type