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 overhead in cell B8 to 0.6 hours. The materials spending variance should now be $1.500 U. the labor spending variance should now be $3.720 F, and the variable overhead spending variance should now be $60 F. If you do not get these answers, find the errors in your worksheet and correct them.
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
to 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…
Berrian Company manufactures car seats in its Tulsa plant. Each car seat passes through the assembly department and the testing department. This problem focuses on the assembly department.
Data for the assembly department for October
2017
are as follows:
Read the requirements3.
Requirement 1. For each cost category, compute equivalent units in the assembly department. Show physical units in the first column of your schedule.
Equivalent Units
Physical
Direct
Conversion
Flow of Production
Units
Materials
Costs
Work in process beginning
Started during current period
To account for
Completed and transferred out during current period
Work in process, ending
Accounted for
Work done to date
Requirement 2. What issues should the manager focus on when reviewing the equivalent-unit calculations?
To show better…
You have been hired as a Cost Accountant by Sundial, Inc., which produces sunglasses. Your duties include developing cost standards for materials and labor, designing and implementing cost accounting systems, defining various product and operational costs, analyzing production costs and recommending changes. When the trial period is over, you will have a performance review to demonstrate the completed tasks and gained knowledge.
You have read the Cost of Quality Report of Sundial, Inc. and discovered that quality costs constitute 4.2% of sales. The amount is enormous, and your boss asks you to develop a set of measures to reduce it.
Sundial, Inc.
Cost of Quality Report
For the Year
Cost of Quality Percent of Sales ($32,000,000)
Prevention costs $160,000 0.5%
Appraisal costs…
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
- Assume 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_forwardMorrison Company had the equivalent units schedule and cost information for its Sewing Department for the month of December, as shown on the next page. Required: 1. Calculate the unit cost for December, using the weighted average method. 2. Calculate the cost of goods transferred out, calculate the cost of EWIP, and reconcile the costs assigned with the costs to account for. 3. What if you were asked to show that the weighted average unit cost for materials is the blend of the November unit materials cost and the December unit materials cost? The November unit materials cost is 6.60 (66,000/10,000), and the December unit materials cost is 12.22 (550,000/45,000). The equivalent units in BWIP are 10,000, and the FIFO equivalent units are 45,000. Calculate the weighted average unit materials cost using weights defined as the proportion of total units completed from each source (BWIP output and current output).arrow_forwardGunnison Company had the following equivalent units schedule and cost information for its Sewing Department for the month of December: Required: 1. Calculate the unit cost for December, using the FIFO method. 2. Calculate the cost of goods transferred out, calculate the cost of EWIP, and reconcile the costs assigned with the costs to account for. 3. What if you were asked for the unit cost from the month of November? Calculate Novembers unit cost and explain why this might be of interest to management.arrow_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-35 (Appendix 4B) Sequential Method Refer to the information for Sanjay Company on the previous page. Now assume that Sanjay uses the sequential method to allocate support department costs. S1 is allocated first, then S2. Required: 1. Calculate the cost assignment ratios to be used under the sequential method for S2, Assembly, and Painting. Carry out your answers to four decimal places. 2. Allocate the overhead costs to the producing departments by using the sequential method.arrow_forwardFor all Problems, assume the weighted-average method is to be used unless you are told otherwise. Preparing a production cost report, second department, with beginning WIP and transferred in costs; journal entries; FIFO method Happy Colors manufactures crayons in a three-step process: mixing, molding packaging. The Mixing Department combines the direct materials of paraffin wax and pigments. The heated mixture is pumped to the Molding Department, where it is poured into molds. After the molds cool, the crayons are removed from the molds and are transferred to the Packaging Department, where paper wrappers are added and the crayons are boxed. In the Mixing Department, the direct materials are added at the beginning of the process and the conversion costs are incurred evenly throughout the process. Work in process of the Mixing Department on April 1, 2018, consisted of 300 batches of crayons that were 30% of the way through the production process. The beginning balance in Work-in-Process…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
- Aragon makes handheld calculators in two models--basic and professional--and wants to refine its costing system by allocating overhead using departmental rates. The estimated $1,149,500 of manufacturing overhead has been divided into two cost pools: Assembly Department and Packaging Department. The following data have been compiled: LOADING... (Click the icon to view the data.) Read the requirements LOADING... . Compute the predetermined overhead allocation rates using machine hours as the allocation base for the Assembly Department and direct labor hours for the Packaging Department. Begin by selecting the formula to calculate the predetermined overhead (OH) allocation rate. Then enter the amounts to compute the allocation rate for each department. (Abbreviation used: Qty = quantity. Enter the allocation rates to the nearest cent.) Predetermined OH Estimated overhead costs ÷ Estimated qty of the allocation base =…arrow_forwardConvert 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.arrow_forwardConvert 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.arrow_forward
- The following information has been extracted from the cost accounting information system database for Casio Ltd. The company manufactures Casio Calculators. The cost accountant wants to carry out some analysis on the following 5 costs to ascertain the behavior of the costs. The cost accountant extracted the values of the 5 costs at three activity levels of 24,000 units,30,000 units and 36,000 units. (Note: The cost accountant intends to use the units produced as the activity level in the cost analysis. Required: i) Using the information provided in the above table identify and explain how you classify each of the above costs according to behavior of cost approach. ii) From the above classification in (i) calculate the fixed cost for any mixed cost that is identified from the above 5 costs using the high-low cost estimation method.arrow_forwardThe Bangor Manufacturing Company makes mechanical toy robots that are typically produced in batches of 250 units. Prior to the current year, the company’s accountants used a standard cost system with a simplified method of assigning manufacturing support (i.e., overhead) costs to products: All such costs were allocated to outputs based on the standard machine hours allowed for output produced. You have recently joined the accounting team and are developing a proposal that the company adopt an ABC system for both product-costing and control purposes. To illustrate the benefit of such a system in terms of the latter, you decide to put together an analysis of batch-related overhead costs. You chose these costs because a previous investigation indicated that there is both a variable component to these costs (materials plus power) plus a fixed component (depreciation and salaries). Last year’s budget indicated that the variable overhead cost per setup hour was $20.00 and that the fixed…arrow_forwardI am trying to figure out how to claculate the finished goods for this problem. for april and may. the answers go on the work-in process filling account and I am having a veryh challenging time trying to figure out how this was calculated. On the example your site provides it says that the finished goods are 49818 but I can't figure out how you got that number. Can you help please? Hearty Soup Co. uses a process cost system to record the costs of processing soup, which requires the cooking and filling processes. Materials are entered from the cooking process at the beginning of the filling process. The inventory of Work in Process-Filling on April 1 and debits to the account during April were as follows: Bal., 700 units, 30% completed: Direct materials (700 × $4.20) $2,940 Conversion (700 × 30% × $1.75) 368 $3,308 From Cooking Department, 7,500 units $32,250 Direct labor 8,560 Factory overhead 2,542 During April, 700 units in process on April 1 were…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
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
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
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
Cost Accounting - Definition, Purpose, Types, How it Works?; Author: WallStreetMojo;https://www.youtube.com/watch?v=AwrwUf8vYEY;License: Standard YouTube License, CC-BY