Alpine Manufacturing has collected the following data concerning its electricity costs for the past 6 months. Month Machine Hours Total Cost January 1,250 $4,375 February 1,850 $5,675 March 2,100 $6,250 April 1,500 $4,875 May 2,350 $6,825 June 1,950 $5,925 Compute the fixed and variable cost elements using the high-low method.

Alpine Manufacturing has collected the following data concerning its electricity costs for the past 6 months. Month Machine Hours Total Cost January 1,250 $4,375 February 1,850 $5,675 March 2,100 $6,250 April 1,500 $4,875 May 2,350 $6,825 June 1,950 $5,925 Compute the fixed and variable cost elements 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 22E: Silven Company has identified the following overhead activities, costs, and activity drivers for the...

See similar textbooks

Similar questions

Sunland Co. gathered the following information on power costs and factory machine usage for the last six months: Month January February March April May June (a) Power Cost $28,390 (b) 36,069 32,895 26,235 (c) 23,890 20,700 Your answer is correct. Variable power costs $ Using the high-low method of analyzing costs, answer the following questions and show computations to support your answers. eTextbook and Media Your answer is correct. Factory Machine Hours What is the estimated variable portion of power costs per factory machine hour? (Round answer to 2 decimal places, e.g. 15.25.) Fixed power costs $ eTextbook and Media 15,800 21,400 Total power cost $ 18,700 High 15,100 13,500 What is the estimated fixed power cost each month? 10,500 1.41 5,895 per factory machine hour Low 5,895 If it is estimated that 13,800 factory machine hours will be run in July, what is the expected total power cost for July?
The following 6 months of data were collected on electricity cost and the number of machine hours in a factory. Electricity Machine Month cost hours June $25,160 4,500 July 26,170 4,810 August 27,250 5,120 September 26,680 5,010 October 27,950 5,430 November 27,500 5,190 An independent variable value used in calculating the cost line using the high-low method is: a. $27,950 b. 5,430 c. $25,160 d. 4,000
At the high level of activity in November, 10,300 machine hours were run and power costs were $20,600. In April, a month of low activity, 3,800 machine hours were run and power costs amounted to $8,000. Using the high-low method, the estimated fixed cost element of power costs is __. ???
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.
During the week of August 21, Parley Manufacturing produced and shipped 4,000 units of its machine tools: 1,500 units of Tool SK1 and 2,500 units of Tool SK3. The cycle time for SK1 is 0.73 hour, and the cycle time for SK3 is 0.56 hour. The following costs were incurred: Required: 1. Assume that the value-stream costs and total units shipped apply only to one model (a single-product value stream). Calculate the unit cost, and comment on its accuracy. 2. Assume that Tool SK1 is responsible for 60% of the materials cost. Calculate the unit cost for Tool SK 1 and Tool SK3, and comment on its accuracy. Explain the rationale for using units shipped instead of units produced in the calculation. 3. Calculate the unit cost for the two models, using DBC. Explain when and why this cost is more accurate than the unit cost calculated in Requirement 2.
Identify cost graphs The following cost graphs illustrate various types of cost behavior: For each of the following costs, identify the cost graph that best illustrates its cost behavior as the number of units produced increases: A. Total direct materials cost B. Electricity costs of 1,000 per month plus 0.10 per kilowatt-hour C. Per-unit cost of straight-line depreciation on factory equipment D. Salary of quality control supervisor, 20,000 per month E. Per-unit direct labor cost
Patterson 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.
Cool Pool has these costs associated with production of 20,000 units of accessory products: direct materials, $70; direct labor, $110; variable manufacturing overhead, $45; total fixed manufacturing overhead, $800,000. What is the cost per unit under both the variable and absorption methods?
The following product costs are available for Kellee Company on the production of eyeglass frames: direct materials, $32,125; direct labor, $23.50; manufacturing overhead, applied at 225% of direct labor cost; selling expenses, $22,225; and administrative expenses, $31,125. The direct labor hours worked for the month are 3,200 hours. A. What are the prime costs? B. What are the conversion costs? C. What is the total product cost? D. What is the total period cost? E. If 6.425 equivalent units are produced, what is the equivalent material cost per unit? F. What is the equivalent conversion cost per unit?
Plata Company has identified the following overhead activities, costs, and activity drivers for the coming year: Plata produces two models of microwave ovens with the following activity demands: The companys normal activity is 21,000 machine hours. Calculate the total overhead cost that would be assigned to Model X using an activity-based costing system: a. 230,000 b. 240,000 c. 280,000 d. 190,000
Bumblebee Mobiles manufactures a line of cell phones. The management has identified the following overhead costs and related cost drivers for the coming year. The following were incurred in manufacturing two of their cell phones, Bubble and Burst, during the first quarter. REQUIREMENT Review the worksheet called ABC that follows these requirements. You have been asked to determine the cost of each product using an activity-based cost system. Note that the problem information is already entered into the Data Section of the ABC worksheet.
SmokeCity, Inc., manufactures barbeque smokers. Based on past experience, SmokeCity has found that its total annual overhead costs can be represented by the following formula: Overhead cost = 543,000 + 1.34X, where X equals number of smokers. Last year, SmokeCity produced 20,000 smokers. Actual overhead costs for the year were as expected. Required: 1. What is the driver for the overhead activity? 2. What is the total overhead cost incurred by SmokeCity last year? 3. What is the total fixed overhead cost incurred by SmokeCity last year? 4. What is the total variable overhead cost incurred by SmokeCity last year? 5. What is the overhead cost per unit produced? 6. What is the fixed overhead cost per unit? 7. What is the variable overhead cost per unit? 8. Recalculate Requirements 5, 6, and 7 for the following levels of production: (a) 19,500 units and (b) 21,600 units. (Round your answers to the nearest cent.) Explain this outcome.