Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 17, Problem 1R
Nutt Products manufactures screws and bolts made to customer specifications. During August, Nutt incurred the following
The overhead application rates are $4 per direct labor hour for Dept. 1 and 175% of direct labor cost for Dept. 2.
Nutt had no beginning work in process for August. Job 8958, which cost $14,190.18 to manufacture, was completed in July and was sold on account in August for $19,000. The
As cost accountant for this company, you have been asked to prepare job cost sheets for each of the four jobs started in August. Review the printed worksheet called JOB that follows these requirements.
Expert Solution & Answer
To determine
Prepare job cost sheets for each of the four jobs started in the month of August.
Explanation of Solution
Prepare job cost sheets for Job 8961.
Table (1)
Prepare job cost sheets for Job 8962.
Table (2)
Prepare job cost sheets for Job 8963.
Table (3)
Prepare job cost sheets for Job 8964.
Table (4)
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Chapter 17 Solutions
Excel Applications for Accounting Principles
Ch. 17 - Nutt Products manufactures screws and bolts made...Ch. 17 - Prob. 2RCh. 17 - Now that your worksheet has been saved as JOB2,...Ch. 17 - Next, open worksheet JOB2 again. Enter the data...Ch. 17 - Use the space provided below to prepare six...Ch. 17 - Nutts management is very concerned about the cost...
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
- The cost accountant for River Rock Beverage Co. estimated that total factory overhead cost for the Blending Department for the coming fiscal year beginning February 1 would be 3,150,000, and total direct labor costs would be 1,800,000. During February, the actual direct labor cost totalled 160,000, and factory overhead cost incurred totaled 283,900. a. What is the predetermined factory overhead rate based on direct labor cost? b. Journalize the entry to apply factory overhead to production for February. c. What is the February 28 balance of the account Factory OverheadBlending Department? d. Does the balance in part (c) represent over- or underapplied factory overhead?arrow_forwardQueen Bees Honey, Inc., estimated its annual overhead to be $110,000 and based its predetermined overhead rate on 27,500 direct labor hours. At the end of the year, actual overhead was $106,000 and the total direct labor hours were 29,000. What is the entry to dispose of the over applied or under applied overhead?arrow_forwardComacho Chemical Co. recorded costs for the month of 18,900 for materials, 44,100 for labor, and 26,250 for factory overhead. There was no beginning work in process, 8,000 units were finished, and 3,000 units were in process at the end of the period, two-thirds completed. Compute the months unit cost for each element of manufacturing cost and the total per unit cost. (Round unit costs to three decimal places.)arrow_forward
- Wyandotte Company provided the following information for the last calendar year: During the year, direct materials purchases amounted to 256,900, direct labor cost was 176,000, and overhead cost was 308,400. There were 40,000 units produced. Required: 1. Calculate the total cost of direct materials used in production. 2. Calculate the cost of goods manufactured. Calculate the unit manufacturing cost. 3. Of the unit manufacturing cost calculated in Requirement 2, 6.62 is direct materials and 7.71 is overhead. What is the prime cost per unit? Conversion cost per unit?arrow_forwardEllerson Company provided the following information for the last calendar year: During the year, direct materials purchases amounted to 278,000, direct labor cost was 189,000, and overhead cost was 523,000. During the year, 100,000 units were completed. Required: 1. Calculate the total cost of direct materials used in production. 2. Calculate the cost of goods manufactured. Calculate the unit manufacturing cost. 3. Of the unit manufacturing cost calculated in Requirement 2, 2.70 is direct materials and 5.30 is overhead. What is the prime cost per unit? Conversion cost per unit?arrow_forwardFoamy Inc. manufactures shaving cream and uses the weighted average cost method. In November, production is 14,800 equivalent units for materials and 13,300 units for labor and overhead. During the month, materials, labor, and overhead costs were as follows: Beginning work in process for November had a cost of 11,360 for materials, 11,666 for labor, and 9,250 for overhead. Compute the following: a. Weighted average cost per unit for materials b. Weighted average cost per unit for labor c. Weighted average cost per unit for overhead d. Total unit cost for the montharrow_forward
- The books of Petry Products Co. revealed that the following general journal entry had been made at the end of the current accounting period: The total direct materials cost for the period was $40,000. The total direct labor cost, at an average rate of $10 per hour for direct labor, was one and one-half times the direct materials cost. Factory overhead was applied on the basis of $4 per direct labor hour. What was the total actual factory overhead incurred for the period? (Hint: First solve for direct labor cost and then for direct labor hours.)arrow_forwardDuring the week of August 21, Parley Manufacturing produced and shipped 4,000 units of its machine tools: 1,500 units of Tool SK1 and 2,500 units of Tool SK3. The cycle time for SK1 is 0.73 hour, and the cycle time for SK3 is 0.56 hour. The following costs were incurred: Required: 1. Assume that the value-stream costs and total units shipped apply only to one model (a single-product value stream). Calculate the unit cost, and comment on its accuracy. 2. Assume that Tool SK1 is responsible for 60% of the materials cost. Calculate the unit cost for Tool SK 1 and Tool SK3, and comment on its accuracy. Explain the rationale for using units shipped instead of units produced in the calculation. 3. Calculate the unit cost for the two models, using DBC. Explain when and why this cost is more accurate than the unit cost calculated in Requirement 2.arrow_forwardRockford Company has four departmental accounts: Building Maintenance, General Factory Overhead, Machining, and Assembly. The direct labor hour method is used to apply factory overhead to the jobs being worked on in Machining and Assembly. The company expects each production department to use 30,000 direct labor hours during the year. The estimated overhead rates for the year include the following: During the year, both Machining and Assembly used 28,000 direct labor hours. Factory overhead costs incurred during the year follow: In determining application rates at the beginning of the year, cost allocations were made as follows, using the sequential distribution method: Building Maintenance to: General Factory Overhead, 10%; Machining, 50%; Assembly, 40%. General factory overhead was distributed according to direct labor hours. Required: Determine the under- or overapplied overhead for each production department. (Hint: First you must distribute the service department costs.)arrow_forward
- Luna Manufacturing Inc. completed Job 2525 on May 31, and there were no jobs in process in the plant. Prior to June 1, the predetermined overhead application rate for June was computed from the following data, based on an estimate of 5,000 direct labor hours: The factory has one production department and uses the direct labor hour method to apply factory overhead. Three jobs are started during the month, and postings are made daily to the job cost sheets from the materials requisitions and labor-time records. The following schedule shows the jobs and amounts posted to the job cost sheets: The factory overhead control account was debited during the month for actual factory overhead expenses of 27,000. On June 11, Job 2526 was completed and delivered to the customer using a mark-on percentage of 50% on manufacturing cost. On June 24, Job 2527 was completed and transferred to Finished Goods. On June 30, Job 2528 was still in process. Required: 1. Prepare job cost sheets for Jobs 2526, 2527, and 2528, including factory overhead applied when the job was completed or at the end of the month for partially completed jobs. 2. Prepare journal entries as of June 30 for the following: a. Applying factory overhead to production. b. Closing the applied factory overhead account. c. Closing the factory overhead account. d. Transferring the cost of the completed jobs to finished goods. e. Recording the cost of the sale and the sale of Job 2526.arrow_forwardSteeler Towel Company estimates its overhead to be $250,000. It expects to have 100,000 direct labor hours costing $2,500,000 in labor and utilizing 12,500 machine hours. Calculate the predetermined overhead rate using: A. Direct labor hours B. Direct labor dollars C. Machine hoursarrow_forwardBaldwin Printing Company uses a job order cost system and applies overhead based on machine hours. A total of 150,000 machine hours have been budgeted for the year. During the year, an order for 1,000 units was completed and incurred the following: The accountant computed the inventory cost of this order to be 4.30 per unit. The annual budgeted overhead in dollars was: a. 577,500. b. 600,000. c. 645,000. d. 660,000.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher: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
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cost Accounting - Definition, Purpose, Types, How it Works?; Author: WallStreetMojo;https://www.youtube.com/watch?v=AwrwUf8vYEY;License: Standard YouTube License, CC-BY