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
Textbook Question
Chapter 5, Problem 2AE
This exercise relates to the Double Diamond Skis’ Shaping and Milling Department that was discussed earlier in the chapter. The Excel worksheet form that appears below consolidates data from Exhibits 5-5 and 5-8. 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.
Required:
2. Enter the following data from a different company into your worksheet:
What is the cost of the units transferred out?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Use the template attached below to complete this activity: (Videos are available in the C4 module on using the ebook + copying worksheets).
Chapter_7_Applying_Excel_template-1.xlsx
Use the data found in the template + use the additional data found in the ebook section, "Applying Excel" (p. 330 print text). All calculations should be performed within the cell using cell referencing/formulas so that I can see how you arrived at your answers! Do not use your calculator and just type in numbers!
You will submit four worksheets within your assignment file:
sheet 1 = original
sheet 2 = requirement 1 quantitative + question responses
sheet 3 = requirement 2 quantitative + question responses
sheet 4 = requirement 3 quantitative + question responses
In scenario 1, 2, and 3.... copy the original worksheet after inputting your cell formulas and change the values as indicated for each requirement. Name each tab by the question #.
Chapter 7: Applying Excel
Data…
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
550
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.
Chapter 5 Solutions
Introduction To Managerial Accounting
Ch. 5 - Under what conditions would it be appropriate to...Ch. 5 - In what ways are job-order and process costing...Ch. 5 - Why is cost accumulation simpler in a process...Ch. 5 - How many Work in Process accounts are maintained...Ch. 5 - Prob. 5QCh. 5 - Assume that a company has two processing...Ch. 5 - Prob. 7QCh. 5 - Watkins Trophies, Inc., produces thousands of...Ch. 5 - This exercise relates to the Double Diamond Skis’...Ch. 5 - This exercise relates to the Double Diamond Skis’...
Ch. 5 - Prob. 3AECh. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Clopack Company manufactures one product that goes...Ch. 5 - Process Costing Journal Entries. Quality Brick...Ch. 5 - Equivalent Units of Production-Weighted-Average...Ch. 5 - Cost per Equivalent Unit-Weighted-Average Method...Ch. 5 - Assigning costs to Units-Weighted-Average Method...Ch. 5 - Cost Reconciliation Report-Weighted-Average Method...Ch. 5 - Equivalent Units of Production-Weighted-Average...Ch. 5 - Process Costing Journal Entries Chocolateris de...Ch. 5 - Equivalent Units; Cost per Equivalent Unit;...Ch. 5 - Equivalent Units and Cost per Equivalent...Ch. 5 - Equivalent Units of Production-Weighted-Average...Ch. 5 - Comprehensive Exercise; Second Production...Ch. 5 - Equivalent Unit; Assigning Costs; Cost...Ch. 5 - Comprehensive Problem; Second Production...Ch. 5 - Analysis of Work in Process...Ch. 5 - Comprehensive Problem-Weighted-Average Method...Ch. 5 - Comprehensive Proble-Weighted-Average Method...Ch. 5 - Prob. 17PCh. 5 - Interpreting a Report-Weighted-Average Method...
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
- 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.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_forwardUsing the following account names, prepare the journal entries for the independent transactions listed below: Raw Materials Inventory Manufacturing Overhead Wages Payable Work in Process: Packaging Accounts Receivable Cost of Goods Sold Factory Wages Expense Finished Goods Inventory Work in Process: Shaping Work in Process: Production Sales Conversion Costs PLEASE NOTE #1: For similar accounting treatment (DR or CR), you are to record accounts in the same order as shown in the problem. PLEASE NOTE #2: You must enter the account names exactly as written above and all whole dollar amounts will be with "$" and commas as needed (Le. $12,345). • Overhead is assigned to the manufacturing department at the rate of $10 per machine hour. There were 3,500 machine hours during October in the shaping department and 2,500 in the packaging department. Prepare the journal entry to apply overhead to the manufacturing departments. DR DR CR • Prepare the joumal entry to record the factory wages of…arrow_forward
- Further info is in the attached images For the Excel part of the question give the solutions in the form of the Excel equations. Please and thank you! :) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B34 enter the formula "= B9". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2,500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion should be $145.50. Thank you!arrow_forwardRequired information (The Excel worksheet form that appears below is to be used to recreate part of the example relating to Turbo Crafters that appears earlier in the chapter.) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B13 enter the formula "= B5". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the estimated total amount of the allocation base in the Data area to 50,000 machine-hours, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the predetermined overhead rate should now be $6.00 per machine-hour. If you do not get this answer, find the errors in your worksheet and correct them. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click "Save." You will use this…arrow_forwardPlease show your computations through excel. c. Using AVERAGE method, compute for the equivalent unit for casting department.arrow_forward
- Write a breif the article should be selected from a professional periodical(cost accounting). The brief must be typed, minimum one full page of in length.arrow_forwardSport 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 Accounts and Explanation Debit Credit pages Raw Materials Inventory Acc Get more help. 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 - $ 32,000 75,000 1,400 61,000 250 X Clear all Check answerarrow_forward6. Using the following account names, prepare the journal entries for the independent transactions listed below: Raw Materials Inventory Manufacturing Overhead Wages Payable Work in Process: Packaging Accounts Receivable Cost of Goods Sold Factory Wages Expense Finished Goods Inventory Work in Process: Shaping Work in Process: Production Sales Conversion Costs PLEASE NOTE #1: For similar accounting treatment (DR or CR), you are to record accounts in the same order as shown in the problem. PLEASE NOTE #2: You must enter the account names exactly as written above and all whole dollar amounts will be with "$" and commas as needed (i.e. $12,345). Overhead is assigned to the manufacturing department at the rate of $10 per machine hour. There were 3,500 machine hours during October in the shaping department and 2,500 in the packaging department. Prepare the journal entry to apply overhead to the manufacturing departments. DR ? ? DR ? ? CR ? ? Prepare the…arrow_forward
- Instructions: Using formulas/functions wherever possible, complete the following on the Input Tab. 1. Prepare a cost of production report for the Cutting Department assuming a FIFO method. 2. Using the data developed from (1), prepare a cost of production report for the Boxing Department assuming a FIFO method.arrow_forwardplease answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) Becker Tabletops has two support departments (Janitorial and Cafeteria) and two production departments (Cutting and Assembly). Relevant details for these departments are as follows: Support Department Cost Driver Janitorial Department Square footage to be serviced Cafeteria Department Number of employees Line Item Description JanitorialDepartment CafeteriaDepartment CuttingDepartment AssemblyDepartment Department costs $280,000 $170,000 $1,520,000 $690,000 Square feet 50 4,900 500 4,500 Number of employees 8 2 36 24 Allocate the support department costs to the production departments using the direct method. Line Item Description CuttingDepartment AssemblyDepartment Janitorial Department cost allocation $fill in the blank 1 $fill in the…arrow_forwardFor 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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher: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
How JOURNAL ENTRIES Work (in Accounting); Author: Accounting Stuff;https://www.youtube.com/watch?v=Y-_Q3rANyxU;License: Standard Youtube License