Please help me to solve this problem Required:a. Use the high-low method to estimate the fixed and variable portions of overhead costs based on machine-hours.b. Managers expect the plant to operate at a monthly average of 1,500 machine-hours next year. What are the estimated monthlyoverhead costs, assuming no inflation?Complete this question by entering your answers in the tabs below.Required A Required BUse the high-low method to estimate the fixed and variable portions of overhead costs based on machine-hours. (Round"Variable cost" answer to 2 decimal places.)Variable cost (per machine hour)Fixed costRequired ARequired:a. Use the high-low method to estimate the fixed and variable portions of overhead costs based on machine-hours.b. Managers expect the plant to operate at a monthly average of 1,500 machine-hours next year. What are the estimated monthlyoverhead costs, assuming no inflation?Required B >Complete this question by entering your answers in the tabs below.Overhead costsRequired A Required BManagers expect the plant to operate at a monthly average of 1,500 machine-hours next year. What are the estimatedmonthly overhead costs, assuming no inflation?< Required ARequired B > Adriana Corporation manufactures football equipment. In planning for next year, the managers want to understand the relationbetween activity and overhead costs. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours,machine-hours, or both. The following data were collected from last year's operations.Month Labor-Hours1234679101112735725670730785750730735710785675705Machine-Hours1,3511,4181,5151,4561,5871,5821,3801,3121,4511,5451,2041,610Overhead Costs$ 102,759103,790109,938108,327116,155114,400107,079102,103106,331113,00098,444111,303)Required:a. Use the high-low method to estimate the fixed and variable portions of overhead costs based on machine-hours.b. Managers expect the plant to operate at a monthly average of 1,500 machine-hours next year. What are the estimated monthlyoverhead costs, assuming no inflation?

The mixed cost comprises of both fixed and variable costs. The fixed and variable costs can be…

Adriana Corporation manufactures football equipment. In planning for next year, the managers want to understand the between activity and overhead costs. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from last year's operations. Month Labor-Hours Machine-Hours Overhead Costa 1 735 2 10 11 725 670 730 795 750 730 735 710 785 675 705 1,351 1,410 1,515 1,456 1,587 1,502 1,380 1,312 1,451 1,545 1,204 1,618 $102,759 103,790 109,938 108,327 116,155 114,400 107,079 102,103 106,331 113,000 98,444 111,303

Adriana Corporation manufactures football equipment. In planning for next year, the managers want to understand the between activity and overhead costs. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from last year's operations. Month Labor-Hours Machine-Hours Overhead Costa 1 735 2 10 11 725 670 730 795 750 730 735 710 785 675 705 1,351 1,410 1,515 1,456 1,587 1,502 1,380 1,312 1,451 1,545 1,204 1,618 $102,759 103,790 109,938 108,327 116,155 114,400 107,079 102,103 106,331 113,000 98,444 111,303

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter3: Cost Behavior

Section: Chapter Questions

Problem 30E: Natur-Gro, Inc., manufactures composters. Based on past experience, Natur-Gro has found that its...

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?
Firenza Company manufactures specialty tools to customer order. Budgeted overhead for the coming year is: Previously, Sanjay Bhatt, Firenza Companys controller, had applied overhead on the basis of machine hours. Expected machine hours for the coming year are 50,000. Sanjay has been reading about activity-based costing, and he wonders whether or not it might offer some advantages to his company. He decided that appropriate drivers for overhead activities are purchase orders for purchasing, number of setups for setup cost, engineering hours for engineering cost, and machine hours for other. Budgeted amounts for these drivers are 5,000 purchase orders, 500 setups, and 2,500 engineering hours. Sanjay has been asked to prepare bids for two jobs with the following information: The typical bid price includes a 40 percent markup over full manufacturing cost. Required: 1. Calculate a plantwide rate for Firenza Company based on machine hours. What is the bid price of each job using this rate? 2. Calculate activity rates for the four overhead activities. What is the bid price of each job using these rates? 3. Which bids are more accurate? Why?
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?
Communications Jamarcus Bradshaw, plant manager of Georgia Paper Companys papermaking mill, was looking over the cost of production reports for July and August for the Papermaking Department. The reports revealed the following: Jamarcus was concerned about the increased cost per ton from the output of the department. As a result, he asked the plant controller to perform a study to help explain these results. The controller, Leann Brunswick, began the analysis by performing some interviews of key plant personnel in order to understand what the problem might be. Excerpts from an interview with Len Tyson, a paper machine operator, follow: Len: We have two papermaking machines in the department. I have no data, but I think paper machine No. 1 is applying too much pulp and, thus, is wasting both conversion and materials resources. We haven't had repairs on paper machine No. 1 in a while. Maybe this is the problem. Leann: How does too much pulp result in wasted resources? Len: Well, you see, if too much pulp is applied, then we will waste pulp material. The customer will not pay for the extra product; we just use more material to make the product. Also, when there is too much pulp, the machine must be slowed down in order to complete the drying process. This results in additional conversion costs. Leann: Do you have any other suspicions? Len: Well, as you know, we have two productsgreen paper and yellow paper. They are identical except for the color. The color is added to the papermaking process in the paper machine. I think that during August these two color papers have been behaving very differently. I don't have any data, but it just seems as though the amount of waste associated with the green paper has increased. Leann: Why is this? Len: I understand that there has been a change in specifications for the green paper, starting near the beginning of August. This change could be causing the machines to run poorly when making green paper. If this is the case, the cost per ton would increase for green paper. Leann also asked for a database printout providing greater detail on Augusts operating results. September 9 Requested by: Leann Brunswick Papermaking DepartmentAugust detail Prior to preparing a report, Leann resigned from Georgia Paper Company to start her own business. You have been asked to take the data that Leann collected, and write a memo to Jamarcus Bradshaw with a recommendation to management. Your memo should include analysis of the August data to determine whether the paper machine or the paper color explains the increase in the unit cost from July. Include any supporting schedules that are appropriate. Round any calculations to the nearest cent.
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.
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.
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?
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?
Abbey Products Company is studying the results of applying factory overhead to production. The following data have been used: estimated factory overhead, 60,000; estimated materials costs, 50,000; estimated direct labor costs, 60,000; estimated direct labor hours, 10,000; estimated machine hours, 20,000; work in process at the beginning of the month, none. The actual factory overhead incurred for November was 80,000, and the production statistics on November 30 are as follows: Required: 1. Compute the predetermined rate, based on the following: a. Direct labor cost b. Direct labor hours c. Machine hours 2. Using each of the methods, compute the estimated total cost of each job at the end of the month. 3. Determine the under-or overapplied factory overhead, in total, at the end of the month under each of the methods. 4. Which method would you recommend? Why?
Rulers Company is a neon sign company that estimated overhead will be $60,000, consisting of 1,500 machine hours. The cost to make Job 416 is $95 in neon, 15 hours of labor at $13 per hour, and five machine hours. During the month, it incurs $95 in indirect material cost, $130 in administrative labor, $320 in utilities, and $350 in depreciation expense. What is the predetermined overhead rate if machine hours are considered the cost driver? What is the cost of Job 416? What is the overhead incurred during the month?
Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 2,000 direct labor hours. The total indirect labor is budgeted to be 200,000. Time records from indirect labor employees revealed that they spent 30% of their time setting up production runs and 70% of their time supporting actual production. The following information about cell phones and tablet PCs was determined from the corporate records: a. Determine the indirect labor cost per unit allocated to cell phones and tablet PCs under a single plantwide factory overhead rate system using the direct labor hours as the allocation base. b. Determine the budgeted activity costs and activity rates for the indirect labor under activity-based costing. Assume two activitiesone for setup and the other for production support. c. Determine the activity cost per unit for indirect labor allocated to each product under activity-based costing. d. Why are the per-unit allocated costs in (a) different from the per-unit activity cost assigned to the products in (c)?