Principles of Cost Accounting
17th Edition
ISBN: 9781305087408
Author: Edward J. Vanderbeck, Maria R. Mitchell
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 4, Problem 4P
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?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
question is in image.
Required:
Prepare a schedule of cost of goods manufactured.
Prepare a schedule of cost of goods sold.
Prepare an income statement.
Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements.
Show how both cost schedules and the income statement will change if the following data change: direct labor is $390,000 and utilities cost $35,000.
The managerial accountant at Sunny Manufacturing needs to determine how many costs are fixed costs and how many costs are variable costs in the organization. The managerial accountant reported the following information:
Use the high-low method to determine the cost equation and use machine hours as the base for a cost driver in the analysis.
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
Month
Machine-Hours
Total Cost
January
1,800
$21,500
February
2,900
$23,200
March
1,000
$19,750
April
2,400
$21,000
May
3,400
$23,900
The following selected information was extracted from the 20x1 accounting records of Lone Oak Products:
Required:1. Calculate Lone Oak’s manufacturing overhead for the year.2. Calculate Lone Oak’s cost of goods manufactured.3. Compute the company’s cost of goods sold.4. Determine net income for 20x1, assuming a 30% income tax rate.5. Determine the number of completed units manufactured during the year.6. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: indirect labor is $115,000 and other factory costs amount to $516,000.
Chapter 4 Solutions
Principles of Cost Accounting
Ch. 4 - What are factory overhead expenses, and what...Ch. 4 - What are three categories of factory overhead...Ch. 4 - What are the distinguishing characteristics of...Ch. 4 - When a products cost is composed of fixed and...Ch. 4 - What effect does a change in volume have on total...Ch. 4 - Distinguish between a step-variable cost and a...Ch. 4 - What is the basic premise underlying the high-low...Ch. 4 - What are the advantages and disadvantages of the...Ch. 4 - Differentiate between an independent variable and...Ch. 4 - Prob. 10Q
Ch. 4 - What is a flexible budget, and how can management...Ch. 4 - How does accounting for factory overhead differ in...Ch. 4 - What is the function and use of each of the two...Ch. 4 - What are two types of departments found in a...Ch. 4 - What are the two most frequently used methods of...Ch. 4 - When using the sequential distribution method of...Ch. 4 - When using the sequential distribution method of...Ch. 4 - Is it possible to close the total factory overhead...Ch. 4 - What are the shortcomings of waiting until the...Ch. 4 - What are the two types of budget data needed to...Ch. 4 - Prob. 21QCh. 4 - What factory operating conditions and data are...Ch. 4 - Prob. 23QCh. 4 - How does activity-based costing differ from...Ch. 4 - What steps must a company take to successfully...Ch. 4 - What is the relationship between activity-based...Ch. 4 - Prob. 27QCh. 4 - Prob. 28QCh. 4 - If the factory overhead control account has a...Ch. 4 - Prob. 30QCh. 4 - Classify each of the following items of factory...Ch. 4 - Ames Automotive Company has accumulated the...Ch. 4 - Prob. 3ECh. 4 - Using the data in E4-2 and spreadsheet software,...Ch. 4 - El Paso Products Company has accumulated the...Ch. 4 - Computing unit costs at different levels of...Ch. 4 - Identifying basis for distribution of service...Ch. 4 - A manufacturing company has two service and two...Ch. 4 - A manufacturing company has two service and two...Ch. 4 - Compute the total job cost for each of the...Ch. 4 - Classify each of the following items of factory...Ch. 4 - Job 25AX required 5,000 for direct materials,...Ch. 4 - Job 19AB required 10,000 for direct materials,...Ch. 4 - Match each of the following cost pools with the...Ch. 4 - The books of Petry Products Co. revealed that the...Ch. 4 - The general ledger of Lawson Lumber Co. contains...Ch. 4 - Nelson Fabrication Inc. had a remaining credit...Ch. 4 - Housley Paints Co. had a remaining debit balance...Ch. 4 - The cost behavior patterns below are lettered A...Ch. 4 - Miller Minerals Co. manufactures a product that...Ch. 4 - Scattergraph method Using the data in P4-2 and a...Ch. 4 - Using the data in P4-2 and Microsoft Excel: 1....Ch. 4 - Listed below are the budgeted factory overhead...Ch. 4 - Menlo Materials is divided into five departments,...Ch. 4 - Distribution of service department costs to...Ch. 4 - Journalizing the distribution of service...Ch. 4 - Channel Products Inc. uses the job order cost...Ch. 4 - Determining job costcalculation of predetermined...Ch. 4 - Focus Fabrication Co. uses ABC. The factory...Ch. 4 - Mansfield Manufacturing Co. uses ABC. The factory...Ch. 4 - Hughes Products Inc. uses a job order cost system....Ch. 4 - Abbey Products Company is studying the results of...Ch. 4 - The following information, taken from the books of...Ch. 4 - Rockford Company has four departmental accounts:...Ch. 4 - Luna Manufacturing Inc. completed Job 2525 on May...Ch. 4 - Phillips Products, Inc. had a remaining credit...Ch. 4 - Nathan Industries had a remaining debit balance of...Ch. 4 - Chrome Solutions Company manufactures special...Ch. 4 - Activity-based Costing
Video Options Ltd....
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- 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?arrow_forwardThis information was collected for the first year of manufacturing for Wifi Apps: Prepare an income statement under variable costing and prepare a reconciliation to the income under the absorption method.arrow_forwardThis information was collected for the first year of manufacturing for Appliance Apps: Prepare an income statement under variable costing, and prepare a reconciliation to the income under the absorption method.arrow_forward
- Using the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total fixed cost, and R2. The plotted data points using the graphing function. Compare the results to your solutions in E4-2 and E4-3 and explain the reasons for the results.arrow_forwardThis cost data from Hickory Furniture is for the year 2017. Using the high-low method, express the companys utility costs as an equation where X represents number of tables produced. Predict the utility costs if 800 tables are produced. Predict the utility costs if 600 tables are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between number of tables produced and utility expenses.arrow_forwardThe cost behavior patterns below are lettered A through H. The vertical axes of the graphs represent total dollars of expense, and the horizontal axes represent production in units, machine hours, or direct labor hours. In each case, the zero point is at the intersection of the two axes. Each graph may be used no more than once. Required: Select the graph that matches the lettered cost described here. a. Depreciation of equipmentthe amount of depreciation charged is computed based on the number of machine hours that the equipment was operated. b. Electricity billflat fixed charge, plus a variable cost after a certain number of kilowatt hours are used. c. City water billcomputed as follows: d. Depreciation of equipmentthe amount is computed by the straight-line method. e. Rent on a factory building donated by the citythe agreement calls for a fixed fee payment, unless 200,000 labor hours are worked, in which case no rent need be paid. f. Salaries of repair workersone repair worker is needed for every 1,000 machine hours or less (i.e., 0 to 1,000 hours requires one repair worker, 1,001 to 2,000 hours requires two repair workers, etc.).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_forwardPotterii sells its products to large box stores and recently added a retail line of products to sell directly to consumers. These estimates are to be used in determining the overhead allocation rate for ABC: What would be the predetermined rate for each cost pool?arrow_forwardLarsen, Inc., produces two types of electronic parts and has provided the following data: There are four activities: machining, setting up, testing, and purchasing. Required: 1. Calculate the activity consumption ratios for each product. 2. Calculate the consumption ratios for the plantwide rate (direct labor hours). When compared with the activity ratios, what can you say about the relative accuracy of a plantwide rate? Which product is undercosted? 3. What if the machine hours were used for the plantwide rate? Would this remove the cost distortion of a plantwide rate?arrow_forward
- This cost data from Hickory Furniture is for the year 2017. Using the high-low method, express the factory utility expenses as an equation where x represents number of chairs produced. Predict the utility costs if 900 chairs are produced. Predict the utility costs if 750 chairs are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between number of chairs processed and utility expenses.arrow_forwardBuild a spreadsheet: Construct and excel spreadsheet to solve all of the preceding requirements. Show how both cost schedules and the income statement will change if raw material purchases amounted to $190,000 and indirect labor was $20,000.arrow_forwardZiegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows: Units Produced Total Costs 97,500 $27,165,000 112,500 29,715,000 124,500 31,755,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Determine the variable cost per unit and the total fixed cost. Round your answer for variable cost to the nearest cent. Round your answer for total fixed costs to the nearest dollar. Variable cost: $fill in the blank 2 per unit Total fixed cost: $fill in the blank 3 Based on part (a), estimate the total cost for 80,000 units of production. Round your answer to the nearest dollar. Total cost for 80,000 units: $fill in the blank 4arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Cost Classifications - Managerial Accounting- Fixed Costs Variable Costs Direct & Indirect Costs; Author: Accounting Instruction, Help, & How To;https://www.youtube.com/watch?v=QQd1_gEF1yM;License: Standard Youtube License