XYZ Company's accountant is estimating next period's total overhead costs (Y). She performed three regression analyses, the first is based on direct labor hours (DLH), the second is based on machine hours (Mhr), and the third is based on quantity produced (Q). The results were: [Y=$95,000 + $9XDLH; R-square = 0.90]; [Y= $120,000 + $5xMhr; R-square = 0.10]; [Y=190,000+2Q; R-square=0.55]. How much of the variations on the overhead costs is explained by %3D the machine hours (Mhr)? Select one: a. 55% b. None of the answers given c. 90% d. 45%

XYZ Company's accountant is estimating next period's total overhead costs (Y). She performed three regression analyses, the first is based on direct labor hours (DLH), the second is based on machine hours (Mhr), and the third is based on quantity produced (Q). The results were: [Y=$95,000 + $9XDLH; R-square = 0.90]; [Y= $120,000 + $5xMhr; R-square = 0.10]; [Y=190,000+2Q; R-square=0.55]. How much of the variations on the overhead costs is explained by %3D the machine hours (Mhr)? Select one: a. 55% b. None of the answers given c. 90% d. 45%

Name: XYZ Company's accountant is estimating nextperiod's total overhead co
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: XYZ Company's accountant is estimating nextperiod's total overhead costs (Y). She performedthree regression analyses, the first is based ondirect labor hours (DLH), the second is based onmachine hours (Mhr), and the third is based onquantity produce

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter4: Accounting For Factory Overhead

Section: Chapter Questions

Problem 3P: Scattergraph method Using the data in P4-2 and a piece of graph paper: 1. Plot the data points on...

See similar textbooks

Similar questions

Felix & Company reports the following information. Period Units Produced Total Costs 1 0 $2,595 2 400 3,235 3 800 3,875 4 1,200 4,515 5 1,600 5,155 6 2,000 5,795 7 2,400 6,435 8 2,800 7,075 9 3,200 7,715 10 3,600 8,355 Use spreadsheet software to use ordinary least-squares regression to estimate the cost equation, including fixed and variable cost amounts.
The Perize Corporation used regression analysis to predict the annual cost of indirect materials. The results were as follows: Indirect Materials Cost Explained by Units Produced Constant $15,685 Standard error of Y estimate $3,500 r2 0.7832 Number of observations 20 X coefficient(s) 10.25 Standard error of coefficient(s) 2.1876 What is the cost function? Select one: a. Y = $19,185 + $4.48X b. Y = $15,685 + $10.25X c. Y = $12,285 + $10.25X d. Y = $3,500 + $5.15X
Based on analyzing the relationship of total factory overhead (Y) to direct labor hours (X). The following relationship was found: Y = $1,000 + $2X The equation was probably found through the use of which of the following mathematical techniques?
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?
Data table Month Total Cost Machine Hours January.. 3,420 1,090 February..... S 3,760 1,120 March .... $ 3,532 1,080 April ..... 3,720 1,220 May S 4,800 1,330 June 4,192 1,480 .. %24 %24
Question: Use the high-low method to determine the estimating cost function with machine-hours as the cost If July's estimated machine-hours are 4,500, calculate the total estimated operating costs of the Machining Department using the cost function in (a)? Max has used least squares regression analysis to obtain the following output:
The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs = +xBillable Hours X Monthly Overhead Costs and Billable Hours Data (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) Overhead Costs Billable Hours 0 $315,000 3,000 $365,000 4,000 $395,000 5,000 $447,000 6,000 $530,000 7,000 $550,000 8,000
Matching graphs with descriptions of cost and revenue behavior. (D. Green, adapted) Given here are a number of graphs. The horizontal axis of each graph represents the units produced over the year, and the vertical axis represents total cost or revenues. Indicate by number which graph best fits the situation or item described (a–h). Some graphs may be used more than once; some may not apply to any of the situations. Direct material costs Supervisors’ salaries for one shift and two shifts A cost-volume-profit graph Mixed costs—for example, car rental fixed charge plus a rate per mile driven Depreciation of plant, computed on a straight-line basis Data supporting the use of a variable-cost rate, such as manufacturing labor cost of $14 per unit produced Incentive bonus plan that pays managers $0.10 for every unit produced above some level of production Interest expense on $2 million borrowed at a fixed rate of interest
The managing director of a law firm has the monthly data (below) on total overhea labor hours to bill to clients. Develop a simple linear regression model between bi costs. \table [[\table[[Overhead], [Costs]], \table [[Billable], [Hours ]]], [375000, 3000], [425000, 4000], [445000, 5000], [496000, 6000], [580000, 7000], [605000, 8000]] Round the coefficient to two decimal places, do not include the $ symbol. For ea billable hours, the predicted overhead costs are estimated to increase by 109.12
Star, Inc. used Excel to run a least-squares regression analysis, which resulted in the following output: Regression Statistics Multiple R 0.9798 R Square 0.9560 Observations 30 Coefficients Standard Error T Stat P-Value Intercept 174,302 60,902 2.86 0.021 Production (X) 11.06 0.9237 11.97 0.000 What total cost would Star predict for a month in which production is 2,000 units? Multiple Choice $21,419 $62,749 $173,282 $196,422
The "x" in the overhead cost equation, y = $5.50x + $92,000, represents which of the following? total overhead costs. the variable costs. total fixed costs. the cost driver in units.
The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs +(9) x Billable Hours (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) X Monthly Overhead Costs and Billable Hours Data Overhead Costs Billable Hours $315,000 3,000 $360,000 4,000 $385,000 5,000 $438,000 6,000 $520,000 7,000 $540,000 8,000 D Print Done