EBK HORNGREN'S ACCOUNTING
12th Edition
ISBN: 8220103677684
Author: Matsumura
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 19, Problem P19.40CT
Using Excel to calculate a predetermined
Download an Excel template for this problem online in MyAccountingLab or athttp://www.pearsonhighered.com/Horngren.
Cedar River Trikes manufactures three-wheeled bikes for adults The company allocates
Raw Materials Inventory | $ 25,000 |
Work-in-Process Inventory | 18,000 |
Finished Goods Inventory | 43,000 |
During June 2018, Cedar River actually used 1,100 machine hours.
Requirements
- Compute the predetermined overhead allocation rate for fiscal year 2018. Use the blue shaded areas for inputs.
- Use Excel to journalize the transactions in the general journal. The account titles are available when you click the down-arrow. Use the Increase Indent button on the Home tab to indent items.
- Enter the beginning balances for the inventories. Assume the rest of the accounts do not have beginning balances. Post the transactions to T-accounts. The balances in the T-accounts are automatically updated.
- Adjust the manufacturing overhead.
- Prepare the
journal entry . - Post to T-accounts.
- List the ending balances for Raw Materials Inventory, Work-in-Process Inventory, Finished Goods Inventory, and Cost of Goods Sold.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionChapter 19 Solutions
EBK HORNGREN'S ACCOUNTING
Ch. 19 - Prob. 1QCCh. 19 - When a manufacturing company uses direct...Ch. 19 - When a manufacturing company uses indirect...Ch. 19 - When a manufacturing company uses direct labor, it...Ch. 19 - What is Gell's predetermined overhead allocation...Ch. 19 - What is Gell's actual manufacturing overhead cost?...Ch. 19 - How much manufacturing overhead would Gell...Ch. 19 - What entry would Gell make to adjust the...Ch. 19 - A manufacturing company completed work on a job....Ch. 19 - Prob. 10QC
Ch. 19 - Why do managers need to know the cost of their...Ch. 19 - What types of companies use job order costing...Ch. 19 - What types of companies use process costing...Ch. 19 - What is the purpose of a job cost record?Ch. 19 - Explain the difference between cost of goods...Ch. 19 - A job was started on May 15, completed on June 27,...Ch. 19 - Give the journal entry for raw materials purchased...Ch. 19 - What is the purpose of the raw materials...Ch. 19 - How does the use of direct and indirect materials...Ch. 19 - Give the journal entry for direct and indirect...Ch. 19 - Give five examples of manufacturing overhead...Ch. 19 - What is the predetermined overhead allocation...Ch. 19 - What is an allocation base? Give some examples.Ch. 19 - How is manufacturing overhead allocated to jobs?Ch. 19 - A completed job cost record shows the unit cost of...Ch. 19 - Explain the journal entry for the allocation of...Ch. 19 - Give the journal entry for the completion of a...Ch. 19 - Why does the sale of a completed job require two...Ch. 19 - Prob. 19RQCh. 19 - If a company incurred $5,250 in actual overhead...Ch. 19 - Refer to the previous question. Give the journal...Ch. 19 - Explain the terms accumulate, assign, allocate,...Ch. 19 - Why would the manager of a service company need to...Ch. 19 - How is the predetermined overhead allocation rate...Ch. 19 - Distinguishing between job order costing and...Ch. 19 - Accounting for materials Back Country manufactures...Ch. 19 - Accounting for materials Learning Objective 2...Ch. 19 - Accounting for labor Learning Objective 2...Ch. 19 - Accounting for overhead Learning Objective 3 Oak...Ch. 19 - Allocating overhead Learning Objective 3 Job 303...Ch. 19 - Calculating predetermined overhead allocation...Ch. 19 - Completing and selling products Learning Objective...Ch. 19 - Comparing actual to allocated overhead Learning...Ch. 19 - Calculating under/overallocated overhead Learning...Ch. 19 - Prob. S19.11SECh. 19 - Prob. S19.12SECh. 19 - Prob. S19.13SECh. 19 - Prob. S19.14SECh. 19 - Distinguishing between job order costing and...Ch. 19 - Defining terminology Learning Objectives 1,2 Match...Ch. 19 - E19-17 Accounting for job costs
Learning Objective...Ch. 19 - E19-18 Recording materials and labor...Ch. 19 - Prob. E19.19ECh. 19 - Allocating and adjusting manufacturing overhead...Ch. 19 - Prob. E19.21ECh. 19 - Prob. E19.22ECh. 19 - Prob. E19.23ECh. 19 - Preparing job order costing journal entries...Ch. 19 - Prob. E19.25ECh. 19 - E19-26 Determining missing amounts
Learning...Ch. 19 - Prob. E19.27ECh. 19 - Prob. P19.28APGACh. 19 - Prob. P19.29APGACh. 19 - Prob. P19.30APGACh. 19 - Prob. P19.31APGACh. 19 - Prob. P19.32APGACh. 19 - Prob. P19.33APGACh. 19 - Prob. P19.34BPGBCh. 19 - Prob. P19.35BPGBCh. 19 - Prob. P19.36BPGBCh. 19 - Prob. P19.37BPGBCh. 19 - Prob. P19.38BPGBCh. 19 - Using job order costing in a service company...Ch. 19 - Using Excel to calculate a predetermined overhead...Ch. 19 - P19-41 Accounting for manufacturing overhead
This...Ch. 19 - Prob. 19.1TIATCCh. 19 - Prob. 19.1DCCh. 19 - Prob. 19.1FC
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
- PREDETERMINED FACTORY OVERHEAD RATE Millerlile Enterprises calculates a predetermined factory overhead rate so that factory overhead may be applied to production during the month. It calculates the overhead using three different methods and then decides which one to use. Total estimated factory overhead costs are 540,000. Total estimated direct labor hours are 50,000. Total estimated direct labor costs are 900,000. Total machine hours are estimated to be 80,000. Calculate the predetermined overhead application rates based on (1) direct labor hours, (2) direct labor costs, and (3) machine hours.arrow_forwardUse the following information for Exercises 9-63 and 9-64: Palladium Inc. produces a variety of household cleaning products. Palladiums controller has developed standard costs for the following four overhead items: Next year, Palladium expects production to require 90,000 direct labor hours. Exercise 9-64 Performance Report Based on Actual Production Refer to the information for Palladium Inc. above. Assume that actual production required 93,000 direct labor hours at standard. The actual overhead costs incurred were as follows: Required: Prepare a performance report for the period based on actual production.arrow_forwardFisico Company produces exercise bikes. One of its plants produces two versions: a standard model and a deluxe model. The deluxe model has a wider and sturdier base and a variety of electronic gadgets to help the exerciser monitor heartbeat, calories burned, distance traveled, etc. At the beginning of the year, the following data were prepared for this plant: Additionally, the following overhead activity costs are reported: Required: 1. Calculate the cost per unit for each product using direct labor hours to assign all overhead costs. 2. Calculate activity rates and determine the overhead cost per unit. Compare these costs with those calculated using the unit-based method. Which cost is the most accurate? Explain.arrow_forward
- Bumblebee Mobiles manufactures a line of cell phones. The management has identified the following overhead costs and related cost drivers for the coming year. The following were incurred in manufacturing two of their cell phones, Bubble and Burst, during the first quarter. REQUIREMENT Review the worksheet called ABC that follows these requirements. You have been asked to determine the cost of each product using an activity-based cost system. Note that the problem information is already entered into the Data Section of the ABC worksheet.arrow_forwardFriedman Company uses JIT manufacturing. There are several manufacturing cells set up within one of its factories. One of the cells makes stands for flat-screen televisions. The cost of production for the month of April is given below. During May, 30,000 stands were produced and sold. Required: 1. Explain why process costing can be used for computing the cost of production for the stands. 2. Calculate the cost per unit for a stand. 3. Explain how activity-based costing can be used to determine the overhead assigned to the cell.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_forward
- Use the following information for Brief Exercises 4-34 and 4-35: Sanjay Company manufactures a product in a factory that has two producing departments, Assembly and Painting, and two support departments, S1 and S2. The activity driver for S1 is square footage, and the activity driver for S2 is number of machine hours. The following data pertain to Sanjay: Brief Exercises 4-34 (Appendix 4B) Assigning Support Department Costs by Using the Direct Method Refer to the information for Sanjay Company above. Required: 1. Calculate the cost assignment ratios to be used under the direct method for Departments S1 and S2. (Note: Each support department will have two ratiosone for Assembly and the other for Painting.) 2. Allocate the support department costs to the producing departments by using the direct method.arrow_forwardA local picnic table manufacturer has budgeted these overhead costs: They are considering adapting ABC costing and have estimated the cost drivers for each pool as shown: Recent success has yielded an order for 1,000 tables. Assume direct labor costs per hour of $20. Determine how much the job would cost given the following activities:arrow_forwardOverhead application rate Creole Manufacturing Inc. uses a job order cost system and standard costs. It manufactures one product, whose standard cost follows: The standards are based on normal capacity of 2,400 direct labor hours. Actual activity for October follows: Required: 1. Compute the variable and fixed factory overhead rates per unit. 2. Compute the variable and fixed overhead rates per direct labor hour. 3. Determine the total fixed factory overhead based on normal capacity.arrow_forward
- Plata Company has identified the following overhead activities, costs, and activity drivers for the coming year: Plata produces two models of microwave ovens with the following activity demands: The companys normal activity is 21,000 machine hours. Calculate the total overhead cost that would be assigned to Model X using an activity-based costing system: a. 230,000 b. 240,000 c. 280,000 d. 190,000arrow_forwardTri-bikes manufactures two different levels of bicycles: the Standard and the Extreme. The total overhead of $300,000 has traditionally been allocated by direct labor hours, with 150.000 hours for the Standard and 50,000 hours for the Extreme. After analyzing and assigning costs to two cost pools, it was determined that machine hours is estimated to have $200,000 of overhead, with 4,000 hours used on the Standard product and 1,000 hours used on the Extreme product. k was also estimated that the setup cost pool would have $100000 of overhead, with 1,000 hours for the Standard and 1,500 hours for the Extreme. What is the overhead rate per product, under traditional and under ABC costing?arrow_forwardWrappers Tape makes two products: Simple and Removable. It estimates it will produce 369,991 units of Simple and 146,100 of Removable, and the overhead for each of its cost pools is as follows: It has also estimated the activities for each cost driver as follows: Â How much is the overhead allocated to each unit of Simple and Removable?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cost Accounting - Definition, Purpose, Types, How it Works?; Author: WallStreetMojo;https://www.youtube.com/watch?v=AwrwUf8vYEY;License: Standard YouTube License, CC-BY