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

Muffler Incorporated produces floor mats for cars and trucks. The owner, Kenneth Muffler, asked you to assist him in estimating his maintenance costs. Together, Mr. Muffler and you determined that the single best cost driver for maintenance costs was machine hours. Below are data from the previous fiscal year for maintenance expense and machine hours: Month 1 2 3 456789 10 11 12 Maintenance Expense $ 3,280 3,470 3,650 3,780 3,780 4,000 Multiple Choice O $1.44. Using the high-low method, unit variable cost is calculated to be: $1.61. $1.66. 3,770 3,580 3,300 2,960 2,860 3,040 $1.50. Machine Hours 2,280 2,380 2,480 2,510 2,360 2,530 2,500 2,470 2,290 2,160 1,770 2,150
Felinas Inc. produces floor mats for cars and trucks. The owner, Kenneth Felinas, asked you to assist him in estimating his maintenance costs. Together, Mr. Felinas and you determined that the single best cost driver for maintenance costs was machine hours. Below are data from the previous fiscal year for maintenance expense and machine hours: Maintenance Machine Month Expense Hours 1 $ 3,120 2,200 3,310 2,300 3 3,490 2,400 4 3,620 2,430 3,620 2,280 3,680 2,440 7 3,610 2,420 8 3,420 2,390 3,140 2,210 10 2,880 2,080 11 2,780 1,690 12 2,940 2,070 Using the high-low method, total monthly fixed cost is calculated to be: LO
Muffler Incorporated produces floor mats for cars and trucks. The owner, Kenneth Muffler, asked you to assist him in estimating his maintenance costs. Together, Mr. Muffler and you determined that the single best cost driver for maintenance costs was machine hours. Below are data from the previous fiscal year for maintenance expense and machine hours: Maintenance Expense Month Machine Hours 1 $ 3,360 2,320 234 2 3,550 2,420 3,730 2,520 3,860 2,550 5 3,860 2,400 6 4,160 2,560 7 3,850 2,540 8 3,660 2,510 9 3,380 2,330 10 3,000 2,200 11 2,900 1,710 12 3,120 2,190 Using the high-low method, total monthly fixed cost is calculated to be (Round final answer to full dollar amount with no decimal places): Multiple Choice
Ethan Manufacturing Incorporated produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: 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. Month Maintenance Costs Machine Hours 1 $ 2,660 1,750 2 2,820 1,830 3 2,970 1,910 4 3,080 1,930 5 3,160 1,960 6 3,130 1,940 7 3,070 1,920 8 2,910 1,900 9 2,680 1,760 10 2,280 1,160 11 2,290 1,360 12 2,510 1,650
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…
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.
The cost data for Evencoat Paint for the year 2019 is as follows: Using the high-low method, express the companys maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Predict the maintenance costs i190,000 gallons of paint are produced. Predict the maintenance costs if 81,000 gallons of paint are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between gallons of paint produced and equipment maintenance expenses.
This cost data from Hickory Furniture is for the year 2017. Using the high-low method, express the factory utility expenses as an equation where x represents number of chairs produced. Predict the utility costs if 900 chairs are produced. Predict the utility costs if 750 chairs are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between number of chairs processed and utility expenses.
Jean and Tom Perritz own and manage Happy Home Helpers, Inc. (HHH), a house-cleaning service. Each cleaning (cleaning one house one time) takes a team of three house cleaners about 1.5 hours. On average, HHH completes about 15,000 cleanings per year. The following total costs are associated with the total cleanings: Required: 1. Calculate the prime cost per cleaning. 2. Calculate the conversion cost per cleaning. 3. Calculate the total variable cost per cleaning. 4. Calculate the total service cost per cleaning. 5. What if rent on the office that Jean and Tom use to run HHH increased by 1,500? Explain the impact on the following: a. Prime cost per cleaning b. Conversion cost per cleaning c. Total variable cost per cleaning d. Total service cost per cleaning
Roper Furniture manufactures office furniture and tracks cost data across their process. The following are some of the costs that they incur. Classify these costs as fixed or variable costs, and as product costs or period costs. Wood used to produce desks ($125,00 per desk) Production labor used to produce desks ($15 per hour) Production supervisor salary ($45,000 per year) Depreciation on factory equipment ($60,000 per year) Selling and administrative expenses ($45,000 per year) Rent on corporate office ($44,000 per year) Nails, glue, and other materials required to produce desks (varies per desk) Utilities expenses for production facility Sales staff commission (5% of gross sales)