Concept explainers
Interpretation of Regression Results: Simple Regression
Your company is preparing an estimate of its production costs for the coming period. The controller estimates that direct materials costs are $45 per unit and that direct labor costs are $21 per hour. Estimating overhead, which is applied on the basis of direct labor costs, is difficult.
The controller’s office estimated overhead costs at $3,600 for fixed costs and $18 per unit for variable costs. Your colleague, Lance, who graduated from a rival school, has already done the analysis and reports the “correct” cost equation as follows:
Overhead = $10,600 + $16.05 per unit
Lance also reports that the correlation coefficient for the regression is .82 and says, “With 82 percent of the variation in overhead explained by the equation, it certainly should be adopted as the best basis for estimating costs.”
When asked for the data used to generate the regression, Lance produces the following:
Required
The company controller is somewhat surprised that the cost estimates are so different. You have therefore been assigned to check Lance’s equation. You accept the assignment with glee.
Analyze Lance’s results and state your reasons for supporting or rejecting his cost equation.
Want to see the full answer?
Check out a sample textbook solutionChapter 5 Solutions
Fundamentals Of Cost Accounting (6th Edition)
- Scattergraph, High-Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. Required: 1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear? 2. Using the high-low method, prepare a cost formula for the receiving activity. Using this formula, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated? Use the following information for Problems 3-60 and 3-61: Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controllers department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows:arrow_forwardGrand Canyon Manufacturing Inc. produces and sells a product with a price of 100 per unit. The following cost data have been prepared for its estimated upper and lower limits of activity: Overhead: Selling and administrative expenses: Required: 1. Classify each cost element as either variable, fixed, or semi-variable. (Hint: Recall that variable expenses must go up in direct proportion to changes in the volume of activity.) 2. Calculate the break-even point in units and dollars. (Hint: First use the high-low method illustrated in Chapter 4 to separate costs into their fixed and variable components.) 3. Prepare a break-even chart. 4. Prepare a contribution income statement, similar in format to the statement appearing on page 540, assuming sales of 5,000 units. 5. Recompute the break-even point in units, assuming that variable costs increase by 20% and fixed costs are reduced by 50,000.arrow_forwardUsing High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period That Differs from the Data Period Refer to the information for Pizza Vesuvio on the previous page. Assume that this information was used to construct the following formula for monthly labor cost. TotalLaborCost=5,237+(7.40EmployeeHours) Required: Assume that 4,000 employee hours are budgeted for the coming year. Use the total labor cost formula to make the following calculations: 1. Calculate total variable labor cost for the year. 2. Calculate total fixed labor cost for the year. 3. Calculate total labor cost for the coming year. Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:arrow_forward
- Method of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. However, assume that Tracy has used the method of least squares on the receiving data and has gotten the following results: Required: 1. Using the results from the method of least squares, prepare a cost formula for the receiving activity. 2. Using the formula from Requirement 1, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? (Note: Round your answer to the nearest dollar.) 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated?arrow_forwardIncome Statements under Absorption and Variable Costing In the coming year, Kalling Company expects to sell 28,700 units at 32 each. Kallings controller provided the following information for the coming year: Required: 1. Calculate the cost of one unit of product under absorption costing. 2. Calculate the cost of one unit of product under variable costing. 3. Calculate operating income under absorption costing for next year. 4. Calculate operating income under variable costing for next year.arrow_forwardHart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, are as follows: During the next production period the labor-hours available are 450 in department A, 350 in department B, and 50 in department C. The profit contributions per unit are 25 for product 1, 28 for product 2, and 30 for product 3. a. Formulate a linear programming model for maximizing total profit contribution. b. Solve the linear program formulated in part (a). How much of each product should be produced, and what is the projected total profit contribution? c. After evaluating the solution obtained in part (b), one of the production supervisors noted that production setup costs had not been taken into account. She noted that setup costs are 400 for product 1, 550 for product 2, and 600 for product 3. If the solution developed in part (b) is to be used, what is the total profit contribution after taking into account the setup costs? d. Management realized that the optimal product mix, taking setup costs into account, might be different from the one recommended in part (b). Formulate a mixed-integer linear program that takes setup costs provided in part (c) into account. Management also stated that we should not consider making more than 175 units of product 1, 150 units of product 2, or 140 units of product 3. e. Solve the mixed-integer linear program formulated in part (d). How much of each product should be produced and what is the projected total profit contribution? Compare this profit contribution to that obtained in part (c).arrow_forward
- Contribution margin, break-even sales, cost-volume-profit chart, margin of safety, and operating leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these estimates is as follows: It is expected that 12,000 units will be sold at a price of 240 a unit. Maximum sales within the relevant range are 18,000 units. Instructions 1. Prepare an estimated income statement for 20Y7. 2. What is the expected contribution margin ratio? 3. Determine the break-even sales in units and dollars. 4. Construct a cost-volume-profit chart indicating the break-even sales. 5. What is the expected margin of safety in dollars and as a percentage of sales? (Round to one decimal place.) 6. Determine the operating leverage.arrow_forwardVariable Cost Ratio, Contribution Margin Ratio Chillmax Company plans to sell 3,500 pairs of shoes at 60 each in the coming year. Unit variable cost is 21 (includes direct materials, direct labor, variable factory overhead, and variable selling expense). Fixed factory overhead is 30,000 and fixed selling and administrative expense is 48,000. Required: 1. Calculate the variable cost ratio. 2. Calculate the contribution margin ratio. 3. Prepare a contribution margin income statement based on the budgeted figures for next year. In a column next to the income statement, show the percentages based on sales for sales, total variable cost, and total contribution margin.arrow_forwardVariable-Costing and Absorption-Costing Income Borques Company produces and sells wooden pallets that are used for moving and stacking materials. The operating costs for the past year were as follows: During the year, Borques produced 200,000 wooden pallets and sold 204,300 at 9 each. Borques had 8,200 pallets in beginning finished goods inventory; costs have not changed from last year to this year. An actual costing system is used for product costing. Required: 1. What is the per-unit inventory cost that is acceptable for reporting on Borquess balance sheet at the end of the year ? How many units are in ending inventory? What is the total cost of ending inventory? 2. Calculate absorption-costing operating income. 3. CONCEPTUAL CONNECTION What would the per-unit inventory cost be under variable costing? Does this differ from the unit cost computed in Requirement 1? Why? 4. Calculate variable-costing operating income. 5. Suppose that Borques Company had sold 196,700 pallets during the year. What would absorption-costing operating income have been? Variable-costing operating income?arrow_forward
- Baxter Company has a relevant range of production between 15,000 and 30,000 units. The following cost data represents average variable costs per unit for 25,000 units of production. Using the costs data from Rose Company, answer the following questions: A. If 15,000 units are produced, what is the variable cost per unit? B. If 28,000 units are produced, what is the variable cost per unit? C. If 21,000 units are produced, what are the total variable costs? D. If 29,000 units are produced, what are the total variable costs? E. If 17,000 units are produced, what are the total manufacturing overhead costs incurred? F. If 23,000 units are produced, what are the total manufacturing overhead costs incurred? G. If 30,000 units are produced, what are the per unit manufacturing overhead costs incurred? H. If 15,000 units are produced, what are the per unit manufacturing overhead costs incurred?arrow_forwardBolger and Co. manufactures large gaskets for the turbine industry. Bolgers per-unit sales price and variable costs for the current year are as follows: Bolgers total fixed costs aggregate to 360,000. Bolgers labor agreement is expiring at the end of the year, and management is concerned about the effects of a new labor agreement on its break-even point in units. The controller performed a sensitivity analysis to ascertain the estimated effect of a 10-per-unit direct labor increase and a 10,000 reduction in fixed costs. Based on these data, the break-even point would: a. decrease by 1,000 units. b. decrease by 125 units. c. increase by 375 units. d. increase by 500 units.arrow_forwardRefer to Exercise 8.27. At the end of the year, Meliore, Inc., actually produced 310,000 units of the standard model and 115,000 of the deluxe model. The actual overhead costs incurred were: Required: Prepare a performance report for the period. In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 300,000 units of the standard model and 120,000 units of the deluxe model during the coming year. The standard model requires 0.05 direct labor hour per unit, and the deluxe model requires 0.08. The controller has developed the following cost formulas for each of the four overhead items: Required: 1. Prepare an overhead budget for the expected activity level for the coming year. 2. Prepare an overhead budget that reflects production that is 10 percent higher than expected (for both products) and a budget for production that is 20 percent lower than expected.arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,