Mary Ellis owns a small manufacturing company and would like to develop more accurate estimates for overhead expenses whenmaking planning decisions. She is pretty sure that overhead is a mixed cost that varies with direct labour-hours but she would like todo a proper analysis to determine the variable and fixed components. She collected the following information for the past 12 monthson direct labour-hours incurred and total overhead expenses.Total OverheadCostsMonthDirectLabour-HoursJanuary1,500$ 44,000February1,680$47,200March1,800$ 48,000April2,520$51,200May2,700$ 53,600June3,300$ 56,800July3,900$ 59,200August4,500$ 61,600September4,200$60,000October2,700$ 54,400November1,860$ 49,600December3,900$ 58,400Required:1. Using the least-squares regression method, estimate the variable overhead cost per direct labour-hour and the total fixed overheadcost per month. (Round Fixed cost to the nearest whole dollar amount and the Variable cost per direct labour-hour to 2 decimalplaces.)Variable overhead costTotal fixed costper direct labour-hourper month

Name: Mary Ellis owns a small manufacturing company and would like to devel
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: Mary Ellis owns a small manufacturing company and would like to develop more accurate estimates for overhead expenses whenmaking planning decisions. She is pretty sure that overhead is a mixed cost that varies with direct labour-hours but she would

Regression analysis is a statistical method used to analyze the relationship between two or more…

Business

Accounting

Mary Ellis owns a small manufacturing company and would like to develop more accurate estimates for overhead expenses when making planning decisions. She is pretty sure that overhead is a mixed cost that varies with direct labour-hours but she would like to do a proper analysis to determine the variable and fixed components. She collected the following information for the past 12 months on direct labour-hours incurred and total overhead expenses. Direct Total Overhead Month January February March April May Labour-Hours 1,500 1,680 1,800 2,520 2,700 Costs $44,000 $47,200 $ 48,000 $51,200 $53,600 $56,800 ITT June July August September October November December 3,300 3,900 4,500 4,200 2,700 $59,200 $ 61,600 $60,000 1,860 3,900 $ 54,400 $ 49,600 $58,400 Required: 1. Using the least-squares regression method, estimate the variable overhead cost per direct labour-hour and the total fixed overhead cost per month. (Round Fixed cost to the nearest whole dollar amount and the Variable cost per direct labour-hour to 2 decimal places.)

Mary Ellis owns a small manufacturing company and would like to develop more accurate estimates for overhead expenses when making planning decisions. She is pretty sure that overhead is a mixed cost that varies with direct labour-hours but she would like to do a proper analysis to determine the variable and fixed components. She collected the following information for the past 12 months on direct labour-hours incurred and total overhead expenses. Direct Total Overhead Month January February March April May Labour-Hours 1,500 1,680 1,800 2,520 2,700 Costs $44,000 $47,200 $ 48,000 $51,200 $53,600 $56,800 ITT June July August September October November December 3,300 3,900 4,500 4,200 2,700 $59,200 $ 61,600 $60,000 1,860 3,900 $ 54,400 $ 49,600 $58,400 Required: 1. Using the least-squares regression method, estimate the variable overhead cost per direct labour-hour and the total fixed overhead cost per month. (Round Fixed cost to the nearest whole dollar amount and the Variable cost per direct labour-hour to 2 decimal places.)

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter4: Job Order Costing

Section: Chapter Questions

Problem 2PA: York Company Is a machine shop that estimated overhead will be $50,000, consisting of 5,000 hours of...

See similar textbooks

Similar questions

Big Mikes, a large hardware store, has gathered data on its overhead activities and associated costs for the past 10 months. Nizam Sanjay, a member of the controllers department, believes that overhead activities and costs should be classified into groups that have the same driver. He has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more general receiving activity, since these three activities are all driven by the number of receiving orders. The 10 months of data shown below have been gathered for the receiving activity. Required: 1. Prepare a scattergraph, plotting the receiving costs against the number of purchase orders. Use the vertical axis for costs and the horizontal axis for orders. 2. Select two points that make the best fit, and compute a cost formula for receiving costs. 3. Using the high-low method, prepare a cost formula for the receiving activity. 4. Using the method of least squares, prepare a cost formula for the receiving activity. What is the coefficient of determination?
Nutts management is very concerned about the cost of overhead on its jobs. When jobs are complete, overhead costs should be between 15% and 20% of total costs. For example, the labor cost on Job 8958 is 25% of total costs, higher than the norm. Open Job 8961 and click the Chart sheet tab. A pie chart appears showing the cost components on that job. Record the labor cost percentage in the space provided. Repeat this for each of the jobs worked on in August. Did Nutt maintain good cost control on all its jobs? Explain. Worksheet. During September, Job 8963 required two additional material requisitions to complete the job. Open JOB8963 and modify the job cost sheet to include an area for four direct material requisition entries instead of three. Then enter the following two materials requisitions onto the worksheet: Preview the printout to make sure it will print neatly on one page, and then print the worksheet. Save the completed worksheet as JOBT. Chart. Open JOB8964 and click the Chart sheet tab. Prepare a bar chart for JOB8964 showing the amount of material, labor, and overhead required to complete the job. Use the Chart Data Table found in rows 4246 as a basis for preparing the chart. Enter your name somewhere on the chart. Save the file again as J0B8964. Print the chart.
CleanCom Company specializes in cleaning commercial buildings and construction sites. Each building and site is different, requiring amounts and types of supplies and labor for each job. CleanCom estimated the following for the year: During the year, the following actual amounts were experienced: If CleanCom uses a normal costing system and overhead is applied on the basis of direct labor hours, what is the cost of cleaning a construction site that takes 140 of direct materials and 21 direct labor hours? a. 455 b. 508 c. 648 d. 644
Please use the information from this problem for these calculations. After grouping cost pools and estimating overhead and activities, Box Springs determined these rates: Box Springs estimates there will be four orders in the next year, and those jobs will involve: What is the total cost of the jobs?
The controller for Muir Companys Salem plant is analyzing overhead in order to determine appropriate drivers for use in flexible budgeting. She decided to concentrate on the past 12 months since that time period was one in which there was little important change in technology, product lines, and so on. Data on overhead costs, number of machine hours, number of setups, and number of purchase orders are in the following table. Required: 1. Calculate an overhead rate based on machine hours using the total overhead cost and total machine hours. (Round the overhead rate to the nearest cent and predicted overhead to the nearest dollar.) Use this rate to predict overhead for each of the 12 months. 2. Run a regression equation using only machine hours as the independent variable. Prepare a flexible budget for overhead for the 12 months using the results of this regression equation. (Round the intercept and x-coefficient to the nearest cent and predicted overhead to the nearest dollar.) Is this flexible budget better than the budget in Requirement 1? Why or why not?
John Sheng, a cost accountant at Starlet Company, is developing departmental factory overhead application rates for the companys Tooling and Fabricating departments. The budgeted overhead for each department and the data for one job are as follows: Using the departmental overhead application rates, total overhead applied to Job 231 in the Tooling and Fabricating departments will be: a. 225. b. 303. c. 537. d. 671.
San Mateo Optics, Inc., specializes in manufacturing lenses for large telescopes and cameras used in space exploration. As the specifications for the lenses are determined by the customer and vary considerably, the company uses a job-order costing system. Manufacturing overhead is applied to jobs on the basis of direct labor hours, utilizing the absorption- or full-costing method. San Mateos predetermined overhead rates for 20x1 and 20x2 were based on the following estimates. Jim Cimino, San Mateos controller, would like to use variable (direct) costing for internal reporting purposes as he believes statements prepared using variable costing are more appropriate for making product decisions. In order to explain the benefits of variable costing to the other members of San Mateos management team, Cimino plans to convert the companys income statement from absorption costing to variable costing. He has gathered the following information for this purpose, along with a copy of San Mateos 20x1 and 20x2 comparative income statement. San Mateo Optics, Inc. Comparative Income Statement For the Years 20x1 and 20x2 San Mateos actual manufacturing data for the two years are as follows: The companys actual inventory balances were as follows: For both years, all administrative expenses were fixed, while a portion of the selling expenses resulting from an 8 percent commission on net sales was variable. San Mateo reports any over-or underapplied overhead as an adjustment to the cost of goods sold. Required: 1. For the year ended December 31, 20x2, prepare the revised income statement for San Mateo Optics, Inc., utilizing the variable-costing method. Be sure to include the contribution margin on the revised income statement. 2. Describe two advantages of using variable costing rather than absorption costing. (CMA adapted)
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.
Please use the information from this problem for these calculations. After grouping cost pools and estimating overhead and activities, Box Springs determined these rates: It estimates there will be five orders in the next year, and those jobs will involve: What is the total cost of the jobs?
Flaherty, Inc., has just completed its first year of operations. The unit costs on a normal costing basis are as follows: During the year, the company had the following activity: Actual fixed overhead was 12,000 less than budgeted fixed overhead. Budgeted variable overhead was 5,000 less than the actual variable overhead. The company used an expected actual activity level of 12,000 direct labor hours to compute the predetermined overhead rates. Any overhead variances are closed to Cost of Goods Sold. Required: 1. Compute the unit cost using (a) absorption costing and (b) variable costing. 2. Prepare an absorption-costing income statement. 3. Prepare a variable-costing income statement. 4. Reconcile the difference between the two income statements.
Geneva, Inc., makes two products, X and Y, that require allocation of indirect manufacturing costs. The following data were compiled by the accountants before making any allocations: The total cost of purchasing and receiving parts used in manufacturing is 60,000. The company uses a job-costing system with a single indirect cost rate. Under this system, allocated costs were 48,000 and 12,000 for X and Y, respectively. If an activity-based system is used, what would be the allocated costs for each product?
Cynthia Rogers, the cost accountant for Sanford Manufacturing, is preparing a management report that must include an allocation of overhead. The budgeted overhead for each department and the data for one job are as follows: Using the departmental overhead application rates, and allocating overhead on the basis of direct labor hours, overhead applied to Job 231 in the Tooling Department would be: a. 44.00. b. 197.50. c. 241.50. d. 501.00.