Answered: 1. What is the cost equation for…

1. What is the cost equation for maintenance costs using the high-low method? 2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter2: Building Blocks Of Managerial Accounting

Section: Chapter Questions

Problem 9EA: The cost data for Evencoat Paint for the year 2019 is as follows: Using the high-low method, express...

See similar textbooks

Similar questions

Horton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the previous fiscal year for maintenance costs and machine hours follow: Month 1 3 4 6 7 8 9 10 11 12 Maintenance Costs Machine Hours $ 2,665 2,710 2,760 2,860 2,895 3,045 2,905 2,945 2,820 2,610 2,630 2,930 Maintenance cost 1,566 1,670 1,685 1,735 1,855 1,890 1,865 1,885 1,775 1,450 1,630 1,465 Required: 1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (unit variable cost)" to 4 decimal places. Enter the…
Horton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the previous fiscal year for maintenance costs and machine hours follow: Month Maintenance Costs Machine Hours $ 2,695 2,740 2,790 2,890 2,925 3,025 2,935 1 2 3 4 56789012 10 11 2,975 2,850 2,640 2,660 2,960 Maintenance cost 1,620 1,730 1,745 1,795 1,790 1,890 1,810 1,845 1,835 1,480 1,690 1,495 Required: 1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (uni variable cost)" to 4 decimal places. Enter the "slope…
Horton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the previous fiscal year for maintenance costs and machine hours follow: Month Maintenance Costs Machine Hours $ 2,665 2,710 2,760 1 2 3 4 6 7 8 9 10 11 12 2,860 2,895 Maintenance cost 3,045 2,905 2,945 2,820 2,610 2,630 2,930 1,566 1,670 1,685 1,735 1,855 1,890 1,865 1,885 1,775 1,450 1,630 1,465 Required: 1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (unit variable cost)" to 4 decimal places. Enter the…
The controller of Sandhill Industries has collected the following monthly cost data for use in analyzing the behavior of maintenance costs. Month January February March April May June (a1) Total Maintenance Costs $2,880 3,273 3,928 4,632 3,491 4,844 X Your answer is incorrect. Total Machine Hours 3,820 Variable cost per machine hour $ 4,364 6,546 8,619 5,455 8,730 Determine the unit variable costs using the high-low method for this mixed cost. (Round answer to 2 decimal places e.g. 2.25.) 1352
Barkoff Enterprises, which uses the high-low method to analyze cost behavior, has determined that machine hours best explain the company's utilities cost. The company's relevant range of activity varies from a low of 600 machine hours to a high of 1,100 machine hours, with the following data being available for the first six months of the year: Month Utilities Machine Hours January $8,700 800 February 8,360 720 March 8,950 810 April 9,360 920 May 9,625 950 June 9,150 900 The variable utilities cost per machine hour for Barkoff is: Select one: a. $5.00. b. $4.50. c. $0.18 d. $5.50.e. None of the answers is correct.
Jake's Roof Repair has provided the following data concerning its costs: Fixed Cost Cost per Repair-Hour per Month Wages and salaries Parts and supplies $ 21,200 $15.00 $ 7.80 $ 0.55 $ 1.80 $ 2,740 $ 5,780 $ 4,610 $ 3,840 Equipment depreciation Truck operating expenses Rent Administrative expenses $ 0.40 For example, wages and salaries should be $21,200 plus $15.00 per repair-hour. The company expected to work 2,500 repair-hours in May, but actually worked 2,400 repair-hours. The company expects its sales to be $47.00 per repair-hour. Required: Compute the company's activity variances for May. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Jake's Roof Repair Activity Variances For the Month Ended May 31 Revenue Expenses: Wages and salaries Parts and supplies Equipment depreciation Truck operating expenses Rent Administrative expenses Total expense Net…
Vinubhai
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?
Ruby Company manufactures and sells a single product. The company's sales and expenses for last year follow: ss attached
Hicks Contracting collects and analyzes cost data in order to track the cost of installing decks on new home construction jobs. The following are some of the costs that they incur. Classify these costs as fixed or variable costs and as product or period costs. Lumber used to construct decks ($12.00 per square foot) Carpenter labor used to construct decks ($10 per hour) Construction supervisor salary ($45,000 per year) Depreciation on tools and equipment ($6,000 per year) Selling and administrative expenses ($35,000 per year) Rent on corporate office space ($34,000 per year) Nails, glue, and other materials required to construct deck (varies per job)
Ventana Window and Wall Treatments Company provides draperies, shades, and various window treatments. Ventana works with the customer to design the appropriate window treatment, places the order, and installs the finished product. Direct materials and direct labor costs are easy to trace to the jobs. Ventanas income statement for last year is as follows: Ventana wants to find a markup on cost of goods sold that will allow them to earn about the same amount of profit on each job as was earned last year. Required: 1. What is the markup on cost of goods sold (COGS) that will maintain the same profit as last year? (Round the percentage to two significant digits.) 2. A customer orders draperies and shades for a remodeling job. The job will have the following costs: What is the price that Ventana will quote given the markup percentage calculated in Requirement 1? (Round the price to the nearest dollar.) 3. What if Ventana wants to calculate a markup on direct materials cost, since it is the largest cost of doing business? What is the markup on direct materials cost that will maintain the same profit as last year? (Round the percentage to two significant digits.) What is the bid price Ventana will use for the job given in Requirement 2 if the markup percentage is calculated on the basis of direct materials cost? (Round to the nearest dollar.)
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.