The managing director of a law firm has the monthly data (below) on total overhealabor hours to bill to clients. Develop a simple linear regression model between bilcosts.Overhead BillableCostsHours375000300042500040004450005000496000600058000070008000605000Round the coefficient to two decimal places, do not include the $ symbol. For eabillable hours, the predicted overhead costs are estimated to increase by109.12 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

Let X = Billable Hours Let Y = Overhead Costs Mx = Mean of x and My = Mean of Y Summary of the data…

Answered: The managing director of a law firm has…

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter2: Building Blocks Of Managerial Accounting

Section: Chapter Questions

Problem 9EB: The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method,...

See similar textbooks

Similar questions

We have seen how cost and volume assumptions affect net income. A common application of CVP analysis is a tool to forecast sales, costs, and income. Assume that you are actively searching for a job. Identify and discuss three assumptions relating to your expected revenue (salary), and three assumptions related to your expected costs (expenses) for the first year of your new job.
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
Several important assumptions underlie CVP analysis. Assumptions often help simplify and focus our analysis of sales and costs. A common application of CVP analysis is as a tool to forecast sales, costs, and income. Required Assume that you are actively searching for a job. Prepare a half-page report identifying (1) three assumptions relating to your expected revenue (salary) and (2) three assumptions relating to your expected costs for the first year of your new job. Be prepared to discuss your assumptions in class.
1. Create a new Excel sheet in which you will find the delivery cost for each delivery. a. Create a new sheet that has information for each delivery. Name this sheet "lookup." b. In this lookup sheet, look up the hourly rate for the driver for each delivery. Do not enter this information manually! Use the VLOOKUP function. c. For each delivery, calculate the delivery cost as hourly rate for the driver multiplied by time (hours). Fill in the table below for the first ten records. Date Delivery ID Driver Time (Hours) Hourly Rate Cost 20.00 X 1 George 1 1/1 25.00 X 2 Deanna 1.5 1/2 2 3 Ben 1/3 4 Caroline 2 1/3 5 Unknown 1 1/4 6 Elizabeth 2 1/5 1/5 7 Unknown 2.5 8 Unknown 1 1/6 9 Adam 2 1/8 10 Hannah 1.5 1/9 2. Create a new Excel sheet that aggregates the data contained in the lookup sheet to show each driver's activity analysis. a. Create a pivot table in a new sheet; name this new sheet "pivot table."
The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method, express the companys overtime wages as an equation where x represents number of invoices processed. Assume BC has monthly fixed costs of $3,800. Predict the overtime wages if 9,000 invoices are processed. Predict the overtime wages if 6,500 invoices are processed. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of invoices processed and overtime wage expense.
Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?
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…
Tom uses his computer to calculate the following regression formula:Weekly total costs = $18,791 + ($19.97 * Number of orders per week) Draw the regression line on your graph. Use your graph to evaluate the regression line using the criteria of economic plausibility, goodness of fit, and significance of the independent variable. Is the cost function estimated using the high-low method a close approximation of the cost function estimated using the regression method? Explain briefly.
Hello question is attached, thanks.
Assume that you are the president of your company and paid a year-end bonus according to the amount of net income earned during the year. When prices are rising, would you choose a FIFO or weighted average cost flow assumption? Explain, using an example to support your answer. Would your choice be the same if prices were falling? I need an example with net income for weighted average
Identifying Fixed, Variable, Mixed, and Step Costs Consider each of the following independent situations: a. A computer service agreement in which a company pays 150 per month and 15 per hour of technical time b. Fuel cost of the companys fleet of motor vehicles c. The cost of beer for a bar d. The cost of computer printers and copiers at your college e. Rent for a dental office f. The salary of a receptionist in a law firm g. The wages of counter help in a fast-food restaurant h. The salaries of dental hygienists in a three-dentist office. One hygienist can take care of 120 cleanings per month. i. Electricity cost which includes a 15 per month billing charge and an additional amount depending on the number of kilowatt-hours used Required: 1. For each situation, describe the cost as one of the following: fixed cost, variable cost, mixed cost, or step cost. (Hint: First, consider what the driver or output measure is. If additional assumptions are necessary to support your cost type decision, be sure to write them down.) Example: Raw materials used in productionVariable cost 2. CONCEPTUAL CONNECTION Change your assumption(s) for each situation so that the cost type changes to a different cost type. List the new cost type and the changed assumption(s) that gave rise to it. Example: Raw materials used in production. Changed assumptionthe materials are difficult to obtain, and a years worth must be contracted for in advance. Now, this is a fixed cost. (This is the case with diamond sales by DeBeers Inc. to its sightholders. See the following website for information: www.keyguide.net/sightholders/.)
Assume that you are the president of your company and paid a year-end bonus according to the amount of net income earned during the year. When prices are rising, would you choose a FIFO or weighted average cost flow assumption? Explain, using an example to support your answer. Would your choice be the same if prices were falling?

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:

Cengage Learning

PAYROLL ACCT., 2019 ED.(LL)-TEXT

Accounting

ISBN:

9781337619783

Author:

BIEG

Publisher:

CENGAGE L

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Essentials of Business Analytics (MindTap Course …

Statistics

ISBN:

9781305627734

Author:

Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS