The controller of Cullumber Industries has collected the following monthily expense data for analyzing the cost behavior of electricity costs. Total Total Electricity Costs Machine Hours January $1890 270 February 2.970 360 March 3,400 470 April 4,610 685 May 3.220 440 June 4,910 710 July 4,120 645 August 3.880 530 September 5.160 660 October 4,380 620 November 3,240 360 December 6,290 730 (a) Determine the fixed-and variable-cost components using regression analysis (We recommend the use of Excel) (Round fixed cost to 3 decimal places es. 1.252 and variable cost to 5 decimal places eg. 1.25125.) Fixed costs Variable-cost

The controller of Cullumber Industries has collected the following monthily expense data for analyzing the cost behavior of electricity costs. Total Total Electricity Costs Machine Hours January $1890 270 February 2.970 360 March 3,400 470 April 4,610 685 May 3.220 440 June 4,910 710 July 4,120 645 August 3.880 530 September 5.160 660 October 4,380 620 November 3,240 360 December 6,290 730 (a) Determine the fixed-and variable-cost components using regression analysis (We recommend the use of Excel) (Round fixed cost to 3 decimal places es. 1.252 and variable cost to 5 decimal places eg. 1.25125.) Fixed costs Variable-cost

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter7: Allocating Costs Of Support Departments And Joint Products

Section: Chapter Questions

Problem 30E: A company uses charging rates to allocate service department costs to the using departments. The...

See similar textbooks

Similar questions

E19-3 The controller of Furgee Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Total Maintenance Costs Total Machine Hours Month January February March $2,500 3,000 3,600 4,500 3,200 4,900 300 350 500 April May 690 400 June 700 Instructions (a)) Determine the fixed- and variable-cost components using the high-low method. (b) Prepare a graph showing the behavior of maintenance costs, and identify the fixed- and variable-cost elements. Use 100-hour increments and $1,000 cost increments.
The controller of the Blade Company wants you to estimate a cost function from the following two observations in a general ledger account called Maintenance: (Click to view the information.) Required 1. Estimate the cost function for maintenance. 2. Can the constant in the cost function be used as an estimate of fixed maintenance cost per month? Explain. Requirement 1. Estimate the cost function for maintenance. (Round your answers to the nearest cent as needed.) Maintenance costs = Maintenance costs = +( +( X X Requirement 2. Can the constant in the cost function be used as an estimate of fixed maintenance cost per month? Explain. the relevant range, not at cost levels the relevant range. If there are no months with zero The cost function in requirement 1 is an estimate of how costs behave machine-hours represented in the maintenance account, data in that account function provides the best available starting point for a straight line that approximates how a cost behaves be used to…
a. Calculate the cost of goods manufactured for the year by Gopaul Electronics b.) Prepare an income statement for Gopaul Electronics for the year ended December 31, 2023, clearly showing the calculation of Cost of Goods Sold. List the non-production overheads in order of size starting with the largest. c) What is the selling price per switch if Gopaul Electronics manufactured 1,500 switches for the period under review and uses a mark-up of 33⅓% on cost?
1. The following information was reported for Gray Enterprises on December 31, 2020.Manufacturing Overhead Debit Credit 3,410 51,520 15,030 37,090 Double line4,010 Double line A. What is the actual manufacturing overhead? B. What is the allocated manufacturing overhead? C. Is manufacturing overhead underallocated or overallocated? D. Prepare the adjusting entry.Journal Date Description Debit Credit Dec. 31, 20 Dec. 31, 20 2. The following information was reported for Gray Enterprises on December 31, 2021.Manufacturing Overhead Debit Credit 2,020 56,340 15,540 31,920 Double line Double line6,860 A. What is the actual manufacturing overhead? B. What is the allocated manufacturing overhead? C. Is manufacturing overhead underallocated or overallocated? D. Prepare the adjusting entry.Journal Date Description Debit Credit Dec. 31, 20 Dec. 31, 20
Bubba Manufacturing Company provided the following information for the fiscal year toJune 30, 2020:Inventories 01/07/2019 30/06/2020Direct MaterialsWork-in-ProcessFinished Goods$72,000107,000149,500$65,000128,000141,700Other information:Office cleaner’s wages 4,500Sales Revenue 1,031,000Raw materials purchased 235,000Factory wages 239,700Indirect materials 23,500Delivery truck driver’s wages 15,400Indirect labor 9,500Depreciation on factory plant & equipment 32,000Insurance 1 60,000Depreciation on delivery truck 7,250Utilities 2 118,750Administrative salaries 41,250Special Design Costs 5,000Selling expenses 9,000Sales Commission 2% of gross profit1 Of the total insurance, 66⅔% relates to the factory facilities & 33⅓% relates to general& administrative costs.2 Of the total utilities, 80% relates to the manufacturing facilities & 20% relates to theoffice area.Requirements:a) What was the amount of direct materials used in production?b) What was the amount of manufacturing…
Determine fixed and variable costs using the high-low method and prepare graph. E2.26 (LO 3) The controller of Furgee Industries has collected the following monthly expense data for use in analyzing the cost behaviour of maintenance costs. Total Maintenance Costs Total Machine Hours Month January February March April May June $2,500 3,000 3,600 4,500 3,200 4,900 300 350 500 690 400 700 Instructions a. Determine the fixed and variable cost components using the high-low method. b. Prepare a graph showing the behaviour of maintenance costs, and identify the fixed and variable cost components. Use 100-hour increments and $1,000 cost increments.
The following information is given for Gator Company, who uses the FIFO method. Item Quantity Cost NetRealizableValue ReplacementCost NRVMinusNormalProfit 1 1 $17.70 $24.60 $18.00 $17.10 2 1 10.80 8.28 9.30 5.58 3 1 72.00 64.80 67.20 57.60 4 1 4.80 3.12 2.88 2.64 5 1 12.00 12.30 12.60 11.10 6 1 48.00 45.60 38.40 40.80 Required: a. Determine the lower of cost or net realizable value for each inventory item for Gator Company. Item 1 2 3 4 5 6 b. Determine the lower of cost or net realizable value for Gator Company's inventory if the lower of cost or net realizable value rule is applied to the total inventory.$_______
The following figures have been extracted from the records of Necon manufacturing companyfor the year ending 31st December, 2019. You are required to prepare a statement of costshowing : (a) Cost of raw materials consumed(b) Prime Cost (c) Factory Cost(d) Cost of production(e) Cost of goods sold (f)Total cost of goods sold and profit on sales. $Stock of Raw Materials (1-1-19) 3,000Stock of Raw Materials (31-12-19) 2,400Purchases of Raw materials 14,000Stock of work-in-progress (1-1-19) 1,000Stock of work-in-progress (31-12-19) 800Carriage inward 500Manufacturing wages 4,000Other direct expenses 200Indirect wages 1,000Experiment expenses 400Wastage of materials…
Assume the following data for Eim Alex Company for the years 2019, 2020, and 2021. Year Lifting.(Production) Costs (excluding DD&A) DD&A Production bbl 2019 750,000 855,000 325,000 2020 685,000 787,000 297,000 2021 578,000 729,000 362,000 Compute the DD&A per BOE for 2019. O 2.6308 2.6380 2.3680
Goggles Company has the following information for the year 2019:Total manufacturing costs .....................P5,621,000Total nonmanufacturing costs ............... 2,370,000Factory overhead .................................... 1,859,400Direct materials used ............................. 1,506,200Indirect materials used .......................... 564,900 1.How much is the prime cost for the year? explanation 2.Compute for the conversion cost? explanation 3.Calculate direct labor employed for the year? explanation
Goggles Company has the following information for the year 2019:Total manufacturing costs .....................P5,621,000Total nonmanufacturing costs ............... 2,370,000Factory overhead .................................... 1,859,400Direct materials used ............................. 1,506,200Indirect materials used .......................... 564,900 How much is the prime cost for the year? Compute for the conversion cost Calculate direct labor employed for the year How much is your product cost?
The following information is given for Gator Company, who uses the FIFO method. Item Quantity Cost NetRealizableValue ReplacementCost NRVMinusNormalProfit 1 1 $17.70 $24.60 $18.00 $17.10 2 1 10.80 8.28 9.30 5.58 3 1 72.00 64.80 67.20 57.60 4 1 4.80 3.12 2.88 2.64 5 1 12.00 12.30 12.60 11.10 6 1 48.00 45.60 38.40 40.80 Required: a. Determine the lower of cost or net realizable value for each inventory item for Gator Company. Item 1 $fill in the blank 1 2 $fill in the blank 2 3 $fill in the blank 3 4 $fill in the blank 4 5 $fill in the blank 5 6 $fill in the blank 6 b. Determine the lower of cost or net realizable value for Gator Company's inventory if the lower of cost or net realizable value rule is applied to the total inventory. $fill in the blank 7