Horngren's Accounting (12th Edition)
12th Edition
ISBN: 9780134486444
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
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 solutionStudents have asked these similar questions
Angler Industries produces a product which goes through two operations, Assembly and Finishing, before it is ready to be shipped. Next year's expected costs and activities are shown below.
Assembly
248,888 DLH
Finishing
154,000 DLH
68,000 MH
448,800 MH
$440,000
Direct labor hours
Machine hours
Overhead costs
Assume that Angler Industries allocates overhead using a plantvide overhead rate based on machine hours. How much total overhead will be assigned to a product that requires 1 direct labor hour and
3.90 machine hours in the Assembly Department, and 4.00 direct labor hours and 0.6 machine hours in the Finishing Department?
Multiple Chaises
O
O
O
$21.50
$17.60
$2.00.
$18.10
$ 677,680
$13.20.
Light Up Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available for the year 2020.
Machine setup-hours is the only driver of manufacturing overhead costs. Light Up has a set up capacity of 960 hours.
(Click the icon to view the information.)
Calculate the manufacturing overhead costs budget (label it Schedule 5).
Schedule 5: Manufacturing Overhead Costs Budget
for the Year Ending December 31, 2020
Machine Setup Overhead Costs
Total manufacturing overhead costs
Fulcrum Industries manufactures dining chairs and tables. The following information is available in December 2020:
Dining Chairs Tables Total CostMachine setups 200 600 $48,000Inspections 250 470 $72,000Labor hours 2,600 2,400
Fulcrum is considering switching from one overhead rate based on labor hours to activity-based costing.InstructionsPerform the following analyses for these two components of overhead:a. Compute total machine setups and inspection costs assigned to each product, using a single overhead rate.b. Compute total machine setups and inspection costs assigned to each product, using activity-based costing.c. Comment on your findings.
Chapter 19 Solutions
Horngren's Accounting (12th Edition)
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
- Steeler 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_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_forwardAngler Industries produces a product which goes through two operations, Assembly and Finishing, before it is ready to be shipped. Next year's expected costs and activities are shown below. Direct labor hours Machine hours Overhead costs Multiple Choice O $15.60. O Assume that the Assembly Department allocates overhead based on machine hours, and the Finishing Department allocates overhead based on direct labor hours. How much total overhead will be assigned to a product that requires 1 direct labor hour and 3.4 machine hours in the Assembly Department, and 4.0 direct labor hours and 0.6 machine hours in the Finishing Department? $3.40 Assembly 190,000 DLH 390,000 MH $16.10. $ 390,000 Finishing) 149,000 DLH: 95,550 MH $ 581,100arrow_forward
- Multiple Versus Single Overhead Rates, Activity Drivers Deoro Company has identified the following overhead activities, costs, and activity drivers for the coming year: Expected Cost Activity Driver Activity Capacity Number of setups Number of orders Machine hours Activity Setting up equipment $491,050 Ordering costs 336,600 Machine costs 898,800 Receiving 362,600 Receiving hours Deoro produces two models of dishwashers with the following expected prime costs and activity demands: Model A Model B $843,000 $455,000 8,200 1,600 Direct materials Direct labor Units completed Direct labor hours Number of setups Number of orders Machine hours $563,000 $459,000 15,600 6,800 360 6,900 23,900 3,200 The company's normal activity is 8,400 direct labor hours. Receiving hours 250 12,900 18,900 6,600 610 19,800 42,800 9,800arrow_forwardeBook Print Item Activity-Based Costing HealthTec Equipment Company manufactures stationary bicycles and treadmills. The products are produced in the Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows: Activity Activity Rate Fabrication $32 per machine hour (mh) Assembly $16 per direct labor hour (dlh) Setup $50 per setup Inspecting $29 per inspection Production scheduling $19 per production order Purchasing $6 per purchase order The activity-base usage quantities and units produced for each product were as follows: Stationary Bicycle Treadmill Machine hours 1,870 950 Direct labor hours 460 170 Setups 30 10 Inspections 660 340 Production orders 40 50 Purchase orders 160 140 Units produced 1,000 1,000 Use the activity rate and usage…arrow_forwardHaywood Printing is processing a job with the following activity rates: Activity Cost Driver Driver Rate Direct labor Number of hours $8 Copying Number of copies $0.05 If this job requires 5 hours for 1,000 copies, what is the activity-based cost of the job?arrow_forward
- Sparkle Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available for the year 2020. Machine setup-hours is the only driver of manufacturing overhead costs. Sparkle has a set up capacity of 2,220 hours. (Click the icon to view the information.) Calculate the manufacturing overhead costs budget (label it Schedule 5). Schedule 5: Manufacturing Overhead Costs Budget for the Year Ending December 31, 2020 Machine Setup Overhead Costs Total manufacturing overhead costs Data table 1. Quantity of lamps to be produced 2. Number of lamps to be produced per batch 3. Setup time per batch Variable cost = $70 per setup-hour Fixed cost = - $79,000 Knox 21,000 lamps 50 lamps/batch 3 hours/batch Ayer 12,000 lamps 50 lamps/batch 4 hours/batch Xarrow_forwardUsing the pre-determined overhead rate calculated above, calculate the overhead that would be allocated to a product that uses 3.5 hours of machine time. What will happen if actual overhead costs turn out to be higher or lower than this calculation? predetermined overhead rate calculated above: $25/ hour of machine run timearrow_forwardMultiple Versus Single Overhead Rates, Activity Drivers Deoro Company has identified the following overhead activities, costs, and activity drivers for the coming year: Activity Expected Cost Activity Driver Activity Capacity Setting up equipment $480,000 Number of setups 600 Ordering costs 360,000 Number of orders 18,000 Machine costs 840,000 Machine hours 42,000 Receiving 400,000 Receiving hours 10,000 Deoro produces two models of dishwashers with the following expected prime costs and activity demands: Model A Model B Direct materials $600,000 $800,000 Direct labor $480,000 $480,000 Units completed 16,000 8,000 Direct labor hours 6,000 2,000 Number of setups 400 200 Number of orders 6,000 12,000 Machine hours 24,000 18,000 Receiving hours 3,000 7,000 The company's normal activity is 8,000 direct labor hours.…arrow_forward
- Magnify Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available the year 2020. Machine setup-hours is the only driver of manufacturing overhead costs. Magnify has a set up capacity of 1,0 hours. (Click the icon to view the information.) Calculate the manufacturing overhead costs budget (label it Schedule 5). Schedule 5: Manufacturing Overhead Costs Budget for the Year Ending December 31, 2020 Machine Setup Overhead Costs Total manufacturing overhead costs Data table 1. Quantity of lamps to be produced 2. Number of lamps to be produced per batch 3. Setup time per batch Variable cost = $65per setup-hour Fixed cost $78,000 = Print Knox 21,000 lamps 50 lamps/batch 2 hours/batch Done Ayer 15,000 lamps 200 lamps/batch 3 hours/batch Xarrow_forwardMultiple Versus Single Overhead Rates, Activity Drivers Deoro Company has identified the following overhead activities, costs, and activity drivers for the coming year: Activity Expected Cost Activity Driver Activity Capacity Setting up equipment $480,000 Number of setups 600 Ordering costs 360,000 Number of orders 18,000 Machine costs 840,000 Machine hours 42,000 Receiving 400,000 Receiving hours 10,000 Deoro produces two models of dishwashers with the following expected prime costs and activity demands: Model A Model B Direct materials $600,000 $800,000 Direct labor $480,000 $480,000 Units completed 16,000 8,000 Direct labor hours 6,000 2,000 Number of setups 400 200 Number of orders 6,000 12,000 Machine hours 24,000 18,000 Receiving hours 3,000 7,000 The company's normal activity is 8,000 direct labor hours.…arrow_forwardActivity-Based Costing Slack Corporation has the following predicted indirect costs and cost drivers for the year for the given activity cost pools: Maintenance Materials handling Machine setups Inspections Machine hours Material moves Machine setups Inspection hours Fabrication Department Finishing Department Cost Driver Machine hours Material moves Direct materials cost Direct labor cost Machine hours (Fabrication) Machine hours (Finishing) Materials moves Machine setups Inspection hours $150,000 The following activity predictions were also made for the year: Fabrication Department Finishing Department Direct materials Direct labor $50,000 30,000 70,000 It is assumed that the cost per unit of activity for a given activity does not vary between departments. Slack's president, Charles Slack, is trying to evaluate the company's product mix strategy regarding two of its five product models, ZX300 and SL500. The company has been using a company- wide overhead rate based on machine hours…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher: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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
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