Introduction To Managerial Accounting
8th Edition
ISBN: 9781259917066
Author: BREWER, Peter C., Garrison, Ray H., Noreen, Eric W.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 9, Problem 1AE
The Excel worksheet form that appears below is to be used to recreate the main example in the text related to the Colonial Pewter Company. Download the workbook containing this form from Connect, where you will also receive instructions about how to use this worksheet form.
You should proceed to the requirements below only after completing your worksheet.
Check your worksheet by changing the direct materials standard quantity in cell B6 to 2.9 pounds, the direct labor quantity standard quantity in cell B7 to 0.6 hours. and the variable manufacturing
a. What is the materials quantity variance? Explain this variance.
b. What is the labor rate variance? Explain this variance.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Convert the accompanying database to an Excel table to find:
a.The total cost of all orders.
b. The total quantity of airframe fasteners purchased.
c. The total cost of all orders placed with Manley Valve.
Convert the accompanying database to an Excel table to find:
a.The total cost of all orders.
b.Thetotal quantity of airframe fasteners purchased.
c. The total cost of all orders placed with Manley Valve.
Question content area bottom
Part 1
a. The total cost of all orders is
$?????? enter your response here.
Hoffman Company manufactures car seats in its Boise plant. Each car seat passes through the assembly department and the testing department. This problem focuses on the assembly department.
A (Click the icon to view information about Hoffman Company's process-costing system.)
Prepare a set of summarized journal entries for all October 2017 transactions affecting Work in Process-Assembly (Record debits first, then credits Exclude explanations from any journal entries.)
Begin by recording the purchase and use of direct materials.
- X
Journal Entry
Data table
Accounts
Debit
Credit
JE 1
Physical Units
Direct
Conversion
(Car Seats)
Materials
Costs
$1,248,000
Work in process, October 1a
Started during October 2017
Completed during October 2017
4,000
$241,650
22,500
26,000
500
Work in process, October 31°
Total costs added during October 2017
$4,635,000 $2,575,125
Accounts Payable
aDegree of completion: direct materials, ?%, conversion costs, 45%.
bDegree of completion direct materials, ?%,…
Chapter 9 Solutions
Introduction To Managerial Accounting
Ch. 9.A - Fixed Overhead Variances Primara Corporation has a...Ch. 9.A - Predetermined Overhead Rate: Overhead Variances...Ch. 9.A - Applying Overhead in a Standard Costing System...Ch. 9.A - Prob. 4ECh. 9.A - Using Fixed Overhead Variances The standard cost...Ch. 9.A - Prob. 6ECh. 9.A - Relations Among Fixed Overhead Variances Selected...Ch. 9.A - Applying Overhead; Overhead Variances Lane Company...Ch. 9.A - Applying Overhead; Overhead Variances Chilczuk....Ch. 9.A - Comprehensive Standard Cost Variances "Wonderful!...
Ch. 9.A - Comprehensive Standard Cost Variances Flandro...Ch. 9.A - Selection of a Denominator: Overhead Analysis:...Ch. 9.B - Standard Cost Flows: Income Statement Preparation...Ch. 9.B - Standard Cost Flows: Income Statement Preparation...Ch. 9.B - Standard Cost Flows Bowen Company manufactures one...Ch. 9.B - Standard Cost Flows Hartwell Company manufactures...Ch. 9.B - Transaction Analysis; Income Statement Preparation...Ch. 9.B - Transaction Analysis; Income Statement Preparation...Ch. 9 - What is a static planning budget?Ch. 9 - What is a flexible budget and how does it differ...Ch. 9 - What are some of the possible reasons that actual...Ch. 9 - Why is it difficult to interpret a difference...Ch. 9 - What is a revenue variance and what does it mean?Ch. 9 - What is a spending variance and what does it mean?Ch. 9 - What does a flexible budget enable that a simple...Ch. 9 - How does a flexibe budget based on the cost...Ch. 9 - Prob. 9QCh. 9 - Why are separate price and quantity variances...Ch. 9 - Who is generally responsible for the materials...Ch. 9 - Prob. 12QCh. 9 - Prob. 13QCh. 9 - Our workers are all under labor contracts:...Ch. 9 - Prob. 15QCh. 9 - Prob. 16QCh. 9 - Prob. 17QCh. 9 - The Excel worksheet form that appears below is to...Ch. 9 - Prob. 2AECh. 9 - Preble Company manufactures one product. Its...Ch. 9 - Prob. 2F15Ch. 9 - Preble Company manufactures one product. Its...Ch. 9 - Prob. 4F15Ch. 9 - Prob. 5F15Ch. 9 - Prob. 6F15Ch. 9 - Preble Company manufactures one product. Its...Ch. 9 - Prob. 8F15Ch. 9 - Prob. 9F15Ch. 9 - Prob. 10F15Ch. 9 - Prob. 11F15Ch. 9 - Preble Company manufactures one product. Its...Ch. 9 - Prob. 13F15Ch. 9 - Preble Company manufactures one product. Its...Ch. 9 - Preble Company manufactures one product. Its...Ch. 9 - Prepare a Flexible Budget Puget Sound Divers is a...Ch. 9 - Prepare a Report Shong Revenue and Spending...Ch. 9 - Prepare a Flexible Budget with More Than One Cost...Ch. 9 - Direct Materials Variances Bandar Industries...Ch. 9 - Prob. 5ECh. 9 - Prob. 6ECh. 9 - Planning Budget Lavage Rapide is a Canadian...Ch. 9 - EXERCISE 98 Flexible Budget L091 Refer to the data...Ch. 9 - Prepare a Report Showing Revenue and Spending...Ch. 9 - Direct Labor and Variable Manufacturing Overhead...Ch. 9 - Prob. 11ECh. 9 - Working with More Than One Cost Driver The...Ch. 9 - Direct Materials and Direct Labor Variances Huron...Ch. 9 - Direct Materials Variances Refer to the data in...Ch. 9 - Prob. 15ECh. 9 - Prob. 16ECh. 9 - Prob. 17ECh. 9 - Comprehensive Variance Analysis Miller Toy Company...Ch. 9 - More than One Cost Driver Milano Pizza is a small...Ch. 9 - Basic Variance Analysis: the Impact of Vanances on...Ch. 9 - Multiple Products. Materials, and Processes...Ch. 9 - Variance Analysis In a Hospital John Fleming,...Ch. 9 - Flexible Budgets and Spending Variances You have...Ch. 9 - Comprehensive Variance Analysis Marvel Parts....Ch. 9 - Direct Materials and Direct Labor Variances:...Ch. 9 - Comprehensive Variance Analysis Highland Company...
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
- Please analyze and compute the problems attached on the photos below.Requirements: Compute the equivalent unit of production for direct materials, direct labor and overhead. Prepare a cost of productin report for the Curing Department for May 2018 using the FIFO method of process costing.arrow_forwardUsing Excel to prepare a production cost report. Download an Excel temp/are for this problem online in MyAccountingLab or at http://www.pearsonhighered.com/Horngren. Salish Craft Beers provides the following information for the Malting Department for the month of August 2018: Requirements Complete a production cost report for the Malting Department for the month of August 2018 to determine the cost of the units completed and transferred out, and the cost of the ending Work-in-Process Inventory. Assume Salish Craft Beers uses the weighted-average method.arrow_forwardThis section has a nine-part comprehensive problem with multiple questions to address. Download the Chapter 9 Comprehensive Problem Template below to complete all parts. You will need your Bergevin and MacQueen book for reference. Redlands Inc. reported standard and actual costs for the product that it manufactures: Item Standard Actual Direct material price $3 per lb. $2 per lb. Direct materials quantity 2 lbs. 4 lbs. Direct labor price $5 $7 Direct labor quantity 3 hours 2 hours Factory overhead cost $2 per machine hour ---- Machine hours per unit 2 machine hours 3 machine hours Number of finished products made 10 12 Number of finished products sold 10 11 Sales per unit $40 $40 * Redlands used machine hours to apply factory overhead costs. The company incurred $90 actual total factory overhead costs to make the 12 products. 1. Standard product cost Item Price Quantity Total Direct materials Direct labor Factory overhead Standard…arrow_forward
- Easy Packs manufactures backpacks. Its plant records include the following materials-related data: (Click the icon to view the transactions.) Journalize the entries to record the transactions, post to the Raw Materials Inventory account, and determine the ending balance in Raw Materials Inventory. Journalize the entries to record the transactions. Begin by recording the journal entry for the purchases of materials. (Record debits first, then credits. Select the explanation on the last line of the journal entry table.) Date Debit Credit Accounts and Explanation Data table Raw Materials Inventory, beginning balance Purchases of canvas, on account Purchases of sewing machine lubricating oil, on account Material requisitions: Canvas Sewing machine lubricating oil Print Done - X $ 35,000 73,000 1,400 66,000 550arrow_forwardDirections: Answer the following questions by the due date. Use numerical calculations (if needed) to support your argument. Submit your answers through uploading a Microsoft Word file, Excel file or PDF. Tread-Force Fitness, Inc. assembles and sells elliptical machines. All activity costs are related to labor. Management must remove $2.00 of activity cost from the product in order for it to remain competitive. Activity-based product information for each elliptical machine is as follows: (Hrs per unit) Activity Activity Based Usage x Activity rate / hr = Activity Cost Moving 0.20 $15 $3.00 Motor Assembly 1.50 $20 $30.00 Final Assembly…arrow_forwardto create a model for a production cost report using the weighted average method for the month of May. Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area. You should also include directions (in a text box) for users. After completion of the production cost report using the weighted average method, create a new worksheet and label the tab “FIFO”. Create a production cost report using the same information using the FIFO method. Spartans Bakery has two department: mixing and baking. All products start in the Mixing Department, where materials are added and conversion costs (labor, overhead) are incurred. Once the product is “finished” with regards to the Mixing, it moves to the Baking Department where additional conversion costs are incurred before moving to Finished…arrow_forward
- For each of the following activities, select the most appropriate cost driver. Each cost driver may be used only once. Activity Cost Driver 1. Pay vendors Answer 2. Evaluate vendors Answer 3. Inspect raw materials Answer 4. Plan for purchases of raw materials Answer 5. Packaging Answer 6. Supervision Answer 7. Employee training Answer 8. Clean tables Answer 9. Machine maintenance Answer 10. Move in-process product from one work station to the next Answerarrow_forwardThe following information has been extracted from the cost accounting information system database for Victoria Furnitures Ltd. The company manufactures different types of furniture’s, including tables; The company manufactured 1,000 tables during the year 2020. Required: Using the information provided in the above table identify and explain how you classify each of the above costs according to the functional approach; Use the tables as the cost object in the classification of the costs.arrow_forwardYour manager asks you to bring the following incomplete accounts of Endeavor Printing, Inc., up to date through January 31, 2017. Consider the data that appear in the T-accounts as well as the following information in items (a) through (j). Endeavor's normal-costing system has two direct-cost categories (direct material costs and direct manufacturing labor costs) and one indirect-cost pool (manufacturing overhead costs, which are allocated using direct manufacturing labor costs). Materials Control Wages Payable Control 12-31-2016 Bal. 30,000 1-31-2017 Bal. 6,000 Work-in-Process Control Manufacturing Overhead Control 1-31-2017 Bal. 114,000 Finished Goods Control Costs of Goods Sold 12-31-2016 Bal. 40,000 Additional information follows: a. Manufacturing overhead is allocated using a budgeted rate that is set every December. You forecast next year's manufacturing overhead costs and next year's direct manufactur- ing labor costs. The budget for 2017 is $1,200,000 for manufacturing overhead…arrow_forward
- Please show your computations through excel. c. Using AVERAGE method, compute for the equivalent unit for casting department.arrow_forwardMatch each of the following cost items with the value chain business function where you would expect the cost to be incurred: Cost Item 1. Purchase of raw materials 2. Advertising 3. Salary of research scientists 4. Delivery expenses 5. Reengineering of product assembly process 6. Replacement labor expense for warranty repairs 7. Manufacturing supplies 8. Sales salaries 9. Purchase of CAD (computer-aided design) software 10. Salary of website manager Business Functionarrow_forwardAssume you are the leather department manager at the Famous Football Factory. The leather department is a cost center and you are reviewing the scrap costs for the previous year, shown here: A. Using Microsoft Excel or another spreadsheet application, create a line chart with markers showing the leather scrap expense. Describe your observations. B. Knowing that leather is susceptible to indoor temperature, you decide to talk with the maintenance manager and obtain the following information: Using Microsoft Excel or another spreadsheet application, create individual line charts with markers showing the indoor temperature, spare parts inventory, and breakdowns. Describe your observations and actions you might consider.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
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Cost Accounting - Definition, Purpose, Types, How it Works?; Author: WallStreetMojo;https://www.youtube.com/watch?v=AwrwUf8vYEY;License: Standard YouTube License, CC-BY